Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The PPMT Function

25 December 2023

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


Excel for Mac: PivotTable Field Layout

22 December 2023

This week, in our series about Microsoft Excel for Mac, we’ll show you some important PivotTable options that don’t show up in the Field Settings dialog on Mac, even though they are available on Windows, and we’ll show how to work around that limitation.


Power BI Blog: More on DAX Query View

21 December 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look in more detail at the new DAX query view feature in Power BI Desktop.


Power Query: Blog List – Part 4

20 December 2023

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I improve the query to extract data from all pages by extracting the last page number from the data.


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

19 December 2023

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 FIXED.


A to Z of Excel Functions: The PIVOTBY Function

18 December 2023

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


Excel for Mac: Basics You Need To Know

15 December 2023

This week in our series about Microsoft Excel for Mac, we’ll touch on some fundamentals to help you get going and be productive using Excel for Mac.


Power BI Blog: DAX Query View

14 December 2023

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


Power Query: Blog List – Part 3

13 December 2023

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I continue to extend the query to extract data from all pages.


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

12 December 2023

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 FIRSTNONBLANKVALUE.


Newsletter