Microsoft Excel 2002 VBA

« back to previous page

Description:	This course is designed as a fast, easy way to learn to program with Visual Basic for Applications, to extend and modify Microsoft Excel behavior, and to take full advantage of the Internet. You'll learn to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, connect applications to the Internet, and more. The easy-to-follow lessons include clear objectives and real-world business examples so you can learn exactly what you need to know. The CD-ROMs offer real-world samples to support each lesson.
Prerequisites:	Successful candidate does not need experience in programming language. Candidates should possess advanced skills in Excel 2002.
Length:	Two days

Part I Automating Everyday Tasks

Lesson 1 Make a Macro Do Simple Tasks
 How Visual Basic for Applications Talks to Excel
 Creating a Simple Macro
 Changing Multiple Properties at Once
 Editing a Recorded Macro
 Recording Actions in a Macro
 Signing Personal Macros

Lesson 2 Make a Macro Do Complex Tasks
• Divide and Conquer
• Task One: Opening the Report File
• Task Two: Filling in Missing Labels
• Task Three: Adding a Column of Dates
• Task Four: Appending to the Database
• Task Five: Deleting the Worksheet
• Assembling the Pieces

Part II Exploring Objects

Lesson 3 Explore Workbooks and Worksheets
• Understanding Workbooks
• Understanding Worksheets

Lesson 4 Explore Graphical Objects
• Exploring Graphical Objects
• Exploring Chart Objects

Lesson 5 Explore Range Objects
• Referring to a Range
• Formatting a Range
• Entering Values and Formulas into a Range
• Enhancing Recorded Selections

Lesson 6 Explore PivotTable Objects
• Building PivotTables
• Refining PivotTables

Part III Exploring Visual Basic

Lesson 7 Controlling Visual Basic
• Using Conditionals
• Creating Loops
• Managing Large Loops

Lesson 8 Extending Excel and Visual Basic
• Creating Custom Functions
• Handling Errors

Part IV Making Macros Easy to Use

Lesson 9 Launching Macros with Events
• Creating Custom Toolbars and Menus
• Creating Custom Command Buttons
• Handling Worksheet and Workbook Events

Lesson 10 Using Dialog Box Controls on a Worksheet
• Using a Loan Payment Calculator
• Creating an Error-Resistant Loan Payment Calculator
• Retrieving a Value from a List
• Protecting the Worksheet

Lesson 11 Creating a Custom Form
• Creating a Form's User Interface
• Preparing a Form's Functionality
• Implementing a Form

Lesson 12 Creating an Enterprise Information System
• Examining an Existing Enterprise Information System
• Charting Data from a Database
• Controlling the Report with Macros
• Creating a Graphical Interface
• Packaging the Application