Search Courses
Course Details    [choose new course]     [printable version]
Migrating to Excel 2007
Course Number: ETX003
Category: Business & Office Applications
Duration: 0.25 days
Description

This 90-minute ExecuTrain Express course is designed for current Excel users who are migrating to Excel 2007. Class participants will learn how to take advantage of Excel 2007’s improved charting engine and its brand-new Page Layout view. Participants will also learn how to use Excel 2007’s powerful Conditional Formatting feature, which applies special formatting to cells when certain conditions are met. Students should take this class, which focuses specifically on Excel’s new features, after taking the Migrating to Office 2007 course.

Prerequisites
  • Familiarity with a previous release of Microsoft Excel, such as Excel 2000 or Excel 2003
  • Successful completion of the Migrating to Office 2007 course
Objectives
  • Make the most of Excel’s new page layout and formatting features.
  • Enhance your worksheets using Excel’s new table and charting features.
  • Use improved tools like conditional formatting to analyze your data more effectively.
Outline
  • Exploring the Basics
    • What’s New in Excel 2007
    • Using New Views
      • Page Layout view
      • Page Break Preview
    • Fast Formatting
  • Presenting Data Using Tables and Charts
    • Working with Tables
      • Creating a Table
      • Creating a Calculated Column
    • Charting Data
      • Creating a Chart
      • Changing the Chart Type
      • Selecting a Layout
      • Applying a Chart Style
  • Analyzing Data
    • Using Conditional Formatting
      • Highlight Cells Rules
      • Top and Bottom Rules
      • Data Bars
      • Color Scales
      • Icon Sets
      • Removing Conditional Formatting
      • Creating a Custom Rule
    • Sorting and Filtering Data
    • Creating Formulas
      • Using the Function Library
      • Using Formula AutoComplete