Computer Training Course Outline for PC Training Experts
Home
About
Contact
Courses
Tutorials
Hot Articles
Blog
Forums
Excel 2016 VBA (Visual Basic for Applications)
(
1.0 day
)
In this foundational overview course, you'll learn the basics of object-oriented programming techniques using Visual Basic for Applications. Discover how to use variables and procedures correctly, how to use methods and events and even add customized buttons to your spreadsheets for automating tasks. Learn how to use decision structures such as If/Then to add artificial intelligence to your spreadsheets, and automate repetitive tasks using loop structures. Learn how to develop your own user forms to capture user input, as well as send messages to users with message boxes. Finally, you'll learn how to handle the inevitable errors that crop up in every project. This course will be a springboard you can use to start developing your own customized solutions in Excel using VBA.
Performance-Based Objectives
Get an overview of VBA and how it integrates into the Microsoft Office environment
Learn about the scope of variables and procedures
Learn how to use Methods, Events, and add buttons to your spreadsheets
Use decision structures such as If/Then to add artificial intelligence to your spreadsheets
Harness the power of loops to automate repetitive and iterative tasks such as checking all the cells in a spreadsheet
Create your own forms to capture user input, and send messages using the Msgbox function
Learn how to debug your projects and handle errors before they handle you
Course Outline*
Module 1: The Visual Basic Editor
Introduction to Visual Basic for Applications
What is Object-Oriented Programming (OOP)?
The Object Browser
Module 4: Custom dialog boxes
User forms
Events
Module 2: Programming basics
Data basics
Scope of variables
Scope of procedures
Module 5: Debugging and error handling
Errors and Error Types
Debugging
Error handling
Setting Breakpoints and Watch expressions
Module 3: Control structures
Decision structures such as If, Then
Loop structures such as Do While and For Next
Register
Dates Offered
Email
Print Friendly
Show All
*Note: webinar courses cover only essential topics due to time constraints. Please discuss topics with your instructor prior to webinars to ensure your necessary topics are covered.
Dates Offered
Email
Print
Friendly
Tuition
Live, In-Person:
$347.00
Live, Webinar:
$0.00
Home
|
About
|
Contact
|
Schedule Training
|
Course Catalog
|
Blog
|
Terms of Use
|
Privacy Statement
Copyright © 2011 Mike Phillips