Microsoft Excel VBA Macro Programming (2010/2013) 2017-09-15T14:03:50+00:00

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 Professional Recognition

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 with the course Microsoft Access for Beginners.

Course Fee

$2460

Course Duration

12 Hours

Course Prerequisites

Course participants are expected to have a basic knowledge in 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
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
EEM6-51C17K
 Mongkok
 Cantonese / PC
20/11~1/12
1900-220012 hrs/
4 sessions
MON, FRI2,460.00
EEM6-6D44E
 Central
 English / PC
2/12~9/12
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-6D2K
 Mongkok
 Cantonese / PC
2/12~9/12
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-24C34C
 Central
 Cantonese / PC
5/12~14/12
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
EEM6-17121C
 Central
 Cantonese / PC
18/12~19/12
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
EEM6-24C2E
 Central
 English / PC
2/1~11/1
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
EEM6-42C4K
 Mongkok
 Cantonese / PC
4/1~16/1
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
EEM6-18011K
 Mongkok
 Cantonese / PC
4/1~5/1
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,460.00
EEM6-6D33C
 Central
 Cantonese / PC
6/1~13/1
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-25C23C
 Central
 Cantonese / PC
23/1~2/2
1900-220012 hrs/
4 sessions
TUE, FRI2,460.00
EEM6-6D3E
 Central
 English / PC
3/2~10/2
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-6D10K
 Mongkok
 Cantonese / PC
10/2~24/2
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-18021C
 Central
 Cantonese / PC
12/2~13/2
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
EEM6-35C33K
 Mongkok
 Cantonese / PC
21/2~2/3
1900-220012 hrs/
4 sessions
WED, FRI2,460.00
EEM6-14C27E
 Central
 English / PC
26/2~8/3
1900-220012 hrs/
4 sessions
MON, THU2,460.00
EEM6-6D3C3C
 Central
 Cantonese / PC
3/3~10/3
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-13C12C
 Central
 Cantonese / PC
12/3~21/3
1900-220012 hrs/
4 sessions
MON, WED2,460.00
EEM6-6D17C
 Central
 Cantonese / PC
17/3~24/3
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-18031K
 Mongkok
 Cantonese / PC
19/3~20/3
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
EEM6-6D54E
 Central
 English / PC
7/4~14/4
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-13C9K
 Mongkok
 Cantonese / PC
9/4~18/4
1900-220012 hrs/
4 sessions
MON, WED2,460.00
EEM6-18041C
 Central
 Cantonese / PC
10/4~11/4
0930-1230
1400-1700
12 hrs/
4 sessions
TUE, WED2,460.00
EEM6-53C13E
 Central
 English / PC
13/4~25/4
1900-220012 hrs/
4 sessions
WED, FRI2,460.00
EEM6-6D14K
 Mongkok
 Cantonese / PC
14/4~21/4
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-42C3C
 Central
 Cantonese / PC
3/5~15/5
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
EEM6-18051K
 Mongkok
 Cantonese / PC
14/5~15/5
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
EEM6-52C25K
 Mongkok
 Cantonese / PC
25/5~5/6
1900-220012 hrs/
4 sessions
TUE, FRI2,460.00
EEM6-6D64E
 Central
 English / PC
2/6~9/6
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-24C12E
 Central
 English / PC
12/6~21/6
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
EEM6-18061C
 Central
 Cantonese / PC
21/6~22/6
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,460.00
EEM6-6D23K
 Mongkok
 Cantonese / PC
23/6~30/6
0900-1200
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-13C25C
 Central
 Cantonese / PC
25/6~9/7
1900-220012 hrs/
4 sessions
MON, WED2,460.00
EEM6-41C12K
 Mongkok
 Cantonese / PC
12/7~23/7
1900-220012 hrs/
4 sessions
MON, THU2,460.00
EEM6-18071K
 Mongkok
 Cantonese / PC
23/7~24/7
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
EEM6-52C3E
 Central
 English / PC
3/8~14/8
1900-220012 hrs/
4 sessions
TUE, FRI2,460.00
EEM6-6D74E
 Central
 English / PC
4/8~11/8
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-52C17C
 Central
 Cantonese / PC
17/8~28/8
1900-220012 hrs/
4 sessions
TUE, FRI2,460.00
EEM6-18081C
 Central
 Cantonese / PC
20/8~21/8
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
EEM6-6D25K
 Mongkok
 Cantonese / PC
25/8~1/9
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
EEM6-25C28K
 Mongkok
 Cantonese / PC
28/8~7/9
1900-220012 hrs/
4 sessions
TUE, FRI2,460.00
EEM6-18091K
 Mongkok
 Cantonese / PC
20/9~21/9
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,460.00
EEM6-42C27E
 Central
 English / PC
27/9~9/10
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
EEM6-18101C
 Central
 Cantonese / PC
9/10~10/10
0930-1230
1400-1700
12 hrs/
4 sessions
TUE, WED2,460.00
EEM6-18111K
 Mongkok
 Cantonese / PC
8/11~9/11
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,460.00
EEM6-18121C
 Central
 Cantonese / PC
20/12~21/12
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,460.00
Microsoft Excel 2013 Macro Programming with VBA
Complete your Enrol
How to enrol/pay online

 

 

COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
THERE IS NO AVAILABLE COURSE AT THE MOMENT!
Microsoft Excel 2010/2007 VBA Macro Programming
Complete your Enrol
How to enrol/pay online

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. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

You may also be interested in