Excel for Business Applications 2020/2021
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 (1) to exploit advanced spreadsheet operations like summarizing, reporting, and analyzing business data (2) to build analytic models to increase profits, reduce costs, or manage operations more efficiently (3) to save time (i.e. being able to achieve good results in less time). This course is designed for (1) Management Engineering students enrolled at the first or second year of the Master degree (Laurea Magistrale in Ingegneria Gestionale) (2) Management Engineering students enrolled at the third year of the Bachelor degree (Laurea in Ingegneria Gestionale) (3) Business students enrolled at the first or second year of the Master degree (Laurea Magistrale in Economia Aziendale) 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.