Excel for Data Analytics - Full Course for Beginners

[@LukeBarousse]

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

[@davidmiller-td1sl]

You need to create a free course on KZbin navigation

[@fabric-with-felmo]

​@@davidmiller-td1sl😂😂, may be, why not?

[@PetterHughes]

Also use the "K" key to pause the video!

[@Mates-e1n]

This channel is amazing

[@MohdJavvadOfficial]

Hi there , please this video translate in hindi

[@divyasharma8820]

I have started this course 2 days back..i completed 3 hrs of this video and broo i am amazed with the patience and hardwork of this guy. God bless you for providing this type of quality content for free. your hardwork is truly visible...will update you guys after i complete this! extremely satisfied till now

[@LukeBarousse]

Appreciate the kind words my dude!!

[@divyasharma8820]

@LukeBarousse 🫂🌍🤍

[@PriyanshuBaranwal-mj2el]

it's been 8 days now that means you never completed?

[@divyasharma8820]

@@PriyanshuBaranwal-mj2elyo! 2 hrs to go!!

[@SultanAbdifitah]

​@@PriyanshuBaranwal-mj2el let the man have life ,we never know what kind of world he is fighting with

[@roxymax8917]

Good people still exist on this greedy planet. My man just uploaded an 11-hour-long Excel tutorial video for FREE

[@jay_wright_thats_right]

It's 11 hour content all over KZbin. LOL

[@Tesseus2006]

​@@jay_wright_thats_right But NOT from yours truly! 🙏🏽

[@maxaldo6767]

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 🙏🙏

[@LukeBarousse]

I appreciate the trust and confidence! 🥹

[@davidmiller-td1sl]

I learned everything I know from Luke!

[@LukeBarousse]

@davidmiller-td1sl LIES! You taught me everything, like how to operate a reactor!

[@davidmiller-td1sl]

@@LukeBarousse operating a reactor!? That sounds like a pretty hefty responsibility

[@rodion-romanovich-raskolnikov]

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!

[@BrightKusiAppiah]

Guys i am just starting.. wish me well.😍😍 And to Luke, i do not even know what to tell you that should be enough......I will just simply say God bless you and i hope to successfully go through this course to make you proud for your time and patience in putting this up.

[@LukeBarousse]

Thanks! I'm glad you appreciate it 🙏

[@kishan0705]

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 😁

[@LukeBarousse]

Ha! I'm just glad I was able to make this October date 😅

[@BasicFolders]

Why....? What have any of us done to deserve this...? If ever a KZbin 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 KZbin in the last 3 years for me. Very much appreciated! 💙

[@LukeBarousse]

🙌🙌🙌

[@Igaozinho]

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.

[@ajalajessica3601]

I just started my data analysis journey with this video from Abuja Nigeria, I’ll come back and update

[@salmabenrazzouq]

me to wish for you the best

[@ajengesam]

Same here from Abuja.

[@Agnes-b2l]

Abuja people, we many here oo😊

[@creatingdigitalwealth8549]

Lol. From lag here o

[@benardkinyua5995]

This is it! I've been learning data analysis with Excel for a while now, mainly through KZbin tutorials, but I’ve never come across one as detailed and comprehensive as this.

[@SynthKid]

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.

[@MCPeeBoy]

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.

[@yanadoroshenko1759]

I've just started my learning path in Data Analytics, and I'm so happy I've found this video. Thank you so much

[@rahulpanchal1]

YOU TEACH AND EXPLAIN TERMS & TOPICS LIKE NO ONE ELSE THANK YOU TO CREATE THIS COURSE LUKE

[@trithinhnguyen4018]

Omg. This is the best ever Excel course that I'm able to find on the internet. So comprehensive and detailed. Your teaching is straightforward and super practical. And all these things are completely free. Thank you so so much, Luke. You are the greatest.

[@LukeBarousse]

Glad you're enjoying it! 🙌

[@НикитаЛебедев-з8л]

The more i dive into Data analytics, more i understand that this job is for me ! Thanks Luke

[@NofarahTech]

After watching the python course and SQL course, I'm ready to level my Excel skills. You are the man

[@sweetdivine2701]

After my recent complaint i just realised that you actually gave us tips how to enjoy the video with the J and L to foward and rewind . your just a genius thank you very much

[@deepanshi3424]

This 10 hours tutorial has literally made me do things and evolve in my data science journey than the whole 8 courses of Google Data Analytics. For the first time I think "thank you" is such a small word sometimes for things people do.

[@LukeBarousse]

Appreciate that, glad you found it helpful! 🙏

[@nourw.1874]

Best EXCEL course anyone could ask for. thank you.

[@swarnachoppella388]

Thank you so much, Luke, for this incredible course. I am almost done with the course and have learned valuable skills along the way.

[@LukeBarousse]

Great to hear!

[@SieanElpidama]

In 1:42:32 the count value is correct because it only counts if the cell contains number and since the header is not a number it didn't count it however in CountA you do need the -1

[@creatingdigitalwealth8549]

Luke, I honestly don't know how to thank you enough 🙏🙏🙏

[@MoncoCarser]

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.

[@aaroncruz5515]

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

[@AnilTamsoy]

I can't thank you enough. I have been trying to find the best excel courses on KZbin. This is it the one and only.

[@FootyLeagueStars]

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.

[@LukeBarousse]

Yeah MINIF and MAXIF don't exist, that's why you get the error

[@mariamwasiu3369]

Wow! I can't thank you enough 🙏 This is an invaluable content. Thank you so much ❤❤❤ Detailed and comprehensive. All in 11hrs. I'm so blessed to come across your channel.

[@MD.RAJUAHMED-zg1hr]

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.

[@Gulhayo-v7k]

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.

[@LukeBarousse]

Looking forward to this post! 🙌

[@jay_wright_thats_right]

Where's the link to that LinkedIn post?

[@nehag6828]

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 🙏

[@vivianwalterduru1866]

You're truly a blessing to me. Thank you so much. Much love from Nigeria❤❤❤

[@vprasanna3534]

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! 🙏

[@Sonidevirasoi]

Nice content I learned Excel for free, thank you for providing such content for free.

[@shwesin8135]

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!

[@sanjusatheesh3320]

This guys is a genius! I love watch his videos

[@grackization]

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

[@abbagada-pk4xh]

From Kenya, many thanks to you brother.

[@Zaidansarrii]

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.

[@adinu5031]

Somehow this is easier to understand rather than other course, maybe just my opinion... Anyway, this is LEGIT

[@MrEduardo4685]

God bless you, man. This is going to help so many people.

[@abrahamskywalker5792]

Thank you so much for this video.. I’m so glad and appreciate that you do this amazing 11 hours excel course, thank you thank you.. may succes always accompany you

[@rosettaogbode8589]

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

[@saicharanchepuri8145]

Thanks a lot dude, you deserve all love in the world from aspiring data analysts. Keep up the great work.

[@kelvinjesu7020]

Wow the best Excel learning video i have ever watched!! You done a great Job buddy

[@fasasiroinat878]

I can't help but thank you for this knowledge. It's unbelievable

[@dillynbaker]

This is so helpful, you are great at making complex topics simple to understand.

[@joeh4638]

What a legend.. glorious high quality content for the masses

[@EvaHernandez-nr3vj]

You are so kind and you work so hard. I’m the luckiest woman alive. I love you.

[@LukeBarousse]

I’m the lucky one! 😍😍 I love you too!

[@just.fisayo]

So grateful to KZbin for recommending this video

[@whatthecat9409]

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 ❤

[@efrainperez257]

Thank you Luke this is just what I need I’m going to start my journey on data analytics with excel and then SQL

[@MCPeeBoy]

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.

[@makedonka11]

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.

[@israelamos8896]

Thanks a trillion for this amazing course. May God continue to bless you.

[@yashpatel6320]

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.

[@Mates-e1n]

I am lucky i find this for free . i will not forget it when this course is so important to me

[@marwaalharbi5042]

JUST AMAZING 🌺 Thank you for your hard work🌼

[@seunshols4391]

Hey Luke, Can't really express my gratitude for this amazing work of art.. than you..

[@leo_1791]

Muchas gracias Luke, se aprecian muchisimos tus aportes.

[@chukwumascholastica4226]

Its finally here! Thank you, Luke!

[@oopz4554]

Kudos to your efforts. Appreciate all the work you put in.

[@cnic299]

Thank you so much Luke and your team!! Sending good vibes to you guys. This course is amazing

[@adityagarg7323]

03:58:23 In this time stamp we are not able to duplicate the table by using the =jobs formula and not able to use any other subformula as well.

[@boiyousra]

i hope this vedio will help me go from having no idea about Excel to becoming an advanced Excel user

[@erproerpro903]

This is just amazing! Will buy these courses from your website to support your efforts! Appreciate your job!

[@LukeBarousse]

Awesome, thank you!

[@erproerpro903]

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 😎

[@LukeBarousse]

Oh goodness! I didn't realize this! Will be looking into bundles, thanks for pointing this out

[@mdsrafa]

Amazing, thanks for your Job! From Brazil

[@innocentmarcel]

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

[@LukeBarousse]

keep up the hard work!

[@notaras1985]

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).

[@aniekemebassey927]

Great one Luke. Kindly create a comprehensive course like this for SQL

[@TheMaxKids]

Excellent idea for a course. Needed this!

[@shashankkumarshah7279]

wow outstanding course✌ Thank you Sir 😊

[@divinguedegbe349]

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😂❤

[@devgupta8657]

Luke respect from every single fan . this efforts means a lot for us aspiring analyst . Would love if you teach mathametics required for analytics .

[@Trep-AI]

I’m eagerly looking forward to diving into this. Thank you for this.

[@abdourazakhoussein6998]

you are the best dude great explaining

[@markfish8539]

okay.... u earn my sub. great work man

[@iamkv]

As always Luke delivers the best! Keep it up!! 👏

[@Akisoki]

ok i am starting to learn excel and this popup in my feed, its long, its new, let's start a fresh journey.

[@mohammadiahmad995]

Actually the function *COUNT* counts just the numbers so no need to subtrat one 1:42:45

[@santiagogomez2931]

A power bi full Course Would be awesome

[@OnlineMarketReviewer]

Thank you Luke. This is gold, sir.

[@SyedMostofaAtiqurRahman]

Thanks a lot Dear Great Mentor for making this sort of Great content. Wish if you could make a Power BI Video like this one. Once again many many thanks..

[@Gonzalo-bx3cj]

I love you Luke, you're the GOAT. Thanks for all the courses ❤❤

[@sezginefe]

Many thanks Luke for sharing with us. It is priceless.

[@VicFix]

If I wanted to learn Excel for book keeping and accounting and taxes purposes for my small business, would this be the ideal course for me as a beginner who is willing to sign over 10 hours of effort? Or do you know of or put out a different course for that? Or is Excel just Excel, and you use it for whatever you want? Thanks!

[@Atty_KelseyK]

me too! watching for an answer for this.

[@LukeBarousse]

Great question; I feel everything in this course would be applicable to the accounting industry. so it would be worth your effort to take it. I went to business school back in the day, so a lot of this comes from what I learned there. I will caveat this tho that the accounting and financial industry have a few more things to learn in Excel, (specifically, I don't cover financial functions in this course) so you may need to watch some other videos to learn concepts like that.

[@CodingIsFun]

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 🐐

[@LukeBarousse]

🤣 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!

[@MaadhavaK-l8x]

Thank you for in-depth course.. thank you

[@arindambanerjee6686]

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?

[@travelview365]

Thank you . I have been looking for one and luckily came here

[@Fosgen]

Luke, what you suggest to do next after this course?

[@LukeBarousse]

SQL

[@Fosgen]

@@LukeBarousse Thanks man

[@GloriaSantillan-h8c]

Brother This is amazing, thank you for all your effort. 💯🔥

[@Hisham-y5p]

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 :) ❤

[@amlanmaharana4882]

#doubt sir at 2:08:53 how did you select the entire M column in one go?

[@ragulmarley4900]

😊really nice kudos to your efforts

[@PowerBiWithVivek]

at 1:17:05, their is mistake, + is equal to OR, * is equal to And

[@rebeccaschmidt6791]

You are complete lifesaver AND a complete saint! May your summers be forever fun. May you always be warm in the winter. May your wallet always be full! May your bills be low. May your life be blessed. May your family be blessed. You will forever be in my prayers. THANK YOU IMMENSELY!

[@bmroyale3817]

done with the course, thanks luke

[@LukeBarousse]

Heck yeah! congrats on finishing the course!

[@muslimahmukbang417]

1:53:57 how did he make this curve from the formula?

[@ShineBringYoutube]

Thank you for this video! A gem!