Please note javascript is required for full website functionality.

Blog

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.


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

9 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 IFERROR.


A to Z of Excel Functions: The PY Function

8 April 2024

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


Excel for Mac: Mac Only – Pick Any Colour in Excel

5 April 2024

This week in our series about Microsoft Excel for Mac, we show you a handy feature that is only available in Excel if you’re using a Mac. There’s a great colour picker that lets you easily choose any color that you can see on your screen.


Power BI Blog: More on Visual Calculations Part 1

4 April 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we take a deeper look at the new Preview feature, visual calculations.


Power Query: Heading Off – Part 8

3 April 2024

Welcome to our Power Query blog. Today, I look at using M code to provide an alternative solution to an issue that occurs when I load to a Table with no headers.


Power Pivot Principles: The A to Z of DAX Functions – IF.EAGER

2 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 IF.EAGER.


Monday Morning Mulling: March 2024 Challenge

1 April 2024

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us with your preferred solution.


Newsletter