Please note javascript is required for full website functionality.
MVP

Blog

Blog

A to Z of Excel Functions: the INFO Function

8 March 2021

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


Charts and Dashboards Blog: Bullet Charts – Part 3

5 March 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we complete our take on Bullet Charts.


Power BI Blog: Different Coloured Columns in a Stacked Column Chart

4 March 2021

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will expand on the last week’s blog, this time with different coloured stacked column charts.


Power Query: Emerging from a Muddle

3 March 2021

Welcome to our Power Query blog. This week, I look at a more efficient way of merging the data from last week, again when there is not a clear link between the tables


Power Pivot Principles: Sensitivity Analysis

2 March 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll perform a sensitivity analysis for different rates of Goods & Services Tax (GST) on the Sales transactions.


Monday Morning Mulling: February 2021 Challenge

1 March 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: February 2021 Challenge

26 February 2021

On the final Friday of each month, we’re going to set an Excel / Power BI 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 are no prizes at this stage: you’re...


Power BI Blog: Different Coloured Columns in a Chart

25 February 2021

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will look at how to create different coloured columns in a column chart.


Power Query: Merging Muddles

24 February 2021

I have some sales contact data for my imaginary business. Unfortunately, I have some complaints and I want to allocate them to the correct salesperson.


Power Pivot Principles: Creating a Disconnected Table for GST

23 February 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll continue last week’s example, and build on the mistake of not including a Goods & Services Tax (GST) on the Sales transactions. For this week, we will create a disconnected table for GST.


Newsletter