Advanced Microsoft Excel 2003 Training

Intermediate and Advanced Microsoft Excel 2003 Training Class Overview

In this 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. 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. You will also gain the Excel 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.

Intermediate and Advanced Microsoft Excel 2003 Training Class Goals

• Learn to create and apply templates.
• Learn to create and modify charts.
• Learn to work with graphic objects.
• Learn to calculate with advanced formulas.
• Learn to sort and filter data.
• Learn to use Excel with the Web.
• 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.

Intermediate and Advanced Microsoft Excel 2003 Training Class 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
7. 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
8. 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
9. 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
10. 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
11. Working with Multiple Workbooks
    1. Create a Workspace
    2. Consolidate Data
    3. Link Cells in Different Workbooks
    4. Edit Links
12. Importing and Exporting Data
    1. Export to Microsoft Word
    2. Import a Word Table
    3. Import Text Files
13. Structuring XML Workbooks (if time allows)
    1. Develop XML Maps
    2. Import, Add, and Export XML Data
    3. Manage XML Workbooks
    4. Apply XML View Options

Intermediate and Advanced Microsoft Excel 2003 Training Class Prerequisites

Experience in the following areas is required:

• Basic Microsoft Excel

Intermediate and Advanced Microsoft Excel 2003 Training Class Materials

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

Class Technical Requirements

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

• Click here for technical requirements and setup instructions