Intermediate and Advanced Excel 2007 Training

Delivery Options

• Live Online Training - Public Class (2 days): $390.00 (Register)

» Register Now

» Free Demo

» Watch Presentation

» More Info

» Contact Education Consultant

• Customized Onsite Training (2 days): Request a Proposal

Show More Classes

Class Description

Class Overview

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.

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
    1. Develop XML Maps
    2. Import and Export XML Data

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 2007 equivalent to that taught in Introduction to Microsoft Excel 2007 Training.

Courses that can help you meet these prerequisites:

• Introduction to Microsoft Excel 2007 Training

Technical Requirements

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

• Onsite and Instructor-led Online course technical requirements and setup instructions.
• WebEx system requirements for Instructor-led Online delivery option.