Advanced Excel With VBA
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool.
Talk to us

COURSE OVERVIEW

This course is aimed at individuals with a basic grounding in Excel VBA and an advanced knowledge of Microsoft Excel, who wish to develop their skills with introduce more sophisticated automation into their workflows.

Students learn the Visual Basic for Applications language as well as the Excel classes and objects needed to create VBA scripts to automate Excel. Participants create procedures and functions using the VBA language and Excel objects. The PivotTable object is used to create macros that add interactivity to the standard Pivot Table. As well, debugging and error handling techniques are reviewed.

Pre-requisite: Knowledge of Microsoft Excel VBA course, or equivalent knowledge.

ADVANCED EXCEL WITH VBA COURSE MODULES

EXCEL ADVANCED FEATURES

• Addressing, Autofill
• Lookup, Goal Seek & What-if
• Advanced functions
• Advanced Charting

INTRODUCING EXCEL VBA

• Programming in Microsoft Office
• Showing the Developer Tab
• The VBA Editor Screen

DISPLAYING THE EXCEL OBJECT MODEL

• Manipulating Object Collections
• Programming With the Object Browser

PROCEDURES

• Understanding Procedures
• Creating a Subroutine
• Using the Edit Toolbar

USING VARIABLES

• Initializing and Using Variables
• Implicit and Explicit Declarations
• The Scope of Variables
• Data Types, Arrays

FUNCTIONS IN VBA

• Building VBA Functions
• Passing and Handling Multiple Arguments
• Building a Function Library
• Importing a VBA Module, Calling a Function

USING EXCEL OBJECTS

• The Application Object
• The Workbook Objects
• The Worksheets Object
• The Range Object

PROGRAMMING TECHNIQUES

• The MsgBox Function, InputBox Techniques
• The IF Statement, Select Case Statement
• For Loops

BUILDING CUSTOM FORMS

• Building a Custom Form
• Adding Option Buttons
• Adding Command Buttons
• Executing a Custom Form

PROGRAMMING USERFORMS

• Handling Form Events
• Transferring Data from a Form
• Running Form Procedures
• Automatic Startup
• Running Automatic Procedures
• Automatically Launching a Workbook

ERROR HANDLING

• Error Handling in your VBA Application
• Error types
• The On Error statement
• Using Decision Structures in Error Handlers

COURSE ORGANISATION & TIMING

We have created a schedule for this course to match with most availabilities.

The course is modular. Courses are hands-on(25% theory, 75% practice)

BENEFITS OF THIS COURSE

There are many benefits in following an Excel VBA course. 

RELATED COURSES - ARTICLES

Vacation Courses

Sharpen Your IT Skills and make your holidays more productive Summer Vacation Courses Table of Contents LEVEL 1  LEVEL 2  Course Organisation Level 1 This

Read More »

GET IN TOUCH

Infoclub Ltd has proudly served IT Professionals seeking to enhace their skillsets with the latest certification in IT with excellence for over 30 years.

You can contact us through the following:

Email: Infoclubltd@yahoo.com

Phone & Whatsapp: +230 2411533

Or fill in the form on the right.

FOR PRICING & REGISTRATION, SEND US A MESSAGE