Excel – An Introduction

A beginner’s guide to the spreadsheet application: Microsoft Excel.

Prerequisites
None.

Course outline

• The difference between a Workbook and a Worksheet
  – Navigation between worksheets
  – Using the Zoom control
• Identifying cells and the Active cell
  – What is the Active cell?
  – Methods of moving the Active cell
• How large is a worksheet?
• Entering data
• Selecting cell ranges
• Changing font characteristics
• Adjusting cell alignment
• Cut, Copy and Paste methods
  – The Undo and Redo commands
• Adjusting column widths and row heights
• Using mathematics in Excel
• Workbook manipulation
  – Adding a new worksheet
  – Renaming, moving, copying a worksheet
  – Deleting a worksheet
  – Changing the colour of a worksheet tab
• Formatting data as an Excel Table

The session will take between 45-55 minutes to complete and is followed by a Q & A which is optional to attend.