Home Events Microsoft Excel Advanced

Microsoft Excel Advanced

The objective of this course is to create complex models involving multiple linked Excel spreadsheets and files, analysing data using what ifs and scenarios, validating and auditing data and automating commonly used features with macros.

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

Event Details

Organisation
Olas
Dates
21 March 2019
Venue
Olas, Unit 206, Q House, Furze Rd., Sandyford, Dublin 18
Contact Phone
279 0020
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 MS Excel. They should be able to create, edit and manipulate spreadsheets containing formulas and functions. They should be able to create a basic chart and pivot table. Ideally they will have completed the Excel Introduction and / or Excel Intermediate course(s).

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

Price: €300 per person

Special Offers

La Dolce Vita Early Bird Menu

For the very finest in fresh Italian food, come and visit La Dolce Vita and try our Early Bird Menu for only €18.95!

Free Hernia Consultation with Mr.John Scurr Cons.Surgeon

Currently we are offering a Free hernia consultation with Mr.John Scurr Consultant General and Vascular Surgeon at our clinic. Mr.Scurr carries out day case hernia surgery at the Beacon Hospital.