Excel Tutorials

A collection of written and video based Excel tutorials

Calculate the Median in a Pivot Table

Last week I was then asked “how can you display the median of a set of values in a pivot table?” It’s not simple because median does not exist as an option. In this tutorial I show you how to do it.

read more

Excel 2016: Creating a Pareto Chart

A Pareto Chart shows the relative frequency of items in descending order. They are often used as the basis for creating a prioritization tool so that, for example process improvement activities can be organised.

read more

Creating a Heat Map with Excel

A heatmap is a graphical representation of data where the individual values contained in a matrix are represented as colours. This tutorial shows you how to create one in Excel.

read more

Excel’s 10,000 Hour Limitation

I was recently asked why a time value divided by a number generated a #VALUE! error. The reason was because the time value was over 10,000 hours. This tutorial shows a workaround.

read more

VMWare, PowerMap and DirectX

When I tried to run PowerMap on Excel 2016 for Windows, running in a VM on my iMac, up popped a message telling me that my video driver may not support DirectX. Here’s how I fixed it

read more