Please note javascript is required for full website functionality.

Blog

Final Friday Fix: November 2019 Challenge

29 November 2019

On the final Friday of each month, we’re going to set an Excel 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 playing for your bragging rights only!


Power BI Blog: Sydney’s Register of Food Penalty Notices – Part 5

28 November 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at creating more custom categories that simplify current data.


Power Query: Not Your Type

27 November 2019

Welcome to our Power Query blog. This week, I look at assigning types to columns.


Power Pivot Principles: Understanding functions for parent-child hierarchies in DAX – Part 1

26 November 2019

Welcome back to the Power Pivot Principles blog. Start from this week, we are going to understand some functions for parent-child hierarchies in DAX.


A to Z of Excel Functions: The GAMMA Function

25 November 2019

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


Charts and Dashboards: Chart Design Best Practice – Part 2: Colours and Compositions

22 November 2019

Welcome back to Charts and Dashboards blog series. This week, we are going to look at colour and the variable aspects of a chart.


Power BI Blog: Sydney’s Register of Food Penalty Notices – Part 4

21 November 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at producing some customised categories for the NSW Food Authority’s register of penalty notices data.


Power Query: Time for a List

20 November 2019

Welcome to our Power Query blog. This week, we take a look at how list() functions can take you to a whole new dimension (time).


Power Pivot Principles: Introducing the CROSSFILTER Function

19 November 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to introduce a new function CROSSFILTER.


A to Z of Excel Functions: The FVSCHEDULE Function

18 November 2019

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


Newsletter