1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 
Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe CS3 Training
◊ PUBLIC EXCEL TRAINING
Watch a 3-minute presentation
on our live instructor-led
online classes

How about taking a class directly from your home or office with a live instructor?
When you register for one of our instructor-led online Excel classes, we send you a computer headset, the courseware for class, and some other goodies. At the time of class, you simply put your headset on and log in to our web conferencing software. You can hear everything the instructor says, see the complete presentation, and ask questions at any time. Classes are small, generally 2-6 students, full of hands-on exercises, and are never cancelled due to low enrollment.

To have someone contact you about our instructor-led online classes, please fill out the form below. We will also email you a class schedule and pricing.

* (Required)
* (Required)
* (Required)
* (Required)
* (Required)
(The number of people requiring training)
* (Required)
(For Federal Government Pricing)

Intermediate Microsoft Excel 2003 Training (1 day)


Classes for individuals are delivered via the Web by a Webucator instructor over a live web conference. For more information on how these classes are delivered click here or call us toll free at 877-932-8228.

Click here for our private onsite Excel classes

Date Range Price Register
November 24, 2008
(Start time: 10:00 AM ET)
$195.00
January 27, 2009
(Start time: 10:00 AM ET)
$195.00
February 11, 2009
(Start time: 10:00 AM ET)
$195.00
March 24, 2009
(Start time: 10:00 AM ET)
$195.00
April 29, 2009
(Start time: 10:00 AM ET)
$195.00
May 27, 2009
(Start time: 10:00 AM ET)
$195.00
June 10, 2009
(Start time: 10:00 AM ET)
$195.00
You may also register by calling 1-877-932-8228.

Intermediate Microsoft Excel 2003 Training Course Overview

In this intermediate Microsoft Excel 2003 training course, you will learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

This course was designed for students who need the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web.

Intermediate Microsoft Excel 2003 Training Course Goals

  • create and apply templates.
  • create and modify charts.
  • work with graphic objects.
  • calculate with advanced formulas.
  • sort and filter data.
  • use Excel with the Web.

Intermediate Microsoft Excel 2003 Training Course Prerequisites

Experience in the following areas is required:

  • Basic Microsoft Excel

Intermediate Microsoft Excel 2003 Training Course Outline

  1. Creating and Applying Templates
    1. Create a Workbook from a Template
    2. Create a Custom Template
    3. Working with Comments
    4. Create a Hyperlink
    5. Use Web-based Research Tools
  2. Creating and Modifying Charts
    1. Create a Chart
    2. Format Chart Items
    3. Change the Chart Type
    4. Create a Diagram
  3. Working with Graphic Objects
    1. Insert Graphics
    2. Create AutoShapes
    3. Format Graphic Objects
    4. Change the Order of Graphic Objects
    5. Group Graphic Objects
    6. Move, Copy, and Resize Graphic Objects
  4. Calculating with Advanced Formulas
    1. Create and Apply a Name for a Range of Cells
    2. Calculate Across Worksheets
    3. Calculate with Date and Time Functions
    4. Calculate with Financial Functions
    5. Calculate with Statistical Functions
    6. Calculate with Lookup and Reference Functions
    7. Calculate with Logical Functions
  5. Sorting and Filtering Data
    1. Sort Data Lists
    2. Filter Data Lists
    3. Create and Apply Advanced Filters
    4. Calculate with Database Functions
    5. Add Subtotals to a Worksheet
  6. Using Excel with the Web
    1. Export Excel Data
    2. Publish a Worksheet to the Web
    3. Import Data from the Web
    4. Create a Web Query

Intermediate Microsoft Excel 2003 Training Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

Intermediate Microsoft Excel 2003 Training Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions

home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2008 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA