Excel VBA Macro Course for Professionals

Physical Training Available

Learn Microsoft VBA Macro Excel Training Course

VBA Excel Training Course: Learn Macro, Formulas, Pivot Tables, Charts, etc and automate your daily Tasks and reports easily.

UTAP

Union Training Assistance Programme

Who Should Attend This VBA Excel Training Course Singapore

VBA excel course Singapore is ideal for those professionals who are already hands-on with advanced features in Microsoft Excel

Training Professionals

Business professionals

Entrepreneur

Students

Why Choose Us

Hands-On Exercises
Attention to each participants
Interactive Class

Step-By-Step Course
100% Satisfactory Record
Trained more than 10000 Participants
20 Year Experienced Trainer

Microsoft VBA Macro Excel Training Course

VBA (Visual Basic for Applications) is the programming language of Excel (and other Office programs), which specifically allow you to automate your repetitive tasks in Excel by writing so called macros.

Upon successful completion of this 3-day hands-on training course, students will be able to:

Record and edit macros
Use the Visual Basic Editor
Create sub and function procedures
Understand objects, properties, methods and events
Explore the Excel object hierarchy and use the Object Browser
Work with variables and understand data types
Use intrinsic functions
Work with control-of-flow structures
Design UserForms and work with controls
Control PivotTables programmatically
Use debugging tools
Add error handling to code

VBA Excel Course Description

Target Student: This course is catered for professionals who are already hands-on with advanced features in Microsoft Excel , looking to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

Prerequisites:

Student should be mastering of Microsoft Office Excel, including but not limited to how to create, edit, format, and print worksheets that include charts and sorted and filtered data and also advanced formulas in Excel (like ifs, vlookup, etc), pivot table, charts.

Master Excel Dashboard Training Course Outlines:

Getting Started with VBA Excel

Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security

Working with Procedures and Functions

Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Working with the Code Editor

Understanding Objects

Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Using the With Statement
Working with Methods
Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions

Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes Declaring and Object Variables

Controlling Program Execution

Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If…End If Decision Structures
Using the Select Case…End Select Structure
Using the Do…Loop Structure
Using the For…To…Next Structure
Using the For Each…Next Structure
Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls

Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods
Understanding Controls
Setting Control Properties in the Properties Window
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching a Form in Code

Working with the PivotTable Object

Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with the PivotTable Objects
Working with the PivotFields Collection
Assigning a Macro to the Quick Access Toolbar

Debugging Code

Understanding Errors
Using Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions

Handling Errors

Understanding Error Handling
Understanding VBA's Error
Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling

VBA Excel Course Description

Efficiency- Automate tasks for increased productivity.
Customization- Tailor Excel solutions to specific needs.
Streamlined Workflows- Reduce errors and save time.
Advanced Data Analysis- Perform complex analysis tasks.
Career Advancement- Open doors to new opportunities.
Competitive Edge- Stand out in the job market.
Problem Solving- Tackle real-world challenges effectively.
Cost Savings- Reduce reliance on manual labor.

We also offer excel 2013 and Excel 2010 training courses. Register Now for quick enquiry to Find here a range of courses from microsoft excel course singapore.