Top 5 Reasons to Learn PowerPivot – Training for Results

Top 5 Reasons to Learn PowerPivot -Training for Results Hey there! Have you discovered the power or PowerPivot for Excel yet? Or are you stuck with boring old Excel sheets and formulas that quickly become cumbersome, inflexible and impossible to maintain without...

Extract Comments Embedded in the N() Function

Not so long ago, I showed you how to insert comments using the N() function in Excel formulas. But can you get the comment out of that cell using a function, reader Dobrin asks? Thank you for this article – the N() funtion is very usefull and I use it often in...

A tri-colour in Excel? Is feider linn. Happy St Patrick’s Day

A tri-colour in Excel? Is feider linn. Contextures blog did it using a column chart, removing the gaps between bars and customising colours. A simple project with useful techniques thrown in. Happy St Patrick’s Day from Business Brains.     How To Make...

A PivotTable that includes new data automatically? Good Question!

Question: How to make a PivotTable automatically select new data as it is added to the source? Answer: Follow these steps – or even just the first one – to see your data source extend automatically for any PivotTable Step 1 – Convert your Source Data...

Why you will never size Excel columns correctly

No better time to learn about the weird and wonderful: how Excel measures stuff. If you have ever tried to fit your spreadsheet columns to fit exact measurements in inches or centimetres and have failed before, this short post explains measurement units in Excel and...

Pin It on Pinterest