Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


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.


Newsletter