Excel Data Analysis Full Course Tutorial (7+ Hours)

[@LearnitTraining]

Exercise Files: learnitanytime.com/p/exercise-files-excel-data-analysis-full-course-tutorial-2024

[@mulbahdiakena7730]

thanks

[@helenonwuchekwa152]

Pls this learning exercise can't open in my phone

[@zintlekumsha3759]

@@helenonwuchekwa152 Mine as well 😥

[@adaobinnaemeka157]

thank you

[@adaobinnaemeka157]

link isn't working

[@haretztj4682]

Start 0:00 Introduction - Excel Intro to Data Analysis 0:09 List Design Basics 1:25 Inserting Tables for Analysis 4:59 Filtering Data in Tables 9:57 Using the Total Row 15:10 Conditional Formatting 18:57 IF Function 25:23 SUMIF and AVERAGEIF 31:52 SUMIFS 39:22 Inserting Recommended Charts 42:37 Adjusting Charts 48:24 Sparklines 50:41 Inserting Pivot Tables 57:25 Displaying Data as Count 1:05:18 Filtering Pivot Tables 1:09:06 Inserting Pivot Charts 1:17:47 Conclusion - Intro to Data Analysis 1:22:04 Introduction - Excel Pivot Tables 1:22:59 What are Pivot Tables? 1:24:05 Preparing Data for Analysis 1:29:39 Pivot Table Components 1:34:12 Building Pivot Tables to Show Different Values 1:40:30 Adding Fields to Pivot Tables 1:45:45 Using Built-In Filters 1:52:34 Filtering Data with Slicers 1:58:24 Displaying New Values from Data Sources 2:05:14 Inserting Pivot Charts 2:11:45 XLOOKUP 2:18:37 Joining Data Sets with XLOOKUP 2:26:48 Introduction to Advanced Pivot Tables 2:34:41 Inserting Pivot Tables from Tables 2:36:07 Calculated Fields 2:43:53 Using the Timeline Tool 2:49:43 Report Filter Pages 2:54:59 Pivot Table Layouts 3:01:42 Creating Pivot Table Designs 3:08:06 Adding Power Pivot Tabs to the Ribbon 3:15:32 Adding Tables to Power Pivot Data Model 3:18:15 Creating Table Relationships 3:23:17 Creating Columns with DAX Expressions 3:27:28 Displaying New Source Data in Power Pivot Tables 3:34:54 Data Mining with Flash Fill 3:37:45 Conclusion - Excel Pivot Tables 3:43:48 Introduction - Excel Copilot 3:44:39 What is Copilot? 3:45:04 Setting Up Copilot in Excel 3:49:05 Copilot Pane and Insights 3:51:54 Visualizing Data with Copilot 3:58:08 Sorting, Highlighting, and Filtering 4:06:16 Adding Formulas with Copilot 4:14:52 Asking Copilot Questions 4:20:37 Accessing Copilot Lab 4:29:44 Copilot Lab 4:30:58 Copilot with Excel Web Version 4:37:47 Conclusion - Excel Copilot 4:41:20 Introduction - Excel Power User 4:41:32 IF Function Basics 4:43:04 IF Functions with Calculations 4:49:20 Nesting AND with IF 4:53:43 Naming Ranges and COUNTIF 5:00:02 SUMIF and AVERAGEIF 5:05:59 SUMIFS 5:10:54 XLOOKUP 5:14:56 Populating Forms with XLOOKUP 5:23:21 Displaying Pivot Table Fields with COUNT Function 5:31:57 Calculated Fields 5:36:47 Slicers 5:43:33 Using the Timeline 5:49:42 Inserting Report Filter Pages 5:54:57 Flash Fill for Text Functions 5:59:38 Introduction to Advanced Conditional Formatting and Macros 6:05:55 Array Formula Basics 6:06:42 Looking Up Multiple Values with XLOOKUP 6:13:00 Array Functions 6:18:01 Advanced Conditional Formatting 6:25:08 Combo Charts 6:32:36 Developer Tab 6:40:18 Macro Basics 6:44:31 Relative Reference Macros 6:51:07 VBA Basics 6:55:07 Cleaning Up Macros 7:01:51 Conclusion - Excel Power User 7:10:22

[@LearnitTraining]

Thanks!

[@Kim-lb5ef]

This is so helpful for someone like me who wants to learn but doesn't have money to pay for online courses. Thank you so much for this!

[@LearnitTraining]

You are welcome!

[@morgancrous3021]

I wish all KZbin tutorials were this easy to follow along. Thank you a million times. This has helped me so much. Thanks Mo Jones for your way of explaining thoroughly.

[@LearnitTraining]

You're very welcome!

[@jiyani998]

hi I am your first subscriber

[@Me-wl3ej]

You are the BEST excel teacher for data analyst i have ever come across on KZbin. Others here on youtube will just push you to hate the course. I don't mind sharing this page to promote your great job .All i will say is that you have a good spirit and i want to say a very BIG THANKS Please is it possible to have tutorial on SQL,PYTHON from you?

[@LearnitTraining]

Thanks! Here is our Python course: kzbin.info/www/bejne/bZfGY4CKgbmLaLM Here is SQL Fundamentals: kzbin.info/www/bejne/r5mcY3V-otufqZo

[@develop7911]

Just started your course and I want to let you know that so far I like the way you talk and explain things

[@LearnitTraining]

Thanks!

[@albedoguardian875]

Hands down best learning channel on KZbin.

[@LearnitTraining]

Appreciate that!

[@sumitkoshti1171]

Watched the whole tutorial in one go along with practice, I must say this is gold mine for data analyst to cover each and every part of the excel along with advance excel skills. Thank you Mo.jones and Learnit for this tutorial.

[@LearnitTraining]

Great to hear!

[@Jubdas]

did you not have any bowel movements?

[@1grim]

@@Jubdas what if he sat down just after ??

[@Tita_jackie]

I am a beginner in excel. This is very straightforward and easy to follow along tutorial for newbies like me. Thanks!

[@LearnitTraining]

You're very welcome!

[@shivakrishnan1707]

Being a KZbinr myself , I know it must have taken a lot of efforts to combine multiple videos into one video or even if you shoot a 7 hour long video, it still takes lot of efforts and of course appreciate that .. Most interesting part for me in this video is Power Pivot because I am getting started with Power Pivot and I am well versed with rest of the features . Good video,thank you for uploading video

[@actautodeskcambodiantraine2550]

Please split them in peace by its criteria, too long

[@LearnitTraining]

Thank you so much for the kind words! Also good luck on your channel! Subbed!

[@sohannotes8399]

Successfully complete this course Alhamdulillah. Thanks MO JONES for your good job.

[@LearnitTraining]

You are very welcome!

[@ajalajessica3601]

The is amazing, just started learning excel as a novice and this is the one I fellow along with practice problem. The instructor is an amazing teacher.

[@LearnitTraining]

Glad you found the course helpful!

[@prem001k]

Thank you Mo Jones Sir

[@LearnitTraining]

You are very welcome!

[@yussufffolorunsho6637]

The best and most honest tutorial ever on KZbin

[@LearnitTraining]

Thanks!

[@raquelsilvagorbea]

⚠If you're practicing with Excel web version, here's what's not included: 1. Adding Sparkline to cell 2. Data Analysis Button 3. Pivot Table Analyze > Pivot Chart 4. Calculated Field 5. Show Report Filter Pages 6. Report Layout 7. Themes for Presentation 8. Add to Data Model 9. Analyze Data button 10. Cannot create pivot table to existing worksheet 11. Report Page Filters 12. Customize Ribbon > developer mode to make Macros (I was excited to try it) 13. Creating Table Relationships 💡If anyone was able to find any of these on the web version, please share! 💖Other than that, I learned so, so much even with the web version! I'm really grateful for this course! Don't let the lack of features stop you from learning, when you get the paid Excel version you can always go over these.

[@LearnitTraining]

Thank you for the great notes!

[@hasanferoz2364]

They also don't have Recommended Charts, Chart Decoration Sets

[@kristinamorris150]

How to add PivotTable Anaylze as a ribbon in excel when selecting a pivot table In your excel document select File > Options > Customize the Ribbon. Select Tool Tabs from the drop-down list of Customize the Ribbon box. Locate PivotTable Tools. Make sure Analyze (PivotTable Analyze) Tab is enabled. Select Ok.

[@raquelsilvagorbea]

@@kristinamorris150 Thanks this is great!

[@dreadfuldevs]

I know how to install excel for free (Whole Office 2019)

[@aurora-rene4263]

Made it to 60 minutes! Taking a brief break but--thank you very much!

[@LearnitTraining]

Great job!

[@balighabutaleb3988]

I have been using excel for years I learnt myself and been using it almost on daily basis and I thought I know a lot .but after watching only 22 mints in here I feel very blinded OMG it’s amazing I can Waite to finish and learn more thank you so much & all respect

[@LearnitTraining]

Thanks for sharing!

[@theoamor3853]

I just completed this course. This is the best excel learning resource I have come across. I'll be going through more videos. May I ask if you can develop python training as well. I know I don't deserve it but you're the best teacher out there.

[@LearnitTraining]

I'm glad you enjoyed the course, I'll be sure to keep an eye out for future Python training ideas!

[@anshikakashyap2000]

This video is amazing!! I have a request, please also create a 'Data Analysis Full Course for Google Sheets' as well, or provide a detailed short video of 'Data Analysis using Google Sheets'. Thanks!

[@LearnitTraining]

We definitely are looking into make a Google Sheets version of this class.

[@Matteblak]

Google sheets is garbage. Professional firms would not use it.

[@Devsodiq]

Hello, please can you share me the exercise file?

[@PahriPersonal]

​@@Matteblakwhy you write that rude comment?

[@Eljefe5948]

But you gonna forget everything 😂 you need to practice it

[@tech-n-data]

This is the one excel course to rule them all. Clear easy to follow instructions and well organized for easy follow along. Thank you.

[@LearnitTraining]

You are very welcome!

[@mehedihasan2276]

Just finished the course. It was great and easy to follow up. I feel confident enough to do my own projects right now. Thanks for this.

[@LearnitTraining]

You are very welcome!

[@critiquessanscomplaisance8353]

I really feel bad watching this for free. What I can do is subscribe and I hope that will suffice. Thank you so much for all the value you brought to everyone on the channel and may God reward you immensely!

[@LearnitTraining]

Do not feel bad! These videos are made for everyone!

[@Raj-3-]

​@@LearnitTraining🙌

[@ihmuiN]

I have completed previous Excel Training 4h and it was amazing. Now I am on this one. I appreciate for all. I would love to see SQL lessons as well if possible. It is really important for Data Analysis :)

[@LearnitTraining]

Thanks for watching! Check out our SQL Training playlist here: kzbin.info/aero/PLoyECfvEFOjYH2C2vl2A8yBPrbkVSbj9l

[@LearnitTraining]

We also have the same courses available ad-free for members like yourself! SQL Querying Basics Full Course Tutorial (2+ Hours): kzbin.info/www/bejne/o56kZXSmirJ8l6M SQL Server Reporting Services: Data Analysis Full Course Tutorial (7+ Hours): kzbin.info/www/bejne/iXzEZKigod9sq6s

[@ihmuiN]

@@LearnitTraining Thank you :)

[@davidonwe5345]

Thank God for this I have being searching for a complete data analysis course but all I get is short short videos Making things complicated

[@LearnitTraining]

You're very welcome! We hope you'll find this course helpful.

[@vishwajeettiwari9054]

I have seen so many tutorials on youtube , but the way you explain is so nice

[@LearnitTraining]

Thanks!

[@wilfredgatimu4947]

Absolutely learned a lot. Thank you

[@LearnitTraining]

You are welcome!

[@samialielghrably367]

Thanks!

[@LearnitTraining]

Thank you so much Sami Ali Elghrably! Your support helps us continue to make new videos each week!

[@Chanandlerbong5897]

I have always been so scared to use excel because I am not very proficient in data. I have been able to watch this tutorial with ease and understand the concepts, I never thought I'd actually enjoy using functions and tools like XLOOKUP and Pivot Tables. I cannot thank you enough! I feel like I will be able to apply and use XLOOKUP or Pivot Tables and Charts wherever needed at my job, seriously I cannot thank you enough!! I have never had the inclination to complete any tutorial but you just made it so easy that this was the first tutorial I ever completed, with ease. THANKS A TON!

[@LearnitTraining]

You are very welcome Nymphadora Tonks! We are glad were able to help you be a better Excel user!

[@mcayindo]

I recently watched this Excel data analysis video and I was thoroughly impressed! The instructor did an outstanding job breaking down complex concepts into easy-to-understand steps. Whether you're a beginner or looking to polish your skills, this video covers it with clarity and precision. The pacing was perfect, and the examples used were practical and relevant. I especially appreciated the tips and shortcuts to save time in everyday tasks. The visual aids and on-screen prompts made it easy to follow along and practice simultaneously. This video has significantly boosted my confidence in using Excel, and I can now handle data more efficiently. Highly recommend it to anyone looking to enhance their Excel skills! Good job Learnit!

[@LearnitTraining]

Thank you so much for the kind words! We hope you learned everything you needed to!

[@Davynchi32]

I'm just starting to learn here, it has been an amazing learning so far, easily explained wow!!

[@LearnitTraining]

Glad it was helpful!

[@ernestattanyarko9549]

Waoo !!! Thank you so much. I've been looking for such video. I love how you take your time explaining things.

[@LearnitTraining]

Glad it was helpful!

[@IustinCristian-f9q]

Thanks a lot for your high quality content !

[@LearnitTraining]

You are welcome!

[@amospan14]

Absolutely love your teaching style and pace! Literally covered every important topic for data analysis in Excel! Plus, it was free! Thank you so much! =)

[@LearnitTraining]

You're very welcome!

[@mohamedarzath632]

Mo jones sir thank you for the wonderful video about data analysis for free ❤ i have ever seen this type of teaching in the youtube you are amazing bless me am searching for a job

[@LearnitTraining]

You are very welcome

[@thomassiebik6063]

the best tutorials ever, very clear slow and detail for beginners phd, phd, phd.

[@LearnitTraining]

Glad you think so!

[@Thataussiebattler]

This will help me so much! I thank you for the time to put this together. I have been doing an excel bootcamp for data analytics and this will strengthen my knowledge.

[@LearnitTraining]

You are welcome!

[@javedsoomro3417]

Hello Sir, I am from Pakistan and trying to complete my future as Data Analyst with your channel.

[@LearnitTraining]

Great! Let us know how it goes!

[@theselfmade6401]

This course cover all the topics about data analysis using excel ! Thanks for it🤩

[@LearnitTraining]

Most welcome 😊

[@timpurcell7775]

What a video, a someone's who's a complete novice thank you

[@LearnitTraining]

You are welcome!

[@GangsterNerd1]

Just finished the course. Thanks Mo and Learnit team, it was very insightful.

[@LearnitTraining]

Glad you enjoyed it!

[@maianhnguyen8631]

Thank you for teaching and sharing knowledges. You help so many people with no money to apply for a course. Thank you so much. Please keep sharing free education.

[@LearnitTraining]

You are very welcome!

[@theoamor3853]

Absolutely Majestic. Hats off to you.

[@LearnitTraining]

Thanks!

[@ahgtrell]

Glad to have come across this Channel. Its very Helpful and Insightful. As a KZbinr Myself. Who has Plans on Data Analysis. This was a Goldmine.

[@LearnitTraining]

Thanks!

[@jm9425]

You got this bro!

[@anenecynthia7186]

Thank you and well done, Completed in 2 days, it was a very helpful refresher

[@LearnitTraining]

Great to hear!

[@hanadhira6795]

6:28:26 The way I've been looking for. Thank You

[@LearnitTraining]

You are very welcome!

[@stellinaukr]

What an excellent course! Thanks so much for creating it! Great lecturer. Material is well structured and easily explained. I ve leant a lot of new information already. Haven't finished the course yet. Cannot wait to use all the information i ve learnt in my data analysis. Must watch this course if you want to start learning Power BI after it. Lots of extremely useful information! Many thanks for your hard work!

[@LearnitTraining]

Glad you enjoyed it!

[@deeppatel4002]

This is the Best Excel Video i ever watch for Data Analysis Thank you for this

[@LearnitTraining]

You are very welcome!

[@pittyj369]

In a word, thank you! I have much gratitude for your making things easier!

[@LearnitTraining]

You are so welcome!

[@jaikishanaubeeluck9777]

Thank you infinitely for your kindness. Thank for sharing and helping those who are unable to afford it elsewhere. K

[@LearnitTraining]

You are very welcome!

[@geewill99]

I am far from finished but I have to say the way you explain things are clear and very precise! Awesome job, thank you!

[@LearnitTraining]

Awesome, thank you!

[@__Maybe__]

Was searching for a course like this for hours, Thank You Learnit Training !

[@LearnitTraining]

Glad it was helpful!

[@SateshwariRawat-z5s]

Thankyou so much for this video❤. This is what true content means. It was easy to follow and the reasoning for using functions was even easier to grasp.

[@LearnitTraining]

You're welcome 😊

[@hosilbeklochinbekov3760]

thank you very much. This tutorial is very helpful and easy to learn. The thing that i liked most is the files with which a learner can practise.

[@LearnitTraining]

Glad it helped!

[@insight4239]

Thanks for the Great Work. The video is quite easy to follow along. Cheers!

[@LearnitTraining]

Our videos have gotten popular in some ASMR playlists recently. We are bit confused as well haha.

[@kartikgautam9276]

Learnit always helps self taught learner thank you so much for this course i hope one day you guys provide Machine learning complete course so we can learn from the finest youtube channel

[@LearnitTraining]

We are making videos on AI Tools like ChatGPT and Co-pilot but Machine Learning is really well covered by Freecodebootcamp!

[@moonphyuphyusin5522]

Thank you so much; this course has been really effective for me

[@LearnitTraining]

You are welcome!

[@CodeingFreak]

Im starting the course. Hope I will learn a lot from it!!!

[@LearnitTraining]

Hope you learned everything you needed

[@AhmadFauzi-tj6xo]

thank you so much, this tutorial help me a lot

[@LearnitTraining]

You're welcome!

[@jasonkid9741]

شكرًا

[@LearnitTraining]

Thank you so much Jason Kid! Your support helps us continue to make new videos each week!

[@protocolwonder4558]

I appreciate the effort you invested in creating this video

[@LearnitTraining]

Glad you enjoyed it!

[@dianam.5957]

Thamk you so much to all the creators of this wonderful course.

[@LearnitTraining]

Our pleasure!

[@HSACPhysicalEducationDeptChann]

Thank you for creating this course. Just started and hopefully developing this skill will help to become a more efficient physical education teacher

[@LearnitTraining]

Best of luck!

[@HSACPhysicalEducationDeptChann]

@@LearnitTraining 43 minutes in, and I've already learned so much about how I can apply this to my profession. Maybe in the future you can use sports performance data for a data analytics course.

[@tarikuabdisa8157]

Excellent Tutorial !! Thanks

[@LearnitTraining]

You are welcome!

[@InsideAfriqa]

Good job sir! This is by far the best video so far! Much love from Nigeria.

[@LearnitTraining]

Thank you for the kind words!

[@ayekokotun6911]

thank you so much! thank you, thank you, and thank you! amazing tone and speed of voice.

[@LearnitTraining]

Glad you liked it!

[@Islam_Universal]

I just wat to pay my heartfelt gratitude for sharing this wonderful content in such a flawless and smooth way which is easy to learn,practice and retain as well♥

[@LearnitTraining]

Thank you so much!

[@nanagyebi3964]

if i had found this long ago i would not have wasted a lot of time doing much i do about notting. And all of these for free woow !! thank you Mo Jones. When i'm counting good people i count you twice

[@LearnitTraining]

You are very welcome! We are glad you have enjoyed the videos and we hope you learned everything you needed!

[@Ambadeharsh]

Thank you for this tutorial sir it was very helpful for a Newbie like me .

[@LearnitTraining]

You are very welcome!

[@chrisawoke_]

Thank you so much for this comprehensive course. It was all I wanted 😍😍

[@LearnitTraining]

You are very welcome!

[@paushaleemajumder6372]

BEST TUTORIAL FOR EXCEL!!

[@LearnitTraining]

Glad it was helpful!

[@Shunno_012]

This video is amazing. It helps me a lot to learn many functions and uses of excel. God bless you❤

[@LearnitTraining]

Glad it was helpful!

[@KhalidSaeed-b9j]

thank you very much for the great video and the efforts you put into, all of my time i was deal with the excel work on my daily working day by going through this training i was learning a lot of new things and knowledge, thank you again for your time spent on this video.

[@bennicbennic]

I have really learnt a lot from your training. Thank you

[@LearnitTraining]

You are welcome!~

[@kasimahmed5531]

Thank you for this amazing video. I have learned a lot of new ways of doing.

[@LearnitTraining]

You are so welcome!

[@RetailAnalysis-z8v]

This no non sense Excel Data Analysis Course, Loved the straight to point and clear explanation.

[@LearnitTraining]

Thanks!

[@sudipsaha2964]

This is high end learning . Thank you for the video

[@LearnitTraining]

You are welcome

[@dudegaming7302]

Love from 🇵🇰 I've watched 1:25:03 I'll learn full course thank u.

[@LearnitTraining]

Thank you for watching!

[@simonanthony9396]

Your voice is beautifully soothing

[@LearnitTraining]

Thanks for the kind words!~

[@claudiosandroni886]

Absolutely brilliant!

[@LearnitTraining]

Thanks!

[@Gebre62]

thanks so much for this wonderful free training.

[@LearnitTraining]

Our pleasure!

[@cyclopelab]

Great video. Lots of good information. The Power User section is kind of a repeat of Pivot Table section though. Also I would have like to try Copilot but Microsoft doesn't seems to offer a free trial.

[@LearnitTraining]

Would be great if it was just baked into the program in future versions

[@josephconradojacer9594]

Thank you in advance for this Tutorial.

[@LearnitTraining]

Welcome 😊

[@fariduddin5300]

Precise and intelligent presentation

[@LearnitTraining]

Thank you!

[@juliajoana2023]

Valeu!

[@LearnitTraining]

Thank you so much Nilton Bispo Amado! Your support helps us continue to make new videos each week!

[@MaribelTirado-t1x]

Thank you so much for this 7hours tutorial!

[@LearnitTraining]

Any time!

[@simpleLJ]

Amazing turtorial... And free... I appreciate it... Thank you! ❤

[@Ranjit_Rajak075]

Instead of writing category and division name every time, in order to change. Can we use filter and drop lists things as it requires. Can you show the process. (42:00) Database Functions sheet.

[@szabobence4763]

Thank you very much for this tutorial, you are amazing!

[@LearnitTraining]

You are very welcome!

[@nahiiptaa]

woahhh, just completed the course, thanks mo

[@LearnitTraining]

Hope you enjoyed it!

[@MdImtiazIbnSeraj]

Hi, How can I thank you? I am totally speechless. So much valueable lesson for free. Thanks a lot again

[@md.sabbir4101]

Is this tutorial covers all the necessary things from basic to advance... Please reply...

[@LearnitTraining]

You're very welcome!

[@mehranbarahouei2346]

One of the best tutorial I 've ever seen. Thanks to Mo Jones and Leanit❤❤❤❤❤

[@LearnitTraining]

thanks!

[@MrCSJ-gl3vs]

THANKS

[@LearnitTraining]

You're welcome!

[@CodeingFreak]

Hope I will learn a lot from watching the tutorial!!

[@LearnitTraining]

We do too!

[@atondahomukwevho4637]

Thank you so much for this, it really helped me a lot and may we also have the one for Power BI

[@LearnitTraining]

That is coming soon!

[@dreamly1364]

The best video . I wish I found it sooner like few month agoòooooo . But still good to see it now tooo

[@LearnitTraining]

Thank you very much!

[@shayankarimi733]

The great excel tutorial. Thank you❤️🍻

[@LearnitTraining]

You are welcome!

[@DavidMartin-pi2md]

Thank you for this tutorial. It is exactly what I was looking for.

[@LearnitTraining]

You are welcome!

[@engineerduraid7517]

min. 7:00 we can use (drop down list) instead of re-writing address of each category frequently... don't you think so?

[@LearnitTraining]

Sure thing!

[@murianabuliamin2039]

Thumbs up👍. You made me comment on KZbin for the first time 😁. Wow! You really did a great job 🙌

[@LearnitTraining]

Thanks, that's so nice to hear!

[@nihitaraj3203]

this is the best video I found for excel on KZbin. so articulately explained.😄

[@LearnitTraining]

Glad it was helpful!