Excel Express Course

Shortcuts, tips, tools and techniques that will rapidly speed up your work so that you’re operating as fast and efficiently as you can be.

10 Quick Tips - Pro tips picked up over the years, and delivered in a quick-fire fashion, that will optimise your working.

Navigation Shortcuts - Top keyboard shortcuts that will get your round your spreadsheet rapidly.

Action Shortcuts - Vital keyboard shortcuts to perform your most repetitive actions at speed. 

Explanation and demos of the most important and relevant functions being applied in commercial contexts, supported by downloadable Excel exercises.

SUM - One of Excel's simplest functions and one of its most used. But there’s still much to learn, such as how to add multiple worksheets with a 3-D Sum, or cumulatively sum a range of cells!

VLOOKUP - Most widely used lookup function that enables the user to lookup a value in a table and return an associated result. This function is prevalent in worksheets and so is vital to know.

XLOOKUP - Released in July 2020 and already available to most users, XLOOKUP is the Swiss Army Knife of lookup functions - there's a lot you can do with it. A cross between VLOOKUP and a more advanced lookup approach known as INDEX & MATCH, this function is vital to have in your pocket.

IF - Used to introduce logic into your work - for instance, if Condition A is true then return Result B, otherwise return Result C. It has a range of applications and will bring great functionality to your spreadsheets.

SUMIFS – Extremely useful function that sums all the values in a range that satisfy one or more criteria. For instance, the quantities sold by product, or showing monthly profits by year.

Explanation and demos of Pivot Tables applied to datasets and bland outputs transformed with Formatting, supported by downloadable Excel exercises.

Pivot Tables - Perfect for slicing, dicing and dissecting large amounts of data...super fast! Pivot Tables and Slicers enable you to organise and summarise a large amount of bland data into something simpler, more meaningful and engaging, in literally seconds.

Formatting - Transform the appearance of outputs to give a more professional look, increase engagement, and ensure they're interpretable by your audience. We'll cover the basics, some useful techniques, and where to go for more advanced options. 

The learning, demos and exercises have been framed in a commercial context but in topics of interest to make the content engaging, fun and relevant. The below subject matter is entirely original and has been created and utilised for learning.

Cinema Business - The underlying Project containing all the exercises that support the learning is set in the context of cinema business. The tasks revolve around helping the cinema owner make more sense of his company’s data and better decisions.

Sales Team Commissions - IF

IMDB Film Data - Pivot Tables

International Spa Business - SUM

Haute Couture Fashion Retailer - SUMIFS

US Domestic Flights - XLOOKUP

Timing of Rent Payments - IF

And Much More... - Learning is set in a range of other engaging and relevant contexts