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.
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 😊
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.
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
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
@@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 :)
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
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.
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
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 !! 🤩
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 😄
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.
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.
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!
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!
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
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.
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!
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!.
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.
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!
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
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.
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!
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!
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.
@@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.
I was looking for a full in depth excel course and i stumbled upon this video , well i was lucky enough to click this video over other video's . This man explains each and every thing meticulously and explain every thing that needed to be explained in excel for the beginner's .
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!
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.
@@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 ?
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.
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 😊
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.
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.
@@Benjaminpro55 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?
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).
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!
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. 👏👏👏👏
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.
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!.
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
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+
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 ?
You are brilliant Professor kudos to you. You have made me to realize that Excel is also a database on it's own. Perfect tutor have ever seen. Greeting you from Zambia Southern Africa.
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))
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.
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.
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.)
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!.
Hello, I see you just finished the course, were you able to download the sales report spread? Can't find it on his github, will appreciate your help thanks
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.
thank you so much,, I watched this tutorial when i was a 1.1 at the university,, and it made me one of the beststudents on my internship propgramme... Thank you so much
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.
Ooj ononjI o onoo
Can't agree more!
Yes ! Absolutely 💯
Absolutely 👏👏👏👏👏👏 and im so excited to learn too.
Just wonderful... thank you!
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 😊
Did you really type all that or did you copy paste from a excel marketing website
Thanks l new in Microsoft ,no body explain like you thanks.
THATS A GREAT COMMENT MY FRIEND !
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.
@@НурдаулетКолбай-ч5ц whats your point ahahah_
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.
Where you able to download the necessary files for the last two lessons?
@@agiwilfred6338 No i was not able to download it
@@agiwilfred6338 same problem with me could you please reply to our comments
@@agiwilfred6338 huii
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
Is it still worthy to learn Excel in 2024?
Please how did you download the file for the sales database
Where is car inventory file 😢😢
@@chukwunonsojoshua it's on GitHub labelled CrystalPools
@@solomonchijioke6148 it's on GitHub
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
life saver thanks.
Yo
Thank you!!
Please l9o
this comment must be pinned
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
thank you
goatee
@@itsavonell hi avonell, can i learn this tutorial using Excel 2010?
Difference between $C4 and C$2?
@@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 :)
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
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.
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
can you pls share the car inventory file here
Thank you for sharing this for free. It is equivalent to paid courses online. Please continue to help other people by uploading free videos.
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 !! 🤩
😂❤
😂😂
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 😄
Sorry, I've tried and it's not working for me.
Kindly explain again 😅
If I see you in person, I wanna shake your hand and show my respect to you. What a legend this guy!
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.
hey, how is your job search going
Thumbs up to the creators and the moderator of this video. I have been exposed to a lot of knowledge. Thank y'all so much.
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.
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!
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!
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.
Swears
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
teaching style is very simple and effective without bringing lots of things..he is imparting his knowledge to the students and working professionals..
Just done three assignments; don't have words to say about this man's way of teaching.
wonderful, excellent job sir !
how do we access the assignments please?
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.
Your explanations are simple and fluid. You have deconstructed all the difficulty myths related to learning Excel. Hats off and thank you!
gone through 1 hour till now. Very well no unnecessary explanation. To the point good explanation.
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!
Excel formula: ruclips.net/video/4CKI_caf3w8/видео.html
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.
The best course for Excel beginner! Very clear and organized instructions with practical examples. Thank you, Shad Sluiter!
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!.
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!
Modern Hero! 👏👏👏 . Help this man by not skipping ads!
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.
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 😂
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!
all the best for the future 🎉😊
@@adelegreen391 hey adele green are you single? im interested
Good luck with your promotion.
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
Please How did you download the car inventory file?
You guys are solving unemployment basically!. I can't thank you enough 😘❤️
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.
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!
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!
Exactly, you spotted on!
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.
I have a job interview requiring basic use of Excel. This course was just what I needed! Thank you!
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
U got the job?
@@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.
How do I say thank you to satisfy how grateful and thankful I am? Words cant express. We love you so much. Life saver
I was looking for a full in depth excel course and i stumbled upon this video , well i was lucky enough to click this video over other video's . This man explains each and every thing meticulously and explain every thing that needed to be explained in excel for the beginner's .
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!
you did complete it in 5 days?
0k
i finished in 1 lmao noob
@@olaaff6922 gago
Yes, it took me about the same time. Good job 👏
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!
true 😂
Dude, can you review the video? I mean does the 2hr video is enough for excel course?
@@raky1989 title clearly say for beginners.
@@iroar5982 there are many tutorials with 3-4.5 hrs.
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 😭♥️
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
I'm five minutes in and the vibes are on point. Love this guy's attitude! Thanks for the tips and tricks!
Yesterday, I was searching for an Excel tutorial, downloaded Edureka's Excel course and today got it on my favourite channel.
Which one was worth the time...before I start on any one of the two...
@@abhisekgupta1543 FCC
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.
Does he have an advanced course? Trying to find one.
Let me also know when it comes
did you find the excercise file of this video?
Excel formula: ruclips.net/video/4CKI_caf3w8/видео.html
this man will be my steppingstone into becoming a data analyst someday, thank you sir
Please where you able to download the spreadsheet for Sales database?
did you become data analyst??????????????????????????????????????????????????
1:23:32 Timestamp n1
1:58:31 Timestamp n2
Tutorial done
Thank you for this helpful video. You taught me well !
This is the best Microsoft Excel tutorial i have seen.
I LOVE how you incorporated real life projects to show us how to do this. Thank you!
hi, can I ask you a question ???
@@zinebrouma952 go ahead ,ask your question if you don t mind .
@@zinebrouma952 go ahead ,ask your question if you don t mind .
@@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 ?
@@zinebrouma952 please were you able to find out how to download the document?
Wow two hours ago i was finding videos for beginner and was disappointed that they didn't have one. And voila..it is here..
I lied on a job interview that I know excel and got the job so now i'm here thank you
I lied too. But then they take an excel test over there. Which I couldn't do. So, NOW i am here.
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.
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 😊
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.
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.
Thanks a lot for the video! Btw how can I get an Excel product key for a good price?
There are a lot of options to get Excel.. After a dip research I found a great company.
@@Benjaminpro55 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?
@@Juan888j haha yeah, BNH-Software. I hope its will help you :)
@@Benjaminpro55 Thanks! Bought Office 2021 and activated my Excel Working perfectly.
I can install it for 250
For the very first time in a year plus I finally completed this course without skipping any work within 3days 🎉❤ unto Excel Project
Give this man A MEDAL, HE DESERVES ITT;
and a new microphone, we deserve it.
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).
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!
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. 👏👏👏👏
It’s marvelous. Really a genuine teacher whose concepts are cleanse and delivering the best. I highly appreciate and recommend.
The best course for Excel beginner! Professor you're the best teacher thank you so much..👏👏👏
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.
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
Thanks a lot. Did practically after each part. Easy, understandable, and very helpful.
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!.
I thought I was an expert in Excel but am seeing I was less than Basic. Thanks. I will now enroll for the next lesson. You are the Best!
Finally someone who can teach in a very easy way!!! Thank you!!!
Woow great never knew that excel has all functions we put into coding for programs. Thanks very much
Yeah! I always teach my students Excel first then programming languages.
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.
This channel is literally the 🐐!
All love ❤️
I must say this course is superb . When learning meets simplicity and talent .
Really it is one of the impressive free course which is available on youtube , salute from my side
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
Professor, thank you so much for this work. The demostrations were simple, easy to remember and follow!
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+
Hii
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 ?
You are brilliant Professor kudos to you. You have made me to realize that Excel is also a database on it's own. Perfect tutor have ever seen. Greeting you from Zambia Southern Africa.
This is absolute gold. So well explained, and covers a lot of things in just a couple of hours. Thank you!
Hi, I see that you took the course recently, were you able to find and download the sales report spreadsheet? Can't find it on his github
THANKS FOR THE FREE COURSE TUTORIAL, GOD BLESS YOU !
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))
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.
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.
Thanks Prof. Shad Sluiter. I am able to do much things excels because of you.
Hope to learn more from you!
Plz continue this series... please upload intermediate level
This guy really taught us so much in 2 hours, thanks Shad
It is undoubtedly the best video for learning excel. Thank you so much for showing every single small details in each section.
Thankyou so much... I have learned so much from your tutorial..
GOD BLESS YOU for sharing with the world.
🙏🙏
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.)
The thing I loved (apart from the video of course) is that he was using Windows 7 in 2020 💖
This is so well done. So clear and meticulous. Love it.
Yes, it's interesting and making of convulsing in hearts and mind by addicting and including the fun and interest in it.
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!.
Trent Mann is a baller.
I want the full lore of this legend.
Bruh Genesis worked 80 hours, a real grinder.
Financial Skills Test?? 69 😎
@@deekki Trent said work smarter not harder (also his dad is the CEO)
Now, I can justify my certificate in excel. This is incredible lecture. Thank you, Sir.
Amazing, after working of 10+ years today i cleared so many doubts. thanks
Hello, I see you just finished the course, were you able to download the sales report spread? Can't find it on his github, will appreciate your help thanks
Wow great 6 projects to sharpen my Excel skills. Thanks shadsluiter ♥️♥️
I just completed this course! This was great!! Thank you!
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.
thank you so much,, I watched this tutorial when i was a 1.1 at the university,, and it made me one of the beststudents on my internship propgramme... Thank you so much
One of the best teachers I have ever had, seriously
Ooh amazing I was just looking for one