Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: The A to Z of DAX Functions – INDEX

23 April 2024

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INDEX.


A to Z of Excel Functions: The QUARTILE.EXC Function

22 April 2024

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


Excel for Mac: Optimised AutoRecover (Only on Mac)

19 April 2024

This week in our series about Microsoft Excel for Mac, we tell you how to protect yourself from losing work in case Excel crashes or is forced to quit without saving your work.


Power BI Blog: Autocreating a Mobile Layout

18 April 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how simple it is to automatically create mobile optimised reports.


Power Query: Revision Time – Part 2

17 April 2024

Welcome to our Power Query blog. Today, I continue to create a refreshable revision timetable by calculating the number of subjects to be studied.


Power Pivot Principles: The A to Z of DAX Functions – IGNORE

16 April 2024

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at IGNORE.


A to Z of Excel Functions: The QUARTILE Function

15 April 2024

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


Excel for Mac: ‘Click To Add’ Mode (Only on Mac)

12 April 2024

This week in our series about Microsoft Excel for Mac, we show you another feature that’s unique to Excel for Mac. You won’t find this on Windows, the web or mobile versions of Excel. It’s called ‘Click To Add’, and it does just what the name suggests.


Power BI Blog: More on Visual Calculations Part 2

11 April 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we take a deeper look at some more of the visual calculations available in this exciting new preview feature.


Power Query: Revision Time – Part 1

10 April 2024

Welcome to our Power Query blog. Today, I begin to create a refreshable revision timetable by extracting the inputs.


Newsletter