Excel Tutorials
A collection of written and video based Excel tutorialsExcel – 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 moreExcel 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 moreRounding 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 moreCalculate Date Difference with Custom Weekends
The NETWORKDAYS.INTL function will calculate the number of working days between 2 dates but will also allow you to define which days are weekends. Useful for regional variations.
read moreCreate a Geographic Heat Map in Excel
Heatmaps are just one way to analyse and present data in a visual way. They are especially useful when it comes to geographic-based data.
read moreCalculate 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 moreExcel 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 moreCreating a Win Loss Sparkline Chart in Excel
A Win Loss chart displays positive and negative values as different colours, helping you to quickly spot trends in a set of figures. This tutorial shows how to create one.
read moreExcel Charts: Creating Custom Data Labels
In this video I’ll show you how to add data labels to a chart and then change the range that the data labels are linked to.
read more