Please note javascript is required for full website functionality.

Blog

Excel for Mac: Switching Languages

13 September 2024

This week in our series about Microsoft Excel for Mac, we show how you can switch Excel from one language to another. The great news is that it’s incredibly easy.


Power BI Blog: Dynamic Per Recipient Subscriptions

12 September 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we discuss ‘Dynamic per recipient’ subscriptions.


Power Query: Filtering of Choice Part 3

11 September 2024

Welcome to our Power Query blog. This week, I continue finding a solution to a challenge involving a choice of filters by transforming Tbl_Sales_Data.


Power Pivot Principles: The A to Z of DAX Functions – INFO.EXTENDEDPROPERTIES

10 September 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 INFO.EXTENDEDPROPERTIES.


A to Z of Excel Functions: The REGEXREPLACE Function

9 September 2024

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


Excel for Mac: Conditional Formatting

6 September 2024

This week in our series about Microsoft Excel for Mac, we show how to set up conditional formatting, and how it’s different from what you might be familiar with on Windows.


Power BI Blog: DAX Query View in the Web

5 September 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we review the DAX query view in the web.


Power Query: Filtering of Choice Part 2

4 September 2024

Welcome to our Power Query blog. This week, I continue to work on a challenge involving a choice of filters by transforming P_Choice.


Power Pivot Principles: The A to Z of DAX Functions – INFO.EXPRESSIONS

3 September 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 INFO.EXPRESSIONS.


Monday Morning Mulling: August 2024 Challenge

2 September 2024

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI 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.


Newsletter