"How Cool Is That! To be able to learn an entire program in 3 days right from your desk or home office!" More Testimonials »
Home > Microsoft > Microsoft Excel > Advanced Microsoft Excel 2003 Training

Advanced Microsoft Excel 2003 Training

Delivery Options

Class Date and Time Price Pricing Information
$195.00
or 1 vouchers voucher
$195.00 or 1 vouchers voucher
Register Now
$195.00 or 1 vouchers voucher
Register Now

Class Description

Class 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.

Class 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.

Class 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

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following areas is required:

  • Experience with Excel 2003.

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Contact Us
  7. Sitemap
  8. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Compare Webucator to leading Competitors
Microsoft Certified Learning Solutions

» Microsoft Certifications

» Certified Microsoft Courses

» Software Assurance Training Vouchers

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723