About this Course

This module enables candidates to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application. Candidates will understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet, in addition to using standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.

On completion of this module each candidate will be able to:

1. Work with spreadsheets and save them in different file formats 
2. Choose built-in options such as the Help function within the application to enhance productivity
3. Enter data into cells and use good practice in creating lists. Select, sort and copy,  move and delete data
4. Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename   worksheets
5. Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognize error values in formulas
6. Format numbers and text content in a spreadsheet
7. Choose, create and format charts to communicate information meaningfully 
8. Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheet

Rate this course:

Log in to submit

Comments