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
Download course outline

Upcoming Sessions

There are currently no openings available for this course.
Please enquire using the button below.

Enquire