This 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.
This event is brought to you courtesy of Olas Software Training & Development
Event Details
Organisation
Olas Software Training & Development
Venue
Olas Virtual Live Classroom Training
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