I watched this tutorial before an interview and I was able to discuss my Excel skills and got the job. Now I use Excel in my role daily and those tips and tricks have helped me. Thank you so much Debs, this is by far the best tutorial on Excel I have seen on UA-cam.
That's an amazing story! Thanks so much for sharing. Congratulation on your new job! We'd love to hear more - please drop us an email at support@simonsezit.com.
Congrats! I'm on an interview tomorrow and doing this for the same reason:) I have always used it but very superficially. Fingers crossed:) Amazing videos: thank you!
I want to give a shout-out to the instructor, Ms. Deb. I have never enjoyed learning Excel as I did with her. She has a unique way of simplifying things and getting to the point quickly. Very well done. I wish she were my college instructor.
Thank you so much for your kind words! We're glad you enjoyed learning Excel with Ms. Deb. She's truly an amazing instructor. 😊 We have lots of additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
The US version of BODMAS is PEMDAS which stands for P: Parenthesis E: Exponents M: Multiplication D: Division A: Addition S: Subtraction multiplication and division are calculated depending on which comes first when reading an equation from the left, and then the same for addition and subtraction. Hope this helps anyone from the US who didn't know what the instructor was talking about with BODMAS or PIDMAS
Brings me back to my algebra class. Our teacher always taught us "Please Excuse My Dear Aunt Sally" - Parenthesis, Exponents, Multiplication, Division, Addition, and Subtraction.
I lied in my resume about being awesome with excel. I got the job and now I have 2 weeks to learn everything about excel. At least I got the job though.
Today is my first day learning on your channel but I am so impressed with your teaching. All I have to say to you is that your instructions about Excel is totally awesome and impressive. Kindly continue to bring up more programs like this. There are many who are willing to learn but the tuition and fees for learning is not available. Your program has inspired me a lot. I am hoping to learning more from you. Your channel from today going forward, will be my best friend.
Hey there! Thanks a ton for your kind words and support. It's awesome to hear that my Excel tutorials have impressed you on your first day. Don't worry, I've got plenty more programs in store for you, so please check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Glad to help! 😊 We have lots of additional Excel training if you need it ➡️ ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here ➡️ ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here ➡️ ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
I can't stop watching this video. it's very Educative and powerful presentation I have ever watched or seen. The step by step tutorial can help a beginner to learn excel without any instructor. Thanks to all the team for putting such pieces together.
I want to take a moment to thank you for the effort, you have chosen to teach us very beneficial skills for free! Thank you so much! I wish you all the best in your life!
Best way of teaching excel from scratch. Helped me a lot as I wasn't familiar with many functions. Thank you Simon Sez and Deb for your time it was super helpful☺
Thank you for your kind words! I'm glad you find the content valuable and that it's making a positive impact on the world. It means a lot to us.😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Wow, thanks a lot 😊 We have lots of additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Awesome to hear you found it helpful! Thanks for the support! 😊 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thank you, Deb! I've been a tutor for 15 years and have no patience for the intolerable instruction in most excel tutorials. This is how training is done!! Excellent.
Hey, thanks a ton! I'm thrilled to hear that my tutorial hit the mark for you. It means a lot, especially coming from an experienced tutor like yourself. Keep rocking it 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Tremendous course and excellent narration. Really helped me take things to the next level. Highly superior to many other more popular excel courses. Thank you taking the time to create this masterpiece.
I did excel a while ago and I hated it but it's never going away so decided to watch this video and i am really liking what i see you just make things easy for us
Thank you so much for your kind words! I'm glad you found the seminar helpful. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Best best beesssssssssssssst!!!!!! The fact that during the lesson we review and repeat some functions such as trim, proper ,... make it stand out from all other videos on Excel , Thank youuu 😍
Hey there! Thanks for the awesome comment! I'm glad you enjoyed it 😊 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Wow! I can't thank you enough for creating this incredible resource. Your generosity and expertise are invaluable, and I'm incredibly grateful for all the effort you put into this course🙌 Keep up the fantastic work. You're a true gem in the world of online education🌟
A HUGE congrats, 💪 😊 Not many viewers complete our multi-hour long videos, so to finish the entire 5 hours is a great accomplishment! 🔥If you need more training like this, please check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
I'm glad you found the tutorial helpful! You're welcome and thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Extremely clear, helpful, and useful for professionals. I did excel projects in college and haven't used it in over 5 years. This was perfect! Thank you very much.
You're very welcome, crazybeartimba! We have additional free Excel training if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
I have been creating the tables from scratch lol I did not notice the files were available for download in the description until now one hour into the course !!! I guess I got a little extra practice...
Wow, thanks a lot 😊 We have lots of additional Excel training if you need it. Here -> ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here -> ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Wow, thanks! Glad you enjoyed it 🤩 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
All we need is classes and tutorials like this and give a public exam. Universities are redundant, just made to rob people money in the name of education and leaving students in huge debts , popularly known as student loans. Of course politicians are not going to do anything because they get a share of the money somehow. Unless people challenge the status quo this robbing will continue. After taking this kind of money many professors are not even willing to teach properly. Just gives assignment, no where to turn to when you are faced with a doubt. Most students depend on You Tube to get the knowledge. Then what is the need for Universities!!!!!!!
You're very welcome Abhishek 😊 We have lots of additional free Excel training if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
You are the goddess of education. Oldest Hindu scripture Rig Veda says imparting education , Knowledge is the best form of charity. So nice teaching by you. It is really such a hard work. Though I learnt Excel in many Computer institutes but always felt dissatisfied and was really helpless in my workplace while working with Excel.
✅Download the Free Instructor Files to follow along the course here ► www.simonsezit.com/the-ultimate-excel-tutorial-instructor-files/ If the link doesn't work, please try another web browser or try clearing your browser cache. 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
I've been trying to learn Excel for the last 3 years but have struggled to both engage and wrap my head around it. Not to mention retaining what I've learned. I've gone through a lot of videos online, then saw this one appear and thought "5 hours? I could never" so I avoided it. Of course, I understand that all the other trainings I've attempted probably add up to around the same time, but seeing a 5 hour video is intimidating. However, it's not the length of time that's the issue. It's the delivery mechanism, and honestly, I'm only 30 minutes into this video and I don't feel like a fool for the first time in my attempts to learn to properly use Excel. The structure simply teaches you something in 30 seconds, reaffirms it, and moves on. And what's better is everything I learned in the first few minutes are used and reused, so I ended up learning it and actually storing it in my brain, so when I needed it again, I used it almost without thinking about it. For some reason my brain just remembers where I would have been stuck before. Yes, I'm only 30 minutes in, but if those 30 minutes are anything to go by, Excel would make sense to so many people if they simply gave this intimidating 5 hour video a real chance. Considerations: Do not try to watch this video in the almost 6 hours that it is. Break it up. Take breaks. Let your mind rest. You'll get there if you keep coming back. Have a 2nd screen (NOT YOUR MOBILE) to hand. That way you can watch the video and work on the Excel sheets without having to switch. Anyway, Thank you so much to the Simon Sez IT team. Time for me to get back to it.
Thank you for sharing your experience! I'm thrilled to hear that this tutorial is making a difference for you. Breaking the video into manageable chunks and using a second screen are great tips. Keep at it, and soon, Excel will become second nature. Good luck with your learning journey! 🤩
I can't find the Pivot Tables Excel Tutorial file in the ones that were provided, please can you direct me where to get it if it's available. Between this an excellent learning tool, kudos 👍
This is a great video course, although the vid quality was a little messed up so things were blurry and choppy. Still able to follow though. Seems like it may have been recorded from a stream so there are lots of audio hiccups and visual hiccups.
We have a number of expert/advanced Excel training videos in our "long video" playlist. Check it out here: ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thanks guys for the amazing tutorial, it was quite easy to get along with. Although I'm stuck and will be needing a little assistance. In the combining functions sheet, I am trying to copy a function down a column but keep getting the same result that's in the first cell. In this case, Claire was what filled the entire column dropdown instead.
Thank you for your kind words! I'm so glad the tutorial was useful to you. 😊 🔥Please check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you so much! I thought excel was going to be the same as google sheets but I had so much trouble switching over easily so this was such a helpful video! Also in the US, I don't know about now, but when I was in middle school 10 years ago we learned PEMDAS (or GEMDAS) and were told to think of Please Excuse My Dear Aunt Sally to remember PEMDAS. My partner who grew up on the other side of the country had this experience as well
Glad you enjoyed it. Thanks for watching! 🙂 We have a lot more courses on MS Office and other topics, with 300+ hours of free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
You're very welcome. Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Thanks for the nice comments, Kristina Bogatinova 😊 There's additional Excel training here if you need it -> ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Great in depth video. The only negative I would have is the video is choppy at some points but luckily Deb is very clear and I had no troubles following. Much more confident at using excel now and will point anyone needing any help to this video. I will now go check out more from your channel. Thank you very much!
Not even half an hour in and already learned so much! (In the US, it's PEMDAS: Parenthesis, Exponents, Multiplication & Division, Addition & Subtraction) You were close! :D
Thank you Charles, appreciate your comments! Here are some additional Excel tutorials that may be helpful -> ua-cam.com/video/oN82Umc9MCQ/v-deo.html & ua-cam.com/video/PlPgYOFJROI/v-deo.html
I watched this tutorial before an interview and I was able to discuss my Excel skills and got the job. Now I use Excel in my role daily and those tips and tricks have helped me. Thank you so much Debs, this is by far the best tutorial on Excel I have seen on UA-cam.
That's an amazing story! Thanks so much for sharing. Congratulation on your new job! We'd love to hear more - please drop us an email at support@simonsezit.com.
Hello could please share the files in the video? Cant seen to get the files when inputting my email
Congrats! I'm on an interview tomorrow and doing this for the same reason:) I have always used it but very superficially. Fingers crossed:) Amazing videos: thank you!
I want to give a shout-out to the instructor, Ms. Deb. I have never enjoyed learning Excel as I did with her. She has a unique way of simplifying things and getting to the point quickly. Very well done. I wish she were my college instructor.
Thank you so much for your kind words! We're glad you enjoyed learning Excel with Ms. Deb. She's truly an amazing instructor. 😊
We have lots of additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
2:13:00 Pivot tables
3:03:50 8 functions that use dynamic arrays: FILTER, RANDARRAY, SEQUENCE, UNIQUE, SORT, SORTBY, XLOOKUP, XMATCH
4:42:00 Marcos and VBA
I think you mean macros
@@PizzaTuber12345 i'm sure they really don't care. it's for their own reference.
@@PizzaTuber12345 ORALE!
The US version of BODMAS is PEMDAS which stands for
P: Parenthesis
E: Exponents
M: Multiplication
D: Division
A: Addition
S: Subtraction
multiplication and division are calculated depending on which comes first when reading an equation from the left, and then the same for addition and subtraction. Hope this helps anyone from the US who didn't know what the instructor was talking about with BODMAS or PIDMAS
Brings me back to my algebra class. Our teacher always taught us "Please Excuse My Dear Aunt Sally" - Parenthesis, Exponents, Multiplication, Division, Addition, and Subtraction.
I lied in my resume about being awesome with excel. I got the job and now I have 2 weeks to learn everything about excel. At least I got the job though.
Good luck with the new job! You can get additional Excel training here ➡️
ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Same bruh
You have to… Good luck!
Fake it till you make it, respect for throwing yourself in an uncomfortable situation. Congrats on the job as well
How is it going?
What can I say? This is by far the most well laid Excel Masterclass on UA-cam. Kudos to @SimonSez and Deb, I've really learnt a lot from you!
Thank you @Markoline Ojok - that's very kind of you!
@@SimonSezIT @1:37:38 The import txt files don't show for me when I browse in excel. Only excel sheets. Is there a fix for this?
Today is my first day learning on your channel but I am so impressed with your teaching. All I have to say to you is that your instructions about Excel is totally awesome and impressive. Kindly continue to bring up more programs like this. There are many who are willing to learn but the tuition and fees for learning is not available. Your program has inspired me a lot. I am hoping to learning more from you. Your channel from today going forward, will be my best friend.
Hey there! Thanks a ton for your kind words and support. It's awesome to hear that my Excel tutorials have impressed you on your first day.
Don't worry, I've got plenty more programs in store for you, so please check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you for a great tutorial, only 1 hour in and already improving my knowledge so much.
Glad to help! 😊 We have lots of additional Excel training if you need it ➡️ ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here ➡️ ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here ➡️ ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
I can't stop watching this video. it's very Educative and powerful presentation I have ever watched or seen. The step by step tutorial can help a beginner to learn excel without any instructor. Thanks to all the team for putting such pieces together.
Wow, thank you!
Great course, even better tutor. Big thanks to the whole Simon Sez IT team. Definitely recommend. 10/10. God bless!
Much appreciated! Thanks!
I want to take a moment to thank you for the effort, you have chosen to teach us very beneficial skills for free! Thank you so much! I wish you all the best in your life!
Thanks for the kind comments. 🙂
🔥 Check out our FREE 300+ hour training course playlist here
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Best way of teaching excel from scratch. Helped me a lot as I wasn't familiar with many functions. Thank you Simon Sez and Deb for your time it was super helpful☺
Glad it was helpful!
What an extremely helpful video. Learned more in 40 minutes of your tutorial than I have from complete books.
Thanks for watching! 😊
I do not see why this video does not have 1M views, it is simply amazing!!
Thank you so much for making the world a better place by providing valuable content like this.
Thank you for your kind words! I'm glad you find the content valuable and that it's making a positive impact on the world. It means a lot to us.😊
We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
I would recommend this course to everyone who wants to learn from scratch to advanced, amazing course which I found on youtube.
Just finished this entire video. By far one of the best excel video tutorials out there. Great job guys. Especially you, Deb!
Wow, thanks a lot 😊 We have lots of additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
This really is an EXCELent tutorial!!
Thank you for this!! Forever grateful. God bless you.
Awesome to hear you found it helpful! Thanks for the support! 😊
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thank you, Deb! I've been a tutor for 15 years and have no patience for the intolerable instruction in most excel tutorials. This is how training is done!! Excellent.
Hey, thanks a ton! I'm thrilled to hear that my tutorial hit the mark for you. It means a lot, especially coming from an experienced tutor like yourself. Keep rocking it 😊
We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Tremendous course and excellent narration. Really helped me take things to the next level. Highly superior to many other more popular excel courses. Thank you taking the time to create this masterpiece.
Wow, thank you!
Madam Deb,I personally loved your way of teaching.!
So patient and so descriptive!
Sending love from INDIA
Thank you! 😊
I did excel a while ago and I hated it but it's never going away so decided to watch this video and i am really liking what i see you just make things easy for us
Deb's seminar was brilliant and comprehensive. Love and regards from India!
Thank you so much for your kind words! I'm glad you found the seminar helpful. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
that first teacher is fantastic, thank you ma'am i wish my professors were more like you
This is a very informative course. I like how the instructor explains the concepts
Thanks for the kind comments, Patrick 🙂 You can watch additional Excel training here ➡️
ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Best best beesssssssssssssst!!!!!! The fact that during the lesson we review and repeat some functions such as trim, proper ,... make it stand out from all other videos on Excel , Thank youuu 😍
Hey there! Thanks for the awesome comment! I'm glad you enjoyed it 😊
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
I really like the common sense delivery of information and the real world examples provided along with shortcuts.
his is by far the best tutorial on Excel I have seen on UA-cam
Thank you so much for the kind words! 😊
Wow! I can't thank you enough for creating this incredible resource. Your generosity and expertise are invaluable, and I'm incredibly grateful for all the effort you put into this course🙌 Keep up the fantastic work. You're a true gem in the world of online education🌟
Wow, thank you! Thank you for taking the time to leave a nice comment :-)
Thank you guys so much for this.
By far the most useful excel training I have taken already. Thank you for all the hardwork🙏
So glad to hear that you found the Excel training useful! Your support means the world 😊
Thank you for this 5 hours. It's really been a greater Excel full lesson. i've learned a lot from you.
A HUGE congrats, 💪 😊 Not many viewers complete our multi-hour long videos, so to finish the entire 5 hours is a great accomplishment!
🔥If you need more training like this, please check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you so so much for your keen effort
From Valencia, Spain.
Glad you liked it. Thanks for watching 😀
Wonderful, just the perfect tutorial!! Thank you so much!
I'm glad you found the tutorial helpful! You're welcome and thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you so much for sharing this awesome Excel tutorial on UA-cam! I've learned a lot from it.
You're very welcome! Thanks for watching 🙂
Extremely clear, helpful, and useful for professionals. I did excel projects in college and haven't used it in over 5 years. This was perfect! Thank you very much.
You're very welcome, crazybeartimba! We have additional free Excel training if you need it 👉
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
thanks for playing
@@SimonSezIT
Thank you for the course! Will you be adding subtitles? I would love to do this course in my downtime at work.
Lovely and systematic way of brilliant teaching. I love it.
Glad you liked it, Aftab! 🙂
Thanks for your complete education series, it improves a lot!
You are a HERO, your videos are very informative and easy to understand. Thank You for all your efforts.
I appreciate that Ashan :-)
what a good accent. makes learning much easier for me, a nonenglish speaker.
Glad you think so! Thanks for leaving as comment ;-)
I have been creating the tables from scratch lol I did not notice the files were available for download in the description until now one hour into the course !!! I guess I got a little extra practice...
this really helped me prepare for my excel assignment.
Awesome!
One of Best Tutorial...Thanks You Simon Sez IT & Instructor
Wow, thanks a lot 😊 We have lots of additional Excel training if you need it. Here -> ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here -> ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
@@SimonSezIT Thanks
Voice of tutor is learner appealing
Thanks for the kind comment. Appreciate it! 😊
this tutorial is on a different level of greatness! will watch more :)
Wow, thanks! Glad you enjoyed it 🤩
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
This is an amazing bootcamp and love the trainer!!
All we need is classes and tutorials like this and give a public exam. Universities are redundant, just made to rob people money in the name of education and leaving students in huge debts , popularly known as student loans. Of course politicians are not going to do anything because they get a share of the money somehow. Unless people challenge the status quo this robbing will continue. After taking this kind of money many professors are not even willing to teach properly. Just gives assignment, no where to turn to when you are faced with a doubt. Most students depend on You Tube to get the knowledge. Then what is the need for Universities!!!!!!!
Honestly, this was GREAT. Very informative and easy to follow. I'll be sharing this with everyone I know!
A big thank to you and your team from my heart, this course so crystal clear and super helpful, love you.
You're very welcome Abhishek 😊 We have lots of additional free Excel training if you need it 👉
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
You are the goddess of education. Oldest Hindu scripture Rig Veda says imparting education , Knowledge is the best form of charity. So nice teaching by you. It is really such a hard work. Though I learnt Excel in many Computer institutes but always felt dissatisfied and was really helpless in my workplace while working with Excel.
Thank you so much R K Singh 🙂
✅Download the Free Instructor Files to follow along the course here ► www.simonsezit.com/the-ultimate-excel-tutorial-instructor-files/
If the link doesn't work, please try another web browser or try clearing your browser cache.
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
& here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Link not working
I followed link, subscribed, still dont have files
The link doesn't work
PivotTables.xlsx missing
Pivottables.xlsx missing? by the way incredible course, cant thank you enough
I'm one hour in and I love the tutorial content so far, I learn so much!
Hats off to you!
Thank you for making this video and making Excel so easy to learn :)
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Thank you very much for this very helpful and really fantastic tutorial! 😊
You are very welcome! Thanks for watching 😃
I'm so excited to learn from this, I've discovered a knack for Data Science and Excel is a must
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
This is gems being made available for free
Thank you guys for putting this great video up
Thank you so much for this. I enjoyed learning word and excel with you.
I've been trying to learn Excel for the last 3 years but have struggled to both engage and wrap my head around it. Not to mention retaining what I've learned. I've gone through a lot of videos online, then saw this one appear and thought "5 hours? I could never" so I avoided it. Of course, I understand that all the other trainings I've attempted probably add up to around the same time, but seeing a 5 hour video is intimidating. However, it's not the length of time that's the issue. It's the delivery mechanism, and honestly, I'm only 30 minutes into this video and I don't feel like a fool for the first time in my attempts to learn to properly use Excel.
The structure simply teaches you something in 30 seconds, reaffirms it, and moves on. And what's better is everything I learned in the first few minutes are used and reused, so I ended up learning it and actually storing it in my brain, so when I needed it again, I used it almost without thinking about it. For some reason my brain just remembers where I would have been stuck before.
Yes, I'm only 30 minutes in, but if those 30 minutes are anything to go by, Excel would make sense to so many people if they simply gave this intimidating 5 hour video a real chance.
Considerations: Do not try to watch this video in the almost 6 hours that it is. Break it up. Take breaks. Let your mind rest. You'll get there if you keep coming back.
Have a 2nd screen (NOT YOUR MOBILE) to hand. That way you can watch the video and work on the Excel sheets without having to switch.
Anyway, Thank you so much to the Simon Sez IT team. Time for me to get back to it.
Thank you for sharing your experience! I'm thrilled to hear that this tutorial is making a difference for you. Breaking the video into manageable chunks and using a second screen are great tips. Keep at it, and soon, Excel will become second nature. Good luck with your learning journey! 🤩
I can't find the Pivot Tables Excel Tutorial file in the ones that were provided, please can you direct me where to get it if it's available. Between this an excellent learning tool, kudos 👍
Even I'm unable to find that data
I will be watching this tomorrow. Like to remind me.
Oh my god it's been a month. Thank you for the person who liked this comment for reminding me. Unfortunately, I am quite busy right now.
@@pauldino3331 DID YOU WATCH BRO. OR YOU ARE BUSY NOW
@@suleymanekremkaya2657 I actually actually watched it last time. but now I'm doing some other things but the knowledge is still here (I hope so 😄)
This is a great video course, although the vid quality was a little messed up so things were blurry and choppy. Still able to follow though. Seems like it may have been recorded from a stream so there are lots of audio hiccups and visual hiccups.
Essentially the blind leading the blind
Thank you for the great course with my favorite instructor !
I was wondering is there going to be full expert Excel tutorial in the future?
We have a number of expert/advanced Excel training videos in our "long video" playlist. Check it out here: ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thanks. A great instructional video. I'll be checking out the other videos.
Thanks guys for the amazing tutorial, it was quite easy to get along with.
Although I'm stuck and will be needing a little assistance.
In the combining functions sheet, I am trying to copy a function down a column but keep getting the same result that's in the first cell. In this case, Claire was what filled the entire column dropdown instead.
How do I go about it please?
It is really good teaching & easy to understand .Thanks teacher for your precious lectures .
Thank you again! Much appreciated it! 😊❤
You are so welcome ;-)
This is absolutely fantastic! Keep it up!
Thanks for the kind comments 😊
Hello Deb,
Thank you so much to my number one online excel tutor.
Is there a detail course on using Power Pivot to create interactive dashboards?
I am very Thankful that I found this Video. I can add to my Resume this skill❤❤
Great!You’re most welcome 😊
Excellent Course one could learn from. Thanks u so much Simon Sez IT.
Thank you!
This is a fantastic tutorial. Thank you so much.
Thank you for your kind words! I'm so glad the tutorial was useful to you. 😊
🔥Please check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Lovely and systematic way of brilliant teaching. I love it.. What a great course! Good job indeed.
Many thanks!
Thank you so much! I thought excel was going to be the same as google sheets but I had so much trouble switching over easily so this was such a helpful video!
Also in the US, I don't know about now, but when I was in middle school 10 years ago we learned PEMDAS (or GEMDAS) and were told to think of Please Excuse My Dear Aunt Sally to remember PEMDAS. My partner who grew up on the other side of the country had this experience as well
This was awesome. Very easy to understand and I absolutely loved the interactive spreadsheets! 🎉
Glad you enjoyed it. Thanks for watching! 🙂
We have a lot more courses on MS Office and other topics, with 300+ hours of free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Never thought I'd have my mind blown by an Excel tutorial of all things. But dang I did not know half the stuff Excel could do.
Glad you enjoyed it. Thanks for watching! 🙂
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
I love love love this video .. very informative. THANK YOU! ❤
You're very welcome. Thanks for watching 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Одлични сте. Хвала Вам.
Huge thanks for providing such an amazing resource!
Many thanks, Michelle! 😊
Thanks a lot. Such an understanding way of teaching! Good job.
I learn so much from it. 10/10!
Recommended 100%
Thanks for the nice comments, Kristina Bogatinova 😊 There's additional Excel training here if you need it -> ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Great narration and tuition here.
Really nice and interesting voice!
Lucky hubby! My misses’s voice puts me to sleep as soon as she starts yapping 😂
Thank you 🙏 guys for this course , it is Amazing .
Thank you for sharing this Awesome Content.
Good Course that's Really Interesting
Many many thanks 🙂
Insane tutorial ❤
Ain't commenting much, but I really appreciated your lesson
Thank you for watching and appreciating the tutorial! Glad it was helpful. 🤩
Thank you so much for your free course!! It helps me a lot
Thanks for the visiting our video!
Thank you guys, I learn a lot. Your channel offer the best 5*
tutorial on IT tools, particularly for business analysis.
this is the best way to start a journey into data science.
Thanks Owen! We have a playlist filled with data science related videos -> ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
Fun class with Deb and Adam. I love Deb!
Thank you Goddibaba Mbanuzue! Here's additional Excel training if you need some: ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
I fell in love with pivot tables after watching this hahah ! Thanks!
Happy to hear that!
Great in depth video. The only negative I would have is the video is choppy at some points but luckily Deb is very clear and I had no troubles following. Much more confident at using excel now and will point anyone needing any help to this video. I will now go check out more from your channel. Thank you very much!
Sorry about that and thank you! :)
You are a very Good Teacher♥
Thank you! 😃
Not even half an hour in and already learned so much! (In the US, it's PEMDAS: Parenthesis, Exponents, Multiplication & Division, Addition & Subtraction) You were close! :D
Glad it was helpful! One of the many differences between the US and UK system. ;)
Just FYI - PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, and Subtraction), not PIDMAS, is taught in these United States.
Thank you so much Deb and Simon Sez.
You're welcome!
I did the same in If, AND and IFS and it worked without putting dollar sign. I am using excel 2021.
Good video, thank you my friend you're the best 😂😂😂😂
this course is amazing!!!!!! thank you soooo much for putting it together and sharing it
Thank you Charles, appreciate your comments! Here are some additional Excel tutorials that may be helpful -> ua-cam.com/video/oN82Umc9MCQ/v-deo.html & ua-cam.com/video/PlPgYOFJROI/v-deo.html
Thank you so much! very helpful and an easy to follow course!
Great to hear!
I'm a beginner (21:27) mark Wow! I did not know, how helpful it was.
Best tutorial I've come across so far
This was amazing, thank you :) Do you have any recommendations for Data Analyst courses?