Contactar Esade

Empowering Excel (CK11024)

General information

Type:

OP

Curs:

1

Period:

S semester

ECTS Credits:

2 ECTS

Teaching Staff:

Group Teacher Department Language
Ed: 1 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences ENG

Group Teacher Department Language
Ed: 2 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences ENG

Group Teacher Department Language
Ed: 3 Josep Lluís Cano Giner Operaciones, Innovación y Data Sciences ENG

Group Teacher Department Language
Ed: 4 Josep Lluís Cano Giner Operaciones, Innovación y Data Sciences ENG

Prerequisites

There are no prerequisites.

Previous Knowledge

Basic knowledge of Excel spreadsheet; especially the working environment and the different commands and basic functions.

COURSE CONTRIBUTION TO PROGRAM

With over 500 million Excel users worldwide, only a small percentage of them knows beyond the basic features.

We aim to overcome that barrier and reach an advanced level that surely will provide you a competitive advantage over other candidates or colleagues.

Course Learning Objectives

The course aims to provide knowledge and skills on how to develop business models with MS Excel to create simulation models, models for data analysis or end-user applications, at a high level.

CONTENT

1. Import data into Excel.

2. Understanding Excel range references (absolute, relative, mixed and names).

3. Modelling: identification and use of dependent and independent variables; model parameterization.

4. Excel functions: financial, text and search functions.

5. Introduction to charts.

6. Data tables (sensitivity analysis).

7. Conditional formats.

8. "What if" Analysis Tools: Scenarios, Goal Seek and Solver.

9. Recording Macros.

10. Introduction to the use of controls.

11. Advanced charts.

12. Audit of a model.

13. Protection of a model.

14. Circular references.

15. Databases in Excel: table sorting, filters, PivotTables and PivotCharts.

16. Creating a working interface for end-user application.

17. Macros with VBA programming.

18. Managing risk in a model.

Methodology

Participative classes. Students will acquire the knowledge about the tool through the development of a set of cases. The required theoretical concepts will be introduced when needed.

Assessment criteria

Attendance and participation in class (25%).
Students delivered before the next session a summary / commentary on the same (25%).
Final work: an application showing the teachings of the course (50%).

Bibliography

Further reading:

Walkenbach, John. (2015): Excel 2016 Bible. John Wiley & Sons, Inc. ISBN-13: 978-1119067511
Jelen , Bill; Syrstad, Tracy. (2015): Excel 2016 VBA and Macros. Pearson Education, Inc. ISBN-13: 978-0789755858
Michael Alexander, Richard Kusleika. (2016): Excel 2016 Power Programming with VBA. John Wiley & Sons, Inc. ISBN-13: 978-1119067726

Timetable and sections

Group Teacher Department
Ed: 1 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences

Timetable Ed: 1

From 2019/1/7 to 2019/1/11:
From Monday to Friday from 9:30 to 13:00.

Group Teacher Department
Ed: 2 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences

Timetable Ed: 2

From 2019/1/14 to 2019/1/18:
From Monday to Friday from 9:30 to 13:00.

Group Teacher Department
Ed: 3 Josep Lluís Cano Giner Operaciones, Innovación y Data Sciences

Timetable Ed: 3

From 2019/1/21 to 2019/1/25:
From Monday to Friday from 9:30 to 13:00.

Group Teacher Department
Ed: 4 Josep Lluís Cano Giner Operaciones, Innovación y Data Sciences

Timetable Ed: 4

From 2019/1/28 to 2019/2/1:
From Monday to Friday from 9:30 to 13:00.