Students who are doing their Graduation/ post graduation, along with people who are starting their career soon.  Analytics is an important part in every job profile. Excel is the most common and advance tool for Analytics.

This course consist of-

1. Introduction to Excel

1. Introduction to Excel and its importance
2. Excel Sort & Filter
3. Conditional Formatting
4. Functions & Formulas in Excel
5. Data validation
6. VLOOKUP & HLOOKUP
7. Pivot table & Charts
8. Goal Seek & Scenarios

2. NEED FOR ANALYTICS & TYPE OF DATA

1. Introduction to Analytics and its importance

a. Type of analytics
b. Applications

2.Data Type & Measures of central tendency

• Numerical variable: Discrete & Continuous
• Categorical variable: Nominal & Ordinal
• Measure of central Tendency & related estimation

3.Sales data Representation & Statistics

• Histogram
• Bar Chart
• Pie Charts
• Scatter Charts
• Line Charts
• Map Charts
• Other Graphs

3. ANALYTICS USING EXCEL

• Data Analysis using Excel
• Dashboard using Excel

Case Studies & Practical Application of Learnings (as per student's req and understanding)

Assessments (MCQ and Case Studies)