Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


Power BI Tips: Xenagogue to Markup Lists - Part 1

12 April 2018

This week we start a new project on using Get Data with the XML format.


Power Query: Comparing Lists

11 April 2018

 

Welcome to our Power Query blog. This week, I look at how to use the List function to compare lists.


Newsletter