Upgrade to Excel 2007 - Course Outline

COURSE INFORMATION

Duration: ½ day
Book: Enquire or make a course booking

TARGET AUDIENCE & PURPOSE

Excel Upgrade to 2007 Training is for people who have been using Intermediate to advanced Excel features in previous versions and wish to learn the new features of Microsoft Excel 2007.

OBJECTIVES

By the end of this course participants should be able to:

  • Use new File Features
  • Use new Help Features
  • Use new Conditional Formatting features
  • Use new Pivot Table features
  • Use new Table features
  • Use new Formula features in Excel
  • Use the new Sort and Filter features
  • Use the new Graphics features
  • Use the new File Format features

PREREQUISITES

Participants should already have existing Intermediate / Advanced skills in Excel 2002 or 2003.

COURSE CONTENT

Exploring New Excel Features
Hiding the Ribbon Tab, Using KeyTips, Inserting a New Worksheet, Freezing the Panes Exploring Excel Options, Customizing the Status Bar, Using Page Layout View, Using the Zoom Slider

Using New Help Features
Using Help, Using Help Online Content

Using New Conditional Formatting Features
Using Highlight Cell Rules, Using Manage Rules, Using Clear Rules, Using Data Bars

Using New PivotTable Features
Creating a PivotTable Report, Adding PivotTable Report Fields, Using Expand & Collapse Buttons
 Using New Table Features
Creating a Table, Removing Duplicates from a Table

Using New Formula Features
Using Formula AutoComplete

Using New Sort & Filtering Features
Sorting Records by Multiple Fields, Filtering Data to find Above Average

Using New Graphic Features
Using New Chart Features, Using SmartArt

Using New File Format Features
Using the Document Inspector, Marking a Workbook as Final, Saving to a PDF Format, Using the Compatibility Checker, Converting a File to Excel 2007 Format, Saving in a Binary Format

 

Upgrade to Excel 2007

Course Inclusions