Please note javascript is required for full website functionality.

Blog

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.


VBA Blogs: 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!


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.


Power BI Blog: 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.


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

13 April 2018

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


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.


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