Please note javascript is required for full website functionality.

Blog

Excel for Mac: Writing and Editing Formulae

12 January 2024

This week in our series about Microsoft Excel for Mac, show a few differences between the experience of writing formulae on a Mac versus a PC.


Power BI Blog: Power BI Home in Desktop

11 January 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the new Power BI Home in Desktop.


Power Query: Equal Split

10 January 2024

Welcome to our Power Query blog. Today, I look at a problem where I need to divide amounts over two rows.


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

9 January 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 FV.


A to Z of Excel Functions: The PRICE Function

8 January 2024

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


Excel for Mac: Should You Buy a Mac?

5 January 2024

This week in our series about Microsoft Excel for Mac, we’ll point out some important features that aren’t available Excel for Mac, which should help you decide whether a Mac is right for you.


Power BI Blog: Power BI Desktop – One Drive and SharePoint Integration

4 January 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to edit One Drive and SharePoint integration for Power BI Desktop.


Power Query: Blog List – Part 6

3 January 2024

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I welcome some new functionality, currently in Preview, which will allow me to achieve my goal in Power Query in Excel.


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

2 January 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 FORMAT.


Monday Morning Mulling: December 2023 Challenge

1 January 2024

Happy New Year! 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 following 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, but we do appreciate your enthusiasm!


Newsletter