Excel Slicers – 2 Pivot Tables Based on Different Data Sources

I have been asked this question several times “I have 2 (or more) pivot tables in a file. The pivot tables are not connected to the same data source (i.e. each one is associated with a different table within the workbook). I am unable to connect the slicer to...

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

Power Pivot and Power Query

Do you work with, analyze and generate reports from large datasets in Excel? 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? If the answer to any of these questions is Yes then...

Excel – What is a Dashboard?

One of the training courses that I deliver is how to create a dashboard in Excel and the first thing I do is to define what a dashboard is. This is actually more difficult than it sounds because there’s actually no single definition of a dashboard. In this short...

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. This short video tutorial shows you how.

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. It’s called the 7 minute rule because the...