Home Events Microsoft Excel Advanced Training with Olas IT

Microsoft Excel Advanced Training with Olas IT

Our Excel Advanced 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
22 March 2023
Olas Office, Unit 206, Q House, Furze Road, Sandyford, Dublin 18, D18 T6T1.
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

Stepping into Spring

It’s time to plan your Spring Getaway to Ireland’s Ancient East

Park Academy Childcare Family Offer

We understand that childcare becomes more expensive with the arrival of a second or third child.