At the end of the course, students will be able to use MS Excel to model and solve typical business problems. They will be able to exploit advanced spreadsheet operations like summarizing, reporting, and analyzing business data building analytic models to increase profits, reduce costs, or manage operations more efficiently save time (i.e. being able to achieve good results in less time).
The course is organized into the following parts:
1. Introduction to MS Excel
2. Range & LookUp functions
3. Modellization and solution of typical financial problems
4. Goal seek, Scenario and Sensitivity analysis
5. Optimization (Solver)
6. Introduction to VBA and macro programming
The course is fully based on practical lessons in a computer laboratory to deal with actual problems.