Contact details: Paul Atwell @ paul.atwell1@nhs.net
Description
A beginner’s guide to the spreadsheet application: Microsoft Excel.
Prerequisites
None.
PLEASE NOTE: This is the 1st course in a suggested series of the 14 Excel sessions available.
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
- Formatting data as an Excel Table
- Workbook manipulation
- Adding a new worksheet
- Renaming, moving, copying a worksheet
- Deleting a worksheet
- Changing the colour of a worksheet tab
The session will take between 45-55 minutes to complete and is followed by a Q & A which is optional to attend.