Excel Advanced

Discover best practice in the design and deployment of business spreadsheets and hot to create user-friendly, automated spreadsheet solutions designed to be used by others. You will also learn to work with complex formulas and advanced analysis tools.

Snapshot

Duration: 1 day

Version: 2010, 2013, 2016

Target Audience: This course will suit you if you are an experienced Excel user who will be creating spreadsheet templates or automated solutions for others in the organisation to use.

Prerequisites: Successful completion of a MCI Solutions Access Intermediate course or equivalent.

Learning outcomes

At the end of this program you will be able to:

  • Use Link formulas
  • Consolidate data
  • Use Data Validation and Auditing tools
  • Protect worksheet data
  • Automate routine tasks with Macros
  • Use Logical, Lookup, Financial and Text Functions
  • Use Goal Seek, Scenario Manager and Solver

Upcoming Sessions

Date Time (AEDT) Location Available Spaces Cost
27 September 2022 09:00 am - 04:45 pm Level 4, 23 Hunter St SYDNEY, NSW 2000 10 $450.00
8 November 2022 09:00 am - 04:45 pm Level 4, 23 Hunter St SYDNEY, NSW 2000 9 $450.00
8 November 2022 09:00 am - 04:45 pm Level 4, 23 Hunter St SYDNEY, NSW 2000 10 $450.00