Overview & Prerequisite

This Microsoft Excel 2007 training course is designed for new users of Microsoft Excel 2007 who have attended a Windows Foundation course or who have previous experience in the use of Windows..

Course content

Getting Started with 2007
Using the Ribbon instead of menus
The Quick Access Toolbar
Command Tabs
Contextual Command Tabs
The New File Menu

Editing Spreadsheet
Enter/Edit
Selection Techniques
Cut/Copy/Paste
Undo/Redo
Fill by Example

Basic Formulae
Enter/Edit Formulae
Arithmetic Operators
Autosum

Presentation
Number Display
Font Type/Size
Align Data
Patterns/Colours
Adjust Col/Row
Borders

File Procedures
Save/Save As
Open/Close

Printing
Print Preview
Define Print Area
Printing Worksheet

Page Setup
Orientation/Scaling
Centring Horiz/Vert
Headers/Footers
Sheet Options

Managing Formulae
Order of Precedence
Relative v. Absolute
Formula to Valve

Functions
Min/Max
Average/Count
Sum
IF
Comparison Operators

Range Names
Create & Define
Going to a Range
Printing a Range
Use in Basic Formula

Spreadsheet Efficiency
Cell Notes
Sorting
Page Breaks
Freeze Titles
Control Large Sheets

Charts
Create
Chart Types
Autoformat
Re-size/Move
Legends & Titles

Basic Filtering
Autofilter
Select Filter
Sort
Remove Filter