Advanced Microsoft Excel 2007 Training

Intermediate and Advanced Excel 2007 Training Class Overview

This Microsoft Excel training course is designed for students with some experience working with Microsoft Excel 2007. You will learn to apply visual elements and advanced formulas to a worksheet to display data in various formats. In addition, 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.

Intermediate and Advanced Excel 2007 Training Class Goals

• Learn to calculate with advanced formulas.
• Learn to organize worksheet and table data using various techniques.
• Learn to create and modify charts.
• Learn to analyze data using PivotTables and PivotCharts.
• Learn to insert graphic objects.
• Learn to customize and enhance workbooks and the Microsoft Office Excel environment.
• Increase productivity and improve efficiency by streamlining your workflow.
• 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 use Excel with the web.
• Learn to structure workbooks with XML.

Intermediate and Advanced Excel 2007 Training Class Outline

1. Calculating Data with Advanced Formulas
   1. Manage Cell and Range Names
   2. Calculate Data Across Worksheets
   3. Use Specialized Functions
   4. Analyze Data with Logical and Lookup Functions
2. Organizing Worksheet and Table Data
   1. Create and Modify Tables
   2. Format Tables
   3. Sort or Filter Worksheet or Table Data
   4. Calculate Data in a Table or Worksheet
3. Presenting Data Using Charts
   1. Create a Chart
   2. Modify Charts
   3. Format Charts
4. Analyzing Data Using PivotTables and PivotCharts
   1. Create a PivotTable Report
   2. Analyze Data Using PivotCharts
5. Inserting Graphic Objects
   1. Insert and Modify Pictures and ClipArt
   2. Draw and Modify Shapes
   3. Illustrate Workflow Using SmartArt Graphics
   4. Layer and Group Graphic Objects
6. Customizing and Enhancing Workbooks and the Excel Environment
   1. Customize the Excel Environment
   2. Customize Workbooks
   3. Manage Themes
   4. Create and Use Templates
7. Streamlining Workflow
   1. Create a Macro
   2. Edit a Macro
   3. Apply Conditional Formatting
   4. Add Data Validation Criteria
   5. Update a Workbook's Properties
   6. 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. Administer Digital Signatures
   7. Restrict Document Access
9. Auditing Worksheets
   1. Trace Cells
   2. Troubleshoot Errors in Formulas
   3. Troubleshoot Invalid Data and Formulas
   4. Watch and Evaluate Formulas
   5. Create a Data List Outline
10. Analyzing Data
    1. Create a Trendline
    2. Create Scenarios
    3. Perform What-If Analysis
    4. 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 Excel Data
    2. Import a Delimited Text File
13. Using Excel with the Web
    1. Publish a Worksheet to the Web
    2. Import Data from the Web
    3. Create a Web Query
14. Structuring Workbooks with XML (if time allows)
    1. Develop XML Maps
    2. Import and Export XML Data

Intermediate and Advanced Excel 2007 Training Class Prerequisites

Experience in the following areas is required:

• Experience with Excel 2007 equivalent to that taught in Introduction to Microsoft Excel 2007 Training or the equivalent experience..

Intermediate and Advanced Excel 2007 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