Home Events Microsoft Excel Advanced : 24th January

Microsoft Excel Advanced : 24th January

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.

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

Event Details

Dates
24 January 2019
Venue
Olas Training Facilities in Sandyford, Dublin 18
Contact Phone
01 279 0020
Contact Email

More Information

The objective of this Excel training 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.

Participants should be existing users of MS Excel.  They should be able to create, edit and manipulate spreadsheets containing formulae 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).

UPON COMPLETION, 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

After Work Friday at Capitol

2 for 1 on 22 cocktails from the "Capitol Cocktails" list from 5-8pm.

Gin O'Clock Sunday

Gin & Tonic specials every Sunday at Capitol