Intermediate Microsoft Excel 2007 Training (1 day)

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:

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

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

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Intermediate Microsoft Excel 2007 Training Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions