Pro Tips for this 11 Hour Video: ⏪ Use the "J" key to rewind 10 secs ⏩ Use the "L" key to fast-forward 10 secs 🪡 Precise Seeking: - Tap the screen to see the progress bar - Slide up from the scrubber (red dot) to see a row of thumbnails - Swipe on the thumbnails to find a specific moment in the video
To be honest, I place all my hopes of becoming a Data Analyst in the future on you. Why? I don't know for sure, but seeing your passion and your videos about SQL and Python keep me hopeful that I will succeed someday. No one can pass on knowledge like you can and carefully select what is needed to become a Data Analyst. Wanting to improve my life through new skills with your help is a bit like playing with codes. We will probably never meet in real life, but I want you to know that you are doing an amazing job and I thank you for that 🙏🙏
That's exactly how I'm learning data stuff. While applying for new positions, I usually see requirements or plus requirements such as SQL, Power BI, and Python. I understand what you mean and all the best!
Why....? What have any of us done to deserve this...? If ever a UA-cam video looked like a van on my street that said "Free Candy" on the side... now I am looking through your other videos, this channel was the best find on UA-cam in the last 3 years for me. Very much appreciated! 💙
This is it! I've been learning data analysis with Excel for a while now, mainly through UA-cam tutorials, but I’ve never come across one as detailed and comprehensive as this.
Providing free, high-quality education is the best way to change the lives of thousands of people around the world. May you be blessed for this. Greetings from Brazil.
Just finished formulas section. Took me a long time because I tend to procrastinate. However when i don't I get super excited to work on other problems outside of the course using the knowledge i just gained. This video is really valuable to excel learners.
Dear Luke: I cannot thank you enough for the effort of providing this useful resources. You are causing a real impact in so many people pursuing a better career and life. Thank you so much.
I've seen excel courses, but this is the one I'll start. After years of working as a contract manager I want to finally get off this field and start to again get some use of my finance degree. Becoming a Data Analyst seems like a good path for my personal desires.
Dear Luke, There is no way in this world the Universe won't infinitely bless you for this. My mind is blown!!!! I came across you in this October and you said it's actually possible to get some type of data job with just Excel expertise. I decided to start learning Excel (I've always hated Excel for reasons I can't explain). I'll start applying to intermediate excel jobs by the end of this week (been learning since the start of October). I just have to take this one from you, yet I'm picking some new things. So, thank you so much, Luke. I hit a tiny bit of snag. While practicing with your training, I noticed there's no MINIF or MAXIF in my excel. When I wrote the formula anyway, it gave me a #NAME? error.
Amazed by how really organized and dedicated you are. You mean it from the title and the way you delivered. Beginner friendly that is very helpful! Thank you
Luke, where were you all this time? This is such an excellent channel with in depth tutorials. I cannot thank you enough for this incredible work. It will be very helpful if you can add power BI series as well 🙏
Thank you so much @LukeBarousse for the amazing content on Python, SQL, and Excel! Your tutorials have been incredibly helpful in my journey to becoming a data analyst. The step-by-step explanations and clear examples make complex topics much easier to understand. I truly appreciate all the effort you put into creating these resources. Keep up the great work - you're making a huge difference for so many of us learning these skills! 🙏
OMG, Luke! You`re incredible! After completing your SQL course, now i `ve started python course and the next step will be definitely this one! You can`t imagine how much I`m grateful to you. After landing my first job as a data analyst, I'll write a big post on linkedin for you, bro. Thank you for your hard work.
I want to commend you for the incredible effort and dedication you put into creating the 10+ hour video on data analysis using Excel. It's clear that a tremendous amount of hard work went into not just the content itself but also ensuring it was thorough and comprehensive. Your explanation of complex Excel functions and data analysis techniques was detailed and easy to follow. The step-by-step breakdown really helps users of all levels-whether beginners or those more advanced-understand and apply the concepts in real-world scenarios. I especially appreciate the practical examples and hands-on demonstrations. They bring theory to life and provide learners with the confidence to use these techniques in their own data analysis projects. Overall, your work is a fantastic resource that adds immense value. The time and effort you invested truly show in the quality and depth of the content. Keep up the excellent work! Thank you so much for my heart.
I JUST finished the 8 hour Excel course by learnit on UA-cam and after finishing it I see yours now!! 😂 I was actually looking for it on your channel before, but will watch your SQL course next. ✨
Hi all. I am trying to get into this field of data analysis, specifically in healthcare/clinical trials. If anyone has any tips on this field, I would love to hear from you. So far loving this course. I use excel almost daily, but never realized you could do so much with it. Thanks Luke.
Hi Luke. Your videos are good and informative. Can you also make a video on Tableau and Power BI. So that we can have everything on your channel? I know it's a lot to ask. But you never disappoint your subscribers.
Pretty sweet vid! I have high hopes in you being able to hammer in the knowledge inside my head. I have been learning excel on and off for about year but never fully committing to it. Maybe once I'm done I might apply to some data analyst/data admin positions without a worry.
My guy !!! I've just finished your courses on sql and python and i was wondering who else would be able to make such great course like you but with excel, then you release this. Let's gooo😂❤
Where’s the *VBA* section in this course, Luke? Been searching for it, but no luck... Just kidding 😉 Hats off to you for putting together such a monster of a course on Excel and sharing it for free. Absolute legend 🐐
🤣 Yeah, I knew someone was going to call me out on it and wasn't expecting you; lol! Also Sven thanks for the kind words my dude, just trying to keep up with you!
A treasure really. Thanks for the amazing educational content. Could we hope in the future to see a course on data cleaning and errors correction? (Financial formulas errors, common logical mistakes etc).
I was wondering what the heck was Lude doing, why hasn't he posted any videos for 3+ months. Now I know why! Although I'm an Excel power user, I probably won't watch this video in full, I loved your python and SQL videos, they are my foundations into coding world. Forever grateful!
SQL and Python purchased 👍 Will get excel one tomorrow as it doesn’t go through with more than two transactions to one vendor from Apple Pay?! Highly suggest just do bundle so can buy everything in one transaction 😎
Can you do PowerBI course next? Now there are already SQL, Excel and Python (and ChatGPT) courses, so that would nicely complement the knowledge of data-analytics 😊
Hello Luke thnx for your videos its really helpful.May i suggest that you split all of your videos into individual parts and create a playlist since sometimes we might need to go back and review the formulaes in the videos again. Since a single 10 hour video is very difficult to browse through and review...
I can't thank you enough for this Excel tutorial. Thanks a lot, bro. Any MySQL tutorial will be of immense help. Thank you in advance. I've one question - is NLP & A I really necessary for a data analyst fresher to get a job?
Hey there ! I just wana give you a big thankss like seriously these are the most amazing and outstanding vedios with appropriate knowledge tbh I've had watched trash vedios but these ones are real gem💎 please do share the data visualization tools vedio also (tableau or power bi ) ❤
As a Data Analyst for 2 years, I'm about to find out that I know nothing. 11 hours of knowledge and experience (with practice tools for us to use)!? I hope UA-cam pays you well for this video. Thank you.
Day 1: Introduction and Basics - Cover the Excel interface, basic formulas, and navigation. Day 2: Data Entry and Formatting - Learn about cell formatting, conditional formatting, and data organization. Day 3: Essential Functions - Focus on core functions like SUM, AVERAGE, COUNT, and IF statements. Day 4: Advanced Functions - Dive into VLOOKUP, HLOOKUP, INDEX, and MATCH for more complex data handling. Day 5: Data Analysis Tools - Understand Pivot Tables, Charts, and Data Validation. Day 6: Data Cleaning Techniques - Practice tools like Text-to-columns, Flash Fill, and Remove Duplicates. Day 7: Advanced Data Visualization - Learn about Sparklines and advanced chart formatting. Day 8: Macros and Automation Basics - Cover recording macros and basic VBA. Day 9: Excel Add-ins and Plugins - Explore Solver, Analysis ToolPak, and other useful add-ins. Day 10: Review and Practice - Revisit challenging concepts and practice with exercises.
Woah Woah slow down. I just recently finished the Project for the SQL course and tagged you on my LinkedIn 👏🏻👏🏻. I'm currently learning Tableau and Power BI. This course looks super interesting but I will have to come back to it in some weeks 😭.
Pro Tips for this 11 Hour Video:
⏪ Use the "J" key to rewind 10 secs
⏩ Use the "L" key to fast-forward 10 secs
🪡 Precise Seeking:
- Tap the screen to see the progress bar
- Slide up from the scrubber (red dot) to see a row of thumbnails
- Swipe on the thumbnails to find a specific moment in the video
You need to create a free course on UA-cam navigation
@@davidmiller-td1sl😂😂, may be, why not?
Also use the "K" key to pause the video!
This channel is amazing
Hi there , please this video translate in hindi
To be honest, I place all my hopes of becoming a Data Analyst in the future on you. Why? I don't know for sure, but seeing your passion and your videos about SQL and Python keep me hopeful that I will succeed someday. No one can pass on knowledge like you can and carefully select what is needed to become a Data Analyst. Wanting to improve my life through new skills with your help is a bit like playing with codes. We will probably never meet in real life, but I want you to know that you are doing an amazing job and I thank you for that 🙏🙏
I appreciate the trust and confidence! 🥹
I learned everything I know from Luke!
@davidmiller-td1sl LIES! You taught me everything, like how to operate a reactor!
@@LukeBarousse operating a reactor!? That sounds like a pretty hefty responsibility
That's exactly how I'm learning data stuff. While applying for new positions, I usually see requirements or plus requirements such as SQL, Power BI, and Python. I understand what you mean and all the best!
Good people still exist on this greedy planet. My man just uploaded an 11-hour-long Excel tutorial video for FREE
It's 11 hour content all over UA-cam. LOL
Man I remember asked you 3 months Ago that when this Excel course coming & you said on October, and see you uploaded it, Your commitment is on Top 😁
Ha! I'm just glad I was able to make this October date 😅
Why....? What have any of us done to deserve this...? If ever a UA-cam video looked like a van on my street that said "Free Candy" on the side... now I am looking through your other videos, this channel was the best find on UA-cam in the last 3 years for me. Very much appreciated! 💙
🙌🙌🙌
This is it! I've been learning data analysis with Excel for a while now, mainly through UA-cam tutorials, but I’ve never come across one as detailed and comprehensive as this.
Providing free, high-quality education is the best way to change the lives of thousands of people around the world. May you be blessed for this. Greetings from Brazil.
I've just started my learning path in Data Analytics, and I'm so happy I've found this video. Thank you so much
Just finished formulas section. Took me a long time because I tend to procrastinate. However when i don't I get super excited to work on other problems outside of the course using the knowledge i just gained. This video is really valuable to excel learners.
YOU TEACH AND EXPLAIN TERMS & TOPICS LIKE NO ONE ELSE THANK YOU TO CREATE THIS COURSE LUKE
After watching the python course and SQL course, I'm ready to level my Excel skills. You are the man
Dear Luke: I cannot thank you enough for the effort of providing this useful resources. You are causing a real impact in so many people pursuing a better career and life. Thank you so much.
The more i dive into Data analytics, more i understand that this job is for me
! Thanks Luke
I've seen excel courses, but this is the one I'll start.
After years of working as a contract manager I want to finally get off this field and start to again get some use of my finance degree. Becoming a Data Analyst seems like a good path for my personal desires.
Best EXCEL course anyone could ask for. thank you.
Dear Luke,
There is no way in this world the Universe won't infinitely bless you for this. My mind is blown!!!! I came across you in this October and you said it's actually possible to get some type of data job with just Excel expertise. I decided to start learning Excel (I've always hated Excel for reasons I can't explain). I'll start applying to intermediate excel jobs by the end of this week (been learning since the start of October). I just have to take this one from you, yet I'm picking some new things. So, thank you so much, Luke.
I hit a tiny bit of snag. While practicing with your training, I noticed there's no MINIF or MAXIF in my excel. When I wrote the formula anyway, it gave me a #NAME? error.
Yeah MINIF and MAXIF don't exist, that's why you get the error
Amazed by how really organized and dedicated you are. You mean it from the title and the way you delivered. Beginner friendly that is very helpful! Thank you
Luke, where were you all this time? This is such an excellent channel with in depth tutorials. I cannot thank you enough for this incredible work. It will be very helpful if you can add power BI series as well 🙏
Thank you so much @LukeBarousse for the amazing content on Python, SQL, and Excel! Your tutorials have been incredibly helpful in my journey to becoming a data analyst. The step-by-step explanations and clear examples make complex topics much easier to understand. I truly appreciate all the effort you put into creating these resources. Keep up the great work - you're making a huge difference for so many of us learning these skills! 🙏
OMG, Luke! You`re incredible! After completing your SQL course, now i `ve started python course and the next step will be definitely this one! You can`t imagine how much I`m grateful to you. After landing my first job as a data analyst, I'll write a big post on linkedin for you, bro. Thank you for your hard work.
Looking forward to this post! 🙌
Where's the link to that LinkedIn post?
I can't thank you enough. I have been trying to find the best excel courses on UA-cam. This is it the one and only.
I want to commend you for the incredible effort and dedication you put into creating the 10+ hour video on data analysis using Excel. It's clear that a tremendous amount of hard work went into not just the content itself but also ensuring it was thorough and comprehensive.
Your explanation of complex Excel functions and data analysis techniques was detailed and easy to follow. The step-by-step breakdown really helps users of all levels-whether beginners or those more advanced-understand and apply the concepts in real-world scenarios.
I especially appreciate the practical examples and hands-on demonstrations. They bring theory to life and provide learners with the confidence to use these techniques in their own data analysis projects.
Overall, your work is a fantastic resource that adds immense value. The time and effort you invested truly show in the quality and depth of the content. Keep up the excellent work! Thank you so much for my heart.
Now it’s our turn to learn as much as we can and make use of it
Thank you very much!! There are indeed good people like you in this world!
You're truly a blessing to me. Thank you so much. Much love from Nigeria❤❤❤
Somehow this is easier to understand rather than other course, maybe just my opinion...
Anyway, this is LEGIT
I finished my python 11 hours video and i move to sql which is 4 hours , i just finished the sql now. i'm gonne finish this also . thank you luke
keep up the hard work!
I’m not good in english but i want to tell you i’m appreciate you kind to teach us.
Thank you so much for being help ❤
I JUST finished the 8 hour Excel course by learnit on UA-cam and after finishing it I see yours now!! 😂 I was actually looking for it on your channel before, but will watch your SQL course next. ✨
This guys is a genius! I love watch his videos
i hope this vedio will help me go from having no idea about Excel to becoming an advanced Excel user
Hi all. I am trying to get into this field of data analysis, specifically in healthcare/clinical trials. If anyone has any tips on this field, I would love to hear from you.
So far loving this course. I use excel almost daily, but never realized you could do so much with it. Thanks Luke.
ok i am starting to learn excel and this popup in my feed, its long, its new, let's start a fresh journey.
You are so kind and you work so hard. I’m the luckiest woman alive. I love you.
I’m the lucky one! 😍😍 I love you too!
I am lucky i find this for free . i will not forget it when this course is so important to me
God bless you, man. This is going to help so many people.
So grateful to UA-cam for recommending this video
Hi Luke. Your videos are good and informative. Can you also make a video on Tableau and Power BI. So that we can have everything on your channel? I know it's a lot to ask. But you never disappoint your subscribers.
Thank you so much Luke, having a data set to work with is a game changer. Thanks for the effort. God bless you for your enthusiasm for Data
Thank you Luke this is just what I need I’m going to start my journey on data analytics with excel and then SQL
Pretty sweet vid! I have high hopes in you being able to hammer in the knowledge inside my head. I have been learning excel on and off for about year but never fully committing to it. Maybe once I'm done I might apply to some data analyst/data admin positions without a worry.
Thanks Luke For Such a Wonderful Excel Course I Have Just Started And It Is Quite On Point.
Please One Request To Make A Course On Power BI As well.
My guy !!! I've just finished your courses on sql and python and i was wondering who else would be able to make such great course like you but with excel, then you release this. Let's gooo😂❤
Thanks a trillion for this amazing course. May God continue to bless you.
Thanks a lot dude, you deserve all love in the world from aspiring data analysts. Keep up the great work.
This is so helpful, you are great at making complex topics simple to understand.
Where’s the *VBA* section in this course, Luke? Been searching for it, but no luck...
Just kidding 😉 Hats off to you for putting together such a monster of a course on Excel and sharing it for free. Absolute legend 🐐
🤣 Yeah, I knew someone was going to call me out on it and wasn't expecting you; lol!
Also Sven thanks for the kind words my dude, just trying to keep up with you!
Wow the best Excel learning video i have ever watched!! You done a great Job buddy
Great one Luke. Kindly create a comprehensive course like this for SQL
Hey Luke, Can't really express my gratitude for this amazing work of art.. than you..
A treasure really. Thanks for the amazing educational content. Could we hope in the future to see a course on data cleaning and errors correction? (Financial formulas errors, common logical mistakes etc).
What a legend.. glorious high quality content for the masses
I am the "Excel Magician" at my company, after I do this course I guess I will upgrade to the "Excel God" 😅 Thanks for this amazing course
Luke respect from every single fan . this efforts means a lot for us aspiring analyst . Would love if you teach mathametics required for analytics .
I was wondering what the heck was Lude doing, why hasn't he posted any videos for 3+ months. Now I know why! Although I'm an Excel power user, I probably won't watch this video in full, I loved your python and SQL videos, they are my foundations into coding world. Forever grateful!
This is just amazing! Will buy these courses from your website to support your efforts! Appreciate your job!
Awesome, thank you!
SQL and Python purchased 👍 Will get excel one tomorrow as it doesn’t go through with more than two transactions to one vendor from Apple Pay?! Highly suggest just do bundle so can buy everything in one transaction 😎
Oh goodness! I didn't realize this! Will be looking into bundles, thanks for pointing this out
Can you do PowerBI course next? Now there are already SQL, Excel and Python (and ChatGPT) courses, so that would nicely complement the knowledge of data-analytics 😊
Thank you so much Luke and your team!! Sending good vibes to you guys. This course is amazing
Kudos to your efforts. Appreciate all the work you put in.
you are amazing!
my only data nerd mentor 😂
im waiting for you to make a guide on how to set up data analyst / scientist portfolio :) ❤
Hello Luke thnx for your videos its really helpful.May i suggest that you split all of your videos into individual parts and create a playlist since sometimes we might need to go back and review the formulaes in the videos again. Since a single 10 hour video is very difficult to browse through and review...
Check out the pinned comment, it talks about how to better navigate these long videos. It'll be the solution you're looking for.
I love you Luke, you're the GOAT. Thanks for all the courses ❤❤
I’m eagerly looking forward to diving into this. Thank you for this.
I can't thank you enough for this Excel tutorial. Thanks a lot, bro. Any MySQL tutorial will be of immense help. Thank you in advance. I've one question - is NLP & A I really necessary for a data analyst fresher to get a job?
Muchas gracias Luke, se aprecian muchisimos tus aportes.
Hey there ! I just wana give you a big thankss like seriously these are the most amazing and outstanding vedios with appropriate knowledge tbh I've had watched trash vedios but these ones are real gem💎 please do share the data visualization tools vedio also (tableau or power bi ) ❤
Brother
This is amazing, thank you for all your effort. 💯🔥
wow outstanding course✌
Thank you Sir 😊
Excellent idea for a course. Needed this!
GPT/Gemini really helps to fix functions, thanks for tip
As always Luke delivers the best! Keep it up!! 👏
Thank you for in-depth course.. thank you
Many thanks Luke for sharing with us. It is priceless.
Its finally here! Thank you, Luke!
okay.... u earn my sub. great work man
As a Data Analyst for 2 years, I'm about to find out that I know nothing. 11 hours of knowledge and experience (with practice tools for us to use)!? I hope UA-cam pays you well for this video. Thank you.
Luke, thank you for the video. Do one for Mac users if possible with the differences on that OS.
Thanks from Brazil!
Thank you . I have been looking for one and luckily came here
Thank you Luke. This is gold, sir.
Saved this. Going to start tomorrow
I’ll keep updating my comment
I think you are going to make us professional Data Analysts for free!
Trying my hardest!
hey luke thank you so much ! we love you and I will ask one more favor for the data nerds . Can you post a Power BI or Tableu course ? THANK YOU
This video is fantastic. Thank you!
😊really nice kudos to your efforts
Wonderfully explained everything
Day 1: Introduction and Basics - Cover the Excel interface, basic formulas, and navigation.
Day 2: Data Entry and Formatting - Learn about cell formatting, conditional formatting, and data organization.
Day 3: Essential Functions - Focus on core functions like SUM, AVERAGE, COUNT, and IF statements.
Day 4: Advanced Functions - Dive into VLOOKUP, HLOOKUP, INDEX, and MATCH for more complex data handling.
Day 5: Data Analysis Tools - Understand Pivot Tables, Charts, and Data Validation.
Day 6: Data Cleaning Techniques - Practice tools like Text-to-columns, Flash Fill, and Remove Duplicates.
Day 7: Advanced Data Visualization - Learn about Sparklines and advanced chart formatting.
Day 8: Macros and Automation Basics - Cover recording macros and basic VBA.
Day 9: Excel Add-ins and Plugins - Explore Solver, Analysis ToolPak, and other useful add-ins.
Day 10: Review and Practice - Revisit challenging concepts and practice with exercises.
Woah Woah slow down. I just recently finished the Project for the SQL course and tagged you on my LinkedIn 👏🏻👏🏻.
I'm currently learning Tableau and Power BI. This course looks super interesting but I will have to come back to it in some weeks 😭.
It will still be here! Thanks for the shoutout on LinkedIn!
Man you are so freaking AWESOME!!!
Thank you
Literally this is awesome ❤
Tableau full course when?
Bro you are doing great keep it up!
Great Video, I'm looking for job transformation from Inventory controlling to Data analytics.
Thank you
Luke, please consider Excel for Data Analytics for advanced learners
FINALLY IT'S HERE :D!!!
i love excel more than other Microsoft stuff
Something for intermediate users too ? I'm struggling in getting a job but wanted to learn a lot.
Thank you so much for this! Subscribed
THIS IS AWESOME🔥🔥🔥
Thank you Luke, thanks a lot 😢❤❤❤
This is a pretty hefty course! Time for me to get my ML Bot to watch it for me
You better not be training your bot on my courses!!