Excel Fundamentals

• Creating, saving closing, opening and renaming a 2007 workbook.
• Working with tabs and ribbons

Working with rows, columns and cells

• Entering text, numbers, dates and percentages
• Selecting a cell, cell-range, row or column
• Insert, delete and resize a row/column
• Moving around a worksheet

Formulas and functions

• Entering and editing a formula
• Rules for formulas
• Fixing problems with a formula
• Five basic functions
    - SUM, AVERAGE, COUNT, MIN, MAX
• Adding together a group of numbers
• Averaging a set of numbers
• Counting how many numbers in a range
• Finding the largest/smallest number in a range
• Where to find and use other functions

Formatting a worksheet

• The Format Cells dialog box
• Formatting a number or date
• Aligning text
• Formatting the font
• Setting borders and shading
• Copying cell formatting quickly
• Using AutoFormat to quickly format a table
• Inserting a picture or clipart
• Changing the background

Basic Auditing

• Identifying and fixing formula errors
• Spell check
• Find and Replace

Charts

• Creating a chart with one key press
• Creating a chart using the Chart Ribbons
• Changing the chart type
• Setting the chart title
• Labelling the chart axes
• Turning the gridlines on or off
• Showing or hiding the legend
• Adding data labels
• Showing the data next to the chart

Copying and moving data

• Cut, copy and paste
• Drag and drop
• The Office Clipboard

Printing

• Setting a worksheet up for printing
• Setting the page size and orientation
• Setting the margins
• Creating a simple header and footer
• Printing the whole worksheet or just a selection
• Previewing the worksheet before printing

Help

• Where to turn for help
• Using the Office Assistant
• Ask Excel a question
• Using the in-built Help facility