The Best of Excel

Unlock the hidden potential of Microsoft Excel with our session, packed with tips and tricks to boost your performance!

Microsoft Excel has a wealth of great features but many of these are untapped by the average user because ‘you don’t know what you don’t know’.

Join us in this session to learn a selection of tips and tricks so that you can leverage the “Best of” of Excel to deliver better performance in your role.

For example: have you used FlashFill? This time-saving feature fills in data for you. Or the Quick Analysis tool which enables you to analyse data quickly using shortcut options?

Learning Outcomes:

In the Best of Excel session, we will demonstrate:

• Some of the useful ‘old’ stuff:

–    Format your data as a Table

–    Add info to many worksheets at once, and duplicate Worksheets

–    Use Charts and Sparklines to get insight

–    Launch PivotTables and Slicers to summarise and Analyse data

• Some of the great new stuff:

–    Get Excel to do the ‘heavy lifting’ with data visualization with Insights

–    Extract data with flashfill

–    New functions, the IFS, XLOOKUP

• Quick analysis

Suited to:

Business professionals, Business owners, Executive Assistants, Administration support staff and anyone using Microsoft Excel.

Attendees should be familiar with the basics of using a PC.

This session will be presented using Microsoft Excel for Microsoft 365, however the content will also be relevant interest to users of Excel 2016. (Please note some of the great new stuff is only available in Excel 2019 or later)

This On Demand Includes: 

• Recording of the Live Webinar, which can be viewed multiple times
• PowerPoint Presentation
• Verbatim Transcript, with Searchability
• Supporting Documentation
• CPD Quiz
• CPD Certificate