Description

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.

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

• Describe the main points covered in Excel
  
• Select the options to print the data in Excel by applying all the techniques under print settings
  
• Create a named range that refers to a range of cells, constant value or a formula
  
• Create formulae by applying suitable Excel function tab on the ribbon
  
• Design a spreadsheet by applying options in data validation and protection to get a secured and error-free data
  
• Analyse the data and find solutions for various business problems
  

Who Should Attend?

• Management Students
  
• Graduates with Management background
  

Job Prospects

• Associate Support Technology Analyst
  
• Excel Analyst, Operations
  
• Information Security Analyst
  
• Technical Support Analyst
  
• Associate Information Security Analyst
  

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'.