Home Events Microsoft Excel Advanced Training with Olas IT

Microsoft Excel Advanced Training with Olas IT

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
Dates
28 June 2024
Venue
Olas Virtual Live Classroom Training
Website
Contact Email

More Information

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 

Special Offers

Looking for a unique Summer event idea? The Royal Marine Hotel Sail n Sizzles returns for 2024.

Enjoy an hour-long Dublin Bay Cruises from DĂșn Laoghaire to Dalkey Island and return, followed by a delicious BBQ on the Royal Marine Hotel's lawn*(weather permitting)