Receive a Course Pre-Quote by Email
Let a Sales Advisor Contact You by Email
Temarios Cursos- Inglés
Receive complete information in your email!
OBJECTIVE:
Knowing what Macros are and what can be done with them.
BASIC COURSE INFORMATION:
ADDRESSED TO:
People with advanced Excel knowledge.
AGENDA
Find function
Pivot tables
Introduction to Macros
3.1. Setting up the Macro Developer environment
3.2. Macro Security
Use Relative References
Record Macros
Create Simple Applications with Macros
Objects and Methods
VB code
Create variables, constant
IF, ELSE
Create Custom Roles
Automate repetitive tasks with Macros
12.1. Import data from database or file
12.2. Generate a report on the imported information.
Assign Buttons to Macros
Add buttons to trigger Environment Macros
Create applications with Form controls
Develop custom functions
Use Active x buttons
Use User Form
Application with User Form
Create Loop, While loops
Create Power Point documents using an Excel database
BENEFITS
- A diagnosis test will be applied to measure the audience knowledge.
- A guide will be given.
- The course includes practices for each subject.
- A test will be applied at the end of the course.
