Excel Tutorials

A collection of written and video based Excel tutorials

Rounding Time to the Nearest 15 Minutes

I was recently asked how to round a time to the nearest 15 minutes. The question was in relation to the “7 minute rule” where employee clock in and clock out times are rounded to the nearest quarter hour.

read more

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