Home Events Microsoft Excel Advanced Training with Olas IT

Microsoft Excel Advanced Training with Olas IT

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

Olas Software Training & Development
28 June 2023
Olas Virtual Live Classroom Training
Contact Email

More Information

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.

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.

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

Special Offers

Acoustic Pods and Booths from Studioline

Acoustic Pods and Booths and Custom design collections to assist with Environmental Acoustics at work.

Free Data & Infrastructure Migration Assessment

Get help evaluating your overall infrastructure in relation to on-premises deployments and future cloud-strategy with insights on the business, cost, and technology benefits of migration.