Microsoft Excel VBA Training

Microsoft Excel VBA Training Microsoft Excel VBA Training
By TED Integrated
PSMB HRDF Claimable
Course Title:
Microsoft Excel VBA for Non-Programmers
Training Category:
Information Technology
Target Audience:
Intermediate and advance Microsoft Excel users who want to leverage the power of VBA on their Excel spreadsheet related tasks and improve productivity.
Duration:
2 Days
Public Program* Now Available! »
Jan 2017 ›
Venue:
Binjai 8, KLCC, Kuala Lumpur, Malaysia
Schedule:
Mon 09 Jan 2017 - Tue 10 Jan 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Feb 2017 ›
Venue:
Binjai 8, KLCC, Kuala Lumpur, Malaysia
Schedule:
Wed 22 Feb 2017 - Thu 23 Feb 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Mar 2017 ›
Venue:
Binjai 8, KLCC, Kuala Lumpur, Malaysia
Schedule:
Mon 13 Mar 2017 - Tue 14 Mar 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Apr 2017 ›
Venue:
TED Integrated, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Thu 06 Apr 2017 - Fri 07 Apr 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
May 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Thu 25 May 2017 - Fri 26 May 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Jun 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Wed 07 Jun 2017 - Thu 08 Jun 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Jul 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Wed 19 Jul 2017 - Thu 20 Jul 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Aug 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 14 Aug 2017 - Tue 15 Aug 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Sep 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 18 Sep 2017 - Tue 19 Sep 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Oct 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 16 Oct 2017 - Tue 17 Oct 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Nov 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Thu 16 Nov 2017 - Fri 17 Nov 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Dec 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Thu 14 Dec 2017 - Fri 15 Dec 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
For In-house Training »
Request for Quotation Request for Quotation
For Customization & Other Inquiries »
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service training@ted.com.my
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Presentation Handouts
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions
Microsoft Excel Training Series:

Microsoft® Excel VBA for Non-Programmers

“Add powerful automation to your Microsoft Excel spreadsheet without programming knowledge!”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service training@ted.com.my Contact Customer Service+603-2386-7788

Introduction

This Microsoft Excel course demonstrates how you can use a combination of Microsoft Excel and VBA to increase your productivity, adding power and flexibility to spreadsheets, automate processes and improve user interaction. It requires intermediate to advance knowledge of Microsoft Excel for participants to attend this course. Programming knowledge, however, is NOT required.

This Microsoft Excel VBA training course is designed for users who wish to learn how to use the built-in macro programming language in Microsoft Excel to enhance their worksheets and automate processes to increase productivity.

Prerequisites

Intermediate to advance knowledge of Microsoft Excel is required.

Course Objectives

Upon completion of this Microsoft Excel VBA training course, participants should have learned Microsoft Excel VBA sufficiently to be able to:

  • Create recorded macros in Microsoft Excel
  • Use the macro recorder to create a variety of macros
  • Understand the Microsoft Excel object model and VBA concepts
  • Create command procedures
  • Create and use variables
  • Write code to manipulate Microsoft Excel objects
  • Use a range of common programming techniques

Course Outline

DAY 1

Recorded Macros

  • Understanding Microsoft Excel macros
  • Setting macro security
  • Saving a workbook as a macro enabled workbook
  • Recording a simple macro
  • Running a recorded macro
  • Viewing a macro
  • Editing a macro
  • Running a macro from the toolbar
  • Assigning a keyboard shortcut to a macro
  • Tips for developing macros

Recorder workshop

  • Preparing data for an application
  • Recording a macro that updates opening balances
  • Recording a macro to open text files
  • Creating objects to run macros
  • Assigning a macro to an object

Understanding VBA

  • VBA terminology
  • About objects
  • Accessing the Microsoft Excel object model
  • Using the immediate window
  • Working with object collections
  • Setting property values
  • Working with worksheets
  • Using the object browser

Using the VBA editor

  • The VBA editor
  • Opening and closing the editor
  • Working with the project explorer
  • Working with the properties window
  • Working with a code module
  • Stepping through a procedure

DAY 2

Procedures

  • About procedures
  • Creating a command procedure
  • Making sense of intellisense
  • Using the edit toolbar
  • Commenting statements
  • Indenting code

Using variables

  • Understanding variables
  • Creating and using variables
  • The scope of variables
  • Procedure level scoping
  • Module level scoping
  • Passing variables by reference
  • Passing variables by value
  • Data types
  • Declaring data types

Using Microsoft Excel objects

  • Application methods and properties
  • Workbook methods and properties
  • Viewing Microsoft Excel and the editor together
  • Using workbook objects
  • Worksheets methods and properties
  • Using worksheet objects
  • Range methods and properties
  • Using range objects
  • Using objects in a procedure

Programming techniques

  • The msgbox function
  • Sending messages to the user
  • Inputbox techniques
  • Using the inputbox function
  • Using if for multiple conditions
  • Looping with known or specified iterations
  • The do...loop statement
  • Looping with unknown iterations

For In-house Training:

Request for Quotation

Request for Quotation Now

For Content Customization & Other Inquiries:

Contact TED Integrated

Contact Customer Service

+603-2386-7788

Email Customer Service training@ted.com.my

Ad by Google

Related Training Courses:

More Other Training Courses:

Published by: ,