Beginner to Pro FREE Excel Data Analysis Course

You asked for it. Here is my free course to help you kick start your data analytics journey.

In this comprehensive video, learn:

1) How to approach a data analysis project
2) A real-world example data with 10 problems
3) Step by step walk thru
4) How to calculate descriptive statistics (mean, median, quartiles, range, distinct items & count)
5) Exploratory data analysis in Excel
6) Analysis with formulas vs. pivots (necessary techniques)
7) Top / bottom performing items
8) Anomaly detection
9) Best in class analysis
10) Complete report preparation
11) Combining data in different tables (spreadsheets)
12) Answering open ended questions
13) Preparing and using Excel charts
14) Challenges & homework assignment

You will also learn below Excel features:
1) Using Tables
2) Formulas
3) Pivot Tables & Power Pivot measures
4) Conditional formatting
5) Charts
6) Data Validation
7) Keyboard Shortcuts & tricks

⏱ Video Timestamps:
==================

0:00 - Introduction
2:12 - Descriptive statistics in Excel
8:05 - Exploratory Data Analysis (EDA) with conditional formatting
13:20 - Sales by Country report with formulas
19:01 - Sales by Country report with Pivots
23:43 - Top 5 products with $ per unit
27:13 - Anomaly detection in your data
31:24 - Best in category analysis
33:36 - Profit analysis (combining two tables)
37:26 - Dynamic country level sales report
41:55 - Which products to discontinue (Open ended questions)

💥📁 Sample files:
================

⛔⚠ Got an ERROR - Can't Change Array?
==================================

What to watch next?
=================
I recommend setting aside sometime to practice what you just learned. But if you are in the mood to watch more, I suggest these videos:

Want to learn more? Join my Excel School 👉
=====================================

If you want more step by step education & resources to be AWESOME at your work, consider joining my Excel School program. This online class will teach you everything you need for data analysis + reporting roles.

My Recommended Excel Books 📚👌:
===============================

😎 SAY HELLO 👋
===============

Apart from YouTube, I frequently post on,

Have a beautiful day 🌼🌞😀

#DataAnalysis #Excel

[chandoo_]

GOT AN ERROR ⛔ "CAN'T CHANGE PART OF ARRAY"

[chuckt]

I've been using Excel for...ages...and I can't tell you how many times I've said "I didn't know you could do that" in this tutorial. Great work!

[laurak]

I just want to once again thank you for your time and for this beautiful tutorial. It’s well planned and filled with so many great tips. Thank you, sir!

[christophernjenga]

It's a pleasure to have a tutor like you chandoo. Your committed work has made it real for me. Congrats 👏

[Optimus]

It is the most detailed, clear and inspiring review of all the most important and useful functions and tools in Excel I've ever seen. Thanks a lot.

[Kingco]

A good teacher is known by his ability to explain complex concepts in simple language. I believe in my heart that you’re indirectly putting food on many people’s tables by making your tutorials easy to follow, and by extension less frustrating. Thanks, Chandoo. You are a star.

I'm not familiar with why and how you generated the KPIs(not sure this is the right word)used in the video. I'm a complete beginner in the world of analysis. Could you recommend a beginner-friendly course that would help me grasp the underlying concepts of Data Analysis, first; then, how to analyze data with Excel? Thanks.

[Nicolaslazar]

Systematic and clear like always. Thank you Chandoo. This video is my new Data Analysis Bible.

[xplosionbox]

you are "Excel Superstar" This is awesome. Thanks for being generous enough to share your knowledge.

[whoamiherein]

This was simply superb to follow and imbibe. It takes a lot to deliver something just as simple yet with clarity and with minimum noise. You have done this Mr. Chandoo. I like your Power BI one too. Thanks

[shashanknanglisatish]

Such an eye opener! Great teaching style and very detailed content, instantly subscribed in the first few minutes of the video. I love the fact that you not only inform us about Excel tools or functions but give us a glimpse of how you would analyse a dataset yourself. Your perspective is so refreshing and gives us much confidence as learners. These 49 minutes were super helpful and I'm very grateful to have stumbled upon your channel. Thanks for being one my online mentors, Chandoo! Sending good vibes your way!

[mariaakpoduado]

This is one of the best data analysis tutorials I've ever watched. So easy to follow. You are a great tutor, Chandoo

[gorihajirabee]

NAMASTE CHANDOO SIR🙏. I HAVE COMPLETED YOUR EXCEL DATA ANALYSIS COURSE. THANK YOU VERYMUCH.I HAVE WORKED AS A GOVT HIGH SCHOOL MATH TEACHER AND THEN AS A HEADMATER FOR 24 YEARS AND NOW GOING TO TAKE VRS.I'M PLANNING TO LEARN SOME SOFT SKILLS AS IT WAS MY DREAM TO BECOME A SOFTWARE.I WAS ADVISED BY SOMEONE TO GO FOR "SAP".I'M LEARNING EXCEL NOW. YOU ARE VERY DEDICATED.THANK YOU ONCE AGAIN FOR HELPING ME UNDERSTAND EXCEL BETTER🙏

[Theportraitdude]

This is fantastic, thank you so much! I have been using Excel for years and considered myself pretty decent at it, but your videos show me how much I have to learn. Thank you for the great examples!

[anuragkumargupta]

Hi Chandoo, Just did the analysis by myself. It was really helpful. USing your tutorial, I am able to say that my excel skills is good. I just need to understand business terms and metrics so that I can start to understand what data should I fetch from the original dataset.

[imgc]

Thank you for all your hard work! It’s a high quality educational content compacted with useful information. Really appreciate it!

[nikitasinha]

Thank you so much for making me feel like a data scientist within these 49 minutes sir

[TanmoyTheDeadBoy]

Thank you so much sir. I took crazy amount of time on this video due to my laziness(kept pausing and continuing for 3 weeks) But I've learned a lot. Idk if these will be sufficient to start a job But It increased my confidence. I'll keep watching your other videos and practicing (already watched many during pausing this one). Keep up the good work! God Bless you!

[rolisingh]

Your videos gave me direction and clarity about what I wanted to work for in life. You've no idea but you're a lifesaver, truly an angel to me. I hope you read this and this brings a bright smile to your face as you have brought to mine.💖

[jixseyloportacion]

Very good video! Learned a lot. Also, other things to consider when discontinuing a product is its contribution margin %. The product may have a high cm% but it may not be performing well in terms of profit % because the fixed expenses on a particular geography is high. Sometimes this can still be remediated especially when the product is newly introduced to the market.

[JayantaRai]

This is one of the best data analysis tutorials I've ever watched. So easy to follow. You are a great tutor, Chandoo ji