This course will focus on advanced spreadsheet features and modelling with Excel. We will use a “learn by doing” modular approach with real life examples. At the end of the course, students should be able to:

• Use advanced conditional formatting and data validation
• Use advanced functions and formula including array functions
• Master Goal Seek, Solver, Tables, Scenarios and Pivot Tables
• Create and Edit Macros
• Create Models that are easy to navigate and use them to assist your decision making process

Prerequisites: Yes (see syllabus)