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! »
Jun 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Wed 19 Jun 2019 - Thu 20 Jun 2019
9:00AM - 5:00PM

Fee Per Person:
RM1,590.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Jul 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 15 Jul 2019 - Tue 16 Jul 2019
9:00AM - 5:00PM

Fee Per Person:
RM1,590.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Aug 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 19 Aug 2019 - Tue 20 Aug 2019
9:00AM - 5:00PM

Fee Per Person:
RM1,590.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Sep 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Thu 19 Sep 2019 - Fri 20 Sep 2019
9:00AM - 5:00PM

Fee Per Person:
RM1,590.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Oct 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 21 Oct 2019 - Tue 22 Oct 2019
9:00AM - 5:00PM

Fee Per Person:
RM1,590.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

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

Fee Per Person:
RM1,590.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Dec 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 23 Dec 2019 - Tue 24 Dec 2019
9:00AM - 5:00PM

Fee Per Person:
RM1,590.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
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: ,
Contact Us

"Hi, I'm your Contact Assistant! I'll help you to reach the right party for the right information. Click me to get started!"

Contact Assistant