Jul 9, 2017
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...
Apr 27, 2017
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,...
Mar 12, 2017
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...
Feb 12, 2017
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...
Jan 22, 2017
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.
Dec 28, 2016
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...
