This course is designed for people who want to learn how to create applications using Microsoft Excel. To that end, we will begin with a brief review of concepts related to application development and an introduction to the elements of the project explorer, which we will use throughout the course.

Overall Objective

Identify and use the main elements of VBA (Visual Basic for Applications).

Thematic Block

Introduction to VBA
Understanding the Programming Environment
Creating Macros with the Macro Recorder
Using Step-Through and Breakpoints in Code
Using Comments
UDF

VBA Basics
Modules
Variables
Variable Types
Variable Scope
Procedures and Functions

Control Structures
If..then..else
Select..Case
For..Next
Do..Loop
With

Forms
Using Controls
Properties, Methods, and Events
Using Objects

Intended for

Students at the Catholic University, the general public, and undergraduate students from other universities who need to learn about the VBA program.

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/ 391.00

Special discounts:

• PUCP Community: Staff, Alumni, Undergraduate and Graduate Students: S/ 279.00
• Students from other universities: S/ 289.00

Teachers

More information

Similar courses

eXential 2022 Short Courses | CENTRUM PUCP

Start Date: February 21

Course in Warehouse and Inventory Management

Start Date: November 16

Workshop on Charts and Pivot Tables in Excel

Start Date: December 4