Many people across all sectors of industry rely heavily on Excel to help provide key insights from their data, using tools such as pivot tables and Vlookups on a day to day basis.

This webinar provided an overview of the key features in Excel which help work with and analyse data on a more advanced level.

Topics covered:

Function Writing: an overview of some of the most powerful functions (old and new) – with a particular focus on Lookup & Reference Functions and Text Functions

Format as Table: learn about its key benefits and the important role it plays when working with datasets and pivot tables

Advanced Filter: Use Criteria and Extract ranges to pull out the data you need

Quick overview of What-If  Analysis & Data Analysis Tools

Shortcuts, Tips & Tricks to help use Excel more efficiently