Data Analysis for BEGINNERS in Excel in 2024 | No Python Required

How to analyze data with no programming languages in 10 minutes.

Have you ever looked at an Excel spreadsheet and wondered, "Where do I even start?" The numbers blur into a maze of confusion, and the data seems like an unsolvable riddle. All while the clock is ticking on your deadline. The good news is, as a data analyst, you don't necessarily need to use complex programming languages like Python or R. In this video, I'm going to show you a real-world example of how we can use Excel to automate gathering and cleaning data, analyzing and exploring data, and then visualizing your findings in a dashboard.

LEARN MORE
===========

⏲ TIMESTAMPS
==============
0:00 You don't need Python or R to analyze data
0:48 Gathering and cleaning data with one tool
4:28 If you want to improve your productivity
4:42 Creating key statistics
8:13 Analyzing data & creating a dashboard
9:55 If you don't have the Analyze Data feature
10:43 Analyzing data & creating a dashboard

#DataAnalysis #Excel #ExcelTutorial

[MyOnlineTrainingHub]

❓What is one Excel feature or function that you wish you understood better?

[excelisfun]

Wow!!! This is wonderful video, Mynda!!!! The reason it is wonderful is because you tell the truth about data analysis: you often do not need tools like R and Python. Excel is right there in front of you ready to sever : ) Then you go on and show a great suite of Excel tools and even showed the Data Analysis Descriptive Statistics tool!

[mikrom]

I love this type of videos. It's not just step by step tutorial, but more a worflow with best practices during which you can learn multiple things by seeing them in real usecases.

[mogarrett]

never get bored with your tutorials. Love it

Mo

[dmitriygalat]

Mynda you are the best! I am checking your news as often as weather forecast.

[foxygvq]

Brilliant thank you. You asked what everyone would like more of, I personally would like more on automation. I'm a Procurement Manager and therefore work with a load of numbers but not in an accounting setting. Bid comparisons, analysis of those, tracking invoice payments against contracts, indices etc. it would be great to help me simplify my work. I've already incorporate a lot of your suggestions, but I can always do better. Thanks

[supinderbabra]

100% my most favourite Excel instructor. Everything is done so well and clearly. Thank you and bless you always!

[gerardthompson]

Welcome back, and thank you for sharing this.

[MichaelVB]

Let and lambda helper functions. Thank you for all you do to help people become more proficient in Excel. Love all your videos.

[FarhanMerchant]

Really fascinating ; you made it really simply and believable.

[moshegolo]

Thank you for the video, you're simply brilliant! I would be happy to learn more about statistical tools in Excel and also about various uses of the SEQUENCE formula.

[leorc]

Excellent! Thank you Mynda! I vote for Power Query!

[marjoriefrancis]

Good Morning Mynda and thank you for all you do!

[dccd]

I loooove this kind of stuff. I didn't know you can do this in Excel!

[MegaTrickykid]

Thank you Mynda. Regarding your question: I'd like to learn more about power pivot. Would be great to see a video in the near future. Thanks in advance!

[DasboardTVDE]

I really want to understand power query better ! Thank you for the video this is what i need ! ❤

[SothearithKONGMrMuyKhmer]

Thank you so much for this tutorial! ❤

[amandeepsinghbassi]

Thank you Mam you are better than the best.power query playlist is dream video series.

[luisalonso]

Dax functions and how to apply then to real cases. thank you. great video!

[TheAndresOpeth]

Wow, it is a fascinating new world. I feel a little bit overwhelmed since I feel like I would like to understand it all. I will start step by step and purchase the Dashboard course now that has a discount. And then look for more topics. Thanks for opening my eyes Mynda.