Course Information
- 27 Aug 2024 (Tue) - 28 Aug 2024 (Wed)
(Enrolling this course on or before 14th February can receive early bird discount of $200
)
Course Overview
This Excel VBA training course , VBA is commonly known as Macros, will teach users how to automate the Excel’s boring and repetitive work without human intervention. The training course will cover a wide range of concepts and techniques which are applicable to most daily spreadsheet task. Topics include the basic concepts of VBA programming, language syntax, controlling program flow, working with Excel’s objects and properties, looping over collections, creating custom functions, designing userforms, working with PivotTables and more.
The easy to follow exercises and small class size teaching approach can ensure the best learning result. It is an ideal course for people working in the accounting, financial analysis and data processing areas. Students can choose the daytime, evening and weekends classes to suit their learning needs.
Objectives
After finishing the course, you will be able to write your own VBA to streamline the daily tasks which include the following :
- Merging tables from different workbooks or worksheets into one single table
- Generating PivotTables unattended with the designated rows and columns and filter the table
- Comparing and highlighting data dissimilarities of two tables
- Performing data lookup and filling
- Data cleansing and analysis
- Generating reports
- Formatting reports and tables
- Designing data entry forms
- Validating data through data entry forms
What you will get after the class
- Hard copy of codes used in the class
- Code and data files
- Ready to use VBA snippets
- Video account for lessons revision
What You’ll Learn
- Recording macros and using buttons
- VBA Programming Basics
- The VBA code editor
- Range's properties and methods
- Other useful object methods
- Messages and variables
- Working with Excel Object Model
- Loops and conditions
- Looping over collections
- Using built-in functions and statements
- Working with UserForms
- Automating Excel PivotTables using VBA