+ 27 (0)10 110 0296    :   +27 (0)11 803 4216     email@m-cot.com

Microsoft Excel 2016 Essentials - DLS Consulting


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


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).




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

...download the programme in Pdf format

...back to ITC Training