VBA for Excel

Loading the player ...

Description
Course Resources

DURATION: 3.57 hours
VIDEOS: 32
LEVEL: Advanced

The course is designed for individuals and professionals who are new to VBA and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently.

In this course, you will learn:

Learn how to automate tasks and operations that you perform frequently.
Discover how to define and manage variables, set up subroutines, and create functions.
Find out how to use input boxes and message boxes to interact with end users.
Learn practical methods for using macro errors to improve your VBA code.
Learn about the PivotTable object and basic approaches to utilizing it.
Discover what variables are, and how they relate to functions versus methods and subroutines.
Create cross-functional flowcharts.
Test your knowledge with an online quiz and Certificate of Completion.

Course Format

This is a video-led training course. You can preview some videos in the pane above. This course is suitable for Windows or Mac users.

VBA for Excel

The course support files consist of a single .ZIP file. You will need to download VBA for Excel exercise Files.zip file to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. Once unzipped, all of the exercise/example files will reside in one folder.

VBA course exercise files

What people are saying

""I enjoyed the logical structure of course. It helps beginners to follow easily."

CHARLENEE HUYNH

"I would definitely recommend this course. I have learned excel before, and I sincerely learned more this time around. I'm now confident when I say “I know excel”. Of course, I'm no professional, but I know much more. "

JESSICA MARTINEZ

"It's clear, the voice over is understandable, I can speed up or slow down at will, the course materials were offered immediately, including how to acquire the program."

CHRISTOPHER BORON

"I thought this course was really well laid out and very in-depth. I have never used Microsoft Project before and I feel I have learned so much by doing this course. Also, it gave me a flavor for other more advanced operations as well."

THEVUTHASAN SENTHURAN