Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


A to Z of Excel Functions: the HARMEAN Function

16 March 2020

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


Newsletter