GS-35F-0556S
Contact Us
Toll Free 877.932.8228

Home

Technology Training

Business Training

I would most definitely consider Webucator for future software training. It was very convenient, tot... More Testimonials »

Home > Microsoft > Microsoft Excel > Intermediate Microsoft Excel 2007 Training

Intermediate Microsoft Excel 2007 Training

Delivery Options

Live eLearning (1 day): $195.00

Customized Onsite Training (1 day): Request a Proposal

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

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.

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.

Class Outline

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
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
Presenting Data Using Charts
1. Create a Chart
2. Modify Charts
3. Format Charts
Analyzing Data Using PivotTables and PivotCharts
1. Create a PivotTable Report
2. Analyze Data Using PivotCharts
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
Customizing and Enhancing Workbooks and the Excel Environment
1. Customize the Excel Environment
2. Customize Workbooks
3. Manage Themes
4. Create and Use Templates

Class Materials

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

Students in private onsite classes will also receive:

Technical Reference Library

Class Prerequisites

Experience in the following areas is required:

Experience with Excel 2007 equivalent to that taught in Introduction to Microsoft Excel 2007 Training.

Technical Requirements

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

Course technical requirements and setup instructions.

Quick Links

Client Success

Join The Team

Learn how you can become a Webucator Trainer
Career Opportunities

Training Classes

Locations

Where We've Trained
Some of the Cities in which Webucator has Trained:
1. Phoenix, AZ
2. Pittsburgh, PA
3. Portland, OR
4. Providence, RI
5. Raleigh, NC
6. Sacramento, CA
7. St. Louis, MO
8. San Diego, CA
9. San Francisco, CA
10. San Jose, CA
11. Santa Clara, CA
12. Seattle, WA
13. Sunnyvale, CA
14. Tallahassee, FL
15. Tempe, AZ
16. Toronto, ON
17. Tucson, AZ
18. Tulsa, OK
19. Virginia Beach, VA
20. Washington, DC
1. Fort Worth, TX
2. Hampton, VA
3. Hollywood, FL
4. Houston, TX
5. Huntsville, AL
6. Indianapolis, IN
7. Jacksonville, FL
8. Las Vegas, NV
9. Lexington, KY
10. Los Angeles, CA
11. Louisville, KY
12. Madison, WI
13. Memphis, TN
14. Milwaukee, WI
15. Nashville, TN
16. New York, NY
17. Oklahoma City, OK
18. Omaha, NE
19. Ottawa, ON
20. Philadelphia, PA
1. Amarillo, TX
2. Atlanta, GA
3. Aurora, IL
4. Austin, TX
5. Baltimore, MD
6. Beaumont, TX
7. Boston, MA
8. Buffalo, NY
9. Calgary, AB
10. Cary, NC
11. Chandler, AZ
12. Chicago, IL
13. Cincinnati, OH
14. Cleveland, OH
15. Colorado Springs, CO
16. Columbus, OH
17. Dallas, TX
18. Dayton, OH
19. Denver, CO
20. Detroit, MI
We have trainers all over North America.
1. Indianapolis, IN
2. Boston, MA
3. Silver Spring, MD
4. Portland, ME
5. Detroit, MI
6. Minneapolis, MN
7. Kansas City, MO
8. St. Louis, MO
9. Jackson, MS
10. Charlotte, NC
11. Nashua, NH
12. Atlantic City, NJ
13. Newark, NJ
14. Jersey City, NJ,
15. Reno, NV
16. Philadelphia, PA
17. Calgary, Canada
18. Toronto, Canada
1. Phoenix, AZ
2. Los Angeles, CA
3. Oakland, CA
4. San Diego, CA
5. San Francisco, CA
6. San Jose, CA
7. Santa Clara, CA
8. Sacramento, CA
9. Boulder, CO
10. Denver, CO
11. Hartford, CT
12. Fort Lauderdale, FL
13. Fort Myers, FL
14. Orlando, FL
15. Tallahassee, FL
16. Atlanta, GA
17. Boise, ID
18. Chicago, IL

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

» Certified Microsoft Courses

» Software Assurance Training Vouchers