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.