EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.
Recent Searches
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, and several 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. This session will conclude with how Microsoft Copilot can be used with Microsoft Excel.
Learning objectives
The overall learning objectives for this workshop will include:
- The overall learning objectives for this workshop will include:
- Utilising text functions (LEFT, RIGHT, MID, LEN, CONCAT, FIND) for advanced data manipulation.
- Employing the Text to Columns feature to organise complex data.
- Applying conditional functions (IF, IFS) for decision-making analysis.
- Using COUNTIF and COUNTIFS to perform data counting based on criteria.
- Implementing SUMIF and SUMIFS for conditional summation of data.
- Leveraging date functions (YEAR, MONTH, DATE, DATEDIF) for effective date analysis.
- Applying data validation techniques to ensure data integrity.
- Implementing XLOOKUP for efficient data retrieval across datasets.
- Sorting and filtering data using the SORT and UNIQUE functions.
- Creating and analysing Pivot Tables to summarise and visualise data insights.
- Identifying key data points using the LARGE and SMALL functions.
Who Should Attend?
The workshop will be available to anyone with an interest to improve their existing knowledge of Excel.
Registration fee
Click on Register to confirm your place.
- Price for this session: Eur95
Facilitators
Emma Forace
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.
Location
EY Malta, Regional Business Centre, Achille Ferris Street
Msida, Malta, MSD1751, MT
Date
Time
your local time
