Advanced Analysis in Excel Part II
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 take your knowledge of Excel to the next level. You will see how to use a wide range of more advanced functions to get the most out of your data. You will also learn how to automate time-consuming tasks with the macro recorder.
Beyond Vlookup Function – exploring other key functions which help perform more complex lookups (Index, Match, XLookup)
Working with logical functions – IF, IFS, AND/OR, IS functions
Exploring Date Functions
Array functions in Office 365 (Unique, Sort, Filter)
Suitable for regular Excel users who are familiar with key essentials such as Pivots, VLOOKUPS and Conditional Formatting and want to develop a deeper knowledge and understanding of how to use Excel efficiently
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.