Please note javascript is required for full website functionality.

Blog

Power Query: Types of Value

27 March 2019

Welcome to our Power Query blog. This week, I introduce more Value() M functions; Value.Type() and Value.ReplaceType().


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 Blogs: 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 Blog: 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 Blogs: 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 Blog: 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.


Newsletter