Excel Tutorials

A collection of written and video based Excel tutorials


VLOOKUP and HLOOKUP are very useful functions however sometimes their inflexibility lets them down. Here I explain how INDEX and MATCH can be used instead

read more

Excel 2010 – Create a Combo Chart

A combo (or combination chart) is a chart that plots multiple sets of data using two different chart types. A typical combo chart uses a line and a column. Despite being out of support for several years, Excel 2010 is still in use in many organisations, however,...

read more

Power Pivot and Power Query

Do you need to create pivot tables from multiple datasets? Do you spend too much time cleaning up imported data before it can be used?

read more

Excel – What is a Dashboard?

One of the training courses that I deliver is how to create a dashboard in Excel. In this short video I explain what an Excel-based dashboard means to me.

read more

Excel 2016 – Create a Map Chart

A Map Chart (new in the November 2016 release of Excel 2016 for Office 365 subscribers) allows you to quickly and easily display geographic data as a map

read more

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