HOT
blank

Data analysis in Excel

Business

Rating4.4
Enroll Now

Data analysis in Excel, available at $59.99, has an average rating of 4.39, with 80 lectures, based on 438 reviews, and has 2085 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to learn Excel completely or Business analysts or Financial Analysts or Consultants or Start up founders or Project Managers or College students It is particularly useful for Anyone who wants to learn Excel completely or Business analysts or Financial Analysts or Consultants or Start up founders or Project Managers or College students.

Enroll now: Data analysis in Excel

Summary

Title: Data analysis in Excel

Price: $59.99

Average Rating: 4.39

Number of Lectures: 80

Number of Published Lectures: 73

Number of Curriculum Items: 80

Number of Published Curriculum Objects: 73

Original Price: $64.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

  • Anyone who wants to learn Excel completely
  • Business analysts
  • Financial Analysts
  • Consultants
  • Start up founders
  • Project Managers
  • College students

Target Audiences

  • Anyone who wants to learn Excel completely
  • Business analysts
  • Financial Analysts
  • Consultants
  • Start up founders
  • Project Managers
  • College students

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.

Course Curriculum

Chapter 1: INTRODUCTION

Lecture 1: Course overview

Chapter 2: Module 1: Overview of data analytics and MS Excel

Lecture 1: Introduction to data analytics

Lecture 2: What are the key data analyst skills you need to learn?

Lecture 3: Data analyst vs data scientist? What is the difference?

Lecture 4: Overview of Microsoft Excel

Lecture 5: Getting familiar with MS Excel interface

Lecture 6: Warm up with very basic excel functionalities

Lecture 7: Understanding formatting in excel

Lecture 8: Using the $ sign in Excel

Lecture 9: Keyboard short cuts in Excel

Lecture 10: Recap: what did we learn Module 1?

Lecture 11: Practice Assignment #1: DIFFICULTY LEVEL – EASY

Lecture 12: SOLUTION TO PRACTICE ASSIGNMENT #1

Chapter 3: Module 2: Data cleaning and analysis using TEXT functions

Lecture 1: What will we learn in this module?

Lecture 2: Download the excel template for this module

Lecture 3: Illustration 1: Introduction

Lecture 4: Illustration 1: Understanding LEN, FIND, LEFT, CONCATENATE functions

Lecture 5: Illustration 2: Understanding the TRIM and FIND function

Lecture 6: Illustration 2: Understanding the LEFT and MID function

Lecture 7: Illustration 3: Introduction

Lecture 8: Illustration 3: Understanding the SEARCH function

Lecture 9: Illustration 3: Understanding the IFERROR function

Lecture 10: Illustration 3: Understanding the IF function

Lecture 11: Recap: what did we learn in Module 2

Lecture 12: Practice Assignment #2: DIFFICULTY LEVEL – MEDIUM

Lecture 13: SOLUTION TO PRACTICE ASSIGNMENT #2

Lecture 14: Please provide us your valuable feedback on the course thus far

Chapter 4: Module 3: Data analysis and visualization using basic excel functions

Lecture 1: What will we learn in this module?

Lecture 2: Download the excel template for this module

Lecture 3: Lets look at the data

Lecture 4: Data analysis: Understanding the SUMIF function

Lecture 5: Data analysis: Understanding how to calculate the growth rates

Lecture 6: Data analysis: Understanding the VLOOKUP function

Lecture 7: Data analysis: Understanding the HLOOKUP function

Lecture 8: Data analysis: Understanding the INDEX and MATCH function

Lecture 9: Data analysis: Understanding the COUNTIFS function

Lecture 10: Data visualization: Understanding the LINE chart

Lecture 11: Data visualization: Understanding the PIE chart

Lecture 12: Data visualization: Understanding the COLUMN chart

Lecture 13: Data visualization: Understanding the STACKED chart

Lecture 14: Data visualization: Understanding the CONDITIONAL FORMATTING functionality

Lecture 15: Recap: what did we learn in Module 3

Lecture 16: Practice Assignment #3: DIFFICULTY LEVEL – MEDIUM

Lecture 17: SOLUTION TO PRACTICE ASSIGNMENT #3

Chapter 5: Module 4: Data analysis using advanced excel functions

Lecture 1: What will we learn in this module?

Lecture 2: Download the excel template for this module

Lecture 3: Understanding the LIST function

Lecture 4: Understanding the OFFSET function

Lecture 5: Understanding the SUMPRODUCT function

Lecture 6: Understanding the GOAL SEEK functionality

Lecture 7: Understanding the INDEX and MATCH function

Lecture 8: Understanding the PIVOT TABLES functionality

Lecture 9: Understanding the INDIRECT function

Lecture 10: Recap: what did we learn in Module 4?

Lecture 11: Practice Assignment #4: DIFFICULTY LEVEL – MEDIUM

Lecture 12: SOLUTION TO PRACTICE ASSIGNMENT #4

Chapter 6: Module 5: Advanced data visualization in excel

Lecture 1: What will be learn in this module?

Lecture 2: Download the excel template for this module

Lecture 3: Understanding the COMBINATION chart in excel

Lecture 4: Understanding the WATERFALL chart in excel

Lecture 5: Understanding the DYNAMIC LINE chart in excel

Lecture 6: Understanding the AREA chart in excel

Lecture 7: Understanding the INDEX chart in excel

Lecture 8: Understanding the RADAR chart in excel

Lecture 9: Understanding the SCATTER chart in excel

Lecture 10: Understanding the BUBBLE chart in excel

Lecture 11: Understanding the GANTT chart

Lecture 12: Recap: what did we learn in Module 5?

Lecture 13: Practice Assignment #5: DIFFICULTY LEVEL – MEDIUM

Lecture 14: SOLUTION TO PRACTICE ASSIGNMENT #5

Lecture 15: Please provide us your valuable feedback on the course thus far

Chapter 7: End of course – what did we learn?

Lecture 1: Quick Recap

Lecture 2: Please provide us your valuable feedback

Instructors

  • Ashish Agarwal
    Ashish Agarwal
    15+ years in Business & Finance, ex-McKinsey & ex-BlackRock

Rating Distribution

  • 1 stars: 9 votes
  • 2 stars: 13 votes
  • 3 stars: 55 votes
  • 4 stars: 175 votes
  • 5 stars: 186 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024