N90350 Excel for Business Applications

Scuola di Ingegneria Industriale
Syllabus
Academic Year 2018/19 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.

Syllabus

Session 1
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Introduction to MS Excel - basic functions

Readings:

Session 2
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Range & lookup functions

Readings:

Session 3
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Index & match functions

Readings:

Session 4
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Text & Dates functions

Readings:

Session 5
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Basic financial functions (NPV, IRR, ...)

Readings:

Session 6
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Management of circular references - IF based functions - Audit

Readings:

Session 7
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Sensitivity Analysis

Readings:

Session 8
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Goal Seek & Scenario Comparisons

Readings:

Session 9
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Usage of Offset & Indirect functions

Readings:

Session 10
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Conditional formatting

Readings:

Session 11
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Optimization

Readings:

Session 12
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Solver [1/2]

Readings:

Session 13
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Solver [2/2]

Readings:

Session 14
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Introduction to macro recording and VBA programming [1/2]

Readings:

Session 15
Hours of lesson: 2
Instructor: G. Buonanno

Topics:

Introduction to macro recording and VBA programming [2/2]

Readings:


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