Custom Search
Provided by: Last Minute Training

VBA for Excel 2003

Excel

Last Minute Training
Training Provided by Last Minute Training In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development. In Excel 2003: Introduction to VBA you apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks you learned in Excel 2003: Level 1 and Excel 2003: Level 2.
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:introductory
Duration:1 days
Training Presented in:English
VBA for Excel 2003 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
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Advertise With Us
Want to market your vba training?
This page was last updated on sb5- 10/07/08 at 16:19:28 - 19:20:57