Microsoft Office Excel 2003 VBA
|
|
MS Office |
Language Course |
ILT Classroom |
Mentored Learning |
OnLine AnyTime |
OnLive Live |
|
VBA -
Excel 2003 |
Portuguese /
English |
Yes |
Yes |
Yes |
Yes |
40HRS / 5 DAYS
Lesson 1: Developing Macros
• Create a Macro with the Macro Recorder
• Edit a Macro
• Debug a Macro
• Customize Toolbars, Menus, and Hotkeys
Lesson 2: Formatting Worksheets
• Sort Data
• Insert Rows and Columns
• Insert Text
• Format Text
• Duplicate Data
• Generate a Report
Lesson 3: Creating an Interactive Worksheet
• Determine Dialog Box Type
• Capture User Input
Lesson 4: Working with Multiple Worksheets
• Insert, Copy, and Delete Worksheets
• Rename Worksheets
• Modify the Order of Worksheets
• Print Worksheets
Lesson 5: Performing Calculations
• Create User-defined Functions
• Automate SUM Functions
Lesson 6: Introduction
• Applications Interfaces
• Options
• Setup
Lesson 7: Programming Languages
• OOP & The Excel Object Model
• Macros vs. Programming
Lesson 8: Creating & Running Macros
• Macros in Excel
• Using Macros to Learn & Use Code
• Using Macros to Learn Objects
Lesson 9: Visual Basic Editor
• Application Switching
• Menus - View, Tools, Help
• Windows - Project, Property, Object, Immediate & Module
• Code Conventions
• Use Immediate Window
• Run & Debug
• Modules, Subs, Functions & Scope
Lesson 10: Interface Boxes
• Message Boxes
• Input Boxes
• Forms - Dialog Boxes
Lesson 11: Variables
Lesson 12: Conditional Routines
• Immediate IF Statements
• IF-THEN Statements
• Case Statements
• Loops - FOR/NEXT, DO/WHILE, DO/UNTIL
Lesson 13: Introduction to Arrays
Lesson 14: Functions in Excel