Please note javascript is required for full website functionality.

Blog

Power Query: Durable Duplicates

3 July 2019

Welcome to out Power Query blog. Today, I look at using ‘duplicate’ to replicate queries.


Power Pivot Principles: Grouping Text Columns with New Categories Dynamically using an Input Table

2 July 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use an input Table to group text columns into new categories


Challenges: Monday Morning Mulling: June 2019 Challenge

1 July 2019

On the final Friday of each month, we set an Excel problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Challenges: Final Friday Fix: June 2019 Challenge

28 June 2019

On the final Friday of each month, we’re going to set an Excel challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only!


Power BI Blog: Waffle Chart

27 June 2019

Welcome back to this week’s Power BI blog series! This week, we’re going to look at another Power BI’s awesome custom visual: Waffle Chart.


Power Query: Are Any of Them on the Table?

26 June 2019

Welcome to our Power Query blog. Today, I revisit the data I looked at last week to extend one of my solutions.


Power Pivot Principles: Introducing the LASTNONBLANK Function

25 June 2019

Welcome back to our Power Pivot blog. Today, we will go over how to use the LASTNONBLANK function.


A to Z of Excel Functions: The FINV Function

24 June 2019

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the FINV function.


VBA Blogs: File Path Selector confined to CSV

21 June 2019

Welcome back to the VBA blog! This week we are going to expand on our blog from last week, relating to file path selectors.


Power BI Blog: June 2019 Update New Interface

20 June 2019

Welcome back to this week’s Power BI blog series! This week, we’re going to look at Power BI’s updated interface look.


Newsletter