Attention: You are using an outdated browser, device or you do not have the latest version of
Please download the latest software or switch device to avoid further issues.
Masterclass: Advanced Data Analysis in Excel
Thursday 24 Nov 2022
02:30 PM - 3:45 PM
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 will provide you with an overview of the key features in Excel which help work with and analyse data on a more advanced level. You will learn about some of the most powerful functions available to help extract the information you need from your data as well as features like Format as Table, Advanced Filter and a range of other tools available such as What-If Analysis
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
Anyone who regularly uses Excel to analyse data and is familiar with basic pivot tables and formula and function writing, but is keen to learn more about what is available to help get the most out of their data.
The session will be run by Yvonne Gamble of Neueda Training. Yvonne is a Data Analysis and Visualisation Specialist with key technical competencies in MS Excel to an advanced level, excel VBA Programming, database fundamentals, Data visualisation and Power BI.