Microsoft Excel Tutorial for Beginners - Full Course

Поделиться
HTML-код
  • Опубликовано: 30 июл 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 RUclips 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,5 тыс.

  • @BryanSamuelTorresJose
    @BryanSamuelTorresJose 2 года назад +3979

    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.

  • @parassrivastava5603
    @parassrivastava5603 3 года назад +652

    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 года назад +36

      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 года назад +6

      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_

  • @amazhobner
    @amazhobner Год назад +484

    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

  • @MercyEyoette
    @MercyEyoette 4 месяца назад +234

    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

  • @zeroze6860
    @zeroze6860 2 года назад +1027

    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 года назад +3

      thank you

    • @itsavonell
      @itsavonell 2 года назад +3

      goatee

    • @deepp60
      @deepp60 2 года назад

      @@itsavonell hi avonell, can i learn this tutorial using Excel 2010?

    • @Unknown-rh5jh
      @Unknown-rh5jh 2 года назад

      Difference between $C4 and C$2?

    • @udaythapar4237
      @udaythapar4237 2 года назад +18

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

  • @pashutamayaya3233
    @pashutamayaya3233 2 года назад +88

    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 Год назад +41

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

  • @JERKINSRICE
    @JERKINSRICE 6 месяцев назад +123

    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 5 месяцев назад +1

      Where you able to download the necessary files for the last two lessons?

    • @fredaakuaamoah1560
      @fredaakuaamoah1560 5 месяцев назад

      @@agiwilfred6338 No i was not able to download it

    • @srikarsnv7791
      @srikarsnv7791 4 месяца назад

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

    • @Krishna-ii77
      @Krishna-ii77 4 месяца назад

      @@agiwilfred6338 huii

  • @mistys48
    @mistys48 2 года назад +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!

  • @MsDerrrrrrrrr
    @MsDerrrrrrrrr 2 года назад +20

    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!

  • @remoteworkstuff
    @remoteworkstuff 11 месяцев назад +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.

  • @nolanschweitzer8815
    @nolanschweitzer8815 Год назад +241

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

  • @dwightarroyo1784
    @dwightarroyo1784 2 года назад +154

    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: ruclips.net/video/4CKI_caf3w8/видео.html

  • @lipingyang8475
    @lipingyang8475 2 года назад +30

    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 7 месяцев назад +9

    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.

  • @vedantkarale4077
    @vedantkarale4077 Год назад +89

    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 6 месяцев назад

      Sorry, I've tried and it's not working for me.
      Kindly explain again 😅

  • @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: ruclips.net/video/4CKI_caf3w8/видео.html

  • @evarosales7930
    @evarosales7930 Год назад +19

    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!

  • @saminda7228
    @saminda7228 Год назад +250

    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 ruclips.net/video/axTt_5Zr46M/видео.html

    • @user-ze7qb9yx4i
      @user-ze7qb9yx4i 8 месяцев назад +2

      can you pls share the car inventory file here

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

  • @mohammadshekhu9717
    @mohammadshekhu9717 Год назад +31

    teaching style is very simple and effective without bringing lots of things..he is imparting his knowledge to the students and working professionals..

  • @PonderP378
    @PonderP378 Месяц назад +18

    Thank you for sharing this for free. It is equivalent to paid courses online. Please continue to help other people by uploading free videos.

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

  • @mckennalynch3476
    @mckennalynch3476 2 года назад +19

    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.

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

  • @TurnToData
    @TurnToData Год назад +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. 👏👏👏👏

  • @navneetsingh2118
    @navneetsingh2118 3 месяца назад +1

    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.

  • @christya879
    @christya879 3 года назад +391

    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!

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

  • @Nobleflex101
    @Nobleflex101 11 месяцев назад +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.

  • @Juan-re6rt
    @Juan-re6rt Месяц назад +247

    Thanks a lot for the video! Btw how can I get an Excel product key for a good price?

    • @BenjamainTelekeni
      @BenjamainTelekeni Месяц назад

      There are a lot of options to get Excel.. After a dip research I found a great company.

    • @Juan-re6rt
      @Juan-re6rt Месяц назад

      @@BenjamainTelekeni I tried several sources, including eBay, but they all stopped working after a couple of months. Can you share with me the name of the company?

    • @BenjamainTelekeni
      @BenjamainTelekeni Месяц назад

      @@Juan-re6rt haha yeah, BNH-Software. I hope its will help you :)

    • @Juan-re6rt
      @Juan-re6rt Месяц назад

      @@BenjamainTelekeni Thanks! Bought Office 2021 and activated my Excel Working perfectly.

    • @lwazigcingca893
      @lwazigcingca893 22 дня назад

      I can install it for 250

  • @imehmbang1903
    @imehmbang1903 3 года назад +22

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

  • @damariceakinyi6845
    @damariceakinyi6845 Год назад +6

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

  • @Dufy_Duf
    @Dufy_Duf 4 месяца назад

    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.

  • @johnborron1059
    @johnborron1059 2 года назад +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!

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

  • @robinemmons9674
    @robinemmons9674 Год назад +5

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

  • @georgekrax
    @georgekrax 3 года назад +174

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

  • @nafisakhanam9530
    @nafisakhanam9530 3 года назад +5

    It is undoubtedly the best video for learning excel. Thank you so much for showing every single small details in each section.

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

  • @elenaa9904
    @elenaa9904 Год назад +4

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

  • @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 7 месяцев назад

      I like ur yamato pfp 🏴‍☠️🏴‍☠️ hopefully they become a straw hat lol

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

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

  • @Chingbong1
    @Chingbong1 11 дней назад +1

    I did the first 2 projects so far and learnt so much. I will complete this course, watch a few more tutorials, and keep practising until I'm good enough to put it on my LinkedIn as "Proficient in Excel". I wish I had done this when I was 19 or 20, sadly I am 22 and under pressure to get a job.

  • @Moon-gn7dp
    @Moon-gn7dp 2 года назад +15

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

  • @mrCetus
    @mrCetus 2 года назад +4

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

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

  • @Priyanka-ik4uw
    @Priyanka-ik4uw Месяц назад +2

    You sound the kind of calm which comes from a confidence in your craft with years of experience and professionalism. I've never watched an excel tutorial which didn't bore me to death and made me want to give up in a few minutes. Your teaching style is so simple, easy to follow which makes me eager to keep watching and learn more. For anyone looking to learn HTML, CSS, JavaScript, SuperSimpleDev on RUclips is an equivalent to this man when it comes to teaching. I have recently finished his videos and am glad to have found a tutorial with the same pace and project-based teaching style as him.

    • @Felipe-rn1gf
      @Felipe-rn1gf 19 дней назад

      yes, it seems like I'm seeing knowledge from a wise master stored in mp4 format on the internet and not just a random tutorial 😂

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

  • @obasaoluwafisayomi6753
    @obasaoluwafisayomi6753 2 года назад +3

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

  • @dirantechie9411
    @dirantechie9411 Год назад +5

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

  • @stiernonhorimbere2688
    @stiernonhorimbere2688 5 месяцев назад +1

    i love the way we move step by step, it is very easy to understand.. thank you for this course! you are such an amazing person

  • @mandandi
    @mandandi 3 года назад +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

  • @RSTutor-df1de
    @RSTutor-df1de 2 месяца назад

    You are a brilliant teacher, you have taught me a lot in Excel, which i wanted to learn over summer. Thank you for explaining so clearly and concisely, and for letting us have and use this content for free.

  • @jacobpickos733
    @jacobpickos733 9 месяцев назад

    I'm five minutes in and the vibes are on point. Love this guy's attitude! Thanks for the tips and tricks!

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

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

  • @c0ry357
    @c0ry357 Год назад

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

  • @shahtajp4379
    @shahtajp4379 8 месяцев назад

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

  • @katieparkyn355
    @katieparkyn355 3 года назад +24

    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 ?

  • @marisolrios5186
    @marisolrios5186 3 года назад +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 😭♥️

  • @mohammedalmahdidewan8188
    @mohammedalmahdidewan8188 Год назад

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

  • @happylucky7590
    @happylucky7590 5 месяцев назад

    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!

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

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

  • @muhammadtabishsami
    @muhammadtabishsami 6 месяцев назад

    Thanks Prof. Shad Sluiter. I am able to do much things excels because of you.
    Hope to learn more from you!

  • @michaelyizhaoliu8423
    @michaelyizhaoliu8423 Год назад

    Shad, you are an excellent instructor. Thank you for the training.

  • @spazworrier
    @spazworrier 2 года назад +3

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

  • @chinonsoaluma3553
    @chinonsoaluma3553 6 месяцев назад +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!

  • @iroajachukwuemeka314
    @iroajachukwuemeka314 Год назад +1

    this training is really awesome, its like pouring out your heart so to feed others with it. thank you so much sir

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

  • @MK-zf6or
    @MK-zf6or 2 года назад +9

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

  • @olababa761
    @olababa761 Год назад

    I'm enjoying this tutorial, I'm glad I stumbled on this. A million thanks to you!

  • @adriananunez7536
    @adriananunez7536 Год назад +3

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

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

  • @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 2 года назад +1

      all the best for the future 🎉😊

    • @AMP_PLUS
      @AMP_PLUS 2 года назад

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

    • @firelordzuko345
      @firelordzuko345 2 года назад +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?

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

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

  • @safdarkh786
    @safdarkh786 3 года назад +88

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

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

  • @teefedtips
    @teefedtips 4 месяца назад

    How do I say thank you to satisfy how grateful and thankful I am? Words cant express. We love you so much. Life saver

  • @mmetimfongladstone5335
    @mmetimfongladstone5335 Год назад +1

    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 😊

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

  • @rulzsimplice7335
    @rulzsimplice7335 3 года назад +9

    This channel is literally the 🐐!
    All love ❤️

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

  • @TheDriftak
    @TheDriftak Год назад

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

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

    • @sillysamv9900
      @sillysamv9900 Месяц назад

      U got the job?

    • @haroldcjennettiii
      @haroldcjennettiii Месяц назад

      ​@@sillysamv9900 I did not, but at no fault to this course. I did great with the test they gave me. To this day I don't know why they didn't consider me. It's ok though, I have a job I love now.

  • @wilhellmllw3608
    @wilhellmllw3608 3 года назад +37

    Ooh amazing I was just looking for one

  • @impamervedie5143
    @impamervedie5143 Год назад

    Thank you so much (author ) this video really helped me remember most of the things that I forgot about Excel. I really appreciate this.

  • @Metal_seer
    @Metal_seer 4 месяца назад

    Thks for a pleasant and clear teaching style. Since I haven't used Excel for 25 years, I need this. I'm sure Excel has added many enhancenents. ( Incidentally, my first spreadsheet program was Excel in the 70s.)

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

  • @cek3800
    @cek3800 Год назад +6

    Very interesting and well-explained! Thanks

  • @behappythewayyouare
    @behappythewayyouare Год назад

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

  • @Jord-xh1nk
    @Jord-xh1nk 7 дней назад

    You're A Great Teacher!!!Thank You So Much For Creating This Video

  • @clintonmkadinali3821
    @clintonmkadinali3821 4 месяца назад +4

    THANKS FOR THE FREE COURSE TUTORIAL, GOD BLESS YOU !

  • @daminikharat3812
    @daminikharat3812 3 года назад +4

    Thanks for this amazing course!❤️

  • @leahp.mchisengangoma7980
    @leahp.mchisengangoma7980 10 месяцев назад

    Thank you so much we need people like you in today's world kudos for putting these up for us