Excel: Discovering the power of VBA

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. Students will work with their own laptops in class using a remote desktop environment.

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.

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

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

Excel: Discovering the power of VBA (19CI15886)