Excel Basics

• Overview of the Excel screen
• Creating, saving, closing, opening and updating a workbook
• Worksheets and workbooks

Working with rows, columns and cells

• Entering text, numbers, dates and percentages
• Selecting a cell, row or column
• Inserting and deleting rows or columns
• Resizing rows or columns
• Moving around the worksheet using the mouse or keyboard.
• Un-do and re-do
• Editing cell contents
• Copying and moving data
• Using the Office Clipboard

Working with formulas and functions

• Entering and editing a formula
• Formula rules
• The five basic functions – SUM, AVERAGE, MAX, MIN and COUNT

Formatting cells

• Aligning data within cells
• Wrapping and shrinking text
• Formatting numbers and dates
• Adding borders and shading
• Using the Format Painter