Please note javascript is required for full website functionality.

Blog

Poisson D'Avril

1 April 2018

Happy April's Fool Day! In France, it's called Poisson D'Avril and in honour we've released a new thought article.


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...


Newsletter