Program Highlights

Programs are designed to empower participants by focusing on industry relevant process training.

Courses are crisp but comprehensive, lucid and relevant.

Simulated office environment to enhance, consolidate and reinforce the industry ready supplements effectively.

Knowledgeable, credible and dedicated industry veterans as trainers.

 

Benefits

Understanding of the industry in its width.

Smaller learning curve which will enable quicker growth.

Improved efficiency and quicker yields in operations.

 
 
Data Analytics Program
 
  Program Objectives:  
 
  • Appreciate the importance of data analytics in business
  • Understanding the use of MS Excel for basic data analytics
  • Comprehend, understand and use of functions for various situations
  • Understand the use of tools to Automate repetitive tasks
  • Incorporate quality checks while automating tasks
  • Learn to automate repetitive tasks with dynamic user interface
  • Increase readiness to use the learning at work immediately
 
  Program Content:  
 
  • Setting the context
    Business context of large data generation
    Need for data analytics
  • Introduction to MS Excel
    Scope and Features
    Data Import & Export
    Data Presentation
  • Functions and Situations
    Data classification and arrangement
    Look-up functions
    Database functions
    Arrays and Pivot tables
  • Automation
    Macros Basics
    Adding
    / Modifying sheets
  • Dynamic Inputs
    Input Boxes
    Message Boxes
    Alerts