The learner will learn to create, edit, format and print a spreadsheet
Version 2003
Duration
1 day
Unit Standards
Saqa US ID: 116937: Use a Graphical User Interface (Gui)-Based Spreadsheet Application to Create and Edit Spreadsheets
Prerequisites
The learner must have attended an introductory Windows course
Course Content
Module 1: Microsoft Excel Essentials
- The Ms Excel screen
- Toolbars
- Using the Mouse
- Menu commands
- Help
- Workbooks and Sheets
- Selecting Ranges
- Moving and Scrolling through the Workbook
Module 2: Creating a Spreadsheet
- Types of Data
- Data Entry
- Using AutoFill
- Editing Data
- File Management
- Formulas
- Absolute and Relative Addressing
Module 3: Editing a Spreadsheet
- Changing column/row widths
- Alignment
- Centring headings over a group of cells
- Inserting and deleting rows / columns
- Moving and Copying
- Checking spelling
Module 4: Formatting a Spreadsheet
- Changing number formats
- Borders and Fill (shading)
- AutoFormats
- Changing character fonts, sizes, styles and colours
- Freezing worksheet titles
- Zooming the display
- Copying a format to other cells
Module 5: Printing a Spreadsheet
- Selecting a Printer
- Print Preview
- Page Breaks
- Page Setup
- Headers & Footers
- Compressing Printouts
- Selecting a print area
- Print repeating headings on different pages
