EY helps clients create long-term value for all stakeholders. Enabled by data and technology, our services and solutions provide trust through assurance and help clients transform, grow and operate.
At EY, our purpose is building a better working world. The insights and services we provide help to create long-term value for clients, people and society, and to build trust in the capital markets.
Excelerate | Intermediate Microsoft Excel Workshop
This intermediate workshop will continue building on the beginner workshop and is designed for those who want to take their Excel knowledge to the next level. A solid knowledge in basic Excel functions will act as a strong foundation, as you will expand your knowledge with the use and application of Data Validation, Pivot Tables, Table and Lookup functions. Beyond the application of these functions, this training will also include basic theoretical perspectives on information management, enabling you to manage large datasets and to harness the power of Excel functionality.
Learning objectives
The overall learning objectives for this workshop will include:
Learning the most common Microsoft Excel functions used in data analysis
Maintaining large sets of Excel data in lists or tables
Building a solid understanding on the basics of Microsoft Excel
Establishing foundational knowledge of formula syntax and its functionality
Knowing how to format data in an excel sheet using borders, font and cell colours, and conditional formatting
Using Images, Shapes and Charts to visualise data
Managing Lists and Tables
Use of Pivot Tables
Comfort with the use of conditional and lookup functions
Who Should Attend?
The workshop will be available to anyone with an interest in establishing a foundational knowledge of Excel. It will cater for individuals who do not use Excel regularly and are not familiar with the full functionality of the application.
Emma is an Associate within the People Consultancy team at EY. In her role, she assists clients with various people-related issues to enhance their workforce strategy and ensure alignment with broader organisational goals. Additionally, she plays a key role in HR transformation projects, which involve implementing effective HR solutions, advancing digitalisation initiatives, and facilitating change management processes. Emma is also tasked with creating and analysing data-driven dashboards that deliver valuable insights to aid strategic decision-making and enhance organisational performance.
11
Jun 2025
location_onLocation
EY Malta, Regional Business Centre, Achille Ferris Street,