ICDL Excel Advanced

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.


What are the benefits ?

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.


Download Outline
Scheduled Venues and Dates

RegionDates
Gauteng 14 Feb 22-17 Feb 22
27 Jun 22-30 Jun 22
12 Dec 22-15 Dec 22
25 Jan 21-28 Jan 21
17 May 21-20 May 21
20 Sep 21-23 Sep 21
Entry Requirements

It is assumed that learners accessing this skills programme are competent in:
•communication (NQF level 2); and
• MS Excel Intermediate.