Subject: Using Microsoft Excel to produce spreadsheets
Unit Standards: 16937 Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets (4 Credits) Level 2
Pre-requisites
Prior knowledge and skills to:
- Mathematical literacy and communication skills at least at NQF Level 1
- Operate a personal computer system (ID 116932 – NQF Level 1)
- Use generic functions in a Graphical User Interface (GUI)-environment (ID 117902 – NQF Level 1).
Level: Basic
Modules:
- Spreadsheet principles
- What is a spreadsheet
- Why use a spreadsheet application
- What are the names of some spreadsheet programmes
Starting with spreadsheets
- Starting the programme
- Understanding the screen
- Using the mouse
- Using the keyboard to move around the screen
- Entering data on a spreadsheet
- Editing data on a spreadsheet
- Entering data using the automatic fill
Working with file commands
- Saving a workbook
- Closing a workbook
- Opening an existing workbook
- Starting a new blank workbook
- Saving changes to a workbook
- Saving a workbook with a different Name
- Saving an Excel file in a different file format
- Deleting an Excel workbook file
- Exit the spreadsheet programme
Formatting spreadsheets
- Selecting cells for changes
- Formatting columns
- Formatting rows
- The Alignment command group
- The Number command group
- The Font command group
- Setting borders
- Using the Format Painter
Producing spreadsheets with formulas
- Entering formulas
- Filling formulas
- Using functions
- Checking your work
Editing spreadsheets
- Using the Cells command group
- Using the Clipboard command group
More features
- Check your spelling
- Using Auto Correct
- Finding and replacing
- Getting help
Printing a worksheet
- Previewing the worksheet
- Using page layout
- Printing a worksheet