Data analysis in Excel
4.3 (379 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,914 students enrolled

Data analysis in Excel

Learn the complete Excel functions to undertake data analysis, data manipulation, visualization and much more in Excel.
4.3 (379 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,914 students enrolled
Created by Ashish Agarwal
Last updated 5/2020
English
English
Current price: $51.99 Original price: $74.99 Discount: 31% off
11 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 12 articles
  • 15 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Become an Expert in Excel
  • Undertake data analysis in Excel
  • Apply data cleaning techniques in Excel
  • Do advanced data visualization in Excel
  • Create dynamic and flexible models in Excel
Requirements
  • Absolutely none. We will teach everything from scratch.
Description

Hey, welcome to our very popular online course. 

We are glad to see you visit this course. 

If only we could shake hands!


What is this course about?

In this course, we will teach you the comprehensive skills to make you an Expert in Excel for all sorts of data analysis.

We will illustrate the following broad content topics in great detail in this course:

1) Data analysis on real life data sets

2) Data cleaning and manipulation 

3) Data visualization

It is a very comprehensive course that will teach you the complete Excel skills in 1 single course.


How is this course useful for YOUR purpose?

Hey, did you watch the promo video? If not, please do. 

If you are looking to learn the complete Microsoft Excel skills, then you are at the right place.

We take you from basics to more advanced functionalities of Excel in this course.

Look, Microsoft Excel is ubiquitous. 

It is used in almost every job we do in today's world.

So your job will also possibly require you to work with Excel.

As such, being proficient in Excel is a must have skill in today's data driven world.

Our course does exactly that - we teach all that you need to know in Excel.

You have lifetime access to the course once you enroll. 

So even if you don't plan to start now, you can still enroll and come back anytime later.


What makes this course different than others?

This course content is unique!

You will learn exactly what you need to know in Excel.

You get access to practical real life illustrations of all functionalities in Excel.

It is a completely hands-on course.

You will be carrying out the real life illustrations along with the instructor.

We provide you the same set up as the instructor. 

You can download all illustration spreadsheets at your end.

You will feel as if somebody is guiding you step by step in all the illustrations.

It is a very practical on the job training for you.

You are going to love our instructor's teaching style. 

He makes it very engaging and fun learning experience.

You will have practice assignments to test your learning from the course

The Practice Assignments are marked with varying difficulty levels - High, Medium and Low.

There are manually edited hand typed captions added on all lectures of this course. 

Feel free to refer to them in case you feel the need.



What are other students saying about this course?

Check our our reviews below.

Read what student Supanut Konsila wrote - 

"Thanks a lot for teaching me. This course helps me understand enormously for working with large data."

Go to the reviews section below to read more such stories.


What if I do not like the course?

Well, we will be very sad to hear that you did not like the course.

But you are well protected.

You have a 30 day money back guarantee in case you are not happy with the course.

No questions asked.

But we sincerely hope, you will definitely like the course!



What  next?

Start learning now.

See you inside the course.


Who this course is for:
  • Anyone who wants to learn Excel completely
  • Business analysts
  • Financial Analysts
  • Consultants
  • Start up founders
  • Project Managers
  • College students
Course content
Expand all 71 lectures 06:31:01
+ Module 1: Overview of data analytics and MS Excel
12 lectures 37:40
Warm up with very basic excel functionalities
07:01
Understanding formatting in excel
04:13
Using the $ sign in Excel
05:35
Keyboard short cuts in Excel
00:03
Recap: what did we learn Module 1?
01:16
Practice Assignment #1: DIFFICULTY LEVEL - EASY
00:24
SOLUTION TO PRACTICE ASSIGNMENT #1
00:03
+ Module 2: Data cleaning and analysis using TEXT functions
14 lectures 01:00:07
What will we learn in this module?
04:39
Download the excel template for this module
00:34
Illustration 1: Understanding LEN, FIND, LEFT, CONCATENATE functions
15:04
Illustration 2: Understanding the TRIM and FIND function
08:35
Illustration 2: Understanding the LEFT and MID function
12:28
Illustration 3: Introduction
01:44
Illustration 3: Understanding the SEARCH function
06:26
Illustration 3: Understanding the IFERROR function
03:33
Illustration 3: Understanding the IF function
03:32
Recap: what did we learn in Module 2
00:52
Practice Assignment #2: DIFFICULTY LEVEL - MEDIUM
00:24
SOLUTION TO PRACTICE ASSIGNMENT #2
00:05
Please provide us your valuable feedback on the course thus far
00:25
+ Module 3: Data analysis and visualization using basic excel functions
17 lectures 02:00:39
What will we learn in this module?
03:44
Download the excel template for this module
00:34
Data analysis: Understanding the SUMIF function
08:14
Data analysis: Understanding how to calculate the growth rates
03:58
Data analysis: Understanding the VLOOKUP function
11:40
Data analysis: Understanding the HLOOKUP function
09:31
Data analysis: Understanding the INDEX and MATCH function
13:56
Data analysis: Understanding the COUNTIFS function
09:09
Data visualization: Understanding the LINE chart
12:33
Data visualization: Understanding the PIE chart
11:45
Data visualization: Understanding the COLUMN chart
13:03
Data visualization: Understanding the STACKED chart
10:56
Data visualization: Understanding the CONDITIONAL FORMATTING functionality
06:58
Recap: what did we learn in Module 3
01:03
Practice Assignment #3: DIFFICULTY LEVEL - MEDIUM
00:25
SOLUTION TO PRACTICE ASSIGNMENT #3
00:15
+ Module 4: Data analysis using advanced excel functions
12 lectures 01:17:31
What will we learn in this module?
02:52
Download the excel template for this module
00:34
Understanding the LIST function
05:45
Understanding the OFFSET function
08:30
Understanding the SUMPRODUCT function
08:24
Understanding the GOAL SEEK functionality
08:29
Understanding the INDEX and MATCH function
18:54
Understanding the PIVOT TABLES functionality
11:14
Understanding the INDIRECT function
11:31
Recap: what did we learn in Module 4?
00:51
Practice Assignment #4: DIFFICULTY LEVEL - MEDIUM
00:25
SOLUTION TO PRACTICE ASSIGNMENT #4
00:02
+ Module 5: Advanced data visualization in excel
14 lectures 01:28:48
Download the excel template for this module
00:34
Understanding the COMBINATION chart in excel
10:34
Understanding the WATERFALL chart in excel
14:16
Understanding the DYNAMIC LINE chart in excel
13:17
Understanding the AREA chart in excel
04:46
Understanding the INDEX chart in excel
10:01
Understanding the RADAR chart in excel
04:24
Understanding the SCATTER chart in excel
09:42
Understanding the BUBBLE chart in excel
06:24
Understanding the GANTT chart
11:47
Recap: what did we learn in Module 5?
00:55
Practice Assignment #5: DIFFICULTY LEVEL - MEDIUM
00:24
SOLUTION TO PRACTICE ASSIGNMENT #5
00:02