This course is designed for people who want to learn how to create applications with Microsoft Excel using VBA code extensively. We will briefly review concepts related to application development and familiarize ourselves with the elements of the Project Explorer, which we will use throughout the course.
The course continues with an introduction to the elements of the VBA language, ranging from the use of variables, data types, and control structures used in VBA routines to working with Sub Procedures and Functions. Students will learn how to create dialog boxes using User Forms, as well as how to use controls and events, and will conclude by accessing and manipulating data in a database.
Overall Objective
Design and develop macros in MS Excel using the features of the Project Explorer.
Thematic Block
1. Introduction to VBA
2. Variables
3. Flow Control Structures
4. User-Defined Functions (UDFs)
5. Arrays, User-Defined Data Types (Type Statement), Dynamic Memory Management
6. Class-Based Programming (Class Module)
7. Implementing Collections (Collection Object)
8. Error Handling (On Error Statement)
9. Advanced Form Handling, Including Record Updates
10. Implementing Pivot Tables with VBA
11. Database Integration, Accessing External Databases (MS Access)
Intended for
Students enrolled in engineering programs and professionals working in the economic sector—primarily in data management—who have intermediate-level knowledge of MS Excel, basic mathematical and logical skills, and advanced programming concepts.
Certifications
- Certificate: INFOPUCP will issue a digital certificate to participants who earn a passing grade of 11 or higher.
- Certificate of Participation: INFOPUCP will issue a certificate of participation to students who earn a grade of 10 or lower and who have participated in all graded course activities.
Economic Investment
S/ 399.00
Special Discounts
- PUCP Community: Staff, Alumni, Undergraduate and Graduate Students: S/ 299.00
- Undergraduate student at another university: S/ 309.00
Teachers
Jayro Guerreros Echia
A mechatronics engineer from the Pontifical Catholic University of Peru with an interest in STEM education and promoting programming for all. Winner of the Mechatronics Project Fair organized by the PUCP for his mechatronics design project. He currently designs and develops robotics courses for various departments at the university and teaches classes.
More information
Similar courses
eXential 2022 Short Courses | CENTRUM PUCP
Course in Warehouse and Inventory Management
Workshop on Charts and Pivot Tables in Excel
Subject area:
22
Organized by:
Infopuc - Institute of Computer Science
Headquarters:
Main Campus - 1801 Av. Universitaria, San Miguel, Lima
Language:
1
State:
0115