Key Principles for Planning and Designing Dynamic Excel Files
October 13, 2014 | 09:00 - October 13, 2014 | 18:00
Vacoas-Phoenix, 1st Floor, The Hub, Industrial Zone, Phoenix, Mauritius
Vacoas-Phoenix, 1st Floor, The Hub, Industrial Zone, Phoenix, Mauritius
Organized by: Nuclei
Contacts: (230) 601 28 28
Contacts: (230) 601 28 28
This course is designed to enable you to develop good Microsoft Excel Model. Modelling is an essential skill for Ms Excel Users. Unfortunately, Excel users follow time-consuming trial and error approaches to modelling and end up with models that are not sufficiently flexible and powerful. This course presents a comprehensive approach for developing simple to sophisticated models.
Duration: 6 hours
Level: All levels
Target Audience: Personnel at all levels/IT Administrators
Prerequisite: Participants should have a basic knowledge of Microsoft Excel
Course Outline
Part 1 – Introduction to Modelling
- What is Modelling?
- My assumptions about you and users of your model
- Excel and VBA as Modelling Tools
- Independent and Dependent Variables
Part 2 – How to Build Good Excel Models
- Steps in creating a model
- Attributes of a Good Excel Model
- Common ways to document a model
- Debugging Excel Model
- Errors you will have to find yourself
Part 3 – Practicals
- Steps and Attributes of a Model
- Types of Errors
- Designing a Model for a Dance Competition