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