Comprehensive Microsoft Excel 2007 Training

Delivery Options

• Customized Onsite Training (3 days): Request a Proposal

Class Description

Class Overview

Class Goals

• Explore the Microsoft Office Excel 2007 environment and create a basic worksheet.
• Learn to perform calculations.
• Learn to modify a worksheet.
• Learn to format a worksheet.
• Learn to print workbook contents.
• Learn to manage large workbooks.
• 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.
• 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. Creating a Basic Worksheet
   1. Explore the User Interface and the Ribbon
   2. Navigate and Select in Excel
   3. Obtain Help
   4. Enter Data and Save a Workbook
   5. Customize the Quick Access Toolbar
2. Performing Calculations
   1. Create Basic Formulas
   2. Calculate with Functions
   3. Copy Formulas and Functions
3. Modifying a Worksheet
   1. Manipulate Data
   2. Insert and Delete Cells, Columns, and Rows
   3. Search for Data in a Worksheet
   4. Spell Check a Worksheet
4. Formatting a Worksheet
   1. Modify Fonts
   2. Add Borders and Color to Cells
   3. Change Column Width and Row Height
   4. Apply Number Formats
   5. Position Cell Contents
   6. Apply Cell Styles
5. Printing Workbook Contents
   1. Print Workbook Contents Using Default Print Options
   2. Set Print Options
   3. Set Page Breaks
6. Managing Large Workbooks
   1. Format Worksheet Tabs
   2. Manage Worksheets in a Workbook
   3. Manage the View of Large Worksheets
7. 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
8. 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
9. Presenting Data Using Charts
   1. Create a Chart
   2. Modify Charts
   3. Format Charts
10. Analyzing Data Using PivotTables and PivotCharts
    1. Create a PivotTable Report
    2. Analyze Data Using PivotCharts
11. 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
12. Customizing and Enhancing Workbooks and the Excel Environment
    1. Customize the Excel Environment
    2. Customize Workbooks
    3. Manage Themes
    4. Create and Use Templates
13. 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
14. 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
15. 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
16. Analyzing Data
    1. Create a Trendline
    2. Create Scenarios
    3. Perform What-If Analysis
    4. Perform Statistical Analysis with the Analysis ToolPak
17. Working with Multiple Workbooks
    1. Create a Workspace
    2. Consolidate Data
    3. Link Cells in Different Workbooks
    4. Edit Links
18. Importing and Exporting Data
    1. Export Excel Data
    2. Import a Delimited Text File
19. Using Excel with the Web
    1. Publish a Worksheet to the Web
    2. Import Data from the Web
    3. Create a Web Query
20. 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:

• Technical Reference Library

Technical Requirements

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

• Course technical requirements and setup instructions.