Microsoft Excel Tutorial for Beginners - Full Course

  Рет қаралды 8,964,371

freeCodeCamp.org

freeCodeCamp.org

Күн бұрын

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 KZfaq channel: / shadsluiter
⭐️ 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: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

Пікірлер: 2 400
@BryanSamuelTorresJose
@BryanSamuelTorresJose 2 жыл бұрын
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.
@stephenomondi6981
@stephenomondi6981 2 жыл бұрын
Ooj ononjI o onoo
@mariovelasquez6695
@mariovelasquez6695 2 жыл бұрын
Can't agree more!
@purvishah3796
@purvishah3796 2 жыл бұрын
Yes ! Absolutely 💯
@ItsMeSienna
@ItsMeSienna 2 жыл бұрын
Absolutely 👏👏👏👏👏👏 and im so excited to learn too.
@bobbihanson8254
@bobbihanson8254 Жыл бұрын
Just wonderful... thank you!
@MercyEyoette
@MercyEyoette 2 ай бұрын
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
@Captivatingclips1
@Captivatingclips1 2 ай бұрын
Is it still worthy to learn Excel in 2024?
@chukwunonsojoshua
@chukwunonsojoshua 2 ай бұрын
Please how did you download the file for the sales database
@solomonchijioke6148
@solomonchijioke6148 Ай бұрын
Where is car inventory file 😢😢
@susanwilliams-ie3ik
@susanwilliams-ie3ik Ай бұрын
@@chukwunonsojoshua it's on GitHub labelled CrystalPools
@susanwilliams-ie3ik
@susanwilliams-ie3ik Ай бұрын
@@solomonchijioke6148 it's on GitHub
@JERKINSRICE
@JERKINSRICE 4 ай бұрын
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.
@agiwilfred6338
@agiwilfred6338 4 ай бұрын
Where you able to download the necessary files for the last two lessons?
@fredaakuaamoah1560
@fredaakuaamoah1560 3 ай бұрын
@@agiwilfred6338 No i was not able to download it
@srikarsnv7791
@srikarsnv7791 2 ай бұрын
@@agiwilfred6338 same problem with me could you please reply to our comments
@Krishna-il8tw
@Krishna-il8tw 2 ай бұрын
@@agiwilfred6338 huii
@amazhobner
@amazhobner Жыл бұрын
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
@joseayala2921
@joseayala2921 Жыл бұрын
life saver thanks.
@imaginedragon4595
@imaginedragon4595 10 ай бұрын
Yo
@designhub360customtshirtsa3
@designhub360customtshirtsa3 8 ай бұрын
Thank you!!
@zippianmasese
@zippianmasese 7 ай бұрын
Please l9o
@happiestperson761
@happiestperson761 5 ай бұрын
this comment must be pinned
@parassrivastava5603
@parassrivastava5603 3 жыл бұрын
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 😊
@mynameis1880
@mynameis1880 3 жыл бұрын
Did you really type all that or did you copy paste from a excel marketing website
@luzperilla7706
@luzperilla7706 3 жыл бұрын
Thanks l new in Microsoft ,no body explain like you thanks.
@bayroncastillo7653
@bayroncastillo7653 3 жыл бұрын
THATS A GREAT COMMENT MY FRIEND !
@user-ww9we4qj9q
@user-ww9we4qj9q 3 жыл бұрын
Toyota Camry, Hyundai Grandeur, KIA Cadenza K8, KIA Quoris K9 platinum 2.5литр куб with optional rear infotainment screens. Range Rover evoque or Velar 2L Lexus ES 250 or Mercedes-Benz E class, BMW Last series. Lexus RX, Lexus LS byu a used car that is just coming off of a 2 or 3 year lease. With Jaguar XF,XE, E-Pace, F-Pace VOLVO S90 2liter cubic Genesis g80 Mercedes-Benz E 53 AMG Tesla model with red, green, purple and several colors. Creed Aventus Versace Dior Sauvage Channel 5 Blue de Chanel Shaik opulent blue no Rolex, tissot, Armani, hublot Buds, Samsung, Apple watch) Apple Macbook pro Laptop , computer, camera) Big and beautiful house. To speak English fluently. Memorize Quran, training))) Become proficient in Full-stack, Video editing, Digital marketing, Copywriting mobilography, photoshop ))) Travel in the world Agriculture, Livestock Cafe, Tractor, Fura, Construction shop, grocery store,poultry farming To be a businessman Open at IT company.
@bayroncastillo7653
@bayroncastillo7653 3 жыл бұрын
@@user-ww9we4qj9q whats your point ahahah_
@pashutamayaya3233
@pashutamayaya3233 2 жыл бұрын
Excellent practical course for someone who knows only the very minimal basics, if that. Well modulated and articulated. Designed for adult self learners. Easy to follow and it is a plus that you did not use "techie' language. Your presentation style made it easy to follow without distractions. Real life examples are a plus. Application of knowledge always enhances learning. Looking forward to your next course.
@Dexcelo
@Dexcelo Жыл бұрын
Your explanations are simple and fluid. You have deconstructed all the difficulty myths related to learning Excel. Hats off and thank you!
@nolanschweitzer8815
@nolanschweitzer8815 Жыл бұрын
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 !! 🤩
@shindaratalks7641
@shindaratalks7641 Жыл бұрын
😂❤
@casmirmiracle2605
@casmirmiracle2605 5 ай бұрын
😂😂
@MsDerrrrrrrrr
@MsDerrrrrrrrr 2 жыл бұрын
I am just beginning my bookkeeping journey and THIS is internet GOLD! You are calm, precise, pleasant and thorough and all of my Y9 ICT class came flooding back to me 😆 Thank you for this!
@vedantkarale4077
@vedantkarale4077 Жыл бұрын
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+ 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 😄
@kalondumakau268
@kalondumakau268 4 ай бұрын
Sorry, I've tried and it's not working for me. Kindly explain again 😅
@mistys48
@mistys48 Жыл бұрын
I haven't even watched 10 minutes of your presentation and I am astounded at how well you explain the processes! Thank you for helping me learn what I have wanted to learn for a long time!
@saminda7228
@saminda7228 Жыл бұрын
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.
@shreya6115
@shreya6115 Жыл бұрын
Hey, follow this guy. He has pivoted into data analyst and has really helpful videos and content. I like the fact he also shares datasets on request kzfaq.info/get/bejne/l96Ep8Jmv9iYZoE.html
@user-ze7qb9yx4i
@user-ze7qb9yx4i 6 ай бұрын
can you pls share the car inventory file here
@zeroze6860
@zeroze6860 Жыл бұрын
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
@veecillaangel1523
@veecillaangel1523 Жыл бұрын
thank you
@itsavonell
@itsavonell Жыл бұрын
goatee
@deepp60
@deepp60 Жыл бұрын
@@itsavonell hi avonell, can i learn this tutorial using Excel 2010?
@Unknown-rh5jh
@Unknown-rh5jh Жыл бұрын
Difference between $C4 and C$2?
@udaythapar4237
@udaythapar4237 Жыл бұрын
@@Unknown-rh5jh $C4 means the Column 'C' is freezed so that the reference value (the value referred to) doesn't change even while other input number changes. C$2 means the Row '2' is freezed so that even if the column value changes the reference value doesn't change. I hope it is easy to understand :)
@mohammadshekhu9717
@mohammadshekhu9717 Жыл бұрын
teaching style is very simple and effective without bringing lots of things..he is imparting his knowledge to the students and working professionals..
@remoteworkstuff
@remoteworkstuff 9 ай бұрын
Thank you so much!!! for making this video available. I love how the teaching is not too hard to digest, clear and pretty thorough. I take this course for refreshing memory and also learnt a lot more that I missed to learn in the past. It helps me so much to start my online work journey... means a lot!! Sending my prayers out to you and everyone that makes this video happen/available. Hope all goodness and abundance come back to you guys in from all directions.
@evarosales7930
@evarosales7930 Жыл бұрын
You Dear Sir are AMAZING! Thank you so much for this AWESOME tutorial. Everything I know about excel I have learned from videos on youtube. Yours by far has been the absolute BEST!
@tomemaster1744
@tomemaster1744 3 жыл бұрын
I just wanna say thank you. I've came back each day to do each task and I feel it's really bolstered my skills at using Excel (and Spreadsheets in general).
@mckennalynch3476
@mckennalynch3476 2 жыл бұрын
A huge thank you to this man and everyone who is willing to share information like this for free on the internet to complete strangers.
@tiffanyalston2613
@tiffanyalston2613 Жыл бұрын
I have been trying to update myself on access allllllll day! This video was by far the best crash course I have seen it helped me figure out exactly what I need to do. Thank you so much for taking time to create this.
@thejoker8471
@thejoker8471 Жыл бұрын
Guys I'm gonna say, You'll find many excel tutorials here but trust me this man is an absolute genius. I have tried to learn excel before and forgot everything later. But this here is easy to learn with effective exercises to recall learnings. Best time saving tutorial for beginners who have a little knowledge about excel
@towelamvula4428
@towelamvula4428 3 жыл бұрын
Thank you very much for the lessons! I just started learning excel and I already feel like a pro! You have made my learning easier.
@lipingyang8475
@lipingyang8475 2 жыл бұрын
The best course for Excel beginner! Very clear and organized instructions with practical examples. Thank you, Shad Sluiter!
@neaworld3960
@neaworld3960 Жыл бұрын
Hey there! Have you heard about sin? Basically, it is anything that is wrong that we do to upset God. Sin upsets God because He is Holy. Just like this( Imagine if you saw someone being robbed!) God does not like sin, and Heaven is His God's home. So imagine you are sinning and trying to enter into God's house! What happens is, you WON'T end up in God's House! Basically, you end up in Satan's, the creature who is deceiving souls into going to his house, hell, which will be his permanent residence in a few years, where he wants to take millions of souls including yours! There is no second chance when you get into hell. It is jail, but ain't no bail". And that's why Jesus died. He died in our place, that we might just have a chance at life if we believed in Him. Repent of your sins and believe in Him!.
@user-wg8dd9os5m
@user-wg8dd9os5m 5 ай бұрын
Absolute gold! This is by far one of the most cleanest and on-point facilitation I've seen. Kudos to Shad Sluiter and the freecodecamp team for publishing this.
@Nobleflex101
@Nobleflex101 9 ай бұрын
I applauded you sir for taking the time out to get this lesson across the globe, you're a global scholar and we do appreciate your time and effort.
@Moon-gn7dp
@Moon-gn7dp Жыл бұрын
Just done three assignments; don't have words to say about this man's way of teaching. wonderful, excellent job sir !
@oluwaseyiadigun8079
@oluwaseyiadigun8079 4 ай бұрын
how do we access the assignments please?
@dori9027
@dori9027 2 жыл бұрын
I need excel for my new work so i searched a lot of tutorials during the past week and they were ok, but this video.. it was THE BEST tutorial so far. simple explanation, detailed and easy to UNDERSTAND, even the timing when you explain and do something is perfect (gives the time to understand, not only how to do it but why is done that way. Really i wanted to say "THANKS for the video, GREAT JOB"!! 👍😊👍 helped me a lot.
@navneetsingh2118
@navneetsingh2118 Ай бұрын
You guys have no idea how great this is everyone trying to learn excel at home. I really just want to thank you for making this for everyone to watch and learn for free.
@shy4real
@shy4real Жыл бұрын
this man will be my steppingstone into becoming a data analyst someday, thank you sir
@priscillaemiator9296
@priscillaemiator9296 Жыл бұрын
Please where you able to download the spreadsheet for Sales database?
@frhadlizad2013
@frhadlizad2013 4 ай бұрын
did you become data analyst??????????????????????????????????????????????????
@JohannBaritono
@JohannBaritono 3 жыл бұрын
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.
@alexengland9540
@alexengland9540 2 жыл бұрын
Does he have an advanced course? Trying to find one.
@riyagoel6197
@riyagoel6197 2 жыл бұрын
Let me also know when it comes
@ornobc.h.y2869
@ornobc.h.y2869 Жыл бұрын
did you find the excercise file of this video?
@nitinbaadkar6741
@nitinbaadkar6741 Жыл бұрын
Excel formula: kzfaq.info/get/bejne/aql7fMKUxsyXp2w.html
@dwightarroyo1784
@dwightarroyo1784 2 жыл бұрын
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!
@nitinbaadkar6741
@nitinbaadkar6741 Жыл бұрын
Excel formula: kzfaq.info/get/bejne/aql7fMKUxsyXp2w.html
@Dufy_Duf
@Dufy_Duf 2 ай бұрын
I'm starting a new career in Procurement next month so I wanted to get a refresher on Excel and just some basic formulas. This course was fantastic! You're a great teacher and explained everything so well and it's simple enough to follow through without pausing the video too many times. Highly recommend if anybody needs a good refresh on Excel
@CollinsK_
@CollinsK_ Жыл бұрын
Thank you so much for this, I absolutely loved this video tutorial, and the examples and exercise really covered a lot. The way he explains and carries you along in examples really helped me because I had been panicking a little about learning excel again. Thank you so much P.S for anyone who noticed the formula for miles/year gave double the value of miles you can use this formula for correction =IF(G2=0, H2*0.5, H2/(G2+0.5))
@nafisakhanam9530
@nafisakhanam9530 2 жыл бұрын
It is undoubtedly the best video for learning excel. Thank you so much for showing every single small details in each section.
@christya879
@christya879 3 жыл бұрын
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!
@jerryweajs
@jerryweajs 2 жыл бұрын
you did complete it in 5 days?
@Supriadi-nl3fb
@Supriadi-nl3fb 2 жыл бұрын
0k
@olaaff6922
@olaaff6922 Жыл бұрын
i finished in 1 lmao noob
@sajordajuliusclarencea.5323
@sajordajuliusclarencea.5323 Жыл бұрын
@@olaaff6922 gago
@1622roma
@1622roma Жыл бұрын
Yes, it took me about the same time. Good job 👏
@dirantechie9411
@dirantechie9411 Жыл бұрын
Wow great 6 projects to sharpen my Excel skills. Thanks shadsluiter ♥️♥️
@elenaa9904
@elenaa9904 Жыл бұрын
Your KZfaq video on Excel skills was incredibly helpful and engaging. Your practical teaching style made it easy to follow and apply the concepts. Thank you for creating this informative and valuable resource and for your dedication to educating people. Keep up the great work! 🙏🌺🍀
@haroldcjennettiii
@haroldcjennettiii 3 жыл бұрын
I have a job interview requiring basic use of Excel. This course was just what I needed! Thank you!
@cesaruribe781
@cesaruribe781 3 жыл бұрын
Me too broooooo, This thing helped me so much, even if I find stuff in my future job I didn't see here, I feel so much confident now
@chinonsoaluma3553
@chinonsoaluma3553 4 ай бұрын
Half way into the class and I am still glued. This is the simplest excel course I have encountered. Very easy to understand Thank you sir!
@robinemmons9674
@robinemmons9674 Жыл бұрын
Thank you so much for this excellent training. Incredibly efficient and easy to grasp. Your teaching skills are outstanding 👏🏾
@ichiroutakashima4503
@ichiroutakashima4503 3 жыл бұрын
I remember my first time working in a company, I thought I'd need some special skills or need some experience on using complicated softwares, what's surprising is that even though decades pass, most companies still use Excel (most of them outdated ones) and databases. Two of the most common used softwares.
@melaniethurman386
@melaniethurman386 2 жыл бұрын
Just got a promotion that would include using excel! I was really good with it years back but haven’t used it in close to 10 years. This is such a great video to refresh my memory and prepare me for this new chapter in my life. THANK YOU! This is honestly so detailed, you’re a great teacher!
@adelegreen391
@adelegreen391 Жыл бұрын
all the best for the future 🎉😊
@AMP_PLUS
@AMP_PLUS Жыл бұрын
@@adelegreen391 hey adele green are you single? im interested
@firelordzuko345
@firelordzuko345 Жыл бұрын
Good luck with your promotion.
@neaworld3960
@neaworld3960 Жыл бұрын
You need to hear this: Matt 21:37 But as the days of Noah were, so shall also the coming of the Son of man be. 38 For as in the days that were before the flood they were eating and drinking, marrying and giving in marriage, until the day that Noe entered into the ark, 39 And knew not until the flood came, and took them all away; so shall also the coming of the Son of man be. 8 people were saved... THE MILLION-DOLLAR QUESTION: Will you go to Heaven when you die? Have you lied, stolen, used God’s name in vain, or lusted (which Jesus said was adultery, (Matthew 5:28)? If so, God sees you as a liar, thief, blasphemer, and adulterer at heart. If you die in your sins, you will end up in a terrible place called Hell. But there's good news. Though we broke God's Law, Jesus paid the fine by dying on the cross: "God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life" (John. 3:16). Then Jesus rose from the dead and was seen by hundreds of eyewitnesses. He fulfilled all the prophecies of the promised Savior. Please, today, repent and trust Jesus, and God will forgive you and grant you the gift of eternal life (Ephesians. 2:8-9). The ABCs of salvation by JDFarag.org ❤ Admit that you are a sinner in need of a saviour. 📖Romans 3:10 KJV 10 As it is written, There is none righteous, no, not one: 📖Romans 3:23 KJV 23 For all have sinned, and come short of the glory of God; B- Believe that Jesus is Lord, died for your sins and rose from the dead. 📖Romans 5:8 KJV 8 But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. 📖Romans 6:23 KJV 23 For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. C- Call upon his name. 📖Romans 10:9 KJV 9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 📖Romans 10:13 KJV 13 For whosoever shall call upon the name of the Lord shall be saved God loves you bro. don't commit suicide
@wilda2199
@wilda2199 Жыл бұрын
Please How did you download the car inventory file?
@1minuteofmemes
@1minuteofmemes Жыл бұрын
The best excel tutor I've ever seen. All in one video, short and sweet and quikl6 understandable. Thank you very much.
@damariceakinyi6845
@damariceakinyi6845 Жыл бұрын
Professor, thank you so much for this work. The demostrations were simple, easy to remember and follow!
@simrangoel9481
@simrangoel9481 3 жыл бұрын
Wow two hours ago i was finding videos for beginner and was disappointed that they didn't have one. And voila..it is here..
@marisolrios5186
@marisolrios5186 2 жыл бұрын
My friend redid my resume and put proficient in excel on it even though I am nowhere near that I have no experience at all, so thank you for this 😭♥️
@hersh23
@hersh23 Жыл бұрын
I'm a first time Excel (hoping to learn the minimum for a job), 12 minutes in and I'm already amazed at what can be done with excel! I legit thought it was just a program for lines and columns and aligning words.
@c0ry357
@c0ry357 Жыл бұрын
Thank you for this course, very well structured and informative. I completed the whole thing in a day, great stuff.
@karanprajapati4686
@karanprajapati4686 3 жыл бұрын
Yesterday, I was searching for an Excel tutorial, downloaded Edureka's Excel course and today got it on my favourite channel.
@abhisekgupta1543
@abhisekgupta1543 3 жыл бұрын
Which one was worth the time...before I start on any one of the two...
@karanprajapati4686
@karanprajapati4686 3 жыл бұрын
@@abhisekgupta1543 FCC
@myusername6622
@myusername6622 3 жыл бұрын
It’s almost as if you guys read my search history. Every-time I think of a topic, you guys make a video about it! Love it!
@naufalharits8259
@naufalharits8259 3 жыл бұрын
true 😂
@raky1989
@raky1989 3 жыл бұрын
Dude, can you review the video? I mean does the 2hr video is enough for excel course?
@iroar5982
@iroar5982 3 жыл бұрын
@@raky1989 title clearly say for beginners.
@raky1989
@raky1989 3 жыл бұрын
@@iroar5982 there are many tutorials with 3-4.5 hrs.
@wigglesft1574
@wigglesft1574 Жыл бұрын
Thank you for this. As an IT student at university, I was embarrassed by my lack of skills with Office applications, especially Excel. I now look halfway competent at least!
@imiruku5118
@imiruku5118 Жыл бұрын
1) I wanted to say this is a really good darn video. Easy to follow, you can pause it whenever you want to mimic what's on the screen so that you fully understand, and then once you do; you can pause the rest of the video during the sections of inputting more data, then creating the formulas; repetition is key and once you've got that groove, you don't have to watch parts of the video, you can get it done before he does, and then watch him do it afterwards before moving on. 2) During this video, I know it's targeted towards Microsoft's Excel Spreadsheets, but during the beginning and end of this video and going forward in life with my Spreadsheet education, I've been using WPS Suite, which is only $40 for a whole year. The formulas, navigation of the buttons, formatting, etc; are all quite identical to Microsoft Excel, in WPS Suite, just an FYI. I've been able to follow the video so far 100% using WPS Suite and they're using Microsoft Excel.
@Dani-tp4wn
@Dani-tp4wn 2 жыл бұрын
I'm about 30 minutes in and I gotta admit, you are brilliant at organizing what you want to teach. You've managed to organize even zooming in and out at specific intervals to teach all those small aspects of the program. Really cool! I never knew excel was so intuitive either.
@neaworld3960
@neaworld3960 Жыл бұрын
Somebody needs to hear this: Matt 21:37 But as the days of Noah were, so shall also the coming of the Son of man be. 38 For as in the days that were before the flood they were eating and drinking, marrying and giving in marriage, until the day that Noe entered into the ark, 39 And knew not until the flood came, and took them all away; so shall also the coming of the Son of man be. 8 people were saved... THE MILLION-DOLLAR QUESTION: Will you go to Heaven when you die? Have you lied, stolen, used God’s name in vain, or lusted (which Jesus said was adultery, (Matthew 5:28)? If so, God sees you as a liar, thief, blasphemer, and adulterer at heart. If you die in your sins, you will end up in a terrible place called Hell. But there's good news. Though we broke God's Law, Jesus paid the fine by dying on the cross: "God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life" (John. 3:16). Then Jesus rose from the dead and was seen by hundreds of eyewitnesses. He fulfilled all the prophecies of the promised Savior. Please, today, repent and trust Jesus, and God will forgive you and grant you the gift of eternal life (Ephesians. 2:8-9). The ABC's of salvation by JDFarag.org ❤ A-Admit that you are a sinner in need of a savior. 📖Romans 3:10 KJV 10 As it is written, There is none righteous, no, not one: 📖Romans 3:23 KJV 23 For all have sinned, and come short of the glory of God; B- Believe that Jesus is Lord , died for your sins and rose from the dead. 📖Romans 5:8 KJV 8 But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. 📖Romans 6:23 KJV 23 For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. C- Call upon his name. 📖Romans 10:9 KJV 9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 📖Romans 10:13 KJV 13 For whosoever shall call upon the name of the Lord shall be saved
@sponge8406
@sponge8406 5 ай бұрын
I like ur yamato pfp 🏴‍☠️🏴‍☠️ hopefully they become a straw hat lol
@mrCetus
@mrCetus 2 жыл бұрын
This is so well done. So clear and meticulous. Love it.
@TheDriftak
@TheDriftak Жыл бұрын
1:23:32 Timestamp n1 1:58:31 Timestamp n2 Tutorial done Thank you for this helpful video. You taught me well !
@ireneeze97
@ireneeze97 Жыл бұрын
This is the best piece of info I've come across in a long time. You not only took the time to explain everything detail by detail, but you also made in such a way that even the beginner of the able to understand everything. thank you thank you thank you so much for this piece of information. I look forward to learning more from you.
@markfrank0924
@markfrank0924 3 жыл бұрын
This was an excellent class, well done in organization, methods and process. There are lots of tools out there but this class is better because problems are solved as examples are worked out. In this way it keeps your attention while deepening the learning.
@johnborron1059
@johnborron1059 Жыл бұрын
What I like about this is that you are providing multiple instruction at once. I've been learning excel in a sort of linear way (one topic/feature at a time), and this video has used a whole range of useful things (formatting, functions, column manipulation, cell tricks etc) at the same time, which is such a better way to learn this program. Only half an hour in but had to comment because I've learned so much from this video in that half hour. Maybe my prior learning helped.I've had to rewind it a couple of times just to make some things sink in, but this is definitely the most effective learning method I've used so far. This is excellent instruction, Professor Sluiter!
@jamaali3509
@jamaali3509 Жыл бұрын
Exactly, you spotted on!
@gaballa2118
@gaballa2118 7 ай бұрын
Give this man A MEDAL, HE DESERVES ITT; and a new microphone, we deserve it.
@TurnToData
@TurnToData 10 ай бұрын
Absolute gold! This is by far one of the most cleanest and on-point facilitation I've seen. Kudos to Shad Sluiter and the freecodecamp team for publishing this. 👏👏👏👏
@safdarkh786
@safdarkh786 3 жыл бұрын
You guys are solving unemployment basically!. I can't thank you enough 😘❤️
@holbek01
@holbek01 2 жыл бұрын
This was a great tutorial. Perfect for beginners or for those who need a refresher course. I have not searched your playlist but you should definitely do one on short keys. Excel is even more efficient of a tool when you do not have to touch the mouse.
@eleanorachieng9044
@eleanorachieng9044 2 жыл бұрын
..lm. .m
@r1tw1ck46
@r1tw1ck46 Жыл бұрын
Thank you for this very easy to understand and amazing course Sir.
@geraldeneadendorff6627
@geraldeneadendorff6627 Жыл бұрын
Thank you for this course. I finished it today and really enjoyed the problem solvers especially. My head is full of formulas but I actually like Microsoft excel after this 😉 Now I just need to practice 💪 Well done on this great course. Regards from South Africa.
@imehmbang1903
@imehmbang1903 3 жыл бұрын
Thanks so much for this in-depth tutorial, for being so clear and making every moment fun.
@obasaoluwafisayomi6753
@obasaoluwafisayomi6753 2 жыл бұрын
Thank you so much for this. God bless you. Such a well detailed and explanatory course. I was blown away. 👍👍
@cek3800
@cek3800 Жыл бұрын
Very interesting and well-explained! Thanks
@lucasrosielle604
@lucasrosielle604 Жыл бұрын
Tip for inserting loads of sample Numbers such as the rate or the hours worked, use rand.between(bottom;upper). This way you dont need to insert loads of individual cells
@yeseniadiaz5146
@yeseniadiaz5146 2 жыл бұрын
Motivated to learning and being able to exceed in excell thank you 🥰 i am taking it a course at a time so this might take longer but i am happy to say I've learned the first part ( payroll) how fun ! Thank u for taking the time to create a video like this
@neaworld3960
@neaworld3960 Жыл бұрын
Hey there! Have you heard about sin? Basically, it is anything that is wrong that we do to upset God. Sin upsets God because He is Holy. Just like this( Imagine if you saw someone being robbed!) God does not like sin, and Heaven is His God's home. So imagine you are sinning and trying to enter into God's house! What happens is, you OWN'T end up in God's House! Basically, you end up in Satan's, the creature who is decieving souls into going to his house, hell, which will be his permanent residence in a few years, where he wants to take millions of souls including yours! There is no second chance when you gte into hell. It is jail, but aint no bail". And that's why Jesus died. He died in our place, that we might just have a chance at life if we believed in Him. Repent of your sins and believe in Him!.
@jordynmarburger1016
@jordynmarburger1016 2 жыл бұрын
I LOVE how you incorporated real life projects to show us how to do this. Thank you!
@zinebrouma952
@zinebrouma952 2 жыл бұрын
hi, can I ask you a question ???
@ahmedbenlarbi2348
@ahmedbenlarbi2348 2 жыл бұрын
@@zinebrouma952 go ahead ,ask your question if you don t mind .
@ahmedbenlarbi2348
@ahmedbenlarbi2348 2 жыл бұрын
@@zinebrouma952 go ahead ,ask your question if you don t mind .
@zinebrouma952
@zinebrouma952 2 жыл бұрын
@@ahmedbenlarbi2348 thank you , in 1:05:13 this teacher said that we have to download something for I thing web site but when I search I found nothing can please tell how I can download this data base please ?
@chiamakanwaa
@chiamakanwaa Жыл бұрын
@@zinebrouma952 please were you able to find out how to download the document?
@adriananunez7536
@adriananunez7536 Жыл бұрын
Thanks a lot for sharing all this knowledge. Great course!
@bosunolawore7406
@bosunolawore7406 Жыл бұрын
I thought I knew Excel, until I got here i know am just a beginner. Thank you Prof. Sluiter for simplifying this lecture. Its a good way to learn. Many thanks. I appreciate your sir.
@yrn_mya
@yrn_mya 2 жыл бұрын
High school senior trying to secure my future in product management for tech companies, I thought excel was simple like Microsoft word but I was wrong😭
@MoReal2
@MoReal2 2 жыл бұрын
If tou think Word is simple, you have no idea what you can do with it.
@vipulbhatia3562
@vipulbhatia3562 2 жыл бұрын
Trust me! Its simple.
@priyal7244
@priyal7244 2 жыл бұрын
Hey mya what you have done to become product management. If you can give me brief introduction of that field i wanna know
@user-od4zs8qr3j
@user-od4zs8qr3j 2 жыл бұрын
❤❤❤❤❤❤❤❤❤❤🎉😊
@Nick-pd2yo
@Nick-pd2yo 2 жыл бұрын
U got it
@derickayisiasare1566
@derickayisiasare1566 3 жыл бұрын
Woow great never knew that excel has all functions we put into coding for programs. Thanks very much
@ck0024
@ck0024 2 жыл бұрын
Yeah! I always teach my students Excel first then programming languages.
@shahtajp4379
@shahtajp4379 7 ай бұрын
It’s marvelous. Really a genuine teacher whose concepts are cleanse and delivering the best. I highly appreciate and recommend.
@happylucky7590
@happylucky7590 3 ай бұрын
I just followed the entire course, minus the last 3 problems in the problem solving scenarios. Thus was very helpful, informative, and his voice easy to understand and listen to. Anyway, lots of thumbs up for this great course, thank you Mr. Sluiter!
@katieparkyn355
@katieparkyn355 3 жыл бұрын
Thank you so much for this great tutorial. I have done lots of Excel courses in class and online and this is the best by far. The yellow pointer makes it so much easier to follow A+
@Fact_video-
@Fact_video- 3 жыл бұрын
Hii
@obitouchiha8087
@obitouchiha8087 2 жыл бұрын
I wanna ask a question . It means i don't need to go private institutions and do you need any certificate for jobs or you can just put in your resume ?
@anthonynotarnicola1272
@anthonynotarnicola1272 2 жыл бұрын
Trent Mann is a baller. I want the full lore of this legend.
@deekki
@deekki 2 жыл бұрын
Bruh Genesis worked 80 hours, a real grinder.
@Samuelhgflax
@Samuelhgflax 2 жыл бұрын
Financial Skills Test?? 69 😎
@Samuelhgflax
@Samuelhgflax 2 жыл бұрын
@@deekki Trent said work smarter not harder (also his dad is the CEO)
@behappythewayyouare
@behappythewayyouare Жыл бұрын
You are a very good professor. Explained in a simple way 👏👏 keep up the good work👍
@mohammedalmahdidewan8188
@mohammedalmahdidewan8188 Жыл бұрын
Lots of love to you for making an effortless and effective tutorial for excel learners. made my learning is way better.
@mandandi
@mandandi 2 жыл бұрын
Thanks Shad for the course. Impressive stuff. I started it today and hope to complete it in 2 days! I have worked with Excel for many years, but not for data analysis. I cant wait to update the Excel proficiency part of my CV after completing this.
@neaworld3960
@neaworld3960 Жыл бұрын
You need to hear this: Matt 21:37 But as the days of Noah were, so shall also the coming of the Son of man be. 38 For as in the days that were before the flood they were eating and drinking, marrying and giving in marriage, until the day that Noe entered into the ark, 39 And knew not until the flood came, and took them all away; so shall also the coming of the Son of man be. 8 people were saved... THE MILLION-DOLLAR QUESTION: Will you go to Heaven when you die? Have you lied, stolen, used God’s name in vain, or lusted (which Jesus said was adultery, (Matthew 5:28)? If so, God sees you as a liar, thief, blasphemer, and adulterer at heart. If you die in your sins, you will end up in a terrible place called Hell. But there's good news. Though we broke God's Law, Jesus paid the fine by dying on the cross: "God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life" (John. 3:16). Then Jesus rose from the dead and was seen by hundreds of eyewitnesses. He fulfilled all the prophecies of the promised Savior. Please, today, repent and trust Jesus, and God will forgive you and grant you the gift of eternal life (Ephesians. 2:8-9). The ABCs of salvation by JDFarag.org ❤ Admit that you are a sinner in need of a saviour. 📖Romans 3:10 KJV 10 As it is written, There is none righteous, no, not one: 📖Romans 3:23 KJV 23 For all have sinned, and come short of the glory of God; B- Believe that Jesus is Lord, died for your sins and rose from the dead. 📖Romans 5:8 KJV 8 But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. 📖Romans 6:23 KJV 23 For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. C- Call upon his name. 📖Romans 10:9 KJV 9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 📖Romans 10:13 KJV 13 For whosoever shall call upon the name of the Lord shall be saved
@simpleexcelexamples9619
@simpleexcelexamples9619 2 жыл бұрын
WOW your way of teaching is very clear! Also beautiful realistic cases you work with! Thanks for the video which gave me inspiration for my own classes (I give Excel training to students) 😊
@casandragenas2886
@casandragenas2886 2 жыл бұрын
Sir I really like the way you deliver your content.Thank you for these lessons
@neaworld3960
@neaworld3960 Жыл бұрын
You need to hear this: Matt 21:37 But as the days of Noah were, so shall also the coming of the Son of man be. 38 For as in the days that were before the flood they were eating and drinking, marrying and giving in marriage, until the day that Noe entered into the ark, 39 And knew not until the flood came, and took them all away; so shall also the coming of the Son of man be. 8 people were saved... THE MILLION-DOLLAR QUESTION: Will you go to Heaven when you die? Have you lied, stolen, used God’s name in vain, or lusted (which Jesus said was adultery, (Matthew 5:28)? If so, God sees you as a liar, thief, blasphemer, and adulterer at heart. If you die in your sins, you will end up in a terrible place called Hell. But there's good news. Though we broke God's Law, Jesus paid the fine by dying on the cross: "God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life" (John. 3:16). Then Jesus rose from the dead and was seen by hundreds of eyewitnesses. He fulfilled all the prophecies of the promised Savior. Please, today, repent and trust Jesus, and God will forgive you and grant you the gift of eternal life (Ephesians. 2:8-9). The ABCs of salvation by JDFarag.org ❤ Admit that you are a sinner in need of a saviour. 📖Romans 3:10 KJV 10 As it is written, There is none righteous, no, not one: 📖Romans 3:23 KJV 23 For all have sinned, and come short of the glory of God; B- Believe that Jesus is Lord, died for your sins and rose from the dead. 📖Romans 5:8 KJV 8 But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. 📖Romans 6:23 KJV 23 For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. C- Call upon his name. 📖Romans 10:9 KJV 9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 📖Romans 10:13 KJV 13 For whosoever shall call upon the name of the Lord shall be saved
@sexyneszy2010
@sexyneszy2010 Жыл бұрын
I love this course and the way you teach it, very easy to grasp and simplified. Thank you for this video. I needed it.
@neaworld3960
@neaworld3960 Жыл бұрын
Hey there! Have you heard about sin? Basically, it is anything that is wrong that we do to upset God. Sin upsets God because He is Holy. Just like this( Imagine if you saw someone being robbed!) God does not like sin, and Heaven is His God's home. So imagine you are sinning and trying to enter into God's house! What happens is, you OWN'T end up in God's House! Basically, you end up in Satan's, the creature who is decieving souls into going to his house, hell, which will be his permanent residence in a few years, where he wants to take millions of souls including yours! There is no second chance when you gte into hell. It is jail, but aint no bail". And that's why Jesus died. He died in our place, that we might just have a chance at life if we believed in Him. Repent of your sins and believe in Him!.
@jacobpickos733
@jacobpickos733 8 ай бұрын
I'm five minutes in and the vibes are on point. Love this guy's attitude! Thanks for the tips and tricks!
@redhood255
@redhood255 3 жыл бұрын
Exactly what we Need 🔥🔥❤️
@rulzsimplice7335
@rulzsimplice7335 3 жыл бұрын
This channel is literally the 🐐! All love ❤️
@michaelyizhaoliu8423
@michaelyizhaoliu8423 10 ай бұрын
Shad, you are an excellent instructor. Thank you for the training.
@abundance2469
@abundance2469 3 ай бұрын
For the very first time in a year plus I finally completed this course without skipping any work within 3days 🎉❤ unto Excel Project
@MK-zf6or
@MK-zf6or 2 жыл бұрын
This guy really taught us so much in 2 hours, thanks Shad
@georgekrax
@georgekrax 3 жыл бұрын
Really nice course! Literally loved every minute of it, as you explain things very clearly
@neaworld3960
@neaworld3960 Жыл бұрын
You need to hear this: Matt 21:37 But as the days of Noah were, so shall also the coming of the Son of man be. 38 For as in the days that were before the flood they were eating and drinking, marrying and giving in marriage, until the day that Noe entered into the ark, 39 And knew not until the flood came, and took them all away; so shall also the coming of the Son of man be. 8 people were saved... THE MILLION-DOLLAR QUESTION: Will you go to Heaven when you die? Have you lied, stolen, used God’s name in vain, or lusted (which Jesus said was adultery, (Matthew 5:28)? If so, God sees you as a liar, thief, blasphemer, and adulterer at heart. If you die in your sins, you will end up in a terrible place called Hell. But there's good news. Though we broke God's Law, Jesus paid the fine by dying on the cross: "God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life" (John. 3:16). Then Jesus rose from the dead and was seen by hundreds of eyewitnesses. He fulfilled all the prophecies of the promised Savior. Please, today, repent and trust Jesus, and God will forgive you and grant you the gift of eternal life (Ephesians. 2:8-9). The ABCs of salvation by JDFarag.org ❤ Admit that you are a sinner in need of a saviour. 📖Romans 3:10 KJV 10 As it is written, There is none righteous, no, not one: 📖Romans 3:23 KJV 23 For all have sinned, and come short of the glory of God; B- Believe that Jesus is Lord, died for your sins and rose from the dead. 📖Romans 5:8 KJV 8 But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. 📖Romans 6:23 KJV 23 For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. C- Call upon his name. 📖Romans 10:9 KJV 9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 📖Romans 10:13 KJV 13 For whosoever shall call upon the name of the Lord shall be saved God loves you!!!!!
@teefedtips
@teefedtips 2 ай бұрын
How do I say thank you to satisfy how grateful and thankful I am? Words cant express. We love you so much. Life saver
@cenoh2381
@cenoh2381 Жыл бұрын
Modern Hero! 👏👏👏 . Help this man by not skipping ads!
@spazworrier
@spazworrier 2 жыл бұрын
I learned more about excel in this video than I ever did in school! Thank you so much for this!
@cesaruribe781
@cesaruribe781 3 жыл бұрын
Just wanna say thank you because, even if I come across things I didn't see here I feel so much confident now when using Excel, THANK YOU
@tshedisothulo2667
@tshedisothulo2667 Жыл бұрын
I'm so thankful for this amazing tutorial, as I'm writing this I'm still watching it and I'm enjoying every passing secs and mins of it.
@mmetimfongladstone5335
@mmetimfongladstone5335 Жыл бұрын
You're truly a blessing.. Please 🙏 know this, you've blessed alot of people with your knowledge. I'm just one that is openly saying this... Thank you 😊
@dadsownchannel3729
@dadsownchannel3729 2 жыл бұрын
This is definitely a great way to connect with individuals wanting to learn EXCEL. You have truly made is easier and simplified the whole process so everyone understands clearly. Thank you{
@wilhellmllw3608
@wilhellmllw3608 3 жыл бұрын
Ooh amazing I was just looking for one
@nenitaalcances7400
@nenitaalcances7400 11 ай бұрын
The best course for Excel beginner! Professor you're the best teacher thank you so much..👏👏👏
@_uduak_akpabio
@_uduak_akpabio Жыл бұрын
Very beneficial and easy to understand. Teaching style ✔️. Best tutorial ever!
@Siddhesh1123
@Siddhesh1123 3 жыл бұрын
The thing I loved (apart from the video of course) is that he was using Windows 7 in 2020 💖
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 4,9 МЛН
Data Analysis with Python for Excel Users - Full Course
3:57:46
freeCodeCamp.org
Рет қаралды 2,1 МЛН
Cat story: from hate to love! 😻 #cat #cute #kitten
00:40
Stocat
Рет қаралды 15 МЛН
What are you going to do in 2023? Tops 5 skills to get!
18:56
David Bombal
Рет қаралды 2,4 МЛН
Microsoft Excel Tutorial -  Beginners Level 1
32:49
Teacher's Tech
Рет қаралды 12 МЛН
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Leila Gharani
Рет қаралды 659 М.
Programming Is NOT Enough | Add these 7 skills…
13:19
Travis Media
Рет қаралды 410 М.
Computer & Technology Basics Course for Absolute Beginners
55:04
freeCodeCamp.org
Рет қаралды 2,8 МЛН
Excel Formulas and Functions | Full Course
52:40
Kevin Stratvert
Рет қаралды 1,2 МЛН
EASILY Combine Multiple Excel Sheets Into One With This Trick
8:48
Kenji Explains
Рет қаралды 212 М.
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 7 МЛН