Excel for Business Applications 2024/2025

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 Business students enrolled in 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)
The course is fully based on practical lessons in a computer laboratory to deal with actual problems.