Computer Training Course Outline for PC Training Experts, Serving Irvine, Newport Beach, and Mission Viejo

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.