Home >> Courses >> Application Training Courses

Migrating to Excel 2007 (90 minutes)

Course ID #: MIG2EXCEL2007
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.
Course date and time:  
    Price per seat $99.00
    Qty
    Seats Available: 0

    		  
    • Additional Course Details

      • Overview

        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

    Other courses that may be of interest:
    Click the "Details" button to check availability or special pricing options.

    $225.00
       
    EX2K3L2 - Excel 2003 Training (Level 2)
    In this course, you will use Microsoft Excel 2003 to manage, edit, and print data. (See full description below)
    $225.00
       
    EX2K3L1 - Excel 2003 Training (Level 1)
    In this course, you will use Microsoft Excel 2003 to manage, edit, and print data. (See full description below)
    $99.00
       
    MIG2ACC07 - Migrating to Access 2007 (90 Minutes)
    This 90-minute ExecuTrain Express course is designed for current Access users who are migrating to Access 2007. Class participants will learn how to take advantage of new tools and interface elements to speed up database creation and editing tasks.
    $99.00
       
    MIG2OFF07 - Migrating to Office 2007 (90 Minutes)
    This 90-minute ExecuTrain Express course is designed for current Microsoft Office users who are migrating to Office 2007.
    $99.00
       
    MIG2OUTLOOK2007 - Migrating to Outlook 2007
    This 90-minute ExecuTrain Express course is designed for current users of Outlook who are migrating to Outlook 2007. Class participants will learn how the new “Office Fluent” interface design has changed even the most basic functionality in Outlook 2007.
    $99.00
       
    MIG2PPT07 - Migrating to PowerPoint 2007 (90 minutes)
    This 90-minute ExecuTrain Express course is designed for current PowerPoint users who are migrating to PowerPoint 2007. Class participants will learn how to take advantage of new features in PowerPoint 2007 to create great-looking presentations more quick
    $99.00
       
    MIG2VISTA - Migrating to Windows Vista (90 Minutes)
    This 90-minute ExecuTrain Express course is designed for current Windows users who are migrating to Windows Vista.
    $99.00
       
    MIG2WORD2007 - Migrating to Word 2007
    This 90-minute ExecuTrain Express course is designed for current Word users who are migrating to Word 2007. Class participants will learn how to use new features in Word 2007 to create and format documents more quickly.

    Customer Reviews


    Write A Review