✅ 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 👉ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀Level up your data analysis skill set with this free playlist 👉ru-vid.com/group/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi
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 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
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.
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 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
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
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 🙏
Great to hear! We have additional free tutorials for various data analysis tools and services here 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
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.
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.
nvm i figured it out, you click on geography in the data type, then you'll see the same icon that is shown on the video click it and click on currency code for column B
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 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtf
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 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Glad you like it! We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
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 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
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 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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.
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 😊
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 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@@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!)
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.
Wow, thanks! Glad it was helpful. 🤩 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ 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 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ 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 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
✅ 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 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ 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.
Great to hear! You're welcome 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
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 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support
You are very welcome! Thanks for watching 🙂 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & 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 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
Thanks for the kind comments 🙂 🔥 Check out our other free tutorials on various data analysis tools and services here 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
Wow, thanks for the kind comments 🙂 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
You're welcome! 🙂 Check out our FREE 300+ hour training course playlist here ➡️ 🔥ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
You're welcome! Thanks for watching 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!