Home Events Microsoft Excel Advanced Training with Olas IT

Microsoft Excel Advanced Training with Olas IT

Our Microsoft Excel Advanced training course is designed to enable participants to create complex models involving multiple linked spreadsheets and files, analyse data using what-ifs and scenarios, and automate common processes.

This event is brought to you courtesy of Olas Software Training & Development

Event Details

Organisation
Olas Software Training & Development
Dates
9 February 2023
Venue
Olas Office, Unit 206, Q House, Furze Road, Sandyford, Dublin 18, D18 T6T1.
Website
Contact Email

More Information

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

Special Offers

Park Academy Childcare Groupschemes Corporate Discount

At Park Academy Childcare we also know that juggling work and family life can be challenging.

Park Academy Childcare Family Offer

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