Description
Our Microsoft Excel Advanced training course is designed to enable participants to create complex models involving multiple linked spreadsheets and files, analysing data using what ifs and scenarios, validating and auditing data and automating common processes.
Full Day Course Price: €400 per person
Click here to view the upcoming Virtual Live Training 1.5 hour session schedule.
To book onto a Virtual Live Training 1.5 hour session, or series of sessions, please click here.
Dates
- 04 May 2023 – 1 Day
- 28 June 2023 – 1 Day
- 06 September 2023 – 1 Day
- 03 October 2023 – 1 Day
- 22 November 2023 – 1 Day
TARGET AUDIENCE
This Microsoft Excel advanced course is aimed at experienced Excel users who need to create and manipulate more complex models using the advanced features of Excel.
PREREQUISITES
Participants should be existing users of Microsoft Excel. They should be able to create, edit and manipulate spreadsheets containing formulae and functions. They should also be able to create basic charts and pivot tables. Ideally they should have completed the Excel Introduction and / or Excel Intermediate course.
Goals and Objectives
Having completed this course, participants will be able to:
- Create complex formulae
- Use a wide range of Excel functions – Mathematical / Statistical / Financial / Text / Lookup / Date & Time
- Link worksheets and workbooks via formulae
- Use Data Validation and Audit a workbook
- Analyse data using Scenarios / What Ifs / Goalseek
- Share workbooks
- Use advanced sorting and filtering features
- Create advanced Pivot Tables
- Create and use a keystroke macro
