Excel Overview

Ribbon Tabs and Mini toolbars

Office Buttons

Quick Access Toolbars

File formats

Graphic Enhancements

Enhanced Theme Colours

Office Themes and SmartArt

Spreadsheet Basics

Navigation & GoTo

Selecting Cell(s), Column(s), Row(s), Sheet(s)

Data Entry of Text, Numbers, Dates, Fractions,

Pick From List

New, Open, Close & Save Workbooks

New, Copy, Move, Rename & Delete Sheets

Formatting Data, Cell Borders, Colour Options, Alignment, Column Width, Auto Fit

Inserting Cell(s), Row(s), Column(s)

Deleting Cell(s), Row(s), Column(s)

Clearing Data, Formatting

Cut, Copy, Paste, Paste Options, Drag & Drop

AutoFill & Custom Lists

AutoCalculate

Calculations and Formulae

Entering Simple Calculations

AutoSum Functions including:-

Sum, Average, Max, Min

Operators: + - * /

Watch Window

Data Lists

AutoFilter

Criteria

Sorting Options

Forms

Printing

Print Preview

Margins

Centre options

Page Break view

Print Area

Charts

Creating Charts with Wizard and Keyboard

Basic editing of charts

Resizing, Moving

Colour options

Data changes

Chart types

Printing Charts with or without data

Changing Chart Location

Additional Features

Help, Office Assistant, Tip of the Day

AutoCorrect

Window Panes

Smart Tags Overview

Sending via Email

Find & Replace