This course is aimed at experienced Excel users who need to create and manipulate more complex models using the advanced features of Excel.
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
The main course objectives of this course are to create complex models involving multiple linked spreadsheets and files, analysing data using what if scenarios, validating, and auditing data and automating common processes.
The major course content materials include topics as follows:
Review of Intermediate level
Lookup and Information functions
Summarising Data with Pivot Tables
What If Analysis Tools
Advanced Filtering and Sorting
Formulae Auditing Formula View
Protecting and Sharing
Advanced Charts
Introduction To Macros