🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?OOWAk2aLEfk&Comments&RUclips 🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?OOWAk2aLEfk&Comments&RUclips 🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?OOWAk2aLEfk&Comments&RUclips 🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?OOWAk2aLEfk&Comments&RUclips
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.
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.
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.
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 🙂
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.
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
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.
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?
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.
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
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 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.
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.
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!
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!
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 :)
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?
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?
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 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.
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!
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
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, 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.
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!
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.
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 🙏🙏🙏
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, 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.
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.
🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?OOWAk2aLEfk&Comments&RUclips
🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?OOWAk2aLEfk&Comments&RUclips
🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?OOWAk2aLEfk&Comments&RUclips
🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?OOWAk2aLEfk&Comments&RUclips
Good day - please how do i get a sample of the spreadsheet used in this tutorial?
34:02 total,avg row
35:10 drop downs
37:58 importing data
49:11 custom sort
53:45 advanced filter
1:12:29 sumifs
1:25:46 not condition
1:29:11 countif
1:41:00 custom color scale and editing
1:47:28 data bars
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@@SimplilearnOfficial shut up!
@@karthik-qj4bw 🙄
@@SimplilearnOfficial Can i get the excel used in the Video to keep it as refrence
it takes 8 hours to complete this with practice
thank you @simplilearn for such a wonderful session
34:02 total,avg row
35:10 drop downs
37:58 importing data
49:11 custom sort
53:45 advanced filter
1:12:29 sumifs
1:25:46 not condition
1:29:11 countif
1:41:00 custom color scale and editing
1:47:28 data bars
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
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.
Yes it was not working can you help me actually I want drop down of cities according to state
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
Bro is it full course for beginner to advanced in Excel ?
thanks so much. I got stuck indeed until I saw your post. thanks again
this is incredible! i come back everytime i forget something thanks a lott
Happy to hear that!
Is it full Course?
@@dexxxxxxxx yes
Basically a great course! No fun! This is really amazingly instructive. Thanks for your hard work!
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
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.
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. 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.
We are glad that you have enjoyed your learning experience with us : )
i am shocked ,this very useful content is available on youtube for free,thanks simplilearn team.
You are most welcome
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 :)
Amazing bro I hope you get all you want in life ! Human kind is amazing when people like you exist. Thank you so much !
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!
Bro is it full course for beginner to advanced in Excel ?
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.
This video is very useful for data entry setup. Thanks for your support.
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.
Can you please sent me the Data sets used in this video
My email ID is - surajgawadesg69@gmail.com
@@surajgawade5362 hey suraj can you forward the sample sheets to me. That would be great. Thanks
@@SimplilearnOfficial please send the datasets used in this video on
mirrorviewl25@gmail.com
@@SimplilearnOfficial could you please send me the datasets used as well please? My email is nashf005@gmail.com
Thank you so much in advance
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 🙂
Our pleasure 😊
I learned a lot from this great video. it is extremely interesting and informative Thank you so much simplilearn team !!
Our pleasure!
Gratitude from Another data analyst in Cameroon.
Thank you for this incredible useful VDO , during lockdown, this is so meaningful
Glad it was helpful!
I learnt a lot from this generous course!
Thanks a lot
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 hope this video was useful. The link for the dataset used in the video is provided in the description. Thanks!
Thank u @Simplilearn for ur dataset.It is helpful.
Hello, please can I get the dataset you used in the video, this is my email wilfredmassias.wm@gmail.com
samwelmasanzu@gmail.com, please send the practice sheets for practical.
@Simplilearn pls send me the data set at sabuz2325@yahoo.com
Can I get the sheet for the above exercise?
It was very effective and informative, thank you very much👍
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
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Excellent explanation .....
Tq for uploading this video
You're most welcome
Thank you so much! Highly useful and well explained! :)
You're very welcome!
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.
Could you please send it to me gautamarora436900@gmail.com
could you pls share them with me
could you please share with me also?
Brother can you share the Dataset with me too. My mail id is: saurabhgiri141@gmail.com
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?
exactly same doubt
"Hi,
Yes, you are correct. There is an error in the formula applied. The criteria range should have been static."
sir thank you very much. it is a very wonderful video to understand data analytics in Excel
You are most welcome
1:32:24 I think we have to put a dollar$ sign in the formula between C and 2 and C and 44 if we want to drag and drop. Please correct me if I am wrong
This is beautiful...
Where have been all these while?
Wow!
thank you so much
You're welcome 😊
Amazing video god bless you dear.. Can you please share data set of that project??
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Subscribed to your channel simply because content is amazing and easily understandable. Thank you for the great work that you are doing.
Welcome aboard!
0:40 topics
11:05 sum
12:21 new sum
14:36 split
17:31 delimiter split
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
Thanks Simplilearn for this awesome video
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.
I love this course, it is exploratory. Thanks to you guys. However, the lookup file in 2:37:06 is missing in the drive. Any help?
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
Such a great course ... Can get data set for practice..
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.
You put such great content for free.. whats your business model .?
Just trying to help our viewers out! Thank you for watching!
This video is very useful for data entry setup. Thanks for your support.
You are welcome
Thank you simplilearn for a wonderful tutorials, I need help on how years and quarters were created quarterly
Glad it was helpful!
Excellent!! Informative and Practical Content Based Video for Beginners
Glad it was helpful!
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.
Great lecture sir , Thank you so much simplilearn
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.
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
"Hello,
By default, MS Excel copies the count if formula for sales rep greater than 3 and populates in throughout the colum."
@@SimplilearnOfficialsame thing here, i applied it but my excel couldn't figure out which column to apply the greater than criteria
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.
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
Thanks a lot for putting out such a course on RUclips! Please, can I have the dataset to practice?
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!
@@SimplilearnOfficial Can you share the datasets with me? It'd of great help to me.
For datasets , you can explore kaggle .
@@prernasrivastava2839 Thank you!
Respect for the tutorial, thank you very much!
Glad it was helpful!
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!
Yes in my NYC area low paying jobs in data analytics ask for some excel skill, that alone can get your foot through the door
@@davida99 thank you
Its a really good video...very very helpful....(just one Observation too much use of "BASICALLY" word)
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 :)
Hello Simplilearn,
This tutorial is filled with learning, but kindly check that there is one dataset(lookup excel) file is missing in the drive.
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@@SimplilearnOfficial doesn't exist
@@SimplilearnOfficial I do not see it in the description or google drive. please assist
nice tutorial, thanks
You're welcome!
Awesome content as always. Could you please share the data sheets used in this?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
It's there in the description, download it's a zip file
Great Sir, and Thank you sir.
Most welcome
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?
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?
Amazing tutorial. Is there any way I can get the sample data sheets 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.
ahmeddimeji58@gmail.com I will need it too
@@SimplilearnOfficial giftonwunyirigbo@gmail.com I will need it to thanks
@@Onyinyedevs did you get the datasets?
Thank you @Simplilearn for sending over the data set to practise!
Glad it was helpful!
@@SimplilearnOfficial Hey! I need the dataset for practice too. My email is dhir.3dharankar@gmail.com
@@41dhir hey can you share the excel sheet with me plz aryan.20raykar@gmail.com
Bro can you please send me the data sheets pls, bhushanborse20@gmail.com
please send the sample excel sheet to practice at( roshanguragain90@gmail.com)
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.
@@SimplilearnOfficial jitendra7500@gmail.com
@@SimplilearnOfficial deleoladimeji@yahoo.com I would really appreciate it if I get the data sheets too. Thanks!
@@SimplilearnOfficial siddheshthavre1997@gmail.com
@@SimplilearnOfficial yatiememories@gmail.com me too! mind sharing sir? Youre vedio really helpful
Thanks Simplilearn. Please I'll need the datasets used here to have a hands on practice with the course. Thank you!!!
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Could you please share the Excel sheet so I can practice along? 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.
Can you share it to me also?
My email is: sharmakartikaydev@gmail.com
@@SimplilearnOfficial yes sure, my email: gamatdarso@gmail.com thank you very much!
@@SimplilearnOfficial can you share it to my email: tuandhtl@gmail.com
Thanks alot
@@SimplilearnOfficial can you share it to email too akinleye.akinbola123@gmail.com
Very very useful video.
Glad it was helpful!
sir you have not gave us lookup file in zip
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Part 51:00 it will not sort by S.County, Central, and N.County and I did it exact way
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
Yes mine tooo... its in Central, S.County, N.County sequence
You give certificates after having completed courses
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 love this channel, please continue to make videos
We are glad that you have enjoyed your learning experience with us : )
it is showing "false" even for the sales > 3 as well. According to you it should have shown "true" instead @1:32:50
Thank you so much for this video...god bless this channel..!
Our pleasure!
Could you please share the link to the exercise and example files?
Thanks for the tutorial sir. Please kindly help me with the data's your using for the tutorial. I'm just a beginner. Thanks
Hey, thank you for your suggestion. Do check out our other tutorial videos and subscribe to us to stay connected. Cheers :)
Amazing video..really very helpful for beginners..plz share the dataset for practice more
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Amazing tutorial!
Best Best Best🤩🤩🤩🤩
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
Very well explained. 👍🏻
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
2:37:00 The excel workbook used for *Sorting and Filtering* is not provided in the Google Drive Folder... where can I find it?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
This is video is super cool 😎😎😎👍 and thank you so much for creating this❤️❤️❤️. Can I get excel file for practicing on my pc?🙏
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 sir you have not provided the file. I have already given my email in the above. Please send me the file
Thankyou so much for this tutorial
Thanks for the video.
You are welcome!
Very nice ajay bhaiya
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.
Thank you so much. So helpful 🎉
You're so welcome!
Amazing work.
Thank you! Cheers!
Great explanation thanks.
Can you please share data set
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 there, can you please send me the dataset required for this course at deep.dnr@gmail.com
@@JesusRamAllahWaheguru Sent!
at 3:21:05 the 3rd question LOOKUP FORMULA does'nt work , can you explain me why
Thank you so much for this simplified teaching. Can you send me the data for practice?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Highly recommend this video to anyone who need to sharpen their Excel skills.
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.
Thanks Simplilearn
You're welcome!
Sir, It will be helpful, if you share the data set for practice
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. 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!
Can u advise me more on the skillset
Have you started your Data Analyst job? How's it going.
@4:02:04 Actually the squared deviations of the original data from the mean is Variance right?
guys can anybody tell me how the formula figured out >3 is indicating sales above 3 only and any other field? I am referring to 1:31:38
thankyou for this.
Welcome!
The content is so informative. could you please share the dataset?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Thanks!
Welcome!
useful thank you
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.
Would you please share the data sets for practice?
useful session
Glad to hear that!
1:32:55 Boolean values for cell H19 seems to be incorrect. Multiple values below it are also incorrect. Any reason for the aforementioned error?
"Hi,
The formula was not copied correctly in the cells below, hence the error. Apologies for that."
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 🙏🙏🙏
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Thanks for the video... can you please send the Data set
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 my mailid is Shanmugakrish96@gmail.com
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.
@@SimplilearnOfficial hi! youre vedio really healpful. Could you share me also the dataset for my practices? yatiememories@gmail.com TQ!
@@moresources if you have that data sample could you mail that me as well
@@manjunathhipparagi8493 Hi
could you please mail me the data set here: kssubhodh99@gmail.com
@@moresources Hi could you please mail me the data set here: kssubhodh99@gmail.com
Nice Video! Can you send the lookup sheets for practice.
Thanks for this video. Can you please share datasheet. It willbe be helpful for me😊
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
thanks god bless!!!!!!
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.