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.
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.
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
There are currently no openings available for this course.
Please enquire using the button below.