This course introduces to the basic features of MS Excel for a business and also for personal purpose. It starts with absolute basics, creating and saving workbooks. It steps further into the process of entering data in cells, basic calculations, applying basic mathematical calculations, formatting worksheets, setting up pages for print and protecting workbooks. It provides learners with the core understanding of how to effectively operate and use the Excel spreadsheet software at basic and advance level. This course helps a learner to create workbooks, maintain the records of past, present and future with built-up formulae and get final charts in graphical form.
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
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'.