Data analysis in Excel from Udemy

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.

What's inside

Learning objectives

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

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

Syllabus

Course overview

Module 1: Overview of data analytics and MS Excel

Introduction to data analytics

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

Data analyst vs data scientist? What is the difference?

Overview of Microsoft Excel

Getting familiar with MS Excel interface

Warm up with very basic excel functionalities

Understanding formatting in excel

Using the $ sign in Excel

Keyboard short cuts in Excel

Recap: what did we learn Module 1?

Practice Assignment #1: DIFFICULTY LEVEL - EASY

SOLUTION TO PRACTICE ASSIGNMENT #1

Module 2: Data cleaning and analysis using TEXT functions

What will we learn in this module?

Download the excel template for this module

Illustration 1: Introduction

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

Illustration 2: Understanding the TRIM and FIND function

Illustration 2: Understanding the LEFT and MID function

Illustration 3: Introduction

Illustration 3: Understanding the SEARCH function

Illustration 3: Understanding the IFERROR function

Illustration 3: Understanding the IF function

Recap: what did we learn in Module 2

Practice Assignment #2: DIFFICULTY LEVEL - MEDIUM

SOLUTION TO PRACTICE ASSIGNMENT #2

Please provide us your valuable feedback on the course thus far

Module 3: Data analysis and visualization using basic excel functions

Lets look at the data

Data analysis: Understanding the SUMIF function

Data analysis: Understanding how to calculate the growth rates

Data analysis: Understanding the VLOOKUP function

Data analysis: Understanding the HLOOKUP function

Data analysis: Understanding the INDEX and MATCH function

Data analysis: Understanding the COUNTIFS function

Data visualization: Understanding the LINE chart

Data visualization: Understanding the PIE chart

Data visualization: Understanding the COLUMN chart

Data visualization: Understanding the STACKED chart

Data visualization: Understanding the CONDITIONAL FORMATTING functionality

Recap: what did we learn in Module 3

Practice Assignment #3: DIFFICULTY LEVEL - MEDIUM

SOLUTION TO PRACTICE ASSIGNMENT #3

Module 4: Data analysis using advanced excel functions

Understanding the LIST function

Understanding the OFFSET function

Understanding the SUMPRODUCT function

Understanding the GOAL SEEK functionality

Understanding the INDEX and MATCH function

Understanding the PIVOT TABLES functionality

Understanding the INDIRECT function

Recap: what did we learn in Module 4?

Practice Assignment #4: DIFFICULTY LEVEL - MEDIUM

SOLUTION TO PRACTICE ASSIGNMENT #4

Module 5: Advanced data visualization in excel

What will be learn in this module?

Understanding the COMBINATION chart in excel

Understanding the WATERFALL chart in excel

Understanding the DYNAMIC LINE chart in excel

Understanding the AREA chart in excel

Understanding the INDEX chart in excel

Understanding the RADAR chart in excel

Understanding the SCATTER chart in excel

Understanding the BUBBLE chart in excel

Understanding the GANTT chart

Recap: what did we learn in Module 5?

Practice Assignment #5: DIFFICULTY LEVEL - MEDIUM

SOLUTION TO PRACTICE ASSIGNMENT #5

End of course - what did we learn?

Quick Recap

Please provide us your valuable feedback

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Explores data analysis with Excel, which is ubiquitous in today's world

Taught by Ashish Agarwal, who is an expert in Excel and data analysis

Provides lifetime access to the course, allowing for flexible learning

Offers practical, hands-on training with real-life illustrations

May require basic knowledge of Microsoft Excel for optimal learning

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Data analysis in Excel with these activities:

Review basic statistical functions

Show steps

This course heavily utilizes statistical functions and concepts. Reviewing basic statistical functions prior to taking this course will provide reinforcement.

Browse courses on Statistics

Show steps

Review your notes from a previous statistics course or textbook.
Complete online tutorials covering mean, median, mode, standard deviation, range, and variance.
Practice using basic statistical functions in Excel or another software program.

Show all one activities

Career center

Learners who complete Data analysis in Excel will develop knowledge and skills that may be useful to these careers:

Financial Analyst

Financial Analysts use data to help businesses make investment decisions. To be successful in this role, you'll need to be proficient in Excel. This course will teach you how to clean data, analyze it, and present it in a way that is easy to understand.

See salaries and explore the career path for Financial Analyst

Operations Analyst

Operations Analysts use data to help businesses improve their operations. In this role, you'll need to be proficient in Excel, and this course will help you do that. You'll learn how to clean data, analyze it, and present it in a way that is easy to understand.

See salaries and explore the career path for Operations Analyst

Data Engineer

Data Engineers build and maintain the infrastructure that supports data analysis. In this role, you'll need to be proficient in Excel, and this course will help you do that. You'll learn how to clean data, analyze it, and present it in a way that is easy to understand.

See salaries and explore the career path for Data Engineer

Data Scientist

Data Scientists use data to build models that can help businesses make better decisions. In this role, you'll need to be proficient in Excel, and this course will help you do that. You'll learn how to clean data, analyze it, and present it in a way that is easy to understand.

See salaries and explore the career path for Data Scientist

Market Researcher

Market Researchers use data to help businesses understand their customers. In this role, you'll need to be proficient in Excel, and this course will help you do that. You'll learn how to clean data, analyze it, and present it in a way that is easy to understand.

See salaries and explore the career path for Market Researcher

Data Analyst

As a Data Analyst, your job is to refine and interpret data. An understanding of Microsoft Excel is essential, as you likely use it every day. This course will help you refine your skills. You'll learn how to clean data, interpret it, and present it in a meaningful way.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts help businesses understand their data and make better decisions. In this role, you'll need to be proficient in Excel, and this course will help you do that. You'll learn how to clean data, analyze it, and present it in a way that is easy to understand.

See salaries and explore the career path for Business Analyst

Statistician

Statisticians use data to make inferences about the world. In this role, you'll need to be proficient in Excel, and this course will help you do that. You'll learn how to clean data, analyze it, and present it in a way that is easy to understand.

See salaries and explore the career path for Statistician

Financial Manager

Financial Managers plan, direct, and coordinate the financial activities of an organization. While proficiency in Excel is not always a requirement for this role, it can be a valuable asset. This course will teach you how to use Excel to clean data, analyze it, and present it in a way that is easy to understand. These skills can be especially helpful for financial managers who are responsible for making data-driven decisions.

See salaries and explore the career path for Financial Manager

Software Engineer

Software Engineers design, develop, and maintain software applications. While proficiency in Excel is not always a requirement for this role, it can be a valuable asset. This course will teach you how to use Excel to clean data, analyze it, and present it in a way that is easy to understand. These skills can be especially helpful for software engineers who are working on data-driven projects.

See salaries and explore the career path for Software Engineer

Database Administrator

Database Administrators design, develop, and maintain databases. While proficiency in Excel is not always a requirement for this role, it can be a valuable asset. This course will teach you how to use Excel to clean data, analyze it, and present it in a way that is easy to understand. These skills can be especially helpful for database administrators who are working on projects that involve data analysis.

See salaries and explore the career path for Database Administrator

Web Developer

Web Developers design and develop websites. While proficiency in Excel is not always a requirement for this role, it can be a valuable asset. This course will teach you how to use Excel to clean data, analyze it, and present it in a way that is easy to understand. These skills can be especially helpful for web developers who are working on projects that involve data analysis.

See salaries and explore the career path for Web Developer

IT Manager

IT Managers plan, direct, and coordinate the activities of an organization's IT department. While proficiency in Excel is not always a requirement for this role, it can be a valuable asset. This course will teach you how to use Excel to clean data, analyze it, and present it in a way that is easy to understand. These skills can be especially helpful for IT managers who are responsible for making data-driven decisions.

See salaries and explore the career path for IT Manager

Computer Systems Analyst

Computer Systems Analysts design, develop, and maintain computer systems. While proficiency in Excel is not always a requirement for this role, it can be a valuable asset. This course will teach you how to use Excel to clean data, analyze it, and present it in a way that is easy to understand. These skills can be especially helpful for systems analysts who are working on projects that involve data analysis.

See salaries and explore the career path for Computer Systems Analyst

Marketing Manager

Marketing Managers plan, direct, and coordinate the marketing activities of an organization. While proficiency in Excel is not always a requirement for this role, it can be a valuable asset. This course will teach you how to use Excel to clean data, analyze it, and present it in a way that is easy to understand. These skills can be especially helpful for marketing managers who are responsible for making data-driven decisions.

See salaries and explore the career path for Marketing Manager