VBA for Excel
- Description
- Course Resources
VBA for Excel
- 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.
What people are saying
Trusted by
Start Your Membership
Simon Sez: “Let’s make you a software superstar!”
From Excel to photo editing, experience quality courses that ensure easy learning.
START YOUR MEMBERSHIPLearn More