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.

Last week using the US Historical Population Estimates we created our first DAX formula. Now we have categorised our data by decade, how can we focus the view on a specific decade?

I have been looking at List functions in M language recently, and this one reminds me of my problems with null values in lists...