Please note javascript is required for full website functionality.

Blog

Power Query: Divide and Conquer

8 May 2019

Welcome to our Power Query blog. Today, I am going to look at a method to extract multiple columns from a single column of mixed data.


Power Pivot Principles: Introducing the MEDIAN Function

7 May 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use the MEDIAN function in Power Pivot.


A to Z of Excel Functions: The FACTDOUBLE Function

6 May 2019

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


VBA Blogs: Common Traps 4

3 May 2019

Welcome back to the VBA blog series! We’re going to continue with last month’s blog theme, focusing on common errors and issues that people run into.


Power BI Blog: Get Data from Exchange

2 May 2019

Welcome back to this week’s Power BI blog series! This week, we’re going to look at how to get data from Microsoft Exchange.


Power Query: Absolutely Fabulous

1 May 2019

Welcome to our Power Query blog. Today, I am going to look at how Power Query turns a tricky transformation into a simple task.


Power Pivot Principles: MAXX with Filter Criteria

30 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to include filters in the MAXX function.


Challenges: Monday Morning Mulling: April 2019 Challenge

29 April 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: April 2019 Challenge

26 April 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: Key Influencers - Continuous Variables

25 April 2019

Welcome back to the Power BI blog series! This week, we’re going to talk about some new updates to the Key Influencers visualisation.


Newsletter