Тёмный

Microsoft Excel Tutorial for Beginners - Full Course 

freeCodeCamp.org
Подписаться 9 млн
Просмотров 9 млн
50% 1

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 RU-vid 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

Опубликовано:

 

22 май 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 2,4 тыс.   
@BryanSamuelTorresJose
@BryanSamuelTorresJose 2 года назад
Can we all just give this man a round of applause for putting this information out here for FREE! Great video man!! Thank you so much for this course!!!🙌🏼👏🏼 I will study it all.
@stephenomondi6981
@stephenomondi6981 2 года назад
Ooj ononjI o onoo
@mariovelasquez6695
@mariovelasquez6695 2 года назад
Can't agree more!
@purvishah3796
@purvishah3796 2 года назад
Yes ! Absolutely 💯
@ItsMeSienna
@ItsMeSienna Год назад
Absolutely 👏👏👏👏👏👏 and im so excited to learn too.
@bobbihanson8254
@bobbihanson8254 Год назад
Just wonderful... thank you!
@MercyEyoette
@MercyEyoette 2 месяца назад
who else is here in 2024? i just got to discover this channel.....few mins into the lecture and i've grabbed a whole lot Thanks for this indebt lecture,you made it so easy
@Captivatingclips1
@Captivatingclips1 Месяц назад
Is it still worthy to learn Excel in 2024?
@chukwunonsojoshua
@chukwunonsojoshua Месяц назад
Please how did you download the file for the sales database
@solomonchijioke6148
@solomonchijioke6148 Месяц назад
Where is car inventory file 😢😢
@susanwilliams-ie3ik
@susanwilliams-ie3ik Месяц назад
@@chukwunonsojoshua it's on GitHub labelled CrystalPools
@susanwilliams-ie3ik
@susanwilliams-ie3ik Месяц назад
@@solomonchijioke6148 it's on GitHub
@amazhobner
@amazhobner Год назад
30:50 Relative referencing v/s absolute referencing in columns. 41:33 Unique way of Formatting Column Headers. 45:00 Absolute referencing on row level. 46:13 Conditional Formatting. 54:00 Insert Chart and manipulate it. 1:12:00 Fill large areas while copy pasting. (ctrld+d is the shortcut for "Fill Down" other options are available as well) 1:13:30 SUMIF Function 1:19:30 Pivot Tables 1:31:14 VLOOKUP Function
@joseayala2921
@joseayala2921 Год назад
life saver thanks.
@imaginedragon4595
@imaginedragon4595 10 месяцев назад
Yo
@designhub360customtshirtsa3
@designhub360customtshirtsa3 8 месяцев назад
Thank you!!
@zippianmasese
@zippianmasese 7 месяцев назад
Please l9o
@happiestperson761
@happiestperson761 5 месяцев назад
this comment must be pinned
@JERKINSRICE
@JERKINSRICE 4 месяца назад
I am 15 minutes into the lesson and it's so refreshing to be thought this way with so much ease. What a great teacher you are. Thank you very much.
@agiwilfred6338
@agiwilfred6338 3 месяца назад
Where you able to download the necessary files for the last two lessons?
@fredaakuaamoah1560
@fredaakuaamoah1560 2 месяца назад
@@agiwilfred6338 No i was not able to download it
@srikarsnv7791
@srikarsnv7791 2 месяца назад
@@agiwilfred6338 same problem with me could you please reply to our comments
@Krishna-il8tw
@Krishna-il8tw 2 месяца назад
@@agiwilfred6338 huii
@zeroze6860
@zeroze6860 Год назад
04:20 - Avr, sum, min, max 16:45 - IF formula 29:15 - absolute cell reference (its something with $) 38:47 - something about printing 39:37 - Gradebook 46:05 - conditional formating 49:37 - OR formula 53:00 - Chart 57:24 - Decision maker 01:04:43 - Sales report 01:07:57 - text to columns 01:13:07 - sumif 01:16:04 - sort and filter 01:19:15 - pivot tables 01:23:15 - Car database 01:24:22 - import a text file into excel 01:27:57 - wrap text 01:28:06 - right, mid and left formulas 01:30:07 - Lookup Table 01:33:51 - part 2 of 3? 01:34:28 - mid 01:41:01 - Y2K bug Year 2000 bug 01:45:33 - part 3 of 3 01:46:44 - concatenate formula 01:49:16 - upper 01:56:40 - something 01:57:31 - Problem Solvers
@veecillaangel1523
@veecillaangel1523 Год назад
thank you
@itsavonell
@itsavonell Год назад
goatee
@deepp60
@deepp60 Год назад
@@itsavonell hi avonell, can i learn this tutorial using Excel 2010?
@Unknown-rh5jh
@Unknown-rh5jh Год назад
Difference between $C4 and C$2?
@udaythapar4237
@udaythapar4237 Год назад
@@Unknown-rh5jh $C4 means the Column 'C' is freezed so that the reference value (the value referred to) doesn't change even while other input number changes. C$2 means the Row '2' is freezed so that even if the column value changes the reference value doesn't change. I hope it is easy to understand :)
@parassrivastava5603
@parassrivastava5603 3 года назад
Excel is one of the most used tools in business, engineering, accountancy and many more industries. It helps you organise and manipulate a large amount of data which can be otherwise time-consuming, mundane and difficult to organise. Excel has proven to be a skill that increases your chances of securing a job. It can help you accelerate your career in many different directions such as you can start your journey as a data analyst. If you are in the business sector, it becomes a necessity to learn excel. It helps you manage inventory, human resources and finances. Thanks a lot for sharing such valuable content 😊
@mynameis1880
@mynameis1880 3 года назад
Did you really type all that or did you copy paste from a excel marketing website
@luzperilla7706
@luzperilla7706 3 года назад
Thanks l new in Microsoft ,no body explain like you thanks.
@bayroncastillo7653
@bayroncastillo7653 3 года назад
THATS A GREAT COMMENT MY FRIEND !
@user-ww9we4qj9q
@user-ww9we4qj9q 3 года назад
Toyota Camry, Hyundai Grandeur, KIA Cadenza K8, KIA Quoris K9 platinum 2.5литр куб with optional rear infotainment screens. Range Rover evoque or Velar 2L Lexus ES 250 or Mercedes-Benz E class, BMW Last series. Lexus RX, Lexus LS byu a used car that is just coming off of a 2 or 3 year lease. With Jaguar XF,XE, E-Pace, F-Pace VOLVO S90 2liter cubic Genesis g80 Mercedes-Benz E 53 AMG Tesla model with red, green, purple and several colors. Creed Aventus Versace Dior Sauvage Channel 5 Blue de Chanel Shaik opulent blue no Rolex, tissot, Armani, hublot Buds, Samsung, Apple watch) Apple Macbook pro Laptop , computer, camera) Big and beautiful house. To speak English fluently. Memorize Quran, training))) Become proficient in Full-stack, Video editing, Digital marketing, Copywriting mobilography, photoshop ))) Travel in the world Agriculture, Livestock Cafe, Tractor, Fura, Construction shop, grocery store,poultry farming To be a businessman Open at IT company.
@bayroncastillo7653
@bayroncastillo7653 3 года назад
@@user-ww9we4qj9q whats your point ahahah_
@mistys48
@mistys48 Год назад
I haven't even watched 10 minutes of your presentation and I am astounded at how well you explain the processes! Thank you for helping me learn what I have wanted to learn for a long time!
@Dexcelo
@Dexcelo Год назад
Your explanations are simple and fluid. You have deconstructed all the difficulty myths related to learning Excel. Hats off and thank you!
@pashutamayaya3233
@pashutamayaya3233 2 года назад
Excellent practical course for someone who knows only the very minimal basics, if that. Well modulated and articulated. Designed for adult self learners. Easy to follow and it is a plus that you did not use "techie' language. Your presentation style made it easy to follow without distractions. Real life examples are a plus. Application of knowledge always enhances learning. Looking forward to your next course.
@MsDerrrrrrrrr
@MsDerrrrrrrrr Год назад
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 Год назад
Incredibly helpful video. As a senior in college, none of my classes ever went into a deep dive of how to do basic actions in Excel. I didn't even know half of these features existed until I came across this video. Being thrown into an upper level course where Excel is needed, this video will certainly help me excel ; ) Thanks so much for making this FREE !! 🤩
@shindaratalks7641
@shindaratalks7641 Год назад
😂❤
@casmirmiracle2605
@casmirmiracle2605 4 месяца назад
😂😂
@mohammadshekhu9717
@mohammadshekhu9717 Год назад
teaching style is very simple and effective without bringing lots of things..he is imparting his knowledge to the students and working professionals..
@tomemaster1744
@tomemaster1744 3 года назад
I just wanna say thank you. I've came back each day to do each task and I feel it's really bolstered my skills at using Excel (and Spreadsheets in general).
@remoteworkstuff
@remoteworkstuff 9 месяцев назад
Thank you so much!!! for making this video available. I love how the teaching is not too hard to digest, clear and pretty thorough. I take this course for refreshing memory and also learnt a lot more that I missed to learn in the past. It helps me so much to start my online work journey... means a lot!! Sending my prayers out to you and everyone that makes this video happen/available. Hope all goodness and abundance come back to you guys in from all directions.
@saminda7228
@saminda7228 Год назад
Most logical and very easy-to-understand course content. His way of explaining is incomparable to anyone in his profession, and the topic is covered vividly and never feels bored. I gained so strong knowledge immensely in a tiny time. Hat off to the professor. You're the great teacher to me I ever had in this field, sir. Best wishes for your future tutorials and life as well.
@shreya6115
@shreya6115 Год назад
Hey, follow this guy. He has pivoted into data analyst and has really helpful videos and content. I like the fact he also shares datasets on request ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-axTt_5Zr46M.html
@user-ze7qb9yx4i
@user-ze7qb9yx4i 5 месяцев назад
can you pls share the car inventory file here
@vedantkarale4077
@vedantkarale4077 Год назад
This content is so amazing! Not just for beginners but also works as a quick refresher for people who've worked on excel previously. There's just one thing that I'd like to add which is not related to Excel or programming or analysis but might prove helpful and save some time. ♦Press Ctrl+ to navigate through rows and columns in excel. ♦Use this in combination with the Shift key and the mouse movement could reduced! Although this speed-up is very subjectively perceived yet being a programmer, I like using the keyboard more than the mouse. Hope this helps 😄
@kalondumakau268
@kalondumakau268 3 месяца назад
Sorry, I've tried and it's not working for me. Kindly explain again 😅
@dwightarroyo1784
@dwightarroyo1784 2 года назад
By far the best Excel tutorial I have seen for beginners. Complete, basic, to the point and very useful in real life situations. Great course! Thank you, Shad Sluiter, for sharing!
@nitinbaadkar6741
@nitinbaadkar6741 Год назад
Excel formula: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4CKI_caf3w8.html
@towelamvula4428
@towelamvula4428 3 года назад
Thank you very much for the lessons! I just started learning excel and I already feel like a pro! You have made my learning easier.
@evarosales7930
@evarosales7930 Год назад
You Dear Sir are AMAZING! Thank you so much for this AWESOME tutorial. Everything I know about excel I have learned from videos on youtube. Yours by far has been the absolute BEST!
@user-wg8dd9os5m
@user-wg8dd9os5m 4 месяца назад
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.
@lipingyang8475
@lipingyang8475 2 года назад
The best course for Excel beginner! Very clear and organized instructions with practical examples. Thank you, Shad Sluiter!
@neaworld3960
@neaworld3960 Год назад
Hey there! Have you heard about sin? Basically, it is anything that is wrong that we do to upset God. Sin upsets God because He is Holy. Just like this( Imagine if you saw someone being robbed!) God does not like sin, and Heaven is His God's home. So imagine you are sinning and trying to enter into God's house! What happens is, you WON'T end up in God's House! Basically, you end up in Satan's, the creature who is deceiving souls into going to his house, hell, which will be his permanent residence in a few years, where he wants to take millions of souls including yours! There is no second chance when you get into hell. It is jail, but ain't no bail". And that's why Jesus died. He died in our place, that we might just have a chance at life if we believed in Him. Repent of your sins and believe in Him!.
@ichiroutakashima4503
@ichiroutakashima4503 3 года назад
I remember my first time working in a company, I thought I'd need some special skills or need some experience on using complicated softwares, what's surprising is that even though decades pass, most companies still use Excel (most of them outdated ones) and databases. Two of the most common used softwares.
@tiffanyalston2613
@tiffanyalston2613 Год назад
I have been trying to update myself on access allllllll day! This video was by far the best crash course I have seen it helped me figure out exactly what I need to do. Thank you so much for taking time to create this.
@deborahbowers
@deborahbowers Год назад
Thank you so much for this course. It have probably saved me my job as I had a basic knowledge of Excel, but you have greatly increased my understanding and ability to use the application.
@JohannBaritono
@JohannBaritono 3 года назад
When I thought this channel can't be better than it already is, then you surprise me again. Excellent idea. Looking forward to the advanced course of Excel.
@alexengland9540
@alexengland9540 2 года назад
Does he have an advanced course? Trying to find one.
@riyagoel6197
@riyagoel6197 2 года назад
Let me also know when it comes
@ornobc.h.y2869
@ornobc.h.y2869 Год назад
did you find the excercise file of this video?
@nitinbaadkar6741
@nitinbaadkar6741 Год назад
Excel formula: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4CKI_caf3w8.html
@mckennalynch3476
@mckennalynch3476 Год назад
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.
@navneetsingh2118
@navneetsingh2118 23 дня назад
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.
@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
@dori9027
@dori9027 2 года назад
I need excel for my new work so i searched a lot of tutorials during the past week and they were ok, but this video.. it was THE BEST tutorial so far. simple explanation, detailed and easy to UNDERSTAND, even the timing when you explain and do something is perfect (gives the time to understand, not only how to do it but why is done that way. Really i wanted to say "THANKS for the video, GREAT JOB"!! 👍😊👍 helped me a lot.
@markfrank0924
@markfrank0924 3 года назад
This was an excellent class, well done in organization, methods and process. There are lots of tools out there but this class is better because problems are solved as examples are worked out. In this way it keeps your attention while deepening the learning.
@Moon-gn7dp
@Moon-gn7dp Год назад
Just done three assignments; don't have words to say about this man's way of teaching. wonderful, excellent job sir !
@oluwaseyiadigun8079
@oluwaseyiadigun8079 4 месяца назад
how do we access the assignments please?
@thejoker8471
@thejoker8471 Год назад
Guys I'm gonna say, You'll find many excel tutorials here but trust me this man is an absolute genius. I have tried to learn excel before and forgot everything later. But this here is easy to learn with effective exercises to recall learnings. Best time saving tutorial for beginners who have a little knowledge about excel
@nafisakhanam9530
@nafisakhanam9530 2 года назад
It is undoubtedly the best video for learning excel. Thank you so much for showing every single small details in each section.
@damariceakinyi6845
@damariceakinyi6845 Год назад
Professor, thank you so much for this work. The demostrations were simple, easy to remember and follow!
@Nobleflex101
@Nobleflex101 8 месяцев назад
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.
@imehmbang1903
@imehmbang1903 3 года назад
Thanks so much for this in-depth tutorial, for being so clear and making every moment fun.
@safdarkh786
@safdarkh786 3 года назад
You guys are solving unemployment basically!. I can't thank you enough 😘❤️
@cenoh2381
@cenoh2381 Год назад
Modern Hero! 👏👏👏 . Help this man by not skipping ads!
@dirantechie9411
@dirantechie9411 Год назад
Wow great 6 projects to sharpen my Excel skills. Thanks shadsluiter ♥️♥️
@Dani-tp4wn
@Dani-tp4wn 2 года назад
I'm about 30 minutes in and I gotta admit, you are brilliant at organizing what you want to teach. You've managed to organize even zooming in and out at specific intervals to teach all those small aspects of the program. Really cool! I never knew excel was so intuitive either.
@neaworld3960
@neaworld3960 Год назад
Somebody needs to hear this: Matt 21:37 But as the days of Noah were, so shall also the coming of the Son of man be. 38 For as in the days that were before the flood they were eating and drinking, marrying and giving in marriage, until the day that Noe entered into the ark, 39 And knew not until the flood came, and took them all away; so shall also the coming of the Son of man be. 8 people were saved... THE MILLION-DOLLAR QUESTION: Will you go to Heaven when you die? Have you lied, stolen, used God’s name in vain, or lusted (which Jesus said was adultery, (Matthew 5:28)? If so, God sees you as a liar, thief, blasphemer, and adulterer at heart. If you die in your sins, you will end up in a terrible place called Hell. But there's good news. Though we broke God's Law, Jesus paid the fine by dying on the cross: "God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life" (John. 3:16). Then Jesus rose from the dead and was seen by hundreds of eyewitnesses. He fulfilled all the prophecies of the promised Savior. Please, today, repent and trust Jesus, and God will forgive you and grant you the gift of eternal life (Ephesians. 2:8-9). The ABC's of salvation by JDFarag.org ❤ A-Admit that you are a sinner in need of a savior. 📖Romans 3:10 KJV 10 As it is written, There is none righteous, no, not one: 📖Romans 3:23 KJV 23 For all have sinned, and come short of the glory of God; B- Believe that Jesus is Lord , died for your sins and rose from the dead. 📖Romans 5:8 KJV 8 But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. 📖Romans 6:23 KJV 23 For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. C- Call upon his name. 📖Romans 10:9 KJV 9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 📖Romans 10:13 KJV 13 For whosoever shall call upon the name of the Lord shall be saved
@sponge8406
@sponge8406 5 месяцев назад
I like ur yamato pfp 🏴‍☠️🏴‍☠️ hopefully they become a straw hat lol
@marisolrios5186
@marisolrios5186 2 года назад
My friend redid my resume and put proficient in excel on it even though I am nowhere near that I have no experience at all, so thank you for this 😭♥️
@robinemmons9674
@robinemmons9674 Год назад
Thank you so much for this excellent training. Incredibly efficient and easy to grasp. Your teaching skills are outstanding 👏🏾
@TurnToData
@TurnToData 10 месяцев назад
Absolute gold! This is by far one of the most cleanest and on-point facilitation I've seen. Kudos to Shad Sluiter and the freecodecamp team for publishing this. 👏👏👏👏
@mrCetus
@mrCetus 2 года назад
This is so well done. So clear and meticulous. Love it.
@johnborron1059
@johnborron1059 Год назад
What I like about this is that you are providing multiple instruction at once. I've been learning excel in a sort of linear way (one topic/feature at a time), and this video has used a whole range of useful things (formatting, functions, column manipulation, cell tricks etc) at the same time, which is such a better way to learn this program. Only half an hour in but had to comment because I've learned so much from this video in that half hour. Maybe my prior learning helped.I've had to rewind it a couple of times just to make some things sink in, but this is definitely the most effective learning method I've used so far. This is excellent instruction, Professor Sluiter!
@jamaali3509
@jamaali3509 Год назад
Exactly, you spotted on!
@CollinsK_
@CollinsK_ Год назад
Thank you so much for this, I absolutely loved this video tutorial, and the examples and exercise really covered a lot. The way he explains and carries you along in examples really helped me because I had been panicking a little about learning excel again. Thank you so much P.S for anyone who noticed the formula for miles/year gave double the value of miles you can use this formula for correction =IF(G2=0, H2*0.5, H2/(G2+0.5))
@elenaa9904
@elenaa9904 Год назад
Your RU-vid 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! 🙏🌺🍀
@holbek01
@holbek01 2 года назад
This was a great tutorial. Perfect for beginners or for those who need a refresher course. I have not searched your playlist but you should definitely do one on short keys. Excel is even more efficient of a tool when you do not have to touch the mouse.
@eleanorachieng9044
@eleanorachieng9044 2 года назад
..lm. .m
@wilhellmllw3608
@wilhellmllw3608 3 года назад
Ooh amazing I was just looking for one
@1minuteofmemes
@1minuteofmemes Год назад
The best excel tutor I've ever seen. All in one video, short and sweet and quikl6 understandable. Thank you very much.
@hersh23
@hersh23 Год назад
I'm a first time Excel (hoping to learn the minimum for a job), 12 minutes in and I'm already amazed at what can be done with excel! I legit thought it was just a program for lines and columns and aligning words.
@haroldcjennettiii
@haroldcjennettiii 3 года назад
I have a job interview requiring basic use of Excel. This course was just what I needed! Thank you!
@cesaruribe781
@cesaruribe781 3 года назад
Me too broooooo, This thing helped me so much, even if I find stuff in my future job I didn't see here, I feel so much confident now
@simrangoel9481
@simrangoel9481 3 года назад
Wow two hours ago i was finding videos for beginner and was disappointed that they didn't have one. And voila..it is here..
@cek3800
@cek3800 Год назад
Very interesting and well-explained! Thanks
@chinonsoaluma3553
@chinonsoaluma3553 4 месяца назад
Half way into the class and I am still glued. This is the simplest excel course I have encountered. Very easy to understand Thank you sir!
@obasaoluwafisayomi6753
@obasaoluwafisayomi6753 2 года назад
Thank you so much for this. God bless you. Such a well detailed and explanatory course. I was blown away. 👍👍
@georgekrax
@georgekrax 3 года назад
Really nice course! Literally loved every minute of it, as you explain things very clearly
@neaworld3960
@neaworld3960 Год назад
You need to hear this: Matt 21:37 But as the days of Noah were, so shall also the coming of the Son of man be. 38 For as in the days that were before the flood they were eating and drinking, marrying and giving in marriage, until the day that Noe entered into the ark, 39 And knew not until the flood came, and took them all away; so shall also the coming of the Son of man be. 8 people were saved... THE MILLION-DOLLAR QUESTION: Will you go to Heaven when you die? Have you lied, stolen, used God’s name in vain, or lusted (which Jesus said was adultery, (Matthew 5:28)? If so, God sees you as a liar, thief, blasphemer, and adulterer at heart. If you die in your sins, you will end up in a terrible place called Hell. But there's good news. Though we broke God's Law, Jesus paid the fine by dying on the cross: "God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life" (John. 3:16). Then Jesus rose from the dead and was seen by hundreds of eyewitnesses. He fulfilled all the prophecies of the promised Savior. Please, today, repent and trust Jesus, and God will forgive you and grant you the gift of eternal life (Ephesians. 2:8-9). The ABCs of salvation by JDFarag.org ❤ Admit that you are a sinner in need of a saviour. 📖Romans 3:10 KJV 10 As it is written, There is none righteous, no, not one: 📖Romans 3:23 KJV 23 For all have sinned, and come short of the glory of God; B- Believe that Jesus is Lord, died for your sins and rose from the dead. 📖Romans 5:8 KJV 8 But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. 📖Romans 6:23 KJV 23 For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. C- Call upon his name. 📖Romans 10:9 KJV 9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 📖Romans 10:13 KJV 13 For whosoever shall call upon the name of the Lord shall be saved God loves you!!!!!
@oluebubeokeke1207
@oluebubeokeke1207 5 дней назад
Your tutorial got me glued.... Professorship, well deserved 👏
@wigglesft1574
@wigglesft1574 Год назад
Thank you for this. As an IT student at university, I was embarrassed by my lack of skills with Office applications, especially Excel. I now look halfway competent at least!
@myusername6622
@myusername6622 3 года назад
It’s almost as if you guys read my search history. Every-time I think of a topic, you guys make a video about it! Love it!
@naufalharits8259
@naufalharits8259 3 года назад
true 😂
@raky1989
@raky1989 3 года назад
Dude, can you review the video? I mean does the 2hr video is enough for excel course?
@iroar5982
@iroar5982 3 года назад
@@raky1989 title clearly say for beginners.
@raky1989
@raky1989 3 года назад
@@iroar5982 there are many tutorials with 3-4.5 hrs.
@melaniethurman386
@melaniethurman386 2 года назад
Just got a promotion that would include using excel! I was really good with it years back but haven’t used it in close to 10 years. This is such a great video to refresh my memory and prepare me for this new chapter in my life. THANK YOU! This is honestly so detailed, you’re a great teacher!
@adelegreen391
@adelegreen391 Год назад
all the best for the future 🎉😊
@AMP_PLUS
@AMP_PLUS Год назад
@@adelegreen391 hey adele green are you single? im interested
@firelordzuko345
@firelordzuko345 Год назад
Good luck with your promotion.
@neaworld3960
@neaworld3960 Год назад
You need to hear this: Matt 21:37 But as the days of Noah were, so shall also the coming of the Son of man be. 38 For as in the days that were before the flood they were eating and drinking, marrying and giving in marriage, until the day that Noe entered into the ark, 39 And knew not until the flood came, and took them all away; so shall also the coming of the Son of man be. 8 people were saved... THE MILLION-DOLLAR QUESTION: Will you go to Heaven when you die? Have you lied, stolen, used God’s name in vain, or lusted (which Jesus said was adultery, (Matthew 5:28)? If so, God sees you as a liar, thief, blasphemer, and adulterer at heart. If you die in your sins, you will end up in a terrible place called Hell. But there's good news. Though we broke God's Law, Jesus paid the fine by dying on the cross: "God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life" (John. 3:16). Then Jesus rose from the dead and was seen by hundreds of eyewitnesses. He fulfilled all the prophecies of the promised Savior. Please, today, repent and trust Jesus, and God will forgive you and grant you the gift of eternal life (Ephesians. 2:8-9). The ABCs of salvation by JDFarag.org ❤ Admit that you are a sinner in need of a saviour. 📖Romans 3:10 KJV 10 As it is written, There is none righteous, no, not one: 📖Romans 3:23 KJV 23 For all have sinned, and come short of the glory of God; B- Believe that Jesus is Lord, died for your sins and rose from the dead. 📖Romans 5:8 KJV 8 But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. 📖Romans 6:23 KJV 23 For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. C- Call upon his name. 📖Romans 10:9 KJV 9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 📖Romans 10:13 KJV 13 For whosoever shall call upon the name of the Lord shall be saved God loves you bro. don't commit suicide
@wilda2199
@wilda2199 Год назад
Please How did you download the car inventory file?
@imiruku5118
@imiruku5118 Год назад
1) I wanted to say this is a really good darn video. Easy to follow, you can pause it whenever you want to mimic what's on the screen so that you fully understand, and then once you do; you can pause the rest of the video during the sections of inputting more data, then creating the formulas; repetition is key and once you've got that groove, you don't have to watch parts of the video, you can get it done before he does, and then watch him do it afterwards before moving on. 2) During this video, I know it's targeted towards Microsoft's Excel Spreadsheets, but during the beginning and end of this video and going forward in life with my Spreadsheet education, I've been using WPS Suite, which is only $40 for a whole year. The formulas, navigation of the buttons, formatting, etc; are all quite identical to Microsoft Excel, in WPS Suite, just an FYI. I've been able to follow the video so far 100% using WPS Suite and they're using Microsoft Excel.
@adriananunez7536
@adriananunez7536 Год назад
Thanks a lot for sharing all this knowledge. Great course!
@mandandi
@mandandi 2 года назад
Thanks Shad for the course. Impressive stuff. I started it today and hope to complete it in 2 days! I have worked with Excel for many years, but not for data analysis. I cant wait to update the Excel proficiency part of my CV after completing this.
@neaworld3960
@neaworld3960 Год назад
You need to hear this: Matt 21:37 But as the days of Noah were, so shall also the coming of the Son of man be. 38 For as in the days that were before the flood they were eating and drinking, marrying and giving in marriage, until the day that Noe entered into the ark, 39 And knew not until the flood came, and took them all away; so shall also the coming of the Son of man be. 8 people were saved... THE MILLION-DOLLAR QUESTION: Will you go to Heaven when you die? Have you lied, stolen, used God’s name in vain, or lusted (which Jesus said was adultery, (Matthew 5:28)? If so, God sees you as a liar, thief, blasphemer, and adulterer at heart. If you die in your sins, you will end up in a terrible place called Hell. But there's good news. Though we broke God's Law, Jesus paid the fine by dying on the cross: "God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life" (John. 3:16). Then Jesus rose from the dead and was seen by hundreds of eyewitnesses. He fulfilled all the prophecies of the promised Savior. Please, today, repent and trust Jesus, and God will forgive you and grant you the gift of eternal life (Ephesians. 2:8-9). The ABCs of salvation by JDFarag.org ❤ Admit that you are a sinner in need of a saviour. 📖Romans 3:10 KJV 10 As it is written, There is none righteous, no, not one: 📖Romans 3:23 KJV 23 For all have sinned, and come short of the glory of God; B- Believe that Jesus is Lord, died for your sins and rose from the dead. 📖Romans 5:8 KJV 8 But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. 📖Romans 6:23 KJV 23 For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. C- Call upon his name. 📖Romans 10:9 KJV 9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 📖Romans 10:13 KJV 13 For whosoever shall call upon the name of the Lord shall be saved
@shy4real
@shy4real Год назад
this man will be my steppingstone into becoming a data analyst someday, thank you sir
@priscillaemiator9296
@priscillaemiator9296 Год назад
Please where you able to download the spreadsheet for Sales database?
@frhadlizad2013
@frhadlizad2013 3 месяца назад
did you become data analyst??????????????????????????????????????????????????
@happylucky7590
@happylucky7590 2 месяца назад
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!
@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.
@jordynmarburger1016
@jordynmarburger1016 2 года назад
I LOVE how you incorporated real life projects to show us how to do this. Thank you!
@zinebrouma952
@zinebrouma952 2 года назад
hi, can I ask you a question ???
@ahmedbenlarbi2348
@ahmedbenlarbi2348 2 года назад
@@zinebrouma952 go ahead ,ask your question if you don t mind .
@ahmedbenlarbi2348
@ahmedbenlarbi2348 2 года назад
@@zinebrouma952 go ahead ,ask your question if you don t mind .
@zinebrouma952
@zinebrouma952 2 года назад
@@ahmedbenlarbi2348 thank you , in 1:05:13 this teacher said that we have to download something for I thing web site but when I search I found nothing can please tell how I can download this data base please ?
@chiamakanwaa
@chiamakanwaa Год назад
@@zinebrouma952 please were you able to find out how to download the document?
@clintonmkadinali3821
@clintonmkadinali3821 2 месяца назад
THANKS FOR THE FREE COURSE TUTORIAL, GOD BLESS YOU !
@c0ry357
@c0ry357 Год назад
Thank you for this course, very well structured and informative. I completed the whole thing in a day, great stuff.
@r1tw1ck46
@r1tw1ck46 Год назад
Thank you for this very easy to understand and amazing course Sir.
@MK-zf6or
@MK-zf6or 2 года назад
This guy really taught us so much in 2 hours, thanks Shad
@geraldeneadendorff6627
@geraldeneadendorff6627 Год назад
Thank you for this course. I finished it today and really enjoyed the problem solvers especially. My head is full of formulas but I actually like Microsoft excel after this 😉 Now I just need to practice 💪 Well done on this great course. Regards from South Africa.
@TheDriftak
@TheDriftak Год назад
1:23:32 Timestamp n1 1:58:31 Timestamp n2 Tutorial done Thank you for this helpful video. You taught me well !
@katieparkyn355
@katieparkyn355 3 года назад
Thank you so much for this great tutorial. I have done lots of Excel courses in class and online and this is the best by far. The yellow pointer makes it so much easier to follow A+
@Fact_video-
@Fact_video- 3 года назад
Hii
@obitouchiha8087
@obitouchiha8087 2 года назад
I wanna ask a question . It means i don't need to go private institutions and do you need any certificate for jobs or you can just put in your resume ?
@spazworrier
@spazworrier 2 года назад
I learned more about excel in this video than I ever did in school! Thank you so much for this!
@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
@jacobpickos733
@jacobpickos733 7 месяцев назад
I'm five minutes in and the vibes are on point. Love this guy's attitude! Thanks for the tips and tricks!
@yeseniadiaz5146
@yeseniadiaz5146 2 года назад
Motivated to learning and being able to exceed in excell thank you 🥰 i am taking it a course at a time so this might take longer but i am happy to say I've learned the first part ( payroll) how fun ! Thank u for taking the time to create a video like this
@neaworld3960
@neaworld3960 Год назад
Hey there! Have you heard about sin? Basically, it is anything that is wrong that we do to upset God. Sin upsets God because He is Holy. Just like this( Imagine if you saw someone being robbed!) God does not like sin, and Heaven is His God's home. So imagine you are sinning and trying to enter into God's house! What happens is, you OWN'T end up in God's House! Basically, you end up in Satan's, the creature who is decieving souls into going to his house, hell, which will be his permanent residence in a few years, where he wants to take millions of souls including yours! There is no second chance when you gte into hell. It is jail, but aint no bail". And that's why Jesus died. He died in our place, that we might just have a chance at life if we believed in Him. Repent of your sins and believe in Him!.
@yrn_mya
@yrn_mya 2 года назад
High school senior trying to secure my future in product management for tech companies, I thought excel was simple like Microsoft word but I was wrong😭
@MoReal2
@MoReal2 2 года назад
If tou think Word is simple, you have no idea what you can do with it.
@vipulbhatia3562
@vipulbhatia3562 2 года назад
Trust me! Its simple.
@priyal7244
@priyal7244 2 года назад
Hey mya what you have done to become product management. If you can give me brief introduction of that field i wanna know
@user-od4zs8qr3j
@user-od4zs8qr3j 2 года назад
❤❤❤❤❤❤❤❤❤❤🎉😊
@Nick-pd2yo
@Nick-pd2yo 2 года назад
U got it
@lucasrosielle604
@lucasrosielle604 Год назад
Tip for inserting loads of sample Numbers such as the rate or the hours worked, use rand.between(bottom;upper). This way you dont need to insert loads of individual cells
@shahtajp4379
@shahtajp4379 6 месяцев назад
It’s marvelous. Really a genuine teacher whose concepts are cleanse and delivering the best. I highly appreciate and recommend.
@redhood255
@redhood255 3 года назад
Exactly what we Need 🔥🔥❤️
@dadsownchannel3729
@dadsownchannel3729 2 года назад
This is definitely a great way to connect with individuals wanting to learn EXCEL. You have truly made is easier and simplified the whole process so everyone understands clearly. Thank you{
@bosunolawore7406
@bosunolawore7406 Год назад
I thought I knew Excel, until I got here i know am just a beginner. Thank you Prof. Sluiter for simplifying this lecture. Its a good way to learn. Many thanks. I appreciate your sir.
@mohammedalmahdidewan8188
@mohammedalmahdidewan8188 Год назад
Lots of love to you for making an effortless and effective tutorial for excel learners. made my learning is way better.
@anthonynotarnicola1272
@anthonynotarnicola1272 2 года назад
Trent Mann is a baller. I want the full lore of this legend.
@deekki
@deekki 2 года назад
Bruh Genesis worked 80 hours, a real grinder.
@Samuelhgflax
@Samuelhgflax 2 года назад
Financial Skills Test?? 69 😎
@Samuelhgflax
@Samuelhgflax 2 года назад
@@deekki Trent said work smarter not harder (also his dad is the CEO)
@michaelyizhaoliu8423
@michaelyizhaoliu8423 10 месяцев назад
Shad, you are an excellent instructor. Thank you for the training.
@abundance2469
@abundance2469 3 месяца назад
For the very first time in a year plus I finally completed this course without skipping any work within 3days 🎉❤ unto Excel Project
@simpleexcelexamples9619
@simpleexcelexamples9619 2 года назад
WOW your way of teaching is very clear! Also beautiful realistic cases you work with! Thanks for the video which gave me inspiration for my own classes (I give Excel training to students) 😊
@casandragenas2886
@casandragenas2886 2 года назад
Sir I really like the way you deliver your content.Thank you for these lessons
@neaworld3960
@neaworld3960 Год назад
You need to hear this: Matt 21:37 But as the days of Noah were, so shall also the coming of the Son of man be. 38 For as in the days that were before the flood they were eating and drinking, marrying and giving in marriage, until the day that Noe entered into the ark, 39 And knew not until the flood came, and took them all away; so shall also the coming of the Son of man be. 8 people were saved... THE MILLION-DOLLAR QUESTION: Will you go to Heaven when you die? Have you lied, stolen, used God’s name in vain, or lusted (which Jesus said was adultery, (Matthew 5:28)? If so, God sees you as a liar, thief, blasphemer, and adulterer at heart. If you die in your sins, you will end up in a terrible place called Hell. But there's good news. Though we broke God's Law, Jesus paid the fine by dying on the cross: "God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life" (John. 3:16). Then Jesus rose from the dead and was seen by hundreds of eyewitnesses. He fulfilled all the prophecies of the promised Savior. Please, today, repent and trust Jesus, and God will forgive you and grant you the gift of eternal life (Ephesians. 2:8-9). The ABCs of salvation by JDFarag.org ❤ Admit that you are a sinner in need of a saviour. 📖Romans 3:10 KJV 10 As it is written, There is none righteous, no, not one: 📖Romans 3:23 KJV 23 For all have sinned, and come short of the glory of God; B- Believe that Jesus is Lord, died for your sins and rose from the dead. 📖Romans 5:8 KJV 8 But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. 📖Romans 6:23 KJV 23 For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. C- Call upon his name. 📖Romans 10:9 KJV 9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 📖Romans 10:13 KJV 13 For whosoever shall call upon the name of the Lord shall be saved
@cesaruribe781
@cesaruribe781 3 года назад
Just wanna say thank you because, even if I come across things I didn't see here I feel so much confident now when using Excel, THANK YOU
@wesleywesolowski3236
@wesleywesolowski3236 10 дней назад
Awesome course I haven't taken a computer since my days at NORQUEST COLLEGE IN 2007 and this course best i have seen on excel and i have other video that helpful for the basic but this one is now my favorite and this will be helpful to get me possibility of going higher in my company i work for as cook and more. THANK YOU
@behappythewayyouare
@behappythewayyouare Год назад
You are a very good professor. Explained in a simple way 👏👏 keep up the good work👍
@rulzsimplice7335
@rulzsimplice7335 3 года назад
This channel is literally the 🐐! All love ❤️
@justicesaid9654
@justicesaid9654 2 года назад
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!.
@sexyneszy2010
@sexyneszy2010 Год назад
I love this course and the way you teach it, very easy to grasp and simplified. Thank you for this video. I needed it.
@neaworld3960
@neaworld3960 Год назад
Hey there! Have you heard about sin? Basically, it is anything that is wrong that we do to upset God. Sin upsets God because He is Holy. Just like this( Imagine if you saw someone being robbed!) God does not like sin, and Heaven is His God's home. So imagine you are sinning and trying to enter into God's house! What happens is, you OWN'T end up in God's House! Basically, you end up in Satan's, the creature who is decieving souls into going to his house, hell, which will be his permanent residence in a few years, where he wants to take millions of souls including yours! There is no second chance when you gte into hell. It is jail, but aint no bail". And that's why Jesus died. He died in our place, that we might just have a chance at life if we believed in Him. Repent of your sins and believe in Him!.
@ARUNSNEGI
@ARUNSNEGI Год назад
That's just awesome❤️
@bobtop4689
@bobtop4689 3 года назад
Just what I needed
@karanprajapati4686
@karanprajapati4686 3 года назад
Yesterday, I was searching for an Excel tutorial, downloaded Edureka's Excel course and today got it on my favourite channel.
@abhisekgupta1543
@abhisekgupta1543 3 года назад
Which one was worth the time...before I start on any one of the two...
@karanprajapati4686
@karanprajapati4686 3 года назад
@@abhisekgupta1543 FCC
@stiernonhorimbere2688
@stiernonhorimbere2688 3 месяца назад
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
Далее
Excel for Beginners - The Complete Course
54:55
Просмотров 4,7 млн
Can You Pass This Excel Interview Test?
11:20
Просмотров 772 тыс.
КАХА и Джин 2
00:36
Просмотров 1,8 млн
Bir mazza qilib ursin dedimda 😂😂
00:46
Просмотров 1,4 млн
EASILY Make an Automated Data Entry Form in Excel
14:52
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Просмотров 651 тыс.
How I would learn to code (If I could start over)
9:16
Google Sheets - Full Course
3:03:32
Просмотров 1,6 млн
Microsoft Excel Tutorial -  Beginners Level 1
32:49
Просмотров 12 млн
Top 10 Most Important Excel Formulas - Made Easy!
27:19