N90350 Excel for Business Applications

Scuola di Ingegneria Industriale
Syllabus
Academic Year 2016/17 First Semester

foto
Docente TitolareGiacomo Buonanno
E-mailbuonanno@liuc.it
Office"Torre" (main tower), 2nd floor
Phone0331 572323

Learning Objectives

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

Learning targets

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)

Course Content

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 and Sensitivity analysis
  5. Scenario analysis
  6. Optimization (Solver)
  7. Introduction to VBA and macro programming

Course Delivery

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

Course Evaluation

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


in order to have access to the complete syllabus please enter on the student self service