Excel Tutorials

I created a short video in response to a question that I received via email… “Is it possible to import a due date listing on an Excel spreadsheet to Outlook and set up reminders for these due dates?”

Until now Excel users have only been able to store text, numbers, dates and formulas in cells. Well now, Microsoft have added 2 new data types – Geography and Stocks. These data type will fundamentally change what’s possible with Excel

Excel Online, the browser-based version of Excel is available to anyone who has a free Microsoft account (as well as a paid-for Office365 account). In March 2018, Microsoft added the ability to create pivot tables to Excel Online

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

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