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.
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 RUclips.
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/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 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!
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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Glad to help! 😊 We have lots of additional Excel training if you need it ➡️ ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here ➡️ ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here ➡️ ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
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!!!!!!!
Wow, thanks a lot 😊 We have lots of additional free Excel training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Awesome to hear you found it helpful! Thanks for the support! 😊 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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! 🤩
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
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! 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🌟
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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 👍
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.
Wow, thanks! Glad you enjoyed it 🤩 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
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! 🙂 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
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.
Wow, thanks a lot 😊 We have lots of additional Excel training if you need it. Here -> ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here -> ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
We have a number of expert/advanced Excel training videos in our "long video" playlist. Check it out here: ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
You're very welcome Abhishek 😊 We have lots of additional free Excel training if you need it 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Woohoo, you made it through an hour! That's awesome! Take a break, grab a snack, and come back when you're ready. We'll be here waiting for you! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
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
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.
You're very welcome. Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
Thanks for the nice comments, Kristina Bogatinova 😊 There's additional Excel training here if you need it -> ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
I got super confused when adding July's data to the pivot chart, until I realised it's July 2017 when all the other months are in 2019, so the timeline slicer doesn't show it unless you've selected all the way from July 2017 to Jun 2019. Not sure if an oversight or intended as a learning point but it sure threw me for a loop.
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 ➡️
ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
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?
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 RUclips.
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!
@@brownpaperbagtalks199 how did it go?
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/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.
What can I say? This is by far the most well laid Excel Masterclass on RUclips. 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?
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!
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!
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
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 ➡️ ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here ➡️ ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here ➡️ ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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!
I do not see why this video does not have 1M views, it is simply amazing!!
Great course, even better tutor. Big thanks to the whole Simon Sez IT team. Definitely recommend. 10/10. God bless!
Much appreciated! Thanks!
What an extremely helpful video. Learned more in 40 minutes of your tutorial than I have from complete books.
Thanks for watching! 😊
I would recommend this course to everyone who wants to learn from scratch to advanced, amazing course which I found on youtube.
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 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
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!!!!!!!
that first teacher is fantastic, thank you ma'am i wish my professors were more like you
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/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!
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
Madam Deb,I personally loved your way of teaching.!
So patient and so descriptive!
Sending love from INDIA
Thank you! 😊
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
his is by far the best tutorial on Excel I have seen on RUclips
Thank you so much for the kind words! 😊
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! 🤩
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
this really helped me prepare for my excel assignment.
Awesome!
Thank you for the course! Will you be adding subtitles? I would love to do this course in my downtime at work.
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 ➡️
ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Thank you so so much for your keen effort
From Valencia, Spain.
Glad you liked it. Thanks for watching 😀
I really like the common sense delivery of information and the real world examples provided along with shortcuts.
what a good accent. makes learning much easier for me, a nonenglish speaker.
Glad you think so! Thanks for leaving as comment ;-)
This is gems being made available for free
Thank you guys for putting this great video up
I'm one hour in and I love the tutorial content so far, I learn so much!
Lovely and systematic way of brilliant teaching. I love it.
Glad you liked it, Aftab! 🙂
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...
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 😊
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 :-)
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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
You are a HERO, your videos are very informative and easy to understand. Thank You for all your efforts.
I appreciate that Ashan :-)
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 🙂
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 👉
ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
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 😄)
I'm a beginner (21:27) mark Wow! I did not know, how helpful it was.
Thank you so much for sharing this awesome Excel tutorial on RUclips! I've learned a lot from it.
You're very welcome! Thanks for watching 🙂
Thank you so much for this. I enjoyed learning word and excel with you.
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 😂
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
I fell in love with pivot tables after watching this hahah ! Thanks!
Happy to hear that!
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
I am very Thankful that I found this Video. I can add to my Resume this skill❤❤
Great!You’re most welcome 😊
Thanks for your complete education series, it improves a lot!
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
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?
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 -> ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here -> ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@@SimonSezIT Thanks
Good video, thank you my friend you're the best 😂😂😂😂
Thanks. A great instructional video. I'll be checking out the other videos.
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?
Voice of tutor is learner appealing
Thanks for the kind comment. Appreciate it! 😊
this is the best way to start a journey into data science.
Thanks Owen! We have a playlist filled with data science related videos -> ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
Thank you again! Much appreciated it! 😊❤
You are so welcome ;-)
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 ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Thank you very much for this very helpful and really fantastic tutorial! 😊
You are very welcome! Thanks for watching 😃
Excellent Course one could learn from. Thanks u so much Simon Sez IT.
Thank you!
Honestly, this was GREAT. Very informative and easy to follow. I'll be sharing this with everyone I know!
Thank you for sharing this Awesome Content.
Good Course that's Really Interesting
Many many thanks 🙂
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: ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 👉
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Best tutorial I've come across so far
I did the same in If, AND and IFS and it worked without putting dollar sign. I am using excel 2021.
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Huge thanks for providing such an amazing resource!
Many thanks, Michelle! 😊
I am 1 hour in. Thank you for all the information. Taking a break but I'll be back.
Woohoo, you made it through an hour! That's awesome! Take a break, grab a snack, and come back when you're ready. We'll be here waiting for you! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
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. ;)
This is an amazing bootcamp and love the trainer!!
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
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
You are a very Good Teacher♥
Thank you! 😃
Lovely and systematic way of brilliant teaching. I love it.. What a great course! Good job indeed.
Many thanks!
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 -> ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
This is how you train, excellent work !
Glad you liked it! 😊 Check out our new 10 hour Excel course -> ruclips.net/video/fODnNDNMXiI/видео.html
Insane tutorial ❤
Ain't commenting much, but I really appreciated your lesson
Thank you for watching and appreciating the tutorial! Glad it was helpful. 🤩
Fun class with Deb and Adam. I love Deb!
Thank you Goddibaba Mbanuzue! Here's additional Excel training if you need some: ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
This was amazing, thank you :) Do you have any recommendations for Data Analyst courses?
Thank you 🙏 guys for this course , it is Amazing .
Thank you so much Deb and Simon Sez.
You're welcome!
One of the best coarse .
Thank you!
This is absolutely fantastic! Keep it up!
Thanks for the kind comments 😊
In Canada we use BEDMAS (Brackets,Exponents,Division,Multiplication,Addition and Subtraction) 😊
range, criteria, value..etc.. it's plain english and clearly defined but finally making sense to me now 😅
Amazing course Debyou are a GURU!!!
Thanks Rodney, I’m glad you’ve enjoyed the lesson😎
Thank you so much for your free course!! It helps me a lot
Thanks for the visiting our video!
It is really good teaching & easy to understand .Thanks teacher for your precious lectures .
I learned so much! Thank you!
You are so welcome!
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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
I got super confused when adding July's data to the pivot chart, until I realised it's July 2017 when all the other months are in 2019, so the timeline slicer doesn't show it unless you've selected all the way from July 2017 to Jun 2019. Not sure if an oversight or intended as a learning point but it sure threw me for a loop.