✅ Download the free course files to follow along ➡www.simonsezit.com/data-analytics-in-excel-exercise-instructor-files/ 🔥Check out our FREE 300+ hour training course playlist here 👉ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀Level up your data analysis skill set with this free playlist 👉ua-cam.com/play/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi.html
Hello, just started learning about Excel. I paused the video to make this comment, your explanation and detailing are so straight forward and easy to follow, Thanks a lot.
Wow, thanks! Glad it was helpful. 🤩 🔥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!
It's always great to keep learning and improving, glad you found the tutorial helpful! 😊 🔥Please check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Great to hear! We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
Glad you like 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!
Glad you enjoyed it. Thanks for watching! 🙂 🔥If you need more training such as this one, please check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Hi, Excellent video to start for absolute beginners with Excel. The only "poor" think that I've seen is "advertising" the Merge (and center) as it can become a really pain in the a.. (I'm French, so you certainly can pardon my French 😁). Centering across the selection is slightly longer to achieve of course but if the result seems to be the same, it prevents all the issues with selecting range and copying and pasting. Again, very nice video that I will share with absolute beginners before starting courses when mixed to non beginners.
Thank you for your feedback! I appreciate your input and will take it into consideration for future videos. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
@@SimonSezIT If I may add, watching the second half of the video, I was surprised to see the formulas dragged down manually instead of double clicking on the fill handle (that's a time saver, especially when you have loads of rows!)
Very beneficial courses, I am very impressed of the simple and logic ways to convey the ideas in clear manner, I have seen many excel courses but but the structure of modules is confusing and unclear. Thank you for meaningful presentation.
Wow, thanks! Glad it was helpful. 🤩 We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
Hey, thanks for the feedback! We're really happy to hear that the training was well-organized and explained in detail. Makes all the hard work worth it! 🙂 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtf.html
Thank you for the video. It would be nice if you let Excel 2021 users (desktop version) know that you are using MS 365 and it is Required to play along with your video, otherwise you are stuck at "data types". All of this training should start with what version of MS Excel you need to participate as there are many different levels and you can spend hours (apparently) searching for what you have and trying to guess what version Simon Says It is using.
this tutorial was so so good. my only problem was the xlookup part because my version doesn't have that yet, so i had to find an alternative by combining the index and match functions
Oh really? I've gone over the lectures on index and match a couple of times and still find it problematic. I'll be honored if you can help out, maybe with a link to a more concise lecture on index and match. Thank you so much 🙏
Oh really? I've gone over the lectures on index and match a couple of times and still find it problematic. I'll be honored if you can help out, maybe with a link to a more concise lecture on index and match. Thank you so much 🙏
Oh really? I've gone over the lectures on index and match a couple of times and still find it problematic. I'll be honored if you can help out, maybe with a link to a more concise lecture on index and match. Thank you so much 🙏
Oh really? I've gone over the lectures on index and match a couple of times and still find it problematic. I'll be honored if you can help out, maybe with a link to a more concise lecture on index and match. Thank you so much 🙏
Oh really? I've gone over the lectures on index and match a couple of times and still find it problematic. I'll be honored if you can help out, maybe with a link to a more concise lecture on index and match. Thank you so much 🙏
Thanks for the useful tutorial, I was expecting to learn data analysis all the time, as the title suggests. I hope you to provide us with a "data analysis" tutorial soon. Best regards to you Mr. Simon.
Wow, thanks! Glad it was helpful. 🤩 🔥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 checking out the video! Excel can be a pain sometimes, but don't worry, you'll get the hang of it. Keep up the great work! 😊 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!
its simple and easy to understand, but its better if you use or do with the help of keyboard shortcuts so viewers can learn shortcuts as well for better navigation and to achieve results quickly.
Great to hear! You're welcome 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.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 kind comments 🙂 🔥 Check out our other free tutorials on various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.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! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
You are very welcome! 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 & Pivot Table training here 👉
Thanks for watching! Glad you found it easy to understand! 😊 We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
Wow, thanks for the kind comments 🙂 🚀 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 2 hour video is not complete, right? It stopped at Module 3, cleaning data. Section 4: Analysing Data and Section 5: What If Analysis is not included.
Hey! Thanks for watching my videos and finding them useful. Yes, you can use the resources for your project. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you for your amazing support. We're so grateful to have awesome viewers like you. 😊 We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.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 wonder if you could answer a question? Regarding clearing out duplicate records: Is there a way to PREVENT duplicates from being entered into the list to begin with? If the user is about to enter a record with one or more fields identical to the same field of a record already in there, is it possible to have a message pop up and flag that? Thank you, and thank you for a wonderful video!!
You're welcome! 🙂 Check out our FREE 300+ hour training course playlist 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!
You're welcome! Thanks for watching 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.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!
You're welcome. When you click the link, please ensure to provide your email address so that we can send it directly to your inbox. 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Yes, you can definitely use Excel Home and Student 2021 to follow along with this course! The basic functions and features should be similar across different versions of Excel. 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!
@@najidmouhammad9708 Because you are not modifying the structure of the sheet, merge & center deletes cells and center across selection leaves the cell structure intact allowing to insert columns, sorting and filtering.
You can use any version of Excel for data analysis, but there may be functions that are only available in the later versions such as Excel 2021, and of course Excel 365.
You didn’t use the format as table to unlock even more powerful functionality. For example, changing the data into a table would have turned filtering on. Also the flash fill function works even better when the data is already in a table. Calculations fill down columns
This was recorded with Excel 365, but you can try going to File - Options - Customize Ribbon, and then from the dropdown, All Commands, then search for Data Types.
You can find the link in the video description. You may also click the link below: ✅ Download the free course exercise files to follow along ➡️www.simonsezit.com/data-analytics-in-excel-exercise-instructor-files/ Thanks for watching 😊
✅ Download the free course files to follow along here👉www.simonsezit.com/data-analytics-in-excel-exercise-instructor-files/ We have additional free tutorials for various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.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!
✅ Download the free course files to follow along ➡www.simonsezit.com/data-analytics-in-excel-exercise-instructor-files/
🔥Check out our FREE 300+ hour training course playlist here 👉ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀Level up your data analysis skill set with this free playlist 👉ua-cam.com/play/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi.html
awesome
why cant I open this file on my laptop. Can you help me out sir
nice one
meshach
awesome
Hello, just started learning about Excel. I paused the video to make this comment, your explanation and detailing are so straight forward and easy to follow, Thanks a lot.
Wow, thanks! Glad it was helpful. 🤩
🔥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!
Thank you so much for the tutorial, Simon Sez IT. I thought that I mastered excel, but I just found that I need to update my knowledge continuously
It's always great to keep learning and improving, glad you found the tutorial helpful! 😊
🔥Please check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Easy to understand for beginner and do not have a lot of vocabularies, thank you so much
This is an exceptionally simplified video on Excel and easy to digest. Your effort is well appreciated
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Thanks for sharing. It has improved my knowledge in sorting, using various mathematical functions, and enhancing the data quality
Great to hear! We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
I am very impressed with simple and short way to do excel formulae in short spam time of time. 😊
Glad you like 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!
Excellent tutorial. The simplicity and method of delivery was superb and fantastic.
Glad it was helpful! :-)
I appreciated the format used to teach each step. I also appreciated all the value provided for serious students.
Glad you enjoyed it. Thanks for watching! 🙂
🔥If you need more training such as this one, please check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you for the course! I am not a beginner in excel, yet I found quite a number of useful shortcuts and lifehacks
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Hi,
Excellent video to start for absolute beginners with Excel.
The only "poor" think that I've seen is "advertising" the Merge (and center) as it can become a really pain in the a.. (I'm French, so you certainly can pardon my French 😁).
Centering across the selection is slightly longer to achieve of course but if the result seems to be the same, it prevents all the issues with selecting range and copying and pasting.
Again, very nice video that I will share with absolute beginners before starting courses when mixed to non beginners.
Thank you for your feedback! I appreciate your input and will take it into consideration for future videos. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
@@SimonSezIT
If I may add, watching the second half of the video, I was surprised to see the formulas dragged down manually instead of double clicking on the fill handle (that's a time saver, especially when you have loads of rows!)
Very beneficial courses, I am very impressed of the simple and logic ways to convey the ideas in clear manner, I have seen many excel courses but but the structure of modules is confusing and unclear. Thank you for meaningful presentation.
Wow, thanks! Glad it was helpful. 🤩 We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
really you are the power house of knowledge
Thank you for the kind comments 🙂
This vid is excellent. The lectures and explanations are crystal clear. You've done a great job!
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
I'm enjoying this course... Awesome for beginners!!! Thank you!
Great Training! Thanks for organizing it so well and explaining everything in details.
Hey, thanks for the feedback! We're really happy to hear that the training was well-organized and explained in detail. Makes all the hard work worth it! 🙂
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtf.html
Thank you for the video. It would be nice if you let Excel 2021 users (desktop version) know that you are using MS 365 and it is Required to play along with your video, otherwise you are stuck at "data types". All of this training should start with what version of MS Excel you need to participate as there are many different levels and you can spend hours (apparently) searching for what you have and trying to guess what version Simon Says It is using.
At 3:13 he gives the course requirements and mentions that Excel 365 works best.
Tutorial Contents :
🕑 0:00 - Simon Sez IT Intro
🕑 0:21 - Course Introduction
🕑 1:53 - Navigating Excel
🕑 15:15 - Data Types in Excel
🕑 21:12 - Viewing, Entering and Copying Data
🕑 30:08 - Formatting and Data Types in Excel
🕑 36:53 - Excel Formula Basics
🕑 48:37 - Exploring Excel Functions
🕑 58:16 - Referencing Data in Formulas
🕑 1:07:11 - Exercise 01
🕑 1:11:28 - Introduction to Data Quality
🕑 1:21:28 - Importing File Data
🕑 1:27:05 - Removing Duplicate Data
🕑 1:34:55 - Identifying Data Attributes
🕑 1:43:19 - Cleaning Data
🕑 1:50:59 - Exercise 02
I like the way you teach, well measured for proper understanding, keep it up.
Appreciate that :-)
this tutorial was so so good. my only problem was the xlookup part because my version doesn't have that yet, so i had to find an alternative by combining the index and match functions
Oh really? I've gone over the lectures on index and match a couple of times and still find it problematic. I'll be honored if you can help out, maybe with a link to a more concise lecture on index and match. Thank you so much 🙏
Oh really? I've gone over the lectures on index and match a couple of times and still find it problematic. I'll be honored if you can help out, maybe with a link to a more concise lecture on index and match. Thank you so much 🙏
Oh really? I've gone over the lectures on index and match a couple of times and still find it problematic. I'll be honored if you can help out, maybe with a link to a more concise lecture on index and match. Thank you so much 🙏
Oh really? I've gone over the lectures on index and match a couple of times and still find it problematic. I'll be honored if you can help out, maybe with a link to a more concise lecture on index and match. Thank you so much 🙏
Oh really? I've gone over the lectures on index and match a couple of times and still find it problematic. I'll be honored if you can help out, maybe with a link to a more concise lecture on index and match. Thank you so much 🙏
Thanks for the useful tutorial, I was expecting to learn data analysis all the time, as the title suggests. I hope you to provide us with a "data analysis" tutorial soon. Best regards to you Mr. Simon.
Thank you. This tutorial is part of the full paid course on our site. You can check it out here: www.simonsezit.com/
Simple and straightforward! I am grateful!
Wow, thanks! Glad it was helpful. 🤩
🔥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!
Thank you very much for the tutorials, it was really helpful
Glad you are finding them helpful, Edward :-)
It's very impressive, its really very explainatory
Thank you! 😊
Great ,good teaching and easy to understand 👍🏽
This is so clear and aimple though couldn't follow through cos if my version of Excel. Asides that...great video for beginners!
Thanks for checking out the video! Excel can be a pain sometimes, but don't worry, you'll get the hang of it. Keep up the great work! 😊
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!
its simple and easy to understand, but its better if you use or do with the help of keyboard shortcuts so viewers can learn shortcuts as well for better navigation and to achieve results quickly.
this is an amazing video!!!. I'm truly grateful for your efforts,thank you for sharing .. More power to your channel!!!
Thank you so much!
best course for beginners
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
am glad to be part of this class
We are glad you are here ;-)
Very easy to follow indeed. Thank you!
So glad you found it easy to follow! Thanks for watching! 🤩
Thank you, the cleaning parts was very beneficial for me
Great to hear! You're welcome 🙂
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.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!
very excellent , explained with simplicity
Thanks for the kind comments 🙂
🔥 Check out our other free tutorials on various data analysis tools and services here 👉 ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.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!
Very useful tutorial. Thanks for your video and it helps me a lot.
Wow, thanks! Glad it was helpful. 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
damn this job will blow up and rise in the future
Thank good lecture and clear understanding
Very informative! Thank you!❤
Good Job.
Love the tutorial.
Very simple, concise explanation with no unnecessary jargon
Great for beginners like me!
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
this is very educative, thanks alot.
You are very welcome! 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
& Pivot Table training here 👉
excellent opportunity to learn
Wow, thanks! Glad it was helpful. 🤩
good job, self explanatory
Thanks for watching! Glad you found it easy to understand! 😊
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
thank you so much! this tutorial was very helpful!
very helpful thank you❣
Awesome tutorial thanks
Wow, thanks for the kind comments 🙂
🚀 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 2 hour video is not complete, right? It stopped at Module 3, cleaning data. Section 4: Analysing Data and Section 5: What If Analysis is not included.
Thanks so much me Simon
Can I make use of ur all the resources provided as my project work??
Hey! Thanks for watching my videos and finding them useful. Yes, you can use the resources for your project. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you it was very healp full
Thank you ❤
THANKS A LOT MAN, LOVE U BRO
Thank you for your amazing support. We're so grateful to have awesome viewers like you. 😊
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.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
Wonderful Course indeed
I wonder if you could answer a question? Regarding clearing out duplicate records: Is there a way to PREVENT duplicates from being entered into the list to begin with? If the user is about to enter a record with one or more fields identical to the same field of a record already in there, is it possible to have a message pop up and flag that? Thank you, and thank you for a wonderful video!!
Yes, use Data Validation to prevent duplicates. It can show an error message if a duplicate is entered.
@@SimonSezIT Thank you
Very Informative but I do like to know the version of Excel you used for this tutorial
Yes. Me too pls, would like to know the version of Excel used 🙏
Great thanks!
You're welcome! 🙂
Check out our FREE 300+ hour training course playlist 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!
the excel app i am using on my laptop does not have "data type" unto the data column. how do i go about this please. thank you
Thank you so much.
You're welcome! Thanks for watching 🙂
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.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!
Interesting class
Glad you think so! Thanks for leaving a comment ;-)
Thank You So Much
You're most welcome
great job ! sir
Thank you! You are very welcome!
Excellent
Thanks 🤗
Succinct. Thank you teacher!
You are very welcome! 😀
Should there be a CSV file included with the course files? Thank you
Helpful and useful 👍
Glad you liked it. Thanks for watching 😀
Great Video!
This is so amazing!
Thank you for watching 😊
Awesome Tutorial. thank you
Woooooow thanks for the tutorial
You're welcome 😊
Hi wanna change my career to Data analyst, what could be your advice? Currently, in medical field
Thank you so much for the tutorial, but I cannot download the data following your link. How can I get the practice file, please?
You're welcome. When you click the link, please ensure to provide your email address so that we can send it directly to your inbox.
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
very useful
thanks
I have Excel Home and Student 2021, can I use that to follow along with this course?
Yes, you can definitely use Excel Home and Student 2021 to follow along with this course! The basic functions and features should be similar across different versions of Excel.
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!
At 1:24:28, you have a query "but not a direct connection". What does that mean? What would be connected to what? Thank you
Use Center across selection instead of merge
could you please explain why it's preferable to use Center across instead of merge
@@najidmouhammad9708 Because you are not modifying the structure of the sheet, merge & center deletes cells and center across selection leaves the cell structure intact allowing to insert columns, sorting and filtering.
Which excel version is needed for this osam practice..?
You can use any version of Excel for data analysis, but there may be functions that are only available in the later versions such as Excel 2021, and of course Excel 365.
You did not talk about or demonstrate the power query tool for cleaning data despite saying Excel 365 is best
You didn’t use the format as table to unlock even more powerful functionality. For example, changing the data into a table would have turned filtering on. Also the flash fill function works even better when the data is already in a table. Calculations fill down columns
what version of MS Excel must we use?
Do you give certificate like Most certified
Couldn't download the exercise file. It shows 50% complete when I try to download.
You have to scroll down that page and click the download button
@@Bdavis2475thanks
Since Wolfram is no longer supported as of June 11, 2023, what else is used instead?
i have signed up , but i am not able to join the community saying its full
Hello why dont I see in my excel file the data type to see options like geography, flag, populations and the likes?
Geography I think is only available in the Microsoft 365 version.
Hi Bro, How you are getting the Yellow color while typing only late that is gone. please let me know how it is working.
How long does it usually take for the data to be sent?
Usually within 10 minutes. Please check your spam or junk folder.
Time stamp 10
3-05. Cleaning data. when i deleted cells after cleaning it returned a reference
error
hii....in excel i dont have the data type tool,,how can i get this??
How can I download this video
I love your teaching, but I know a little English, How can you help some one like me ? on that matter.
The video has English captions, click on the CC icon - hopefully that helps :-)
i dont have phone numbers in format cells - numbers section
Which excel version using in this tutorial?
Hi! This was recorded using Excel 365, but the basics of Excel should be the same across versions, especially the latest 2021 version.
There is no Automatic under my data types, what I have here is STOCK, CURRENCIES AND GEOGRAPHY. What can I do?
it's okay, he had a wolfram data types, now microsoft doesn't support it, as they have stopped the collaboration.
pls what version of Excel are you using because i cant find the data type feature in mine
This was recorded with Excel 365, but you can try going to File - Options - Customize Ribbon, and then from the dropdown, All Commands, then search for Data Types.
i didn't receive the mail to download the files
do you have any pdf form
Very informative & detailed video especially for beginners. ❤
Glad you think so! 😊
I couldn't download the Excel practice files. How can you help with that?
I got it. Thanks
I still after several attempts can’t lock the cells 😢
where i can find the files mentioned in this video
You can find the link in the video description. You may also click the link below:
✅ Download the free course exercise files to follow along
➡️www.simonsezit.com/data-analytics-in-excel-exercise-instructor-files/
Thanks for watching 😊
if(and(A4:H4=A5:H5),*check*,*ok*) crashes, doesnt work in 365 2023 too.
I can not download the data follow your link.
✅ Download the free course files to follow along here👉www.simonsezit.com/data-analytics-in-excel-exercise-instructor-files/
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.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!