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)

Advanced 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 25, 2008
(Start time: 10:00 AM ET)		 $195.00
December 4, 2008
(Start time: 10:00 AM ET)		 $195.00
January 28, 2009
(Start time: 10:00 AM ET)		 $195.00
February 12, 2009
(Start time: 10:00 AM ET)		 $195.00
March 25, 2009
(Start time: 10:00 AM ET)		 $195.00
April 30, 2009
(Start time: 10:00 AM ET)		 $195.00
May 28, 2009
(Start time: 10:00 AM ET)		 $195.00
June 11, 2009
(Start time: 10:00 AM ET)		 $195.00
You may also register by calling 1-877-932-8228.

Advanced Microsoft Excel 2003 Training Course Overview

In this advanced Microsoft Excel 2003 training course, you will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data.

Advanced Microsoft Excel 2003 Training Course Goals

  • Learn to customize workbooks.
  • Learn to collaborate with others using workbooks.
  • Learn to audit worksheets.
  • Learn to analyze data.
  • Learn to work with multiple workbooks.
  • Learn to import and export data.
  • Learn to structure workbooks with XML.

Advanced Microsoft Excel 2003 Training Course Prerequisites

Experience in the following areas is required:

  • Experience with Excel 2003.

Advanced Microsoft Excel 2003 Training Course Outline

  1. Streamlining Workflow
    1. Create a Macro
    2. Edit a Macro
    3. Customize Access to Excel Commands
    4. Apply Conditional Formatting
    5. Add Data Validation Criteria
    6. Update a Workbook's Properties
    7. Modify Excel's Default Settings
  2. Collaborating with Others
    1. Protect Files
    2. Share a Workbook
    3. Set Revision Tracking
    4. Review Tracked Revisions
    5. Merge Workbooks
    6. Adjust Macro Settings
    7. Administer Digital Signatures
  3. Auditing Worksheets
    1. Trace Cell Precedents
    2. Trace Cell Dependents
    3. Locate Errors in Formulas
    4. Locate Invalid Data and Formulas
    5. Watch and Evaluate Formulas
    6. Group and Outline Data
  4. Analyzing Data
    1. Create a Trendline
    2. Create Scenarios
    3. Perform What-If Analysis
    4. Develop a PivotTable Report
    5. Develop a PivotChart Report
    6. Perform Statistical Analysis with the Analysis ToolPak
  5. Working with Multiple Workbooks
    1. Create a Workspace
    2. Consolidate Data
    3. Link Cells in Different Workbooks
    4. Edit Links
  6. Importing and Exporting Data
    1. Export to Microsoft Word
    2. Import a Word Table
    3. Import Text Files
  7. Structuring XML Workbooks
    1. Develop XML Maps
    2. Import, Add, and Export XML Data
    3. Manage XML Workbooks
    4. Apply XML View Options

Advanced Microsoft Excel 2003 Training Course Materials

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

Advanced 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