Please note javascript is required for full website functionality.

Blog

Final Friday Fix: March Challenge 2018

30 March 2018

It’s that time again, the long weekend! That should give you plenty of time to solve our Final Friday Fix!


A to Z of Excel Functions: The CUMPRINC Function

30 March 2018

This function returns the cumulative principal repaid on a loan between a designated start_period and end_period given a constant periodic discount rate...


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

29 March 2018

The fourth part in our series involving the US Historical Population Estimates data set. Using DAX to create a calculated column.


Power Query: Seeded Accommodating Accumulating

28 March 2018

This week, I look at the M function List.Accumulate and its uses where the seed is not zero.


Power Pivot Principles: Power Pivot Menu in Excel

27 March 2018

To conclude our series covering menu tabs, we will cover the Power Pivot menu options in Excel.


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?


Newsletter