Data Science Course : Statistics using Excel

Programme highlights

Placement assistance

All the students would get placement assistance and help in cracking interviews

Mock interview will be conducted those interested 


Duration : 1 MONTHS

Weekdays : 8 am to 10 am

Week ends: 

Saturday: 10 am to 12 Sunday: 1 pm to  3 pm

 FLEXIBLE TIMING : 25 hrs

Training Material

Training Material will be provided to student module wise

Industry Experts as faculty

Instructors are having industry experience and would relate all the training to industry use case

Course Fees

 Course Fee: Rs. 25,000 (Classroom)

                   Rs. 20,000 (Online live)

The fees can be paid in 3 installments

Certifications (Specialization)

Student can choose the following specialization for Industry knowledge and relevant projects.

Specialization : Banking |Retail | Fintech

COURSE CONTENT

image12

Lesson 1: Introduction to Business Analytics

 What is Analytics?  Overview of different - 2 Analytic Areas  Customer Analytics  Industry-focused Analytics  Financial Analytics  Performance Analytics  Risk Analytics 

Lesson 2: Formatting, Conditional Formatting, and Important Functions

Formatting  Conditional Formatting  Logical Functions  And, If, Not, Or, True, False  Vlookup/Hlookup, Index, Match, Offset  Statistical and Mathematical Functions  Rank, Quartile, Decile, Percentile  Standard Deviation, Correlation, Mean, Median, Sum, Count, Sumifs, Countifs 

Lesson 3: Analyzing Data with Pivot Tables

 Pivot Table Creation  Grouping for different - 2 data types  Show and Summarize Values  Calculated Field and Calculated Items  Slicer 

Lesson 4: Dashboarding

 What is Dashboards and Excel Dashboard.  Overview of Chart types, Chart Formatting  Active X Form Controls  Principle of great dashboard design  Selecting Correct Chart to display data  Interactive Charts with Form Controls  Combo box, Check Box, Scroll Bar and Radio Button  Interactive Dashboard with Form Controls 

Lesson 5: Analytics with Excel

 Histogram  Solver Add-In  Goal Seek  Scenario Manager   Data Table  Descriptive Statistics 

 Descriptive Statistics  ANOVA  Moving Average  Testing Hypothesis  Measuring Covariance and Correlation  Distribution  Regression 

 Power Pivot  Power View  Power Query  Power Map 

Projects & Assignment

  • 5 Projects
  • 10 Assignments
  • 2 Exam

call us at +91 9740006768 to know more