Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principles: Recognising Measures

24 April 2018

Welcome back to our Power Pivot blog series. Today we discuss how to tell the difference between a measure and a field.


A to Z of Excel Functions: the DAYS360 Function

23 April 2018

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


A to Z of Excel Functions: the DAYS Function

20 April 2018

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


VBA Blog: Lost and Found

20 April 2018

It’s easy to get lost in a sea of data, but at times we want to find something in particular, be it a word, number or formula. The Find method in VBA can help us do that!


Power BI Tips: Xenagogue to Markup Lists - Part 2

19 April 2018

Using the Power Query Editor to parse through the Reserve Bank of Australia's RSS feed in XML format.


Power Query: Join Me at the Table

18 April 2018

Whilst there are often multiple ways to achieve the same objective in Power Query, the purpose of today’s example is become familiar with the M function, Table.Join.



A to Z of Excel Functions: the DAY Function

16 April 2018

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


A to Z of Excel Functions: the DAVERAGE Function

13 April 2018

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


VBA Blog: 'Do' it 'Until' You Believe

13 April 2018

Welcome back to the VBA Blog! Continuing on our series on the Do...Loop.


Newsletter