Microsoft Excel 2007 Outlines

Excel 2007 New Features             Excel 2007 Introduction             Excel 2007 Intermediate

Classes are available in Microsoft Office 97, 2000, 2002, 2003, and 2007.

 

Excel 2007 New Features
Class Length:  3-Hours

 

Lesson 1: Exploring the Excel Environment

  • Explore the User Interface
  • Work with the Ribbon
  • Work with Contextual Tabs
  • Use the Excel Galleries
  • Customize the Excel Interface

Lesson 2: Organizing Data

  • Explore the Enhancements in Excel 2007 Spreadsheets
  • Insert Tables
  • Format Tables

Lesson 3: Analyzing Data

  • Apply Conditional Formatting
  • Sort Data in a Spreadsheet
  • Filter Data in a Spreadsheet
  • Apply a Formula

Lesson 4: Presenting Data

  • Create Charts
  • Format Charts
  • Work with Illustrations
  • Create PivotTables and PivotCharts
  • Share Excel Charts
  • Save Data in Presentable Formats

     

Excel 2007 Introduction
Class Length:  6-hours

 

Lesson 1: Exploring the Excel Environment

  • Explore the User Interface
  • Explore the Ribbon
  • Obtain Help
  • Customize the Quick Access Toolbar

Lesson 2: Working with an Excel Worksheet

  • Navigate in Excel
  • Select and Enter Data
  • Save a Workbook

Lesson 3: Modifying a Worksheet

  • Manipulate Data
  • Insert and Delete Cells, Columns, Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

Lesson 4: Performing Calculations

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions
  • Create a Mixed Reference

Lesson 5: Formatting a Worksheet

  • Convert Text to Columns
  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Merge Cells
  • Apply Number Formats
  • Align Cell Contents
  • Find and Replace Formats
  • Apply AutoFormat
  • Apply Cell Styles
  • Apply Themes

Lesson 6: Developing a Workbook

  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Insert and Delete Worksheets
  • Copy and Paste Worksheets

Lesson 7: Printing Workbook Contents

  • Set Print Titles
  • Create a Header and a Footer
  • Set Page Margins
  • Change Page Orientation
  • Set Page Breaks
  • Print a Range

Lesson 8: Customizing Layout

  • Split a Worksheet
  • Arrange Windows
  • Freeze/Unfreeze Rows and Columns
  • Hide and Unhide Worksheets

 

Excel 2007 Intermediate
Class Length:  6-hours

Lesson 1: Enhancing Workbooks

  • Customize the Excel Environment
  • Customize an Excel Worksheet
  • Enhance Worksheets Using Themes
  • Work with Comments
  • Access External Resources Using Hyperlinks
  • Use Web-Based Research Tools

Lesson 2: Creating Workbooks Using Templates

  • Create a Workbook from a Template
  • Create a Custom Template

Lesson 3: Organizing Data Using Tables

  • Create Tables
  • Modify Tables
  • Format Tables

Lesson 4: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts
  • Create a Chart Template
  • Share Excel Charts

 Lesson 5: Analyzing Data Using PivotTables and PivotCharts

  • Create a PivotTable
  • Perform Calculations Using PivotTables
  • Analyze Data Using PivotCharts

Lesson 6: Enhancing Visual Appeal Using Graphic Objects

  • Insert Graphics
  • Modify Graphic Objects
  • Emphasize an Area of a Worksheet
  • Illustrate Workflow Using SmartArt Graphics
  • Format Graphic Objects
  • Change the Order of Layered Graphic Objects
  • Group Graphic Objects
  • Organize Graphic Objects

 Lesson 7: Calculating Data with Advanced Formulas

  • Refer to a Range of Cells
  • Calculate Data Across Worksheets
  • Perform Date and Time Calculations
  • Format Text Using Formulas
  • Perform Numeric Calculations
  • Calculate Data with Lookup & Reference Functions
  • Perform Logical Analysis
  • Print Formulas

Lesson 8: Sorting and Filtering Data

  • Sort Data in a Spreadsheet
  • Filter Data in a Spreadsheet
  • Calculate Large Volumes of Data
  • Add Subtotals to a Worksheet

Send mail to tracey@thecomputerhelpbutton.com with questions or comments about this web site.
Copyright © 2004 The Computer Help Button, LLC
Last modified: 04/29/08