|6 Dec 2022|
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.
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