1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 
Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe CS3 Training
◊ PUBLIC EXCEL TRAINING
Watch a 3-minute presentation
on our live instructor-led
online classes

How about taking a class directly from your home or office with a live instructor?
When you register for one of our instructor-led online Excel classes, we send you a computer headset, the courseware for class, and some other goodies. At the time of class, you simply put your headset on and log in to our web conferencing software. You can hear everything the instructor says, see the complete presentation, and ask questions at any time. Classes are small, generally 2-6 students, full of hands-on exercises, and are never cancelled due to low enrollment.

To have someone contact you about our instructor-led online classes, please fill out the form below. We will also email you a class schedule and pricing.

* (Required)
* (Required)
* (Required)
* (Required)
* (Required)
(The number of people requiring training)
* (Required)
(For Federal Government Pricing)

Intermediate Microsoft Excel 2007 Training (1 day)

Classes for individuals are delivered via the Web by a Webucator instructor over a live web conference. For more information on how these classes are delivered click here or call us toll free at 877-932-8228.

Click here for our private onsite Excel classes

Date Range Price Register
December 16, 2008
(Start time: 10:00 AM ET)		 $195.00
January 14, 2009
(Start time: 10:00 AM ET)		 $195.00
February 24, 2009
(Start time: 10:00 AM ET)		 $195.00
March 11, 2009
(Start time: 10:00 AM ET)		 $195.00
April 29, 2009
(Start time: 10:00 AM ET)		 $195.00
May 13, 2009
(Start time: 10:00 AM ET)		 $195.00
June 23, 2009
(Start time: 10:00 AM ET)		 $195.00
You may also register by calling 1-877-932-8228.

Intermediate Microsoft Excel 2007 Training Course Overview

This Microsoft Excel training course is designed for students with some experience working with Microsoft Excel 2007. Students will learn to will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Intermediate Microsoft Excel 2007 Training Course 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.

Intermediate Microsoft Excel 2007 Training Course Prerequisites

Experience in the following areas is required:

Intermediate Microsoft Excel 2007 Training Course 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

Intermediate Microsoft Excel 2007 Training Course Materials

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

Intermediate Microsoft Excel 2007 Training Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions

home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2008 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA