Please note javascript is required for full website functionality.
MVP

Blog

Blog

Monday Morning Mulling: March 2019 Challenge

30 March 2020

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.


Final Friday Fix: March 2020 Challenge

27 March 2020

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 / Power BI fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this...


Power BI Blog: Power BI Report Builder – Part 3 (Editing Print Layouts)

26 March 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look at how to edit the print layout of tables in the Power BI Report Builder.


Power Query: Unique and Distinct

25 March 2020

Welcome to our Power Query blog. This week, I look at how to find the unique or distinct values in a list of data.


Power Pivot Principles: Using SELECTCOLUMNS to Create Calendar Table

24 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a new way of using a DAX function to create a calendar table.


A to Z of Excel Functions: the HEX2BIN Function

23 March 2020

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


Charts and Dashboards Blog: Stock Charts

20 March 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s look at Stock Charts.


Power BI Blog: Power BI Report Builder – Part 2

19 March 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look at how to create reporting tables in the Power BI Report Builder.


Power Query: Reorganising by Numbers

18 March 2020

Welcome to our Power Query blog. This week, I look at using some numerical functions to sort out expense formatting.


Power Pivot Principles: Using ADDCOLUMNS to Create a Calendar Table

17 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a way of using a DAX function to create a calendar table.


Newsletter