Excel new features Overview

Ribbon Tabs and Mini toolbars

Office Buttons

Quick Access Toolbars

File formats

Graphic Enhancements

Enhanced Theme Colours

Office Themes and SmartArt

Advanced Functions

Absolute Cell Addresses

Conditional Functions including:-

IF Statements

LookUp, VLookUp, HLookUp

Data Validation

Formatting

Additional Tools

Paste Options

Working with Sheets

Comments

Smart Tags Overview

Hyperlinks

Worksheet Protection

Track Changes

Create & Define Names

Creating Styles

Hiding Columns, Data, Comments

Editing Data Entries, Cell Contents, Formulae

Subtotals

Customising

Toolbars

Screen view options

Excel options

All printing options

Enhanced Format Tools

Date Formats

Number Formats

Text Alignment

Indenting Lists

Drawing Toolbar

Clear:

Data, Formats Comments

All Graphics:

Clip Art, WordArt, Importing Pictures, enhancing Worksheet/Cell appearance

Compare side by side

Advanced Data Manipulation Tools

Linking:

Cells, Worksheets, Workbooks

Updating Links

Charts

Customising:-

Type, Data, Titles, Legend, Labels

Manipulation of Data

Creating a Combination Chart

Auditing

Precedents and Dependants

Auditing Toolbar

List Functionality

Forms

Criteria, Record count

Sorting Options

Filtering Options including:-

AutoFilter

Advanced Filter

Copy to another Location