Excel 2003 Introduction to VBA training seminars presented by New Horizons register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Excel 2003 Introduction to VBA  

 Email information about this seminar Excel 2003 Introduction to VBA by New Horizons to yourself your manager or associates Email this event... View and register for other training seminars like Excel 2003 Introduction to VBA by New Horizons on FindaSeminar.com Find similar training.. Find and register for other training seminars by New Horizons on FindaSeminar.com Other seminars from New Horizons

By:

New Horizons   

For:

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.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

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.  (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

Excel+2003+VBA+visual++basic training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Excel 2003 Introduction to VBA seminar

 

 

Training Course Syllabus:


Duration:
Instructor-led Classroom Learning - 1.00 Day(s)
Mentored Learning - Flexible


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


Outline:

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

Seminar Summary:

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.  (see full course description)

print this agenda print agenda for the Excel 2003 Introduction to VBA training seminar

 view dates and locations for this seminar

 

 

 

Custom Search