MS Excel 2010 Upgrade

MS Excel 2010 Upgrade Course Information

Duration: 1/2 Day Price: $320

Software and Version	Course Length	June 2021	July 2021	August 2021	September 2021	October 2021	November 2021	December 2021
Excel 2010	1/2 Day Course	1 June – AM session	16 July – AM session	3 August – AM session	23 September – AM session	20 October – AM session	4 November – AM session	–

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

Course Inclusions

Comprehensive learning materials incl. exercise files
Post course telephone support
‘Certificate of Attendance’
on completion of course
Morning & afternoon tea

Course Prerequisites

Participants should already:
Have existing Intermediate/Advanced skills in Excel 2003 or 2007

MS Excel 2010 Course Content

Print Course Outline (PDF)

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 2010 Format
Saving in a Binary Format

MS Excel 2010 Upgrade