Please note javascript is required for full website functionality.
MVP

Blog

Blog

Monday Morning Mulling: March 2018

2 April 2018

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


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.


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


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!


Power BI Tips: 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.


A to Z of Excel Functions: The CUMIPMT Function

26 March 2018

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


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.

 


VBA Blog: '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.


Newsletter