Microsoft Excel VBA Training

  • Course Delivery

Classroom Training

  • 2 days
  • Advanced
  • Difficulty Level
Moderate
  • Pre-requisite

Familiarity with Microsoft Excel.

Course Overview

Visual Basic for Applications (VBA) is a programming language for Excel to program spreadsheets to respond to new data. Participants will learn how to create filters on chaining and combining filter criteria in this excel VBA training. Training in Excel VBA improves the ability to calculate data through the built-in function of Excel.By having excel VBA skills, processing data in Excel will easily automates routine tasks and creating charts with sparklines.

Among the advantages of practicing VBA in Microsoft Excel Macro are useful strategies that shows students how to function in this powerful spreadsheet program more effectively. VBA also allow to add user-friendly variables and reduces formulas burden used in Excel reports.

What you will learn?

Check out  what you can do with Visual Basic in Microsoft Excel. 

Steps to Your First Macro Recording

Examples to Excel tools you can create using VBA.

Role of Assignment & Variables and Declaring Variables, Arrays & Constants (Role of Option Explicit)

Why Collections are a VBA Essential, IF Then (Else, ElseIF) for Conditional Outcomes and Select Case as Alternative for Many IF Statements

 

Looping in VBA:

1. For Next Counter Loops

2. For Next Nested Loop (Loop through Text & Cells)

3. For Next Reverse Loop (Delete Filtered/Hidden Rows)

Debugging, Handling Errors & Procedure Scope:

1. Debugging Options: Watch, Locals, Immediate Windows & More

2. Error Handling: Different Methods

UserForms & ActiveX Controls

Working with Folders & File:

1. Create CSV File from Data in Excel

2. GetOpenFileName Method: User Selects a File

Working with Arrays in VBA:

1. One Dimensional Arrays (and transferring back to sheet)

2. Dynamic Arrays (size adjusts depending on a condition)

3. Variant Arrays: Quick Method to Write to Cells

 

Key Take Away

Making awesome Excel workbook requires a good understanding of Excel features such as Power Query ( Get & Transform Data), tables, cell, styles and formatting options.

  • Creating filters
  • Determining whether workbooks and worksheets exist, with VBA
  • Using VBA to calculate data via Excel's built-in functions
  • Adding fields to UserForms
  • Chaining and combining filter criteria
  • Opening, closing, and saving workbooks
  • Creating charts with sparklines

What You Will Get

Guidebook

Complete step by step latest guidebook

Support

Free chat support for 1 year

Certificate

Certificate of Completion provided

LMS

Online learning with step by step videos

Public Training

Clients can attend the training at our computer lab based on the given date. Pay per person.

Date: Refer to our training calendar

Venue: Computer Lab, MU DOT MY PLT (Subang Jaya)

Syllabus: Predefined course contents

In-House Training

Conduct this training at your office anytime, anywhere. No limit on number of participants. Just pay per day!

1. Unlimited participants

2. Training date can be chosen by your company

3. Training content can be personalized

Register Now

Improve your skills and develop your career by joining our training now!

HRDF and MOF

HRDF Claimable
MOF No: 357-02240271
Catalogue ID : 80141607

Get A Quote Now / Request Brochure

Still have questions? Check out our FAQ section or fill up enquiry form.
Our marketing ninja’s will get in touch with you.

[[[["field4","equal_to","In-House Training"]],[["hide_fields","field7"]],"and"]]
1 Step 1
Name
accessibility
Phone
call
Company / Agency
card_travel
No of People
local_grocery_store
Comments / Enquiry
0 /
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right

Pre-requisite

To learn Excel VBA training requires basic knowledge of Microsoft Excel. Join our Microsoft Excel Advanced Training to master the techniques of Excel from basic to advanced.

Online Register

Coming soon in 2020. Drop us an email for the latest updates.