Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The HEX2OCT Function

6 April 2020

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


Charts and Dashboards: Box and Whisker Charts

3 April 2020

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


Power BI Blog: Power BI Report Builder – Part 4 (Creating Charts)

2 April 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to create charts in the Power BI Report Builder.


Power Query: Row by Row

1 April 2020

Welcome to our Power Query blog. This week, I look at how to add a table of data to an existing query.


Power Pivot Principles: Using USERELATIONSHIP to Activate an Inactive Relationship

31 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a method of creating a virtual relationship in Power Pivot.


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.


A to Z of Excel Functions: The HEX2DEC Function

30 March 2020

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


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 stage: you’re playing for bragging rights only!


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


Newsletter