🔥Post Graduate Program in Data Analytics: www.simplilearn.com/pgp-data-analytics-certification-training-course?DataAnalytics-OOWAk2aLEfk&Comments& 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): www.simplilearn.com/iitk-professional-certificate-course-data-analytics?DataAnalytics-OOWAk2aLEfk&Comments& 🔥Caltech Data Analytics Bootcamp(US Only): www.simplilearn.com/data-analytics-bootcamp?DataAnalytics-OOWAk2aLEfk&Comments& 🔥 Data Analytics Bootcamp(US Only):www.simplilearn.com/data-analytics-bootcamp?DataAnalytics-OOWAk2aLEfk&Comments&
It took me an hour to figure out the Data validation @2:06:00. Incase if anyone is stuck there, make sure that the cells are named according to the city before using the =indirect() function. You have to go to Formula tab> Name Manager and then create names for the range of cells according to the drop down list you want the end result to correlate to, otherwise the indirect function will not work.
What a lovely video it was, everything explained to perfection. You guys at Simplilearn are doing a commendable job for free. Love your content. I have a request if you could share the Datasets used in this video it would be very helpful. I could use them to practice on the skills taught.
Thank you very much for making this available, data sets as well. I kindly suggest that the chapters be updated, since there is a 7hr version that has lots of overlap. I find it difficult to go back and forth to see which one matches each excel sheet. I'm very excited to finish the course!
Hey, thank you for appreciating our work. We are glad to have helped. Do check out our other tutorial videos and subscribe to us to stay connected. Cheers :)
WooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every week on all your favorite topics. Whenever you have the time, you must also check out our blog page @simplilearn.com and tell us what you think. Have a good day!
Hi there, Thanks for the tutorial. Everything is very well explained. It seems data sheets for lookup section (2:35:00-3:23:00) is missing in the zipped file. Can you please share those files too or let me know if I am missing out on something. Thanks.
What a lovely video it was, everything explained to perfection. You guys at Simplilearn are doing a commendable job that too for free. Love your content. Hats off to you. I had a request if you could share the Datasets used in this video it would be very helpful. I could use them to practice on the skills taught.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Oh damn! This platform on youtube providing high quality content at what cost? It's zero. It's just we have to invest our time, if we really want to learn these excel skill. Kudos! Great team work by simplilearn team.
Simplilearn! You guys are the best. Top notch, detailed explanation. A big Kudos to the lecturers. Please how can I get the datasets used in this tutorial? It would really help me practice what I was taught🙏🏽. Thanks
Absolutely wonderful video Simplilearn!! Just found it and I am working my way through it. It is very clear and I really love it! I did run into a problem with one of the countif formula (approx 1:31:30) used to answer the second question. In the question, it says to find the sales person who made more than 3 sales. When you paste the countif formula to the rest of the table, the range reference changes making the sales reps at the bottom half of the table to fail the criteria. Can be avoided if the range is static (i.e.$C$2:$C$44). Or did I misunderstand the question?
Superb ! It's really worth I learned many things 😌thanks a lot 🙏 most amazing part for me sweet, simple n clear language with sub title which hepl me to get easily understand 🙂
Hi Williams, thank you for choosing Simplilearn on your learning journey. Thank you for bringing this to our attention, we will reach out to the concerned team and get you the file ASAP. Cheers! In the meanwhile, why don't you subscribe to our channel and check the over 140+ free certification courses we provide. www.simplilearn.com/skillup-free-online-courses
I have no prior experience in coding and i am from non engineer background. But i am passionate about learning data analytics. Is it possible for anyone with no experience become a data analyst?
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
I really appreciate you people's effort for breakthrough tutorial for beginners in Excel, please I need the data sets for practice. Where can I get it?
Thank you very much for providing this tutorial. But Could you please upload "lookup" excel? I couldn't find it in the folder in your Google Drive. Thanks again, and if you have renewed it, please let me know.
I have a question...to group the dates into quarters and years did you use some special formula? I am asking because if I try to make a pivot table with another dataset the dates do not automatically come out as quarters and years. THANK YOU
hi, So a contextual advertising campaign is a type of online advertising that involves placing ads on web pages or search engine results pages that are related to the content of the page. The structure of a contextual advertising campaign typically includes the elements like Target Audience, ad content, placement, budget, Tracking and optimization etc. I hope this answers your query. Thanks
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. If you're interested in further expanding your knowledge, check out our course offerings in the description box.
Hello there. Thank you very much for the tutorials. Where can i get the sample data sheets to practice? Any idea where I can download free data sheet for study purposes?
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
Thank you for sharing the video. It would be great helpfull. Can you please share the link for the data sets used in this video. So that we can also practice. Thank you 🙏🙏🙏
This is amazing. Thank you for presenting it in a simplified manner. I ha e a request. It seems that a step is missing at 2:17:24 where the regions are sorted in the pivot table. At 2:17:23 the region at the top is Central where as it changes to WEST at 2:17:24. Can you please let us know which step was missing there?
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
sir at 1:32:36 we havent given the range for sales>3 then how would the function automatically take that particular column and compute the result,like it can compute the result taking any column right...can u explain this
Thank you for the knowledge, ALL THE BRAIN IS ALL YOURS, I got enlightenment about excel, I hope the excel class will be great fot other people as well.
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
Hi, I found this Data analytics in excel course helpful. Thank you for the course. Could you please share the sample data set used to practice. Thank you.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Hey, thank you for appreciating our work. We are glad to have helped. Do check out our other tutorial videos and subscribe to us to stay connected. Cheers :)
I just received data sets from simplilearn. Thank you so much really appreciate. Looking forward to buy some courses once I complete this free course. 👍
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. If you're interested in further expanding your knowledge, check out our course offerings in the description box.
We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. If you're interested in further expanding your knowledge, check out our course offerings in the description box.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Hello sir, thank you so much for this course. Can you please kindly help me with sample data used in this course. So I can follow along with the video.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
@@SimplilearnOfficial please I need it too. I want to suggest to make it easy sending to people you create a google drive link and post it everytime to anyone that need to here. Please send it to me at brianvitali@yahoo.com
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
It's long well course. The only problem is that there is no practice files so it's useless if you can't follow along. The main purpose is not to watch the 4 hour video, it's boring to just watch. I can just watch movies if I want it to, it's more enjoyable. The main purpose to practice what's in the video so I can use it in real life. So, if you don't mind kindly share the XL file for people to download. There are so many people asking for it here. Thank you. Have a good life.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
I am soon starting my first job on data analysis. This video is an absolute savior for getting myself prepared. May I get the sheet and practice on it? Thanks a lot!
It would be good if you provide the all data sets used in this video in description. So that everyone get in single click. Because now everyone has to mail you to get data set. Please provide the all data sets in description.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
Hey, thank you for watching our video. We will definitely look into your suggestions. Do subscribe and stay tuned for updates on our channel. Cheers :)