|
Course ID: 5975
| Course Duration: 1 Day
|
|
Course Dates:
|
| |
|
| |
Excel 2003 Introduction to VBA Training Class
Course ID: 5975
|
|
| |
|
|
| |
|
|
| |
Excel 2003 Introduction to VBA Training Seminar
In this course, students will learn how to simplify their work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
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
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
| |
Excel 2003 Introduction to VBA Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5975
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request More Info |
|
Print/Fax Register |
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Business Skills courses
|
|
| |
|
|
| |
Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |

|
|