This is an Online class and I will conduct from my home and participants can login from their homes

Weekend Batch - 4 hours a day - 6 days (3 Weekends)

Probable Start Date: 19th Sept 2020

Probably End Date:  4th Oct 2020

Batches can be conducted in weekdays if a group of atleast 10 request for it - can be a 2 hours per day session for 12 days

For a participant to attend this course, basic Excel knowledge is required. They must be able to know the difference between Row/column/cell, create spreadsheets, modify spreadsheets and make basic calculations

This course will cover the following aspects:

a) Introduction to Data, Data & Its Importance

b) Filtering Data, Data Validation, Working with Charts

c) Right charts for right data, formatting and enhancing charts

d) Tables in Excel

e) Conditional Formating

f) Pivot Tables, Pivot Charts

g) Slicers, Timelines

h) Functions in Excel - Text, Date, Time, Information, Maths, Statistical, Logical, Lookup & Reference, Logical

i) Forecasting in Excel

j) Data Analytics in Excel - Analytics Introduction

K) Statistical & Analytical operations in Excel - Moving Average, Correlation, Regression 

This will be a handson session and participants are expected to have excel instealled in their laptop / desktop and need to use it.  Session will have live examples and assignments.

All participants will be evaluated based on assignment / test / attendance