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

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

Suitable for:

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.