Exploratory Data Analysis With Excel - Part 1 - Basic Numerics

My full tutorial on exploratory data analysis (EDA) with Microsoft Excel. In this series I will introduce you to some of the most useful data analysis techniques in business analytics using trusty old Excel.

Throughout the series I will show you how to use the best that Excel has to offer for EDA:

1 - The mighty Data Analysis ToolPak
2 - Data visualizations like histograms, boxplots, and bar charts.
3 - Pivot tables
4 - Pivot charts

These are the same techniques that I've used in my hands-on analytics work (e.g., as part of my EDA for building machine learning models).

-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
📗 Get the Excel workbooks 📗
All the Excel workbooks used in this series are available here:

-----------------------------------------------------------------------------------------------------------------------
❓ Want to up-level your data analysis skills?
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:

🤖 From Excel to Machine Learning. No, Really! 🤖
Yes, you read that correctly. ANY professional can move from Excel pivot tables to analyzing data using machine learning. 💥

Check out the following YouTube video to learn more:

Stay healthy and happy data sleuthing!

#ExploratoryDataAnalysis #ExploratoryDataAnalysisWithExcel #EDA #EDAwithExcel

[DaveOnData]

💥 From Excel to Machine Learning. No, Really! (Full Webinar) 💥

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:

[venkatasatyaprakashkanduku]

Hi Dave, I came across your videos on Excel, R, and SQL recently. Believe me, you are one of THE BEST in teaching. I love the way you explain each concept and help the budding data scientists. I myself have been in teaching for nearly 12 years but have seen very few like. Keep doing such a great job. May GOD bless you and your family. Keep smiling and helping everyone. Cheers :)

[aobane]

Currently a business data analyst and I must say this is gold. Obtaining my masters in data science graduating in June of 2022, and you put my professors to shame. Clear and straight to the point. Will definitely be checking out more of your stuff.

[suzettepowell]

I am so happy that you decided to teach this topic. I will be watching the others in the series. Very clear delivery. Thanks.

[TheStoneclash]

Hi David! This is pure gold. Thanks for sharing your knowledge!

[manishavyas]

you are one of the best teachers I must say very useful videos. very informative, clear and to the point.

[williamtwichell]

Great video! Showed up in my recommended a couple days ago and I plan to watch many more on your channel.

[katebackshall]

These videos are so easy to follow! Thanks David!

[ifouzezi]

Thank you so much! This was super helpful.

[datarob]

Just getting to these videos. They are fantastic for people looking to use data to find things out

[randomlee]

ya so the teacher sent a whole playlist of this, which is great!

[methodical-monkey]

Thank You. You are helping me understand and put to use the basic statistics I learned from GradCoach channel. I truly appreciate your work.

[sorosfox]

You're fantastic David. Thank you so much for these videos. I'm learning so much. Please keep them coming. You're a lifesaver.

[baljeetgill]

You Rock, David😀
Absolutely love your videos and I am a beginner in Data Analysis

[ibadullahkhan]

very great sir you have dive into the concepts that i am looking for a long time finally here thank you

[atulp]

David - just came across your series.. these are fantastic... and appreciate the patient teaching. Love the content and style in your videos! Thanks for doing these!

[Flow_with_G]

Thank you so much! Great video and teaching. I can't wait to learn more from you!

[banonkekeirnowo]

this is what i am looking for... thank for the add in... it's so usefull...\

[waynelast]

5:00 is pretty insightful... I have not heard that much before.

[nikole]

Exploratory data analysis can have many hearts, don't worry about it!😂