Microsoft excel

The Quick Access Toolbar

The main screen layout

The Ribbons

Zoom Controls

The Home Ribbon

Conditional Formatting

Formatting Excel Tables

Filter by Colour

Inserting, Removing & Formatting Cells

AutoSum

The Fill Tool

Fill Series

Series for a Growth Trend

The Insert Ribbon

The Picture Tools

The Shape Tools

The Shape Effects Tools

SmartArt

Changing Layouts

Colours & SmartArt Styles

Inserting Charts

If statements

Conditional Formatting

Inserting Charts

The Insert Ribbon – Further Features

Linking Workbooks

Linking Excel with other applications

Creating Basic Macros

Data Validation

Custom Views

Working with large spreadsheets

Further Chart Effects

Hyperlinks

Text Box & Format Drawing Tools

Headers & Footers

Page Layout

Entering Basic Formulas

Hiding Cells & Data Protection

Relative Vs Absolute References

Relative & Absolute Addressing

Text functions

Statistical Functions

Logical Functions

Auditing & Comments

Input Tables

Sorting & Filtering

Named Ranged & What-if Scenarios

Pivot Tables

Conditional Formatting

Macros

Web Query

Linking

Consolidation

Standard & Combined Charts

Sharing & Tracking

Subtotals

Further Functions

Controls

Evaluate Errors

Deleting Blank Cells

Vlookup & Hlookup

Date Functions

Rank Function