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. Through this 4-hour course:

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.

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

Get immediate access to the entire library!

ANNUAL Membership - 100% Money Back Guarantee

$ 197 _{/per year}

This is an annual membership to SimonSezIT.com with access to all online training courses. You will be charged again when your membership expires. You can cancel at any time.

MONTHLY Membership - 100% Money Back Guarantee

$ 25 _{/per month}

This is a monthly membership to imonSezIT.com which includes access to all online training courses. You will be charged each month as long as you are a member. You can cancel at any time.

Related courses

What people are saying

"The instructor delivers excellently. He is very timely, clear and concise in his explanations. This course takes you from zero with practical examples on the features and capabilities of MS Project."

Dianne Garvey

"The course was interesting and well organized. The short lessons allowed me to finish a topic in the middle of my work day. The instructor spoke well and was easy to listen to."

Janice Tabbut

"I started this course knowing very little about Project. I'm only half way done with the course and I have already learned so much. It is organized well and flows nicely. I never feel overwhelmed. I like how I can always go back and review anything I want. Overall, this course is well done."

Nathan Braithwaite

"Undertaking this course has now given me the confidence to undertake the Microsoft Project 2013 Certification Exam 74-343. Exceptional course, thank you."

Simon Cox