Please note javascript is required for full website functionality.

Blog

Power Query: Find the Folder

6 March 2019

Welcome to our Power Query blog. This week, I look at an example which uses some of the M functionality for dealing with files and folders.


Power Pivot Principles: Introducing the DIVIDE Function

5 March 2019

Welcome back to our Power Pivot blog. Today, we introduce the DIVIDE function.


A to Z of Excel Functions: The EXPONDIST Function

4 March 2019

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


VBA Blogs: Charts and Macros

1 March 2019

Welcome back to this week’s VBA blog! This month, we’re going to look at the interaction between charts and macros.


Power BI Blog: Practical Influences

28 February 2019

Welcome back to the Power BI blog! This week, we’re going to look at the Key Influencers visual and provide some guidance on how you can use it from a practical perspective.


Power Query: Fold(er) Away

27 February 2019

Welcome to our Power Query blog. This week, I look at some of the M functionality for dealing with folders.


Power Pivot Principles: Introducing the CALCULATETABLE Function

26 February 2019

Welcome back to our Power Pivot blog. Today, we discuss the CALCULATETABLE Function.


Challenges: Monday Morning Mulling: February 2019 Challenge

25 February 2019

On the final Friday of each month, set an Excel 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: February 2019 Challenge

22 February 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...


Power BI Blog: Key Influencers Top Segments

21 February 2019

Welcome back to the Power BI blog. This time, we’re going to be talking about the other part of the Key Influencers visual: the Top Segments.


Newsletter