Project Description

Loading...

Welkin Course Codes: EEM5, EEM6

Course Features

VBA (Visual Basic for Applications) is the built-in macro programming language in Microsoft Office applications. VBA in Excel can help automate the work of your spreadsheets and make available functions that are not usually found on Excel menus or toolbars. You may have been capable in dealing with Excel Functions, Charts, Pivot Tables, etc, but when it comes to routine tasks such as repetitive formatting or moving data, you will find your work tedious and inefficient. VBA solves the problem by allowing you to automate routine tasks the way you want it to, making your life easier and your work more productive. You will learn:

  • Using Macro recorder to create macros for task automation
  • Using VBA to control Workbooks, Worksheets, Ranges, and Cells
  • The best practice of coding VBA programs
  • Creating custom formulas
  • Creating complex decision-making criteria to process data
  • Creating validation functions to ensure source data is correct
  • Using worksheet functions to simplify and empower your VBA programs
  • Handling a dynamic range based upon user input or data content
  • Processing records in dynamic size data tables
  • Using VBA to generate PivotTable reports automatically
  • Using user forms and controls to create customized software interface
  • Distribution issues such as Macro file types and security
  • Basic VBA program diagnostics techniques

Learn from the Experts

Get Your Skills Certified

mos-certificate
Certify your Excel skills with Microsoft Office Specialist Excel certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.
Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills in Microsoft Excel with the course Business Analysis with Microsoft Excel.

Course Fee

$2600

Course Duration

12 Hours

Course Prerequisites

Course participants are expected to have a basic knowledge of Microsoft Excel.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement for the course.

Schedule & Online Enrolment
Enquiry/Booking
Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Microsoft Excel 2013 Macro Programming with VBA
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
EEM6-52C28CCantonese / PC / Central25-Oct05-NovFRI,TUE1900-220012 hours / 4 sessions20191025

$2,600Enrol

EEM6-41C13KCantonese / PC / MongKok07-Nov18-NovTHU,MON1900-220012 hours / 4 sessions20191107

$2,600Enrol

EEM6-6D33KCantonese / PC / MongKok09-Nov16-NovSAT1000-1300;1400-170012 hours / 4 sessions20191109

$2,600Enrol

EEM6-19111KCantonese / PC / MongKok11-Nov12-NovMON,TUE0930-1230;1400-170012 hours / 4 sessions20191111

$2,600Enrol

EEM6-14C34EEnglish / PC / Central02-Dec12-DecMON,THU1900-220012 hours / 4 sessions20191202

$2,600Enrol

EEM6-6D24EEnglish / PC / Central07-Dec14-DecSAT1000-1300;1400-170012 hours / 4 sessions20191207

$2,600Enrol

EEM6-35C30CCantonese / PC / Central11-Dec20-DecWED,FRI1900-220012 hours / 4 sessions20191211

$2,600Enrol

EEM6-19121CCantonese / PC / Central17-Dec18-DecTUE,WED0930-1230;1400-170012 hours / 4 sessions20191217

$2,600Enrol

EEM6-6D22CCantonese / PC / Central21/1228/12SAT1000-1300;1400-170012 hours / 4 sessions20191221

$2,600Enrol

EEM6-15C1KCantonese / PC / MongKok23/1203/01MON,FRI1900-220012 hours / 4 sessions20191223

$2,600Enrol

EEM6-6D34KCantonese / PC / MongKok04/0111/01SAT1000-1300;1400-170012 hours / 4 sessions20200104

$2,600Enrol

EEM6-35C1EEnglish / PC / Central22/0105/02WED,FRI1900-220012 hours / 4 sessions20200122

$2,600Enrol

EEM6-24C1CCantonese / PC / Central04/0213/02TUE,THU1900-220012 hours / 4 sessions20200204

$2,600Enrol

EEM6-24C21KCantonese / PC / MongKok18/0227/02TUE,THU1900-220012 hours / 4 sessions20200218

$2,600Enrol

EEM6-6D39EEnglish / PC / Central22/0229/02SAT1000-1300;1400-170012 hours / 4 sessions20200222

$2,600Enrol

EEM6-6D35KCantonese / PC / MongKok07/0314/03SAT1000-1300;1400-170012 hours / 4 sessions20200307

$2,600Enrol

EEM6-13C30CCantonese / PC / Central23/0301/04MON,WED1900-220012 hours / 4 sessions20200323

$2,600Enrol

EEM6-24C36EEnglish / PC / Central24/0302/04TUE,THU1900-220012 hours / 4 sessions20200324

$2,600Enrol

EEM6-13C34KCantonese / PC / MongKok06/0420/04MON,WED1900-220012 hours / 4 sessions20200406

$2,600Enrol

EEM6-6D41EEnglish / PC / Central02/0509/05SAT1000-1300;1400-170012 hours / 4 sessions20200502

$2,600Enrol

EEM6-6D34CCantonese / PC / Central02/0509/05SAT1000-1300;1400-170012 hours / 4 sessions20200502

$2,600Enrol

EEM6-35C31CCantonese / PC / Central13/0522/05WED,FRI1900-220012 hours / 4 sessions20200513

$2,600Enrol

EEM6-6D31KCantonese / PC / MongKok23/0530/05SAT1000-1300;1400-170012 hours / 4 sessions20200523

$2,600Enrol

EEM6-35C31EEnglish / PC / Central27/0505/06WED,FRI1900-220012 hours / 4 sessions20200527

$2,600Enrol

EEM6-35C78KCantonese / PC / MongKok27/0505/06WED,FRI1900-220012 hours / 4 sessions20200527

$2,600Enrol

In the course you will learn:

  • Using Macro recorder to create macros for task automation
  • Using VBA to control Workbooks, Worksheets, Ranges, and Cells
  • The best practice of coding VBA programs
  • Creating custom formulas
  • Creating complex decision-making criteria to process data
  • Creating validation functions to ensure source data is correct
  • Using worksheet functions to simplify and empower your VBA programs
  • Handling dynamic ranges based upon user input or data content
  • Processing records in dynamic size data tables
  • Using VBA to generate PivotTable reports automatically
  • Using user forms and controls to create customized software interface
  • Distribution issues such as Macro file types and security
  • Basic VBA program diagnostics techniques
  1. Introducing Visual Basic for Applications
    • Getting Some BASIC Background
    • Delving in to VBA
    • Covering the Basics of VBA
    • Introducing the Visual Basic Editor
    • Working with the Project Explorer
    • Working with Code Windows
    • Customizing the VBE Environment
    • The Macro Recorder
    • About Objects and Collections
    • Properties and Methods
    • The Comment Object: A Case Study
    • Some Useful Application Properties
    • Working with Range Objects
    • Things to Know about Objects
  2. VBA Programming Fundamentals
    • VBA Language Elements: An Overview Comments
    • Variables, Data Types, and Constants
    • Assignment Statements
    • Arrays
    • Object Variables
    • User-Defined Data Types
    • Built-in Functions
    • Manipulating Objects and Collections
    • Controlling Code Execution
  3. Working with VBA Sub Procedures
    • About Procedures
    • Executing Sub Procedures
    • Passing Arguments to Procedures
    • Error-Handling Techniques
    • A Realistic Example That Uses Sub Procedures
  4. Creating Function Procedures
    • Sub Procedures versus Function Procedures
    • Why Create Custom Functions?
    • An Introductory Function Example
    • Function Procedures
    • Function Arguments
  1. VBA Programming Examples and Techniques
    • Working with Ranges
    • Working with Workbooks and Sheets
    • VBA Techniques
    • Some Useful Functions for Use in Your Code
    • Some Useful Worksheet Functions
    • Windows API Calls
  2. Custom Dialog Box Alternatives
    • Before You Create That UserForm
    • Using an Input Box
    • The VBA MsgBox Function
  3. Introducing UserForms
    • How Excel Handles Custom Dialog Boxes
    • Inserting a New UserForm
    • Adding Controls to a UserForm
    • Toolbox Controls
    • How Excel Handles Custom Dialog Boxe Adjusting UserForm Controls
    • Adjusting a Control’s Properties
    • Displaying a UserForm
    • Closing a UserForm
    • Creating a UserForm: An Example
    • Understanding UserForm Events
    • Referencing UserForm Controls
    • A UserForm Checklist
  4. Working with Pivot Tables
    • An Introductory Pivot Table Example
    • Creating a More Complex Pivot Table
    • Creating Multiple Pivot Tables
    • Creating a Reverse Pivot Table
  1. Introducing Visual Basic for Applications
    • Getting Some BASIC Background
    • Delving in to VBA
    • Covering the Basics of VBA
    • Introducing the Visual Basic Editor
    • Working with the Project Explorer
    • Working with Code Windows
    • Customizing the VBE Environment
    • The Macro Recorder
    • About Objects and Collections
    • Properties and Methods
    • The Comment Object: A Case Study
    • Some Useful Application Properties
    • Working with Range Objects
    • Things to Know about Objects
  2. VBA Programming Fundamentals
    • VBA Language Elements: An Overview Comments
    • Variables, Data Types, and Constants
    • Assignment Statements
    • Arrays
    • Object Variables
    • User-Defined Data Types
    • Built-in Functions
    • Manipulating Objects and Collections
    • Controlling Code Execution
  3. Working with VBA Sub Procedures
    • About Procedures
    • Executing Sub Procedures
    • Passing Arguments to Procedures
    • Error-Handling Techniques
    • A Realistic Example That Uses Sub Procedures
  4. Creating Function Procedures
    • Sub Procedures versus Function Procedures
    • Why Create Custom Functions?
    • An Introductory Function Example
    • Function Procedures
    • Function Arguments
  1. VBA Programming Examples and Techniques
    • Working with Ranges
    • Working with Workbooks and Sheets
    • VBA Techniques
    • Some Useful Functions for Use in Your Code
    • Some Useful Worksheet Functions
    • Windows API Calls
  2. Custom Dialog Box Alternatives
    • Before You Create That UserForm
    • Using an Input Box
    • The VBA MsgBox Function
  3. Introducing UserForms
    • How Excel Handles Custom Dialog Boxes
    • Inserting a New UserForm
    • Adding Controls to a UserForm
    • Toolbox Controls
    • How Excel Handles Custom Dialog Boxe Adjusting UserForm Controls
    • Adjusting a Control’s Properties
    • Displaying a UserForm
    • Closing a UserForm
    • Creating a UserForm: An Example
    • Understanding UserForm Events
    • Referencing UserForm Controls
    • A UserForm Checklist
  4. Working with Pivot Tables
    • An Introductory Pivot Table Example
    • Creating a More Complex Pivot Table
    • Creating Multiple Pivot Tables
    • Creating a Reverse Pivot Table
  1. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in