Microsoft®
Office Excel: Introduction To VBA Macros
Microsoft Excel 2007 Users:
- Either Excel v2003 or v2007 be used by the student in this class. Our public class is currently taught using version 2003 due to the similarities between versions with the macro features. For 2007 users, we point out specific interface differences. Please include a note with your registration if you are an Excel 2007 user.
- Private Corporate training can be taught using either version.
Excel Training
Course Content
Lesson
1: Developing Macros
Topic
1A: Create a Macro with the Macro Recorder
Topic 1B: Edit a Macro
Topic 1C: Debug a Macro
Topic 1D: Customize Toolbars, Menus, and Hotkeys
Lesson
2: Formatting Worksheets
Topic
2A: Sort Data
Topic 2B: Insert Rows and Columns
Topic 2C: Insert Text
Topic 2D: Format Text
Topic 2E: Duplicate Data
Topic 2F: Generate a Report
Lesson
3: Creating an Interactive Worksheet
Topic
3A: Determine Dialog Box Type
Topic 3B: Capture User Input
Lesson
4: Working with Multiple Worksheets
Topic
4A: Insert, Copy, and Delete Worksheets
Topic 4B: Rename Worksheets
Topic 4C: Modify the Order of Worksheets
Topic 4D: Print Worksheets
Lesson
5: Performing Calculations
Topic
5A: Create User-defined Functions
Topic 5B: Automate SUM Functions
Additional Items:
Version 2003 vs 2007 - Interface Differences
Introduction
To VBA Macros (Excel Level 4) Prerequisites: To
ensure your success, we recommend that you have experience
with intermediate level formulas, charting, data management
tools and basic macros. Students can obtain this level of
skill through our Level 1, 2 and 3 courses. Contact us to
discuss if this level is right for you.
Delivery
Method: Instructor
led, group-paced, hands-on classroom training with activities.
Additionally, manuals are provided for each student for after class
reference.
Excel 2007 Training Class Outlines:
Level
1 - Fundamentals
Level 2 - Intermediate
Level 3 - Advanced
Level 4 - Advanced Formulas and Funtions
|