Microsoft Excel 2007 Foundation Guide

By the end of the Excel 2007 foundation guide you will be able to create new workbooks; edit and format cells; use and understand basic formulae and the different printing options.

Don't forget the end of tutorial quiz to test what you have learnt

Getting Started with Excel 2007

The Application Window

The Office Button

The Quick Access Toolbar

The Ribbon

The Excel spreadsheet

The Formula Bar

The Status Bar

Live Preview and the Mini Toolbar

Excel 2007 Keyboard Shortcuts

Creating a Workbook

Creating a New Workbook

Navigating a Worksheet

Excel Mouse Pointers

Entering and Editing Data

Undo and Redo

Selecting Cells

Using AutoFill

Using Custom Lists

Saving a Workbook

Opening an Existing Workbook

Closing the Workbook

Editing a Worksheet

Using Cut, Copy and Paste

Office Clipboard

Cell Comments

Paste Special

Writing Formulae

Using Formulas

BODMAS

The Sum Function

Using Functions

Statistical Formulas

Relative and Absolute cell References

Formatting a Worksheet

Formatting Labels

Formatting Values

Cell Alignment and Orientation

Borders and Shading

Cell Styles

Format Painter

Clear Cells

Managing Worksheets

Inserting and Deleting Rows, Columns and Cells

Insert and Delete Worksheets

Customising the Sheet Tabs

Splitting and Freezing Panes

Printing a Worksheet

Print Preview

Add a Header and Footer

Adjusting Sheet Margins and Orientation

Adjusting the Size and Scale

Setting the Print Area

Hiding Columns and Rows

Print Titles

Using Page Breaks

Printing the Worksheet

Email Stumble

Guides