Microsoft Excel Tutorial for Beginners - Full Course

Поділитися
Вставка
  • Опубліковано 7 чер 2024
  • 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 UA-cam 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,4 тис.

  • @BryanSamuelTorresJose
    @BryanSamuelTorresJose 2 роки тому +3691

    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.

  • @MercyEyoette
    @MercyEyoette 2 місяці тому +96

    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

  • @JERKINSRICE
    @JERKINSRICE 4 місяці тому +97

    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 місяці тому +1

      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 3 місяці тому

      @@agiwilfred6338 same problem with me could you please reply to our comments

    • @Krishna-il8tw
      @Krishna-il8tw 2 місяці тому

      @@agiwilfred6338 huii

  • @amazhobner
    @amazhobner Рік тому +447

    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

  • @parassrivastava5603
    @parassrivastava5603 3 роки тому +618

    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 роки тому +33

      Did you really type all that or did you copy paste from a excel marketing website

    • @luzperilla7706
      @luzperilla7706 3 роки тому +4

      Thanks l new in Microsoft ,no body explain like you thanks.

    • @bayroncastillo7653
      @bayroncastillo7653 3 роки тому +5

      THATS A GREAT COMMENT MY FRIEND !

    • @user-ww9we4qj9q
      @user-ww9we4qj9q 3 роки тому +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 роки тому +1

      @@user-ww9we4qj9q whats your point ahahah_

  • @zeroze6860
    @zeroze6860 2 роки тому +988

    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 Рік тому +2

      thank you

    • @itsavonell
      @itsavonell Рік тому +3

      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 Рік тому +17

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

  • @mistys48
    @mistys48 Рік тому +31

    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!

  • @vedantkarale4077
    @vedantkarale4077 Рік тому +87

    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 😅

  • @pashutamayaya3233
    @pashutamayaya3233 2 роки тому +85

    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.

  • @MsDerrrrrrrrr
    @MsDerrrrrrrrr 2 роки тому +18

    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!

  • @nolanschweitzer8815
    @nolanschweitzer8815 Рік тому +233

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

  • @Dexcelo
    @Dexcelo Рік тому +36

    Your explanations are simple and fluid. You have deconstructed all the difficulty myths related to learning Excel. Hats off and thank you!

  • @saminda7228
    @saminda7228 Рік тому +249

    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 ua-cam.com/video/axTt_5Zr46M/v-deo.html

    • @user-ze7qb9yx4i
      @user-ze7qb9yx4i 6 місяців тому +2

      can you pls share the car inventory file here

  • @dwightarroyo1784
    @dwightarroyo1784 2 роки тому +153

    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: ua-cam.com/video/4CKI_caf3w8/v-deo.html

  • @mohammadshekhu9717
    @mohammadshekhu9717 Рік тому +30

    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 місяців тому +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.

  • @lipingyang8475
    @lipingyang8475 2 роки тому +29

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

  • @dori9027
    @dori9027 2 роки тому +6

    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.

  • @thejoker8471
    @thejoker8471 Рік тому +2

    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

  • @evarosales7930
    @evarosales7930 Рік тому +17

    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 роки тому +6

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

  • @JohannBaritono
    @JohannBaritono 3 роки тому +170

    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 роки тому +5

      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: ua-cam.com/video/4CKI_caf3w8/v-deo.html

  • @user-wg8dd9os5m
    @user-wg8dd9os5m 5 місяців тому +8

    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.

  • @tiffanyalston2613
    @tiffanyalston2613 Рік тому +1

    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.

  • @Moon-gn7dp
    @Moon-gn7dp Рік тому +14

    Just done three assignments; don't have words to say about this man's way of teaching.
    wonderful, excellent job sir !

  • @mckennalynch3476
    @mckennalynch3476 2 роки тому +15

    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.

  • @CollinsK_
    @CollinsK_ Рік тому +6

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

  • @Nobleflex101
    @Nobleflex101 9 місяців тому +7

    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.

  • @towelamvula4428
    @towelamvula4428 3 роки тому +21

    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.

  • @johnborron1059
    @johnborron1059 Рік тому +19

    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!

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

  • @1minuteofmemes
    @1minuteofmemes Рік тому +2

    The best excel tutor I've ever seen.
    All in one video, short and sweet and quikl6 understandable.
    Thank you very much.

  • @nafisakhanam9530
    @nafisakhanam9530 2 роки тому +6

    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 роки тому +390

    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!

  • @TurnToData
    @TurnToData 10 місяців тому +8

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

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

  • @ichiroutakashima4503
    @ichiroutakashima4503 3 роки тому +49

    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.

  • @markfrank0924
    @markfrank0924 3 роки тому +22

    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.

  • @elenaa9904
    @elenaa9904 Рік тому +4

    Your UA-cam 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! 🙏🌺🍀

  • @dirantechie9411
    @dirantechie9411 Рік тому +5

    Wow great 6 projects to sharpen my Excel skills. Thanks shadsluiter ♥️♥️

  • @mrCetus
    @mrCetus 2 роки тому +4

    This is so well done. So clear and meticulous. Love it.

  • @Dani-tp4wn
    @Dani-tp4wn 2 роки тому +81

    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

  • @damariceakinyi6845
    @damariceakinyi6845 Рік тому +6

    Professor, thank you so much for this work. The demostrations were simple, easy to remember and follow!

  • @imiruku5118
    @imiruku5118 Рік тому +1

    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.

  • @haroldcjennettiii
    @haroldcjennettiii 3 роки тому +33

    I have a job interview requiring basic use of Excel. This course was just what I needed! Thank you!

    • @cesaruribe781
      @cesaruribe781 3 роки тому +2

      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

  • @robinemmons9674
    @robinemmons9674 Рік тому +5

    Thank you so much for this excellent training. Incredibly efficient and easy to grasp. Your teaching skills are outstanding 👏🏾

  • @geraldeneadendorff6627
    @geraldeneadendorff6627 Рік тому +4

    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.

  • @marisolrios5186
    @marisolrios5186 2 роки тому +9

    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 😭♥️

  • @myusername6622
    @myusername6622 3 роки тому +45

    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 роки тому +1

      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.

  • @hersh23
    @hersh23 Рік тому +3

    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.

  • @TheDriftak
    @TheDriftak Рік тому

    1:23:32 Timestamp n1
    1:58:31 Timestamp n2
    Tutorial done
    Thank you for this helpful video. You taught me well !

  • @simrangoel9481
    @simrangoel9481 3 роки тому +15

    Wow two hours ago i was finding videos for beginner and was disappointed that they didn't have one. And voila..it is here..

  • @imehmbang1903
    @imehmbang1903 3 роки тому +22

    Thanks so much for this in-depth tutorial, for being so clear and making every moment fun.

  • @bosunolawore7406
    @bosunolawore7406 Рік тому +1

    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.

  • @chinonsoaluma3553
    @chinonsoaluma3553 4 місяці тому +7

    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!

  • @melaniethurman386
    @melaniethurman386 2 роки тому +41

    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 Рік тому +1

      all the best for the future 🎉😊

    • @AMP_PLUS
      @AMP_PLUS Рік тому

      @@adelegreen391 hey adele green are you single? im interested

    • @firelordzuko345
      @firelordzuko345 Рік тому +2

      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?

  • @holbek01
    @holbek01 2 роки тому +25

    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.

  • @wigglesft1574
    @wigglesft1574 Рік тому +1

    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!

  • @cek3800
    @cek3800 Рік тому +6

    Very interesting and well-explained! Thanks

  • @katieparkyn355
    @katieparkyn355 3 роки тому +25

    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 роки тому +1

      Hii

    • @obitouchiha8087
      @obitouchiha8087 2 роки тому +1

      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 ?

  • @jordynmarburger1016
    @jordynmarburger1016 2 роки тому +19

    I LOVE how you incorporated real life projects to show us how to do this. Thank you!

    • @zinebrouma952
      @zinebrouma952 2 роки тому +1

      hi, can I ask you a question ???

    • @ahmedbenlarbi2348
      @ahmedbenlarbi2348 2 роки тому +1

      @@zinebrouma952 go ahead ,ask your question if you don t mind .

    • @ahmedbenlarbi2348
      @ahmedbenlarbi2348 2 роки тому +1

      @@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 Рік тому +3

    Thanks a lot for sharing all this knowledge. Great course!

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

  • @yeseniadiaz5146
    @yeseniadiaz5146 2 роки тому +7

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

  • @mandandi
    @mandandi 2 роки тому +21

    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

  • @r1tw1ck46
    @r1tw1ck46 Рік тому +4

    Thank you for this very easy to understand and amazing course Sir.

  • @c0ry357
    @c0ry357 Рік тому

    Thank you for this course, very well structured and informative. I completed the whole thing in a day, great stuff.

  • @derickayisiasare1566
    @derickayisiasare1566 3 роки тому +24

    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.

  • @georgekrax
    @georgekrax 3 роки тому +173

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

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

  • @sexyneszy2010
    @sexyneszy2010 Рік тому +1

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

  • @obasaoluwafisayomi6753
    @obasaoluwafisayomi6753 2 роки тому +3

    Thank you so much for this. God bless you. Such a well detailed and explanatory course. I was blown away. 👍👍

  • @simpleexcelexamples9619
    @simpleexcelexamples9619 2 роки тому +25

    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

  • @gaballa2118
    @gaballa2118 7 місяців тому

    Give this man A MEDAL, HE DESERVES ITT;
    and a new microphone, we deserve it.

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

  • @wilhellmllw3608
    @wilhellmllw3608 3 роки тому +37

    Ooh amazing I was just looking for one

  • @karanprajapati4686
    @karanprajapati4686 3 роки тому +15

    Yesterday, I was searching for an Excel tutorial, downloaded Edureka's Excel course and today got it on my favourite channel.

  • @lucasrosielle604
    @lucasrosielle604 Рік тому +5

    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

  • @shy4real
    @shy4real Рік тому +14

    this man will be my steppingstone into becoming a data analyst someday, thank you sir

    • @priscillaemiator9296
      @priscillaemiator9296 Рік тому +1

      Please where you able to download the spreadsheet for Sales database?

    • @frhadlizad2013
      @frhadlizad2013 4 місяці тому

      did you become data analyst??????????????????????????????????????????????????

  • @safdarkh786
    @safdarkh786 3 роки тому +87

    You guys are solving unemployment basically!. I can't thank you enough 😘❤️

  • @behappythewayyouare
    @behappythewayyouare Рік тому

    You are a very good professor. Explained in a simple way 👏👏
    keep up the good work👍

  • @shahtajp4379
    @shahtajp4379 7 місяців тому

    It’s marvelous. Really a genuine teacher whose concepts are cleanse and delivering the best. I highly appreciate and recommend.

  • @justicesaid9654
    @justicesaid9654 2 роки тому +7

    Thanks a lot. Did practically after each part. Easy, understandable, and very helpful.

    • @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!.

  • @rulzsimplice7335
    @rulzsimplice7335 3 роки тому +9

    This channel is literally the 🐐!
    All love ❤️

  • @michaelyizhaoliu8423
    @michaelyizhaoliu8423 11 місяців тому

    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

  • @spazworrier
    @spazworrier 2 роки тому +3

    I learned more about excel in this video than I ever did in school! Thank you so much for this!

  • @cesaruribe781
    @cesaruribe781 3 роки тому +5

    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

  • @mohammedalmahdidewan8188
    @mohammedalmahdidewan8188 Рік тому

    Lots of love to you for making an effortless and effective tutorial for excel learners. made my learning is way better.

  • @ExcelID
    @ExcelID Рік тому

    This is great video, I got better after watching this tutorial so I can make tutorials for many people. Thank you sir

  • @anthonynotarnicola1272
    @anthonynotarnicola1272 2 роки тому +51

    Trent Mann is a baller.
    I want the full lore of this legend.

    • @deekki
      @deekki 2 роки тому +4

      Bruh Genesis worked 80 hours, a real grinder.

    • @Samuelhgflax
      @Samuelhgflax 2 роки тому +1

      Financial Skills Test?? 69 😎

    • @Samuelhgflax
      @Samuelhgflax 2 роки тому +1

      @@deekki Trent said work smarter not harder (also his dad is the CEO)

  • @MK-zf6or
    @MK-zf6or 2 роки тому +9

    This guy really taught us so much in 2 hours, thanks Shad

  • @cenoh2381
    @cenoh2381 Рік тому +2

    Modern Hero! 👏👏👏 . Help this man by not skipping ads!

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

  • @dadsownchannel3729
    @dadsownchannel3729 2 роки тому +3

    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{

  • @redhood255
    @redhood255 3 роки тому +10

    Exactly what we Need 🔥🔥❤️

  • @anthonynderitu4062
    @anthonynderitu4062 Рік тому +1

    excellent explanatory tutorial.its very articulate and has covered diversed areas in excel,looking forward to learn more from you.thank you sir

  • @_uduak_akpabio
    @_uduak_akpabio Рік тому +1

    Very beneficial and easy to understand. Teaching style ✔️. Best tutorial ever!

  • @soumyajitsarkar2372
    @soumyajitsarkar2372 2 роки тому +6

    I know the excel tables are created live during the class, but is there any way we can get them in CSV or xlsx format? So that we can follow along.
    Thanks a ton for the tutorial !!

  • @bedantajyotidas7526
    @bedantajyotidas7526 3 роки тому +21

    Plz continue this series... please upload intermediate level