Great Learning
Great Learning Logo

Data Analytics using Excel 

  • Offered byGreat Learning
  • Private Institute

Data Analytics using Excel
 at 
Great Learning 
Overview

Understand several phases of a Data Analytics project, Data Cleaning, and different Excel functions that support data analytics

Duration

2 hours

Total fee

Free

Mode of learning

Online

Difficulty level

Beginner

Official Website

Explore Free Course External Link Icon

Credential

Certificate

Data Analytics using Excel
Table of contents
Accordion Icon V3

Data Analytics using Excel
 at 
Great Learning 
Highlights

  • Earn a certificate of completion from Great Learning
Details Icon

Data Analytics using Excel
 at 
Great Learning 
Course details

Who should do this course?
  • For anyone who wishes to learn about Data Analytics
What are the course deliverables?
  • Data Cleaning
  • Sort and Filter
  • LOOKUP function
  • Conditional formatting
  • Data Validation
  • Pivot tables
More about this course
  • Learn to perform Data Analytics using excel in this course
  • This free course has been designed in order to prepare you for meaningful opportunities in the future with respect to Data Analytics
  • The course starts with the Introduction to Data Analytics and explains the phases of the Data Analytics project
  • It will further guide you to use different functions of excel with regard to Data Analytics like Sort and Filter, Lookup functions, conditional formatting, and more
  • The course will also guide you about Pivot tables and about their use in Data Analytics
  • The final phase of this course will cover Data Visualization, in which you will be able to learn how to represent data using pictorial charts and tables
  • Using various examples, the instructor has beautifully explained Data Visualization in the course
Read more

Data Analytics using Excel
 at 
Great Learning 
Curriculum

Data Cleaning

Introduction to Data Analytics

Phases of Data Analytics Project

Data Validation

Pivot Tables

Functions - Data Analytics using Excel

Sort and filter

Lookup Functions

Conditional formatting

Data Visualization using excel

Other courses offered by Great Learning

97 K
4 months
– / –
2.75 L
12 months
– / –
1.2 L
4 months
– / –
2.75 L
12 months
– / –
View Other 1237 Courses
Right Arrow Icon

Data Analytics using Excel
 at 
Great Learning 
Students Ratings & Reviews

4.8/5
Verified Icon50 Ratings
N
Neha Agrawal
Data Analytics using Excel
5.0
Learning Experience: It was great actually i understand practically what data are important how to bring all the important in one format do analysis of it
Faculty: Faculty was good actually from A to z he teaches everything in detail with example Course curriculum is good the practically in any company whether marketing, finance, etc how to reduce the time n efforts in all calculation i exceel sheet
Course Support: Any company u go they usually they to have this basic knowledge if u dont they will give training n cut ur salary plus i use data ananlyis in financial analyst
Reviewed on 16 Oct 2022Read More
Thumbs Up IconThumbs Down Icon
A
Ayush Pandey
Data Analytics using Excel
5.0
Learning Experience: Fantastic
Faculty: Best Best
Course Support: Yes
Reviewed on 5 Sep 2022Read More
Thumbs Up IconThumbs Down Icon
View All 7 Reviews
Right Arrow Icon
qna

Data Analytics using Excel
 at 
Great Learning 

Student Forum

chatAnything you would want to ask experts?
Write here...