Excel Tutorials

I have 2 (or more) pivot tables in a file. The pivot tables are not connected to the same data source. I am unable to connect the slicer to all the pivot tables. How can I attach a Slicer to both/all pivot tables?

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,...

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?

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.

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

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.

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.

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.

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.