Today we talk about measures.

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

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

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

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

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

Welcome back to our Power Pivot blog. Today, we consider how to create a calculated column.

This function converts a date that is stored as text to a serial number that Excel recognises as a date..

The second reason that Do…Loop is superior is that While Wend loops check for the condition prior to running – but with Do…Loop the condition can be checked at the end...

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