Please note javascript is required for full website functionality.

Blog

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

16 October 2024

Welcome to our Power Query blog. This week, I look at how to access a folder of data on SharePoint.


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

15 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.HIERARCHIES.


A to Z of Excel Functions: The REPLACE Function

14 October 2024

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


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.


Newsletter