N90350 Excel for Business Applications

At the end of the course students will be able to use MS Excel to model and solve typical business problems.

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)

1. Introduction to MS Excel
2. Range & LookUp functions
3. Modellization and solution of typical financial problems
4. Goal seek and Sensitivity analysis
5. Scenario analysis
6. Optimization (Solver)
7. Introduction to VBA and macro programming

The course is fully based on practical lessons in computer laboratory to apply the methodoligies to actual problems.

Evaluation is based on different assignments, written test and practical solution of given problems.