On the last Friday of each month we set an Excel puzzle for you to puzzle over the weekend. On the Monday, we publish a solution..

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

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

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

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

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

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

This function returns the cumulative interest paid (“cumulative interest payment”) on a loan between a designated start_period and end_period given a constant periodic discount rate...

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

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.