Excel Manuals
Excel Basic
Suggested 1 day course
SAQA US ID 116937 – Create and Edit Spreadsheets
(NQF level 2 – 4 credits)
Formatting; Entering dates, numbers and text; Save; Print; Elementary formulas and Functions
Excel Intermediate
Suggested 1 day course
SAQA US ID 116940 – Use a spreadsheet to solve a given problem
(NQF level 3 – 6 credits)
SAQA US ID 116943
Enhance and functionality of graph /charts to a spreadsheet
(NQF level 4 – 3 credits)
Using Built In Templates; Formulas and functions; charts; Work with large spreadsheets; Working with multiple Workbooks/Worksheets; Advanced printing features; Customizing settings, Introduction to Charts
Excel Advanced
Suggested 2 day course
SAQA US ID 116940 – Use a spreadsheet to solve a given problem
(NQF level 3 – 6 credits)
SAQA US ID 116943
Enhance and functionality of graph /charts to a spreadsheet
(NQF level 4 – 3 credits)
Creating Templates; Database features – sorting, filtering, subtotals, pivot tables; What If Scenarios; Hlookup/Vlookup; Match and Index;Advanced IF statements; Date and Time Functions; Protection of Workbooks/Worksheets; Validation of data; conditional Formatting; Range Names; Introduction to Macros, Charts
Downloads