Contactar Esade

Excel: Discovering the power of VBA (CK15886)

General information

Type:

 OP

Curs:

 1

Period:

 S semester

ECTS Credits:

 3 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

Prerequisites

There are no prerequisites.

Previous Knowledge

General knowledge of Excel spreadsheet with experienced user level.

COURSE CONTRIBUTION TO PROGRAM

Excel Programming with VBA provides students with capabilities that exceed those of most Excel users (including those who have completed different Master programs), being able to develop models and applications that would be impossible otherwise.

Course Learning Objectives

This is an introductory programming course that will enable students to develop Excel applications to a level above the average; both for own use and for third parties.

CONTENT

1. Introduction.

2. Recording basic macros.

3. Recording advanced macros.

4. Object-oriented programming.

5. Excel Data Model.

6. Developing applications in Excel.

7. Development environment (VBE).

8. Creating procedures.

9. Creating functions.

10. Working with forms.

11. Developing user-oriented applications.

Methodology

Participatory classes, where through the development of a set of cases the students are acquiring knowledge about the tool. The necessary theoretical concepts are introduced as they are needed.

Assessment criteria

Attendance and participation in class (25%).
Students will deliver a summary / commentary of each session (25%).
Final work: an application showing the teachings of the course (50%).

Bibliography

Further reading:
Jelen, Bill; Syrstad, Tracy. (2016): Excel 2016 VBA and Macros. Pearson Education, Inc. ISBN-13: 978-0789755858
Walkenbach, John. (2016): Excel 2016 Power Programming with VBA. John Wiley & Sons, Inc. ISBN-13: 978-1119067726
Bovey, Rob; Wallentin, Dennis; Bullen, Stephen; Green, John: Professional Excel Development (2009): The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) 2nd Edition. Pearson Education, Inc. ISBN-10: 0321508793

Timetable and sections

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

Timetable Ed: 1

From 2019/4/26 to 2019/6/21:
Each Friday from 8:45 to 11:45. (Except: 2019/6/7)

Friday 2019/6/7 from 8:00 to 11:00.

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

Timetable Ed: 2

From 2019/4/26 to 2019/6/21:
Each Friday from 12:00 to 15:00. (Except: 2019/6/7)

Friday 2019/6/7 from 11:00 to 14:00.