Please note javascript is required for full website functionality.

Blog

Monday Morning Mulling: April 2021 Challenge

3 May 2021

This month, we want to check if a pair of values are of the same category.


Challenges: Monday Morning Mulling: April 2021 Challenge

3 May 2021

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI 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.


A to Z of Excel Functions: The ISERR Function

3 May 2021

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


Challenges: Final Friday Fix: April 2021 Challenge

30 April 2021

On the final Friday of each month, we are going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”.


Final Friday Fix: April 2021 Challenge

30 April 2021

This month, we want to check if a pair of values are of the same category.


Power BI Blog: Revisiting Built-In Gauge Charts

29 April 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at how to use the built-in Gauge visualisation in Power BI.


Power Query: Arranging a List

28 April 2021

Welcome to our Power Query blog. This week, I look at how to translate a range of data contained in one cell to a list of cells.


Power Pivot Principles: DATEADD Comparison

27 April 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to work on an alternate approach from last week to compare monthly data.


A to Z of Excel Functions: The ISBLANK Function

26 April 2021

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


Charts and Dashboards: Moving Chart Labels – Part 1

23 April 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will talk about creating a chart label that can move.


Newsletter