Excel Tutorials

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.

This tutorial shows how to print the filename and sheet name in the page footer – the white space between the margin and the end of the data

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.

In Excel 2016 for Windows, the new TEXTJOIN function allows you to combine the values from a range of cells.

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

Excel displays numbers containing more than 11 digits in “exponential format” (e.g. 8.2978E+11). This tutorial shows how to display the numbers as proper numbers (e.g. 829780189348)

In this video I explain one of the short-comings of the VLOOKUP function and how to get around the problem using the MATCH function

In this tutorial I explain why adding up a column of time values results in a 0 and how to fix the problem.

This short tutorial explains how to add a line break to a formula – with the added twist that the file containing the formula will be used on both Windows and Mac. Sounds simple – and it is – but with a small gotcha!