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
• Lookup, Goal Seek & What-if
• Advanced functions
• Advanced Charting
INTRODUCING EXCEL VBA
• Showing the Developer Tab
• The VBA Editor Screen
DISPLAYING THE EXCEL OBJECT MODEL
• Programming With the Object Browser
• Creating a Subroutine
• Using the Edit Toolbar
• Implicit and Explicit Declarations
• The Scope of Variables
• Data Types, Arrays
FUNCTIONS IN VBA
• Passing and Handling Multiple Arguments
• Building a Function Library
• Importing a VBA Module, Calling a Function
USING EXCEL OBJECTS
• The Workbook Objects
• The Worksheets Object
• The Range Object
• The IF Statement, Select Case Statement
• For Loops
BUILDING CUSTOM FORMS
• Adding Option Buttons
• Adding Command Buttons
• Executing a Custom Form
• Transferring Data from a Form
• Running Form Procedures
• Automatic Startup
• Running Automatic Procedures
• Automatically Launching a Workbook
• 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
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:
Phone & Whatsapp: +230 2411533
Or fill in the form on the right.