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 If you have issues downloading the Course Files & Project using the link in the description above, use this as an alternative to get the files: lukeb.co/excel_files_alternate

[@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

[@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! 🙏🏽

[@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

[@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!

[@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.

[@LorenFoister]

Hi there, could you please assist me with my issue? My USDT TRX20 is in a wallet, and I have the phrase (clean party soccer advance audit clean evil finish tonight involve whip action). How can I move the funds to OKX?

[@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 😅

[@milospetkovic7827]

Power bi ?

[@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]

🙌🙌🙌

[@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.

[@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.

[@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

[@Healthandlifestylewithpromise]

How is it going? hope you are still on track!

[@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

[@chaitanyakhare1869]

18 Dec: 22:39 19 Dec: 52:06 20 Dec: 1:29:14 22Dec: 2:01:13 24 Dec: 2:23:37 SKIP: 2:21:24 to 2:39:20 25Dec: 3:01:33 26Dec: 3:22:06 27Dec: 3:51:56 28Dec: 4:25:59 29 Dec: 4:51:47 30 Dec: 5:17:05 31 Dec: 5:44:17 1 Jan: 5:54:52 2 Jan: 6:19:41 3 Jan: 6:48:05

[@ravigaming1008]

U r tracking daily progress. That's cool...!!!

[@chaitanyakhare1869]

@@ravigaming1008 Thanks mate

[@HishamArgent]

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

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

[@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

[@rainierlistanco2360]

Just finished it Luke. Your efforts are highly appreciated, the amount of work you have put to this project while making it free is applausable. Got my first excel certificate from you and now I'll be moving forward with the SQL course after I am done with microsoft excel exams. Once again, thank you so much!

[@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

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

[@maxpeacock1313]

Thank you, Luke, as I am coming to the end of my studies in Python and SQL, my Excel was very rusty, putting me off many entry level job applications that I will soon be able to apply for now! It is much appreciated, take care!

[@nourw.1874]

Best EXCEL course anyone could ask for. thank you.

[@maciejdrewniak9512]

Fantastyczny kurs: jasny i bez zbędnego gadania. Wielkie dzięki!

[@getrudeihechi7785]

I'm amazed by this beautiful work of art you created. May the Universe reward you abundantly ❤❤

[@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!

[@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

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

[@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.

[@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.

[@gregoryrasputinpop]

thankyou you saved my time i am blessed to have a great teacher like you 🤩

[@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

[@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?

[@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!

[@jasonokpala2387]

After 2 Months I have Finished this course finally. I had to take a pretty lengthy break for my exams but it's over its finally over

[@LukeBarousse]

Congrats on finishing the course!

[@creatingdigitalwealth8549]

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

[@vivianwalterduru1866]

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

[@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.

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

[@saicharanchepuri8145]

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

[@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

[@adnanap7593]

super amazing 1hr 40 mins . this course super fire.will update once done

[@MrEduardo4685]

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

[@sanjusatheesh3320]

This guys is a genius! I love watch his videos

[@kelvinjesu7020]

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

[@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

[@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 ❤

[@dillynbaker]

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

[@boiyousra]

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

[@vieira_filho]

Great video man! Thanks for sharing your experience, I’ve a some time working with Excel, but this material was very important for me.

[@LukeBarousse]

I'm glad you found it helpful! 🙏

[@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.

[@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.

[@cnic299]

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

[@abbagada-pk4xh]

From Kenya, many thanks to you brother.

[@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.

[@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

[@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!

[@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.

[@oopz4554]

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

[@KaleidoKlips441]

most goated vid i have ever seen for data analytics using excel

[@joeh4638]

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

[@chukwumascholastica4226]

Its finally here! Thank you, Luke!

[@janaft4364]

Thank you for that course! You’re amazing! 11 hours !😲!

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

[@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

[@Sonidevirasoi]

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

[@seunshols4391]

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

[@Mates-e1n]

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

[@sumitpatidar1215]

"Thank you for this amazing Excel course 🙌 From India"

[@Trep-AI]

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

[@iamkv]

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

[@AmericanJunction525]

Luke, you explained sumproduct function for arrays and how it essentially is similar to countif. I don’t think you mentioned (unless i missed it) sumproduct used in a single array (multiplied by 1 instead of a second array) is the reason why it behaves likes a countif. I had that question “if sum product is the sum of all products, what is being multiplied?” Just commenting that in case someone’s wondering.

[@Gonzalo-bx3cj]

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

[@israelamos8896]

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

[@just.fisayo]

So grateful to KZbin for recommending this video

[@fasasiroinat878]

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

[@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

[@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 .

[@Akisoki]

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

[@TheMaxKids]

Excellent idea for a course. Needed this!

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

[@leo_1791]

Muchas gracias Luke, se aprecian muchisimos tus aportes.

[@adinu5031]

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

[@aniekemebassey927]

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

[@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!

[@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

[@markfish8539]

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

[@raquelsilvagorbea]

I JUST finished the 8 hour Excel course by learnit on KZbin 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. ✨

[@sezginefe]

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

[@santiagogomez2931]

A power bi full Course Would be awesome

[@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!

[@OnlineMarketReviewer]

Thank you Luke. This is gold, sir.

[@abdourazakhoussein6998]

you are the best dude great explaining

[@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?

[@MaadhavaK-l8x]

Thank you for in-depth course.. thank you

[@FirmanSyah-dn1bt]

I learn an a data analyst from you, & at once learn English language😂. This is fun but also challengging. Thank you very much sir for your lesson, 🙇‍♂️

[@ivanocarraro7293]

Amazing job! Thanks a lot for sharing it🙏

[@travelview365]

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