Curriculum
Module 1: Introduction to Excel
Excel 2016, Creating and Copying Formulae, Creating Functions, Printing, Charts, Basic Tables
Module 2: Advanced Excel 1
Create Range Name to Cell, Number Formatting, Date and Time Functions, Other Excel Functions
Module 3: Advanced Excel 2
Conditional Formatting, Validation and Protection, Range Names and Absolute References, Charts
Module 4: Excel Functions
Mathematical Functions, Text Functions, Logical & Reference Functions, Date & Time Functions, Financial Functions, Information Functions
Module 5: More on Excel
IF Functions, Nested IF Functions, LOOKUP TABLES, Basic Tables, Advanced Tables, Pivot Tables, Consolidation, Macros
Learning Outcomes
Who Should Attend?
Job Prospects
Certification
After completing this course and successfully passing the certification examination, the student will be awarded the “Excel and Advanced Excel” certification.
If a learner chooses not to take up the examination, they will still get a 'Participation Certificate'.