Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principles: How to Create the CAGR Measure, Part 1

12 March 2019

Welcome back to our Power Pivot blog. Today, we begin a short series on how to create the CAGR measure in Power Pivot.


A to Z of Excel Functions: the F.DIST Function

11 March 2019

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


VBA Blog: Charts and Macros 2

8 March 2019

Welcome back to this week’s VBA blog! This month, we’re going to look at the interaction between charts and macros.


Power BI: Custom Visuals – Box and Whisker Chart

7 March 2019

Welcome back to the Power BI blog series! This month, we’re going to take a look at a number of different custom visuals that are available from the Power BI marketplace.


Power Query: Find the Folder

6 March 2019

Welcome to our Power Query blog. This week, I look at an example which uses some of the M functionality for dealing with files and folders.


Power Pivot Principles: Introducing the DIVIDE Function

5 March 2019

Welcome back to our Power Pivot blog. Today, we introduce the DIVIDE function.


A to Z of Excel Functions: the EXPONDIST Function

4 March 2019

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


VBA Blog: Charts and Macros

1 March 2019

Welcome back to this week’s VBA blog! This month, we’re going to look at the interaction between charts and macros.


Power BI: Practical Influences

28 February 2019

Welcome back to the Power BI blog! This week, we’re going to look at the Key Influencers visual and provide some guidance on how you can use it from a practical perspective.


Power Query: Fold(er) Away

27 February 2019

Welcome to our Power Query blog. This week, I look at some of the M functionality for dealing with folders.


Newsletter