Excel 2007 - Tutorials
The New Interface 
- Navigate the New Interface
- Explore Interface Tabs
- Customise Quick Access Toolbar
- Explore the New Office Button
- Explore the mini toolbar
- Customise Excel
- Format Tables
- Save worksheet in a different Version
Formatting Tables
- Insert, Columns Rows &Tables, Delete, Rename, Add, Worksheets
- Adjust size of Columns and Rows
- Use Set Formats for Tables
- Freezing Rows &Columns
- Modifying Rows and Columns
- Formatting Fonts
- Use Colour
- Apply and Remove Filters
- Format Cells(set condition of cells)
Formulas
- Basic Formulas
- Order of Preference
- Relative Referencing
- Absolute Referencing
- Formula Ribbon
Basic Functions
- Explore the Function Tools
- Use AutoSum Functions - Add & Max
- Turn off AutoFormat Settings
- Use Text Functions Trim, Left & Upper
Advanced Functions
- Concatenate Function
- Sum If Function
- Vlookup & Hlookup Functions
- If Functions
CTRL D to Bookmark 
You will need Adobe reader to view the lessons, get the latest one here free for your computer.
