• +230 2411533
Facebook Twitter Youtube
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.

I'm Interested

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)

  • Monday - Friday (Between 10am - 5pm)
  • Course Materials and Online Content Provided
  • Duration is indicative and may include off-campus assignments and exams questions
  • Flexible Timetable
  • Special Packages + Payment Facilities

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.
Previous
Next

RELATED COURSES - ARTICLES

IOT Application – Smart Home

A smart home is a residence that uses internet-connected devices to enable the remote monitoring and management of appliances and systems, such as lighting and heating.

Read More »
December 12, 2022

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 set of topics is best

Read More »
November 2, 2022

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.

MORE CONTACT DETAILS

FOR PRICING & REGISTRATION, SEND US A MESSAGE

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.

MORE CONTACT DETAILS

FOR PRICING & REGISTRATION, SEND US A MESSAGE

WE ARE ACCREDITED

Infoclub LTD is an accredited training provider. We are registered with several International Professional Bodies.

PARTNERS

Infoclub LTD Partners with several small and medium companies to provide the best IT Services in Mauritius and in the United Kingdom. 

More Details Coming Soon..

CONTACT

We are easily reachable through several social media platforms. You can also leave us an email at any moment and we will get back to you as soon as possible. 

Need Immediate Assistance? Please use the following contact details:

error: Active Learning Copyright content