Excel Unplugged

Monthly Archives: June 2014

Sum of ten largest values

This will be a short lesson on three great and sadly unknown functions and how to use them as an array function. The eighth LARGEst value One of my favorite ...

Fill and Justify in Excel

In my work as a trainer I’m usually the one serving the Excel goodies to the audience. But every so often I’m the one getting served. Whereas sometimes ...

Turn Conditional Formatting On and Off (Show or Hide Conditional Formatting)

Simply put, there are two ways to turn Conditional formatting On and Off. The manual way will take you to the Home/Conditional Formatting/Manage Rules… window ...