The online classroom had so many ways to get help and ask questions. It was like being in a live cla... More Testimonials »
Home > Microsoft > Microsoft Excel > Advanced Microsoft Excel 2007 Training

Advanced Microsoft Excel 2007 Training

Delivery Options

Upcoming Live eLearning Classes

There are currently no upcoming Live eLearning classes. Please contact us if you would like us to schedule a class.

Class Description

Class Overview

In this advanced Microsoft Excel 2007 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.

Class Goals

  • 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. 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
  2. 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
  3. 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
  4. Analyzing Data
    1. Create a Trendline
    2. Create Scenarios
    3. Perform What-If Analysis
    4. 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 Excel Data
    2. Import a Delimited Text File
  7. Using Excel with the Web
    1. Publish a Worksheet to the Web
    2. Import Data from the Web
    3. Create a Web Query
  8. Structuring Workbooks with XML
    1. Develop XML Maps
    2. Import and Export XML Data

Class Materials

All students receive a course manual or book and all the class examples.

Students in private onsite classes will also receive:

Class Prerequisites

Experience in the following areas is required:

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. Why Webucator
  5. Partners
  6. Remote Courses
  7. Contact Us
  8. Sitemap
  9. Privacy Policy
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
Training Classes
  1. Private Onsite Classes
  2. Instructor-Led Online Courses
  3. Self-Paced eLearning
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Live eLearning

Like a class you would go to, but you don't have to go anywhere. More...

Customized Onsite Training

The trainer comes to you and delivers a class customized for your team. More...

Self-Paced eLearning

Our least expensive option. You proceed through the course entirely at your own pace. More...

Reference Library
Partner Programs
Courseware
Microsoft Partner
Microsoft Certified Learning Solutions
» Certified Microsoft Courses

» Software Assurance Training Vouchers
© Webucator, Inc. All rights reserved. | Toll Free: 877-932-8228 | UK: 0808-101-3484 | From outside the USA: 315-849-2724| Fax: 315-849-2723