Spreadsheet Skills 2

Purpose of the Qualification

This course builds upon the Spreadsheet Skills level 2 course. It includes how to combine, compare, consolidate and link large sets of data in a spreadsheet. In addition, how to ensure spreadsheet integrity and security are maintained. The course will be presented through two virtual weekly webinars and all assessments and learning will be conducted using Sparrow’s online portal. Students will need uncapped data, time for 2 weekly 1 hour sessions and access to either a tablet or laptop.

Core Skills

  1. Importing and exporting text files.
  2. Consolidating and linking data within spreadsheets.
  3. Applying filters and using forms in a spreadsheet.
  4. Creating and using macros.
  5. Combining and comparing large sets of data in a spreadsheet.
  6. Applying security features to a spreadsheet.
  7. Check input, output data.
  8. Check formulas and totals.
  9. Present data in different formats
  10. Managing files in a spreadsheet package.

 

NQF Level 3
SAQA ID 258876, 258878, 114977
Credits 9
Duration 6 weeks
Cost per Candidate R2 500,00