Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Reconcilable Differences

22 January 2020

Welcome to our Power Query blog. This week, I look at a common problem in Finance – performing that pesky bank reconciliation!


Power Pivot Principles: Introducing the Function INTERSECT

21 January 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn one way of joining tables together in DAX.


A to Z of Excel Functions: the GAMMALN Function

20 January 2020

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


Charts and Dashboards Blog: Bar Charts

17 January 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we are going to look at Bar Charts.


Power BI Blog: Bullet Charts

16 January 2020

Welcome back to this week’s Power BI blog series. This week, we are going to look at bullet charts.


Power Query: Group Functions

15 January 2020

Welcome to our Power Query blog. This week, I look at using some M functions on grouped data.


Power Pivot Principles: Counting Working Days

14 January 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a method to calculate the working days using PowerPivot.


A to Z of Excel Functions: the GAMMALN.PRECISE Function

13 January 2020

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


Charts and Dashboards Blog: Column Charts

10 January 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we are going to look at Column Charts.


Power BI Blog: Combo Charts

9 January 2020

Welcome back to this week’s Power BI blog series. This week, we are going to look at how to create combo charts (Line and Clustered Column charts).


Newsletter