Please note javascript is required for full website functionality.

Blog

Excel for Mac: No ActiveX Support on Mac, Object Linking and Embedding (OLE) is Limited

11 October 2024

This week in our series about Microsoft Excel for Mac, we discuss some of the limitations you might face if you’re hoping to make use of ActiveX controls or OLE (Object Linking and Embedding).


Power BI Blog: Dark Mode in Power BI

10 October 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we review dark mode, but beware what lurks in those shadows...


Power Query: It’s Good to Share(Point) Part 3

9 October 2024

Welcome to our Power Query blog. This week, I successfully extract a CSV file from a SharePoint site to Power Query.


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

8 October 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.GROUPBYCOLUMNS.


A to Z of Excel Functions: The REGISTER.ID Function

7 October 2024

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


Excel for Mac: Where to Find Stuff That’s on the File Tab in Excel for Windows (Part 2)

4 October 2024

This week in our series about Microsoft Excel for Mac, we have our second article discussing where to find the features that appear in the File tab of the Ribbon in Excel for Windows. We focus on the Info panel, which contains many features in Windows, but they’re in different places on Mac.


Power BI Blog: Q&A in Power BI Desktop Revisited - Part 2

3 October 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to customise Q&A in Power BI Desktop.


Power Query: It’s Good to Share(Point) Part 2

2 October 2024

Welcome to our Power Query blog. This week, I look at how to find the URL I need to access a CSV file on SharePoint.


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

1 October 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.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES.


Monday Morning Mulling: September 2024 Challenge

30 September 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