Please note javascript is required for full website functionality.
MVP

Blog

Blog

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

26 March 2019

Welcome back to our Power Pivot blog. We continue on our CAGR series. Today, we shall look into making our CAGR measure more dynamic and discuss additional improvements to the measures.


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

25 March 2019

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

 

 


VBA Blog: Charts and Macros 4

22 March 2019

Welcome back to this week’s VBA blog! This month, we have been looking at the interaction between charts and macros.


Power BI: Custom Visuals – Summary Table

21 March 2019

Welcome back to the Power BI blog series. This week, we’re going to look at tables that you can customised to your needs, where you can arrange rows, add custom formulas, for example Profit and Loss statement (P&L) that we’ll particularly create in this post.


Power Query: Extra Value

20 March 2019

Welcome to our Power Query blog. This week, I look at some more Value M functionality.


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

19 March 2019

Welcome back to our Power Pivot blog. We continue on our CAGR series: today, we shall look into fixing our measures so we can calculate CAGR.


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

18 March 2019

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


VBA Blog: Charts and Macros 3

15 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 - Histograms

14 March 2019

Welcome back to the Power BI blog series! This month, we’re talking about different custom visuals that you can use in Power BI.


Power Query: Value Added

13 March 2019

Welcome to our Power Query blog. This week, I look at the Value.Is() M functionality.


Newsletter