Starting Excel 2007

• The Excel Environment
• Cell Referencing
• Entering Numbers and Text
• Adding Columns and Rows
• Worksheets and Workbooks
• Creating, Saving and Closing Workbooks
• Switching Between Workbooks
• Saving Using Different Names
• Saving Using Different File Styles

Using Help

• Where to Get Help
• How to Search and Print Contents
• Table of Contents

Selection Techniques

• Selecting a Cell and a Range of Connecting Cells
• Selecting a Range of Non-Connecting Cells
• Selecting the Entire Worksheet
• Selecting a Row, a Range of Connecting and Non-Connecting Rows
• Selecting a Column, Connecting Columns and Non-Connecting Columns

Manipulating Rows and Columns

• Inserting Rows and Columns into a Worksheet
• Deleting Rows and Columns within a Worksheet
• Modifying Columns and Rows
• automatically Resizing

Copying, Moving and Deleting

• Copying and Deleting Cell or Range Content
• Moving Contents of a Cell or Range
• Editing, Using Undo and Redo
• Autofill
• Sorting, Searching and Replacing Data

Manipulating Worksheets

• Switching Between Worksheets
• Renaming Worksheets
• Inserting New Worksheets
• Deleting, Copying and Moving Worksheets
• Moving Worksheets Between Workbooks

Font Formatting

• Using Font Type, Style and Size
• Using Bold, Italic and Underline
• Formatting Cell Borders
• Using Background Colour and Font Colour

Alignment Formatting

• Aligning Cell Contents
• Cell Orientation
• Text Wrapping and Format Painter

Number Formatting

• Setting Currency, Decimal Points, Commas, Dates and Percentages

Formulas

• Creating, Copying and Operating Formulas

Cell Referencing

• Using Relative and Absolute Cell Referencing

Functions

• What are Functions?
• Sum, Average, Max, Min, Count Functions
• Using 'If' Functions

Charts

• Inserting Different Chart Types
• Resizing and Deleting Charts
• Formatting a Chart
• Changing Chart Type
• Copying ands Moving Charts Between Worksheets and Workbooks

Customisation

• Modifying Basic Options
• Using the AutoCorrect Options

Page Setup

• Altering Worksheet Margins, Orientation, Page Size, Headers and Footers
• Scaling Worksheets to Fit

Printing Techniques

• Spell Checking
• Setting Gridlines, Titles, Margins, Row and Column Headings