Description

Unit Standard: 116937

This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel worksheets.

 

Prerequisites: Candidates should be comfortable using a mouse and keyboard

You will learn:

• How to get started with MS Excel
• How to create, modify, format and print a workbook
• Use basic formulas

Candidates who successfully complete a Portfolio of Evidence will receive a certificate of competence and awarded credits for these unit standards.

• Understanding MS Excel
• Explaining the MS Excel Screen
• Creating spreadsheets: entering and editing data
• Adding data to spreadsheets
• Adding data, dates numbers to a spreadsheet
• Navigating in MS Excel
• Creating and using multiple worksheets / workbooks
• Cut, Copy and Paste Options
• Saving Spreadsheets
• Entering basic formulas and using Autosum
• Manipulating cells
• Automatically filling cells
• Formatting a spreadsheet using the HOME ribbon
• Checking spelling
• Printing spreadsheets and printing options
• Using the Zoom feature