Lean how to use Microsoft Excel from the beginning by creating 6 real-world projects. Most of the content applies to Google Sheets as well. You will learn how to - enter data, - navigate through a spreadsheet, - create formulas to solve problems, - create charts and graphs, - understand relative vs absolute references, - import and export data, - implement VLOOKUP, - use pivot tables, - split and concatenate text, - and more. ✏️ Course developed by Shad Sluiter. Check out his YouTube channel: https://www.youtube.com/user/shadsluiter ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp ⭐️ Course Contents ⭐️ ⌨️ (0:00:00) Intro ⌨️ (0:04:14) Payroll ⌨️ (0:39:35) Gradebook ⌨️ (0:57:22) Decision Factors ⌨️ (1:04:40) Sales Database ⌨️ (1:23:13) Car Inventory ⌨️ (1:59:29) Problem Solving Templates ⭐️ Special thanks to our Champion supporters! ⭐️ 🏆 Loc Do 🏆 Joseph C 🏆 DeezMaster -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news
ADVERTISEMENT
Can we all just give this man a round of applause for putting this information out here for FREE! Great video man!! Thank you so much for this course!!!🙌🏼👏🏼 I will study it all.
who is here 2025-2026😊?
Here coz I lied in my resume 😭
04:20 - Avr, sum, min, max 16:45 - IF formula 29:15 - absolute cell reference (its something with $) 38:47 - something about printing 39:37 - Gradebook 46:05 - conditional formating 49:37 - OR formula 53:00 - Chart 57:24 - Decision maker 01:04:43 - Sales report 01:07:57 - text to columns 01:13:07 - sumif 01:16:04 - sort and filter 01:19:15 - pivot tables 01:23:15 - Car database 01:24:22 - import a text file into excel 01:27:57 - wrap text 01:28:06 - right, mid and left formulas 01:30:07 - Lookup Table 01:33:51 - part 2 of 3? 01:34:28 - mid 01:41:01 - Y2K bug Year 2000 bug 01:45:33 - part 3 of 3 01:46:44 - concatenate formula 01:49:16 - upper 01:56:40 - something 01:57:31 - Problem Solvers
Excel is one of the most used tools in business, engineering, accountancy and many more industries. It helps you organise and manipulate a large amount of data which can be otherwise time-consuming, mundane and difficult to organise. Excel has proven to be a skill that increases your chances of securing a job. It can help you accelerate your career in many different directions such as you can start your journey as a data analyst. If you are in the business sector, it becomes a necessity to learn excel. It helps you manage inventory, human resources and finances. Thanks a lot for sharing such valuable content 😊
30:50 Relative referencing v/s absolute referencing in columns. 41:33 Unique way of Formatting Column Headers. 45:00 Absolute referencing on row level. 46:13 Conditional Formatting. 54:00 Insert Chart and manipulate it. 1:12:00 Fill large areas while copy pasting. (ctrld+d is the shortcut for "Fill Down" other options are available as well) 1:13:30 SUMIF Function 1:19:30 Pivot Tables 1:31:14 VLOOKUP Function
who else is here in 2024? i just got to discover this channel.....few mins into the lecture and i've grabbed a whole lot Thanks for this indebt lecture,you made it so easy
I am 15 minutes into the lesson and it's so refreshing to be thought this way with so much ease. What a great teacher you are. Thank you very much.
Thank you so much for this! I had an easy time following the pace of the course. Also, the examples and exercises were great! With 30-60 minutes per day, I could complete the course in 5 days. Good Stuff!
Incredibly helpful video. As a senior in college, none of my classes ever went into a deep dive of how to do basic actions in Excel. I didn't even know half of these features existed until I came across this video. Being thrown into an upper level course where Excel is needed, this video will certainly help me excel ; ) Thanks so much for making this FREE !! 🤩
Most logical and very easy-to-understand course content. His way of explaining is incomparable to anyone in his profession, and the topic is covered vividly and never feels bored. I gained so strong knowledge immensely in a tiny time. Hat off to the professor. You're the great teacher to me I ever had in this field, sir. Best wishes for your future tutorials and life as well.
Who is here in 2026😊?
I lied on a job interview that I know excel and got the job so now i'm here thank you
Give this man A MEDAL, HE DESERVES ITT; and a new microphone, we deserve it.
When I thought this channel can't be better than it already is, then you surprise me again. Excellent idea. Looking forward to the advanced course of Excel.
Really nice course! Literally loved every minute of it, as you explain things very clearly
By far the best Excel tutorial I have seen for beginners. Complete, basic, to the point and very useful in real life situations. Great course! Thank you, Shad Sluiter, for sharing!
Thanks
This content is so amazing! Not just for beginners but also works as a quick refresher for people who've worked on excel previously. There's just one thing that I'd like to add which is not related to Excel or programming or analysis but might prove helpful and save some time. ♦Press Ctrl+<Arrow key> to navigate through rows and columns in excel. ♦Use this in combination with the Shift key and the mouse movement could reduced! Although this speed-up is very subjectively perceived yet being a programmer, I like using the keyboard more than the mouse. Hope this helps 😄
Who is here in April 2026 🤭