The instructor was informative, patient and truly taught the class where I feel I can use PowerPoint and even as... More Testimonials »
Home > Microsoft > Microsoft Excel > Advanced Microsoft Excel 2007 Training

Advanced Microsoft Excel 2007 Training

Excel 2007

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

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:

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. Make Payment
  7. Contact Us
  8. Sitemap
  9. 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.
Compare Us
Compare Webucator to leading Competitors
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
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