|
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
Overview: 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.
Who Should Attend: Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
At Course Completion: Upon successful completion of this course, students will be able to: - develop macros - format worksheets - create an interactive worksheet - work with multiple worksheets - perform calculations
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
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 Information Technology courses
|
|
| |
|
|
| |
Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |

|
|