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.
Advanced Data Analysis in Excel Part II
Wednesday 10 May 2023
2:30 PM - 3:45 PM
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.
Advanced Function Writing:
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)
Creating Custom Rules for Conditional Formatting
Automating repetitive tasks with macros
Shortcuts, Tips & Tricks to help use Excel more efficiently
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.
Sign up for the event
10 May 2023
Analytics Institute Limited38/39 Fitzwilliam SquareDublin 2D02 RV08Ireland