This course describes the performance outcomes, skills and knowledge required to operate spreadsheet applications and perform basic operations, including creating and formatting spreadsheet data, incorporating charts and objects, and customizing and printing spreadsheets.
COURSE STRUCTURE
This course is divided in 12 sections with questions posed at the end to reflect on learning. After successful completion of the course, learners will be awarded a certificate of course completion.
At the end of this course, learners would be familiar with the following:
- Open spreadsheet application, create spreadsheet files and enter numbers, text and symbols into cells according to information requirements.
- Save spreadsheet to directory or folder.
- Enter simple formulas and functions using cell referencing where required.
- Correct formulas when error messages occur.
- Use a range of common tools during spreadsheet development.
- Edit columns and rows within the spreadsheet.
- Use the auto-fill function to increment data where required.
- Open and view different toolbars.
- Use formatting features as required.
- Insert headers and footers using formatting features.
- Manipulate imported object by using formatting features.
- Create a chart using selected data in the spreadsheet.
- Print spreadsheet or selected part of spreadsheet.
Course Features
- DeliveryOnline
- ModeSelf-paced
- Duration6 – 14 hrs.
- TypeNon-accredited
- CertificateYes
- AssessmentsYes
- LanguageEnglish
- Price Why isn’t the price shown?