Please note javascript is required for full website functionality.
MVP

Blog

Blog

A to Z of Excel Functions: the ISERROR Function

10 May 2021

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


Charts and Dashboards Blog: Moving Chart Labels – Part 2

7 May 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to discuss about the moving chart labels.


Power BI Blog: Gauge Visualisation – Presenting Percentages

6 May 2021

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


Power Query: Group Text

5 May 2021

Welcome to our Power Query blog. This week, I look at how to modify a grouping statement to accommodate text fields.


Power Pivot Principles: PARALLELPERIOD Comparison

4 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare monthly data again, but this time using on an alternative approach.


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.


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


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”.


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, Jonathan Liau 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.


Newsletter