Please note javascript is required for full website functionality.

Blog

VBA Blogs: 'Do' You Want To 'Exit'?

23 March 2018

Last week this blog While Wend-ed down a loopy path, but now it is time to find better things to Do. Converting While Wend loops to Do Loop syntax.


A to Z of Excel Functions: The CUBEVALUE Function

23 March 2018

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


Power BI Blog: Text isn't Limiting! - Part 3

22 March 2018

The third part in our series involving the US Historical Population Estimates data set. Creating a basic line chart visualisation with the data in Power BI.


Power Query: Seedless Accommodating Accumulating

21 March 2018

This week, I look at simple examples of how to use the M function List.Accumulate...


Power Pivot Principles: Advancing the Series

20 March 2018

Welcome back to our Power Pivot blog series. In the previous two blogs we’ve covered the ‘Home’ tab, and the ‘Design’ tab, can you guess what’s next?


A to Z of Excel Functions: The CUBESETCOUNT Function

19 March 2018

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


A to Z of Excel Functions: The CUBESET Function

16 March 2018

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


VBA Blogs: Wending down the hill Until you Do

16 March 2018

Last week we looked at For Each…Next loops – but this time let’s have a look at While Wend loops.


Power BI Blog: Text isn't Limiting! - Part 2

15 March 2018

Welcome back to Power BI Tips! Continuing with the US Census Historical Population Estimates text file exercise.


Power Query: Moving Date

14 March 2018

This week, I look at how to transform extracted data into a useful table.


Newsletter