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.