Attention: You are using an outdated browser, device or you do not have the latest version of JavaScript downloaded and so this website may not work as expected. Please download the latest software or switch device to avoid further issues.
6 Dec 2022 | |
Past Events |
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