Excel Data Analysis Masterclass - Dataisgood / Great Reviews

Master Advanced MS Excel topics - Excel Formulas, Excel Formatting, Excel Pivot Tables, Excel Dashboards & Analytics

4.35 (434 reviews)

Udemy

platform

English

language

Data & Analytics

What you will learn

Learn about basic formatting in excel.

Learn about sorting and filtering functions in excel.

Learn about UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, CONCATENATE functions in excel.

Learn how to find outliers and missing values in Excel.

Learn how to find standard deviation and percentiles in data using Excel.

Learn about IF, IF ERROR, COUNTIF, SUMIF and AVERAGEIF functions in excel.

Learn about using Color Bars and Color scales in excel.

Learn applying VLOOKUP and HLOOKUP functions and merge datasets using them in excel.

Learn how to merge datasets using Index and match.

Learn making Pivot Tables and Pivot charts in excel.

Learn making interactive dashboards in excel.

Learn about What-if analysis in excel.

Learn how to perform linear regression in excel.

Quizzes and exercises.

Turn real world data into business insights in Excel.

Best Practices for dashboard development, table and graph design.

Discover the most Powerful tool in Excel to transform your Data into Insight and intelligence.

Why take this course?

Welcome to the best online course from Dataisgood on Excel.

Microsoft Excel is one of the most used software applications of all time.

Hundreds of millions of people around the world use Excel. Read reviews of this course and about Dataisgood. Hundreds and thousands of People can't be wrong.

It is a very handy software that can be used to store and organize many datasets.

Using its features and formulas, one can use the tool to make send of the data.

This course provides you functionalities of excel used by data scientists and data analysts along with its basics.

You will learn to create interactive dashboards using excel.

In this course, you will cover:-

Basic formatting in excel
Datatypes of excel
Insertion and deletion of new rows and columns in excel.
Sorting and filtering data in excel
Learn about the different text functions- UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, TRIM, CONCATENATE, LEN
Learn about the different statistical functions- MIN, MAX, AVERAGE.
Finding different percentiles.
Finding missing values in data
Finding outliers in data
Learn about the different logical functions- IF, IFERROR, COUNTIF, SUMIF, AVERAGEIF.
Learn about conditional formatting.
Learn about lookup functions- VLOOKUP, HLOOKUP.
Learn about index and match
Learn to create pivot tables and pivot charts.
Learn to create interactive dashboards.
Learn about What-if Analysis:- Goal Seek analysis, Data Tables, Scenario Management.
Learn about performing linear regression in excel.
Advanced Filtering

Not only this, you will get to practice a lot of exercises on these topics.

We are also providing quizzes.

You will also have access to all the resources used in this course.

Instructor Support - Quick Instructor Support for any queries.

I'm looking forward to see you in the course!

Enroll now and make the best use of this course.

Screenshots

Excel Data Analysis Masterclass - Dataisgood / Great Reviews - Screenshot_01

Excel Data Analysis Masterclass - Dataisgood / Great Reviews - Screenshot_02

Reviews

Tarun

June 14, 2023

Direct and to the point, though a couple of exercises are missing in the beginning sessions. Nonetheless, a really nice course for quick learning !!

Jeremiah

April 28, 2023

This definitely is a good match for me. It is simplified and quite engaging. I would recommend this course to anyone out there looking to advance his/her knowledge in excel and its application into data analysis.

Elim

March 21, 2023

The instructor went too fast, her accent was difficult to understand. There were no attachments when they said that there were some.

Syed

September 11, 2022

Well-structured course, easy to understand with lots of examples and resources. Definitely a must for any beginner who wants to start learning Excel. Thank you so much!

kamal

August 4, 2022

A very good course. The course is very well structured and clear. Examples are easy to understand. This course helped me get a good understanding on Excel. Each concept is explained in great detail. It is worth taking. Highly Recommended.

Arun

July 20, 2022

Amazing course. This course provided a thorough overview of pivot tables. This course will take you from basic level to the advanced level. The Instructor is knowledgeable and clear with each and every topic. Each section is arranged according to their level. I would definitely recommend this course to everyone.

Rida

July 14, 2022

Amazing course. It's a good beginner course if you know nothing about excel. Everything was explained very well, and easy to follow. This course really covered all the basics and took me from beginner to expert! Thank you for such a wonderful course.

Sanket

July 4, 2022

Brilliant course. This is a great course for learning and improving Excel. I've learnt more things which can be performed in excel.

Debol

June 9, 2022

The header says master class and you start with nursery basics. Many things are not explained. Most irritating is that the resources tabs are not having the course material and when it is said that in the link there is data, the same cannot be found.

James

May 6, 2022

I love the basic fact that she breaks each functions meanings and what they do down in simple terms to help people understand its functions clearly.

SanthaRam

November 12, 2021

Structured course on Excel Fundamental features/functions supplemented by Quick Quizzes- makes this course a easy walk through and Downloadable resources help work on exercises offline, The presenter did a great job !Thumbs Up !

Joseph

November 10, 2021

Excellent course. There is so much to learn here about the Excel software and its associated analytics and formulas!.

Ganesh

November 10, 2021

Thanks very much for everything; All good – learnt lots; Had In-depth understanding sections of Excel & applying this practically.

Mastan

November 9, 2021

Very good course on excel. We knew excel little bit but never knew there are so many untouched features.

Binoy

November 6, 2021

I liked the way the course presented. Tutor was highly interactive to make the course much live and interesting.

Charts

Price

Rating

Enrollment distribution

Excel Data Analysis Masterclass - Dataisgood / Great Reviews - Distribution chart