Data Analytics using Excel

Data Analytics using Excel

In this course, you will learn data manipulation, data cleaning, data mapping, exploratory data analysis and data modeling using Excel. This course will be ideal if you're looking to master the basics of analytics within a short period of time.

Who should do this?

  • If you want to explore the analytics field but are not sure if you should commit to a longer duration PG Program
  • If you're already dealing with data in spreadsheets at work and want to learn advanced Excel capabilities

Skills you will gain

  • Data Manipulation
  • Data Cleaning
  • Data Mapping
  • Data Visualization
  • Exploratory Data Analysis
  • Hypothesis Testing
  • ANOVA
  • Linear Regression
  • Excel
  • Storyboarding
  • Tableau

Learn from the best faculty

Dr. Abhinanda Sarkar

PHD (Stanford University)

Academic Director, Great Learning

Dr. Sarkar has an M.Stat. from the Indian Statistical Institute (ISI) and a PHD in Statistics from Stanford University. He has worked in organisations such as Massachusetts Institute of Technology (MIT) and IBM Research, General Electric(GE).

His publications, patents, and technical leadership have been in applying probabilistic models, statistical data analysis, and machine learning to diverse areas such as experimental physics, computer vision, text mining, wireless networks, e-commerce, credit risk, retail finance, computational marketing.

Prof. Raghavshyam Ramamurthy

MBA (Whitman School of Management)

CoFounder, Wilson Consulting Pvt. Ltd

Mr. Ramamurthy is a data visualization consultant with 15 years of work experience - working across the world. He worked in the US for 10 years in variety of industries like manufacturing, chemical processing, and utilities.

He is a consultant on Visual analytics, KPI management, Dashboard development and Product development. Along with being a consultant his strong passion for teaching has taken him to reputed schools like IIT-Madras, IIM-Trichy, IIM-Ranchi, Great Lakes Institute of Management and SP Jain School of Global Management.

Course syllabus

Module 1

Introduction to Analytics

1:00 hr

  • Course Overview
  • Applications of Analytics
  • Difference between business analytics and business intelligence

Module 2

Data Wrangling using Excel

2:50 hr

  • Data Manipulation
    • Basic functions, If-else, date functions, table, filter, Sort, Border, useful shortcuts to all the functions
  • Data Cleaning
    • Concatenate, left, right, mid, trim, uppercase, lowercase, find, search, Len, replace, and, or, char, substitute, conditional formatting
  • Data Mapping
    • V-lookup, H-lookup, Index-Match, offset, named ranges, dropdowns, radio buttons

Module 3

Exploratory Data Analysis using Excel

2:00 hr

  • Aggregating data using Pivot
  • Calculated Fields
  • Data Visualization
    • Box Plot, Bar Plot, Pie Chart, Line chart, Scatter plot, Histograms, Pivot Charts
  • Slicers
  • Case Study: EDA using Excel
  • Show more

Module 4

Statistics with Excel

6:00 hr

  • Descriptive Statistics
    • Sample, Population
    • Measures of central tendency
    • Measures of dispersion
    • Central limit Theorem
  • Hypothesis Testing
    • Test of proportion, Test of means
    • T-testing- one sample, two sample, paired t tests
    • Type 1 and type 2 error
  • Correlation and Covariance
  • ANOVA
  • Case Study: Decision making using advanced excel
  • Show more

Module 5

Data Modeling using Excel

2:00 hr

  • Linear Regression
  • Case study: Modeling using Excel

Module 6

Data Visualization using Tableau

2:50 hr

  • Basic Charts and Reports
  • Dimensions and Measures
  • Dashboard design and techniques
  • Storyboarding
  • Case study: Dashboard designing using Tableau
  • Show more

Projects

House price prediction using Excel

Analyzing FIFA 2018 player data

Analyzing factors that drives customers satisfaction / dissatisfaction in an airline company

Course certificate

Get certificate from Great learning which you can share in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

FAQ's

How does this course work?

The course is in a Self-Paced learning environment. So the candidates are expected to go through the online videos and are expected to learn concepts at their own convenient learning time. Further, there will be 2 mentored learning session to help the candidates with their doubts.

How does the mentored learning sessions work?

Participants are guided through a unique mentored learning process which happens in a live session. These sessions are guided by a senior industry mentor. These classes are live classes where you will have a video interaction with your mentor on a pre-scheduled weekend.

What is the duration of the program?

Total program duration is 6 weeks. Out of which, 4 weeks of content & 2 weeks of project work. However, the candidates will get 8 weeks to finish the course, in order to earn the certificate.

How long would the course content be available?

All candidates would have access to the course content of the program for 3 years from the date of their enrollment in the course.

When would the mentorship session be held in the program?

The session will happen on 2nd and 4th Saturday of the month.

I do not have Microsoft Excel license, what should I do?

The candidate needs to have Microsoft Excel installed in their Laptop or Desktop as a pre-requisite for taking this course.

I saw tableau in the curriculum, will I get tableau license to do this course?

The candidate will be working on the Tableau Public platform. So for that, there is no requirement for having a license.

What happens if I miss a mentor session?

As a participant of the course, you will be provided with the recording of the mentored session. In case of any additional doubts, our academic operations team will be there to help.

Is my course work evaluated?

The Project work at the end of the course will be evaluated, post satisfactory completion of it. You would be entitled to a certificate of completion for this program.

I do not see my question here, what should I do?

Please contact us at- cda@greatlearning.in

We use cookies to give you the best online experience. By using our website, you agree to our use of cookies in accordance with our privacy policy. Learn More