Upgrade to Excel 2010 - Course Outline

COURSE INFORMATION

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

TARGET AUDIENCE & PURPOSE

Excel Upgrade to 2010 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 2010.

OBJECTIVES

By the end of the 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 2003 or 2007

COURSE CONTENT

Using Excel 2010 Interface
Using the Interface
Using the Backstage View
Use the Quick Access Toolbar
Customise the Quick Access Toolbar
Use the Mini Toolbar
Use Ribbons and Tabs
Use Dialog Box Launchers
Use Contextual tabs
Use Live Preview

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 Sparklines
Insert Sparklines in a Worksheet
Customize Sparklines
Delete Sparklines

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 and Collapse Buttons
Add Slicers

Using New Table Features
Creating a Table
Removing Duplicates from a Table

Using New Formula Features
Using Formula AutoComplete

Using New Sort and 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
Working with the Compatibility Checker
Converting a File to Excel 2007 Format
Saving in a Binary Format

 

Upgrade to Excel 2010

Course Inclusions