Advanced Excel With VBA

Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool.

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.

You can work as a part-time or full-time VBA coder. This skill can provide you with flexible job options, such as one-time projects or long-term working relationships. Some jobs that use data analysis require developing a VBA system. Thus, companies that hire data analyst roles may require VBA knowledge and skills.

The course is beneficial for professional and non-professionals. It is the powerful automated program which makes all the excel work easy and quick. It assists in dealing with complex excel programs. Each and every employee of the organization has to deal with collecting and presenting the data report.

VBA is easy to learn in comparison to other coding languages. This basic programming language is applicable in all Microsoft Office programs. Aspiring VBA users have no trouble learning the program due to its intuitive features.

Multiple industries still use Excel online. Therefore, many companies still have a need to use VBA. Certain industries like finance, logistics and inventory management, and data analytics can benefit from using this program.

RELATED COURSES - ARTICLES

Ethics for IT Professionals

Embarking on a cybersecurity career requires structured learning and certifications. At INFOCLUB Training Centre, we have a plan to make you become a top-level professional in Cybersecurity. Read below a detailed 18-24 month roadmap, highlighting certifications, skills acquired, exam structures, and potential job roles at each stage.

February 21, 2025

Building a Career in Cybersecurity

January 9, 2025

Why IT Kids?

Unleash Your Child’s Digital Potential This Summer with Fun, Hands-On IT Courses! As the summer holidays roll around, it’s time to think beyond the textbooks

October 25, 2024

THE BELBIN MODEL

The Belbin Model, also known as Belbin Team Roles, is a framework for understanding the roles individuals naturally adopt in a team setting. Developed in

July 19, 2024

Writing a Critical Appraisal

INTRODUCTION How do you write a critical appraisal? Many people find difficulties doing this at the end of their project or dissertation. A critical appraisal

July 18, 2024

PRIVACY IN THE MODERN WORLD

What is Privacy? It is the right of an individual to keep their personal information and activities from being disclosed to others without their consent. In our article, we shall review the following: What are the top risks to privacy today, What are the technical solutions to protect privacy, The legal aspect and what is GDPR, How privacy varies across cultures, How new technologies could challenge privacy in the future

July 5, 2024

INTERESTED IN THIS COURSE?

SEND US A MESSAGE