Why join the workshop?
This course teaches participants how to use macros to automate their daily tasks in MS Excel. They will also be taught how to enhance automation through Visual Basic for Application (VBA) which is a programming language used by the MS Office suite.
Knowledge of this skill ultimately simplifies reports by creating modules that would execute spreadsheet tasks in just one click! This saves the company time,from tedious and manually-completed reports.
This course is applicable to MS Excel 2007, 2010, 2013, and 2016.
At the end of the workshop, the participants will be able to:
Identify advanced MS Excel functions and their usage
Combine Basic MS Excel functions with advanced functions in order to address more complex scenarios
Simplify common spreadsheet tasks using MS Excel data management tools
Create basic and special charts using MS Excel
Use advanced features of Pivot Tables in order to analyze data
Create macro recordings to automate tasks in MS Excel
Who Should Attend:
The workshop is ideal for advanced users of MS Excel who wish to expand their knowledge of Excel with VBA in order to automate tasks. Also for employers working with large amounts of data using the application, and those who want to learn how to automate reports.
The workshop follows a specific course outline. The topics are as follows:
B. Introduction to VBA
Defining the Properties
C. Programming Basics
D. Control Structures
For, Next Loop
For Each, Next Loop
Do Until, Loop
E. Creating Your Own Functions
F. Creating UserForms and UserForm Events
G. Handling VBA Module Errors
*Program fee is PHP 11,800 + VAT
Aug 28 - 29, 2019