Home Events Microsoft Excel Advanced : 30th August

Microsoft Excel Advanced : 30th August

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
30 August 2018
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

Concerned regarding Thread or Varicose Veins, have a Free Vascular Nurse Consultation

The most modern methods of diagnosis and management of vein disorders are used in the Vein Clinic.

Porsche Top Team Rally Challenge

Add a little competition to your day out with your mates by choose our Porsche Top Team Rally Challenge. It's all up for grabs but who will come out on top and win the stage in our Porsche 911?