Course At A Glance
Learning Unit 1: Data
Learning Unit 2: Display
Learning Unit 3: Protection
Learning Unit 4: Security
Learning Unit 5: Sorting
Learning Unit 6: Querying and Filtering
Learning Unit 7: Linking
Learning Unit 8: Templates
Learning Unit 9: Charts and Graphs
Learning Unit 10: Using Functions
Learning Unit 11: Pivot Tables and Dynamic Crosstab
Learning Unit 12: Scenarios and Versions
Learning Unit 13: Auditing
Learning Unit 14: Macros
Who Should Attend
This skills programme is designed for the public and private sector and is aimed at:
• individuals who use MS Excel and want to expand their knowledge of MS Excel in terms of data analysis, reporting and functions; and
• individuals who believe they already have most of the skills or knowledge taught in this course, but would like to obtain international certification.
How You Will Benefit
The benefits of this skills programme include:
• knowledge of the advanced capabilities of the MS Excel spreadsheet program;
• improved efficiency in utilising MS Excel to complete tasks; and
• secure documentation.
Duration
Four day practical contact session.
Scheduled Venues and Dates
Gauteng
(Pretoria)
|
Western Cape
(Cape Town)
|
Kwa-Zulu Natal
(Pietermaritzburg)
|
Eastern Cape
(East London)
|
|
8 Jul 2019 - 11 Jul 2019 |
- |
- |
- |
|
2 Dec 2019 - 5 Dec 2019 |
- |
- |
- |
|
10 Feb 2020 - 13 Feb 2020 |
- |
- |
- |
|
20 Apr 2020 - 23 Apr 2020 |
- |
- |
- |
|
13 Jul 2020 - 16 Jul 2020 |
- |
- |
- |
|
19 Oct 2020 - 22 Oct 2020 |
- |
- |
- |
Entry Requirements
It is assumed that learners accessing this skills programme are competent in:
• communication (NQF level 2); and
• MS Excel Intermediate.
