Please note javascript is required for full website functionality.

Blog

Excel for Mac: Use Word to Configure Your Default folders

13 December 2024

This week in our series about Microsoft Excel for Mac, we discuss Microsoft Word. We show you why it's needed to set the folders that will be used by Excel for Personal and Workgroup Templates that you can use when you create new workbooks.


Power BI Blog: New List Slicer

12 December 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the new List Slicer, currently in Preview.


Power Query: Fuzzy Fixing Part 4

11 December 2024

Welcome to our Power Query blog. This week, I look at the M function Table.FuzzyGroup().


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

10 December 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.PARQUETFILESTORAGES.


A to Z of Excel Functions: The ROUND Function

9 December 2024

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


Excel for Mac: VBA and the VB Editor on Mac

6 December 2024

This week in our series about Microsoft Excel for Mac, we cover differences in VBA and the VB Editor in Excel for Mac. The short story is that most things work: some are a little different and some things are just not possible.


Power BI Blog: Quick Measures Update

5 December 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we note that Quick Measure Suggestions with Copilot is to be replaced with Microsoft Fabric Copilot.


Power Query: Fuzzy Fixing Part 3

4 December 2024

Welcome to our Power Query blog. This week, I look at a larger data set with more variants that need to the fixed.


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

3 December 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.OBJECTTRANSLATIONS.


Monday Morning Mulling: November 2024 Challenge

2 December 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. This past Friday, we presented you with the Staircase Challenge.


Newsletter