🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?OOWAk2aLEfk&Comments&KZbin 🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?OOWAk2aLEfk&Comments&KZbin 🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?OOWAk2aLEfk&Comments&KZbin 🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?OOWAk2aLEfk&Comments&KZbin
@kayodeadedeji92322 жыл бұрын
Good day - please how do i get a sample of the spreadsheet used in this tutorial?
@amoeba55473 жыл бұрын
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
@SimplilearnOfficial3 жыл бұрын
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@karthik-qj4bw2 жыл бұрын
@@SimplilearnOfficial shut up!
@Dr.ashwath2 жыл бұрын
@@karthik-qj4bw 🙄
@saraswatsaha7282 жыл бұрын
@@SimplilearnOfficial Can i get the excel used in the Video to keep it as refrence
@waliahad8239 Жыл бұрын
it takes 8 hours to complete this with practice thank you @simplilearn for such a wonderful session
@marcuslkms3 жыл бұрын
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.
@surendra19balco3 жыл бұрын
Yes it was not working can you help me actually I want drop down of cities according to state
@SimplilearnOfficial3 жыл бұрын
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@jemilmangukiya81343 жыл бұрын
Bro is it full course for beginner to advanced in Excel ?
@alfredcolemandadson12093 жыл бұрын
thanks so much. I got stuck indeed until I saw your post. thanks again
@adejimiadeolu4372 жыл бұрын
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.
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@mrCetus2 жыл бұрын
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
@SimplilearnOfficial2 жыл бұрын
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
@funkygoobermelon3 жыл бұрын
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!
@SimplilearnOfficial3 жыл бұрын
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 :)
@rubin9493 жыл бұрын
Amazing bro I hope you get all you want in life ! Human kind is amazing when people like you exist. Thank you so much !
@SimplilearnOfficial3 жыл бұрын
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!
@jemilmangukiya81343 жыл бұрын
Bro is it full course for beginner to advanced in Excel ?
@fifthcarcrash3 жыл бұрын
this is incredible! i come back everytime i forget something thanks a lott
@SimplilearnOfficial3 жыл бұрын
Happy to hear that!
@dexxxxxxxx3 жыл бұрын
Is it full Course?
@karthik-qj4bw2 жыл бұрын
@@dexxxxxxxx yes
@jahanshuvo3 жыл бұрын
Basically a great course! No fun! This is really amazingly instructive. Thanks for your hard work!
@SimplilearnOfficial3 жыл бұрын
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
@showkathali89113 жыл бұрын
i am shocked ,this very useful content is available on youtube for free,thanks simplilearn team.
@SimplilearnOfficial3 жыл бұрын
You are most welcome
@yogitasharma4752 Жыл бұрын
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.
@SimplilearnOfficial Жыл бұрын
We are glad that you have enjoyed your learning experience with us : )
@naimamunir1867 Жыл бұрын
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.
@Marsha-Boyd9 ай бұрын
This video is very useful for data entry setup. Thanks for your support.
@saurabhprakashgiri63533 жыл бұрын
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.
@SimplilearnOfficial3 жыл бұрын
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.
@surajgawade53623 жыл бұрын
Can you please sent me the Data sets used in this video My email ID is - surajgawadesg69@gmail.com
@saeenanimationstudio32853 жыл бұрын
@@surajgawade5362 hey suraj can you forward the sample sheets to me. That would be great. Thanks
@shreya64153 жыл бұрын
@@SimplilearnOfficial please send the datasets used in this video on mirrorviewl25@gmail.com
@freyanash62463 жыл бұрын
@@SimplilearnOfficial could you please send me the datasets used as well please? My email is nashf005@gmail.com Thank you so much in advance
@ahmed8asim Жыл бұрын
I learnt a lot from this generous course! Thanks a lot
@SimplilearnOfficial Жыл бұрын
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.
@snehanoolvi60902 жыл бұрын
I learned a lot from this great video. it is extremely interesting and informative Thank you so much simplilearn team !!
@SimplilearnOfficial2 жыл бұрын
Our pleasure!
@ojongpaulatakang9252 Жыл бұрын
Gratitude from Another data analyst in Cameroon.
@famayeisaac46292 жыл бұрын
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
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@tharineeban14643 жыл бұрын
Thank you for this incredible useful VDO , during lockdown, this is so meaningful
@SimplilearnOfficial3 жыл бұрын
Glad it was helpful!
@Asifkhan-of1di3 жыл бұрын
Amazing video god bless you dear.. Can you please share data set of that project??
@SimplilearnOfficial3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@alhajilawal6854 Жыл бұрын
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?
@rahulgaikwad40903 жыл бұрын
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 🙂
@SimplilearnOfficial3 жыл бұрын
Our pleasure 😊
@Pawvani2 жыл бұрын
Excellent explanation ..... Tq for uploading this video
@SimplilearnOfficial2 жыл бұрын
You're most welcome
@noreensayoc592 жыл бұрын
Thank you so much! Highly useful and well explained! :)
@SimplilearnOfficial2 жыл бұрын
You're very welcome!
@mohammedalam78073 жыл бұрын
This video is very useful for data entry setup. Thanks for your support.
@SimplilearnOfficial3 жыл бұрын
You are welcome
@Rose7982 жыл бұрын
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.
@sampsonrichiedoh48682 жыл бұрын
Thanks for the tutorial sir. Please kindly help me with the data's your using for the tutorial. I'm just a beginner. Thanks
@SimplilearnOfficial2 жыл бұрын
Hey, thank you for your suggestion. Do check out our other tutorial videos and subscribe to us to stay connected. Cheers :)
@manjweerapura57513 жыл бұрын
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?
@fkhan07673 жыл бұрын
exactly same doubt
@SimplilearnOfficial3 жыл бұрын
"Hi, Yes, you are correct. There is an error in the formula applied. The criteria range should have been static."
@abhishiktasarkar94362 жыл бұрын
sir thank you very much. it is a very wonderful video to understand data analytics in Excel
@SimplilearnOfficial2 жыл бұрын
You are most welcome
@saikatghosh903 жыл бұрын
You put such great content for free.. whats your business model .?
@SimplilearnOfficial3 жыл бұрын
Just trying to help our viewers out! Thank you for watching!
@okpalukuwilson94922 жыл бұрын
Thanks Simplilearn. Please I'll need the datasets used here to have a hands on practice with the course. Thank you!!!
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@lunistic72203 жыл бұрын
Hello Simplilearn, This tutorial is filled with learning, but kindly check that there is one dataset(lookup excel) file is missing in the drive.
@SimplilearnOfficial3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@momo18valves13 жыл бұрын
@@SimplilearnOfficial doesn't exist
@anastaysia2 жыл бұрын
@@SimplilearnOfficial I do not see it in the description or google drive. please assist
@vinayrudrapure8513 жыл бұрын
Such a great course ... Can get data set for practice..
@SimplilearnOfficial3 жыл бұрын
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.
@chaitanyathyagi73603 жыл бұрын
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?
@SimplilearnOfficial3 жыл бұрын
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!
@davida993 жыл бұрын
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
@successdavid89593 жыл бұрын
@@davida99 thank you
@aditigujar59223 жыл бұрын
Its a really good video...very very helpful....(just one Observation too much use of "BASICALLY" word)
@SimplilearnOfficial3 жыл бұрын
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 :)
@syedmuhammadshazanalirizvi69922 жыл бұрын
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
@sayedbaqai55243 жыл бұрын
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. 👍
@SimplilearnOfficial3 жыл бұрын
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.
@gautamarora4233 жыл бұрын
Could you please send it to me gautamarora436900@gmail.com
@koostrawberry3 жыл бұрын
could you pls share them with me
@NijatHajiyevv3 жыл бұрын
could you please share with me also?
@saurabhprakashgiri63533 жыл бұрын
Brother can you share the Dataset with me too. My mail id is: saurabhgiri141@gmail.com
@williamsjames42992 жыл бұрын
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?
@SimplilearnOfficial2 жыл бұрын
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
@adetunjiademola13303 жыл бұрын
This is beautiful... Where have been all these while? Wow! thank you so much
@SimplilearnOfficial3 жыл бұрын
You're welcome 😊
@shrutiomatic2 жыл бұрын
0:40 topics 11:05 sum 12:21 new sum 14:36 split 17:31 delimiter split
@SimplilearnOfficial2 жыл бұрын
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
@samuelogada6777 Жыл бұрын
Thanks Simplilearn for this awesome video
@SimplilearnOfficial Жыл бұрын
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.
@chukwuchinedu7933 жыл бұрын
Thank you simplilearn for a wonderful tutorials, I need help on how years and quarters were created quarterly
@SimplilearnOfficial3 жыл бұрын
Glad it was helpful!
@lucadiana22263 жыл бұрын
Highly recommend this video to anyone who need to sharpen their Excel skills.
@SimplilearnOfficial3 жыл бұрын
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.
@vineethvino033 жыл бұрын
Thanks a lot for putting out such a course on KZbin! Please, can I have the dataset to practice?
@SimplilearnOfficial3 жыл бұрын
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!
@vineethvino033 жыл бұрын
@@SimplilearnOfficial Can you share the datasets with me? It'd of great help to me.
@prernasrivastava28393 жыл бұрын
For datasets , you can explore kaggle .
@vineethvino033 жыл бұрын
@@prernasrivastava2839 Thank you!
@JiluJoseph-em5gc8 ай бұрын
It was very effective and informative, thank you very much👍
@adenekanalaminadedeji11373 жыл бұрын
Amazing tutorial. Is there any way I can get the sample data sheets to practice? Thank you.
@SimplilearnOfficial3 жыл бұрын
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.
@youngniche13 жыл бұрын
ahmeddimeji58@gmail.com I will need it too
@giftonwunyirigbo72363 жыл бұрын
@@SimplilearnOfficial giftonwunyirigbo@gmail.com I will need it to thanks
@akshaykalwar47303 жыл бұрын
@@giftonwunyirigbo7236 did you get the datasets?
@HaiLH_2k12 жыл бұрын
Respect for the tutorial, thank you very much!
@SimplilearnOfficial2 жыл бұрын
Glad it was helpful!
@abhinaysingh33153 жыл бұрын
Awesome content as always. Could you please share the data sheets used in this?
@SimplilearnOfficial3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@hendrixmweema33312 жыл бұрын
It's there in the description, download it's a zip file
@siddharthn2133 жыл бұрын
Thank you @Simplilearn for sending over the data set to practise!
@SimplilearnOfficial3 жыл бұрын
Glad it was helpful!
@41dhir3 жыл бұрын
@@SimplilearnOfficial Hey! I need the dataset for practice too. My email is dhir.3dharankar@gmail.com
@aryanraykar21243 жыл бұрын
@@41dhir hey can you share the excel sheet with me plz aryan.20raykar@gmail.com
@fitwithbsb74333 жыл бұрын
Bro can you please send me the data sheets pls, bhushanborse20@gmail.com
@downtownpharmacy36693 жыл бұрын
please send the sample excel sheet to practice at( roshanguragain90@gmail.com)
@SimplilearnOfficial3 жыл бұрын
We hope this video was useful. The link for the dataset used in the video is provided in the description. Thanks!
@selvasubha883 жыл бұрын
Thank u @Simplilearn for ur dataset.It is helpful.
@wilfredsedofiamassiasta70713 жыл бұрын
Hello, please can I get the dataset you used in the video, this is my email wilfredmassias.wm@gmail.com
@samwelmasanzu83483 жыл бұрын
samwelmasanzu@gmail.com, please send the practice sheets for practical.
@shafayatstorylearning43423 жыл бұрын
@Simplilearn pls send me the data set at sabuz2325@yahoo.com
@datasurfer99583 жыл бұрын
Can I get the sheet for the above exercise?
@viralshaha34652 жыл бұрын
Subscribed to your channel simply because content is amazing and easily understandable. Thank you for the great work that you are doing.
@SimplilearnOfficial2 жыл бұрын
Welcome aboard!
@amarpatil1083 жыл бұрын
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?
@ashfaquesayyed9229 Жыл бұрын
Great lecture sir , Thank you so much simplilearn
@SimplilearnOfficial Жыл бұрын
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.
@DELICANA20013 жыл бұрын
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?
@SimplilearnOfficial3 жыл бұрын
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.
@jitendrakushwah53593 жыл бұрын
@@SimplilearnOfficial jitendra7500@gmail.com
@oladimejibamidele11733 жыл бұрын
@@SimplilearnOfficial deleoladimeji@yahoo.com I would really appreciate it if I get the data sheets too. Thanks!
@@SimplilearnOfficial yatiememories@gmail.com me too! mind sharing sir? Youre vedio really helpful
@ranajaymin42203 жыл бұрын
Excellent!! Informative and Practical Content Based Video for Beginners
@SimplilearnOfficial3 жыл бұрын
Glad it was helpful!
@grt-amat3 жыл бұрын
Could you please share the Excel sheet so I can practice along? Thanks!
@SimplilearnOfficial3 жыл бұрын
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.
@kartikaydevsharma35173 жыл бұрын
Can you share it to me also? My email is: sharmakartikaydev@gmail.com
@grt-amat3 жыл бұрын
@@SimplilearnOfficial yes sure, my email: gamatdarso@gmail.com thank you very much!
@tuandhtl3 жыл бұрын
@@SimplilearnOfficial can you share it to my email: tuandhtl@gmail.com Thanks alot
@akinbolaakinleye58783 жыл бұрын
@@SimplilearnOfficial can you share it to email too akinleye.akinbola123@gmail.com
@bukupandora3 жыл бұрын
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.
@SimplilearnOfficial3 жыл бұрын
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
@VIVEK-ld3ey3 жыл бұрын
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
@SimplilearnOfficial3 жыл бұрын
"Hello, By default, MS Excel copies the count if formula for sales rep greater than 3 and populates in throughout the colum."
@offiongakpabio802 жыл бұрын
@@SimplilearnOfficialsame thing here, i applied it but my excel couldn't figure out which column to apply the greater than criteria
@attaonoja45402 жыл бұрын
Thank you so much for this simplified teaching. Can you send me the data for practice?
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@adaiprosperbrou95683 жыл бұрын
You give certificates after having completed courses
@SimplilearnOfficial3 жыл бұрын
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!
@Dr.ashwath2 жыл бұрын
Great Sir, and Thank you sir.
@SimplilearnOfficial2 жыл бұрын
Most welcome
@madhumitasarkar16832 жыл бұрын
Sir, It will be helpful, if you share the data set for practice
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@karnajahnavi3279 Жыл бұрын
Do we want any prior knowledge.. To start this course?
@ahmadmahadi88273 жыл бұрын
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.
@SimplilearnOfficial3 жыл бұрын
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.
@eunx75703 жыл бұрын
@@SimplilearnOfficial please share data set to elsiefunk12@gmail.com for practice. please keep email address hidden. thanks
@mechanicalbrand4442 жыл бұрын
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 🙏🙏🙏
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@kishanbhise47333 жыл бұрын
Thank you so much for this video...god bless this channel..!
@SimplilearnOfficial3 жыл бұрын
Our pleasure!
@Perspective88473 жыл бұрын
Could you please share the link to the exercise and example files?
@pragyadangarh30533 жыл бұрын
Would you please share the data sets for practice?
@karthigalakshmanan70173 жыл бұрын
The content is so informative. could you please share the dataset?
@SimplilearnOfficial3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@krystledianne3707 Жыл бұрын
I love this channel, please continue to make videos
@SimplilearnOfficial Жыл бұрын
We are glad that you have enjoyed your learning experience with us : )
@md.sarfarazhussain41442 жыл бұрын
Kindly provide all the excel sheets which you are using in the video.
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@ashishthakur58853 жыл бұрын
He explained everything in a very lucid way... Thanks a lot.... Can I get these sheets?
@SimplilearnOfficial3 жыл бұрын
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.
@ashishthakur58853 жыл бұрын
@@SimplilearnOfficial rudeashishthakur@gmail.com
@viveksankrit57443 жыл бұрын
@@SimplilearnOfficial sankrit97@gmail.com
@shalinijoshi16983 жыл бұрын
This video is amazing.. I would like to go ahead in this... Can i have this datasets for more practicing on PC? Plz do reply
@SimplilearnOfficial3 жыл бұрын
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.
@DevSharma-eg3sx3 жыл бұрын
@@SimplilearnOfficial can I have get some datasets with question like you have in videos for more practicing on PC .
@shanmugakrish45033 жыл бұрын
Thanks for the video... can you please send the Data set
@SimplilearnOfficial3 жыл бұрын
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.
@shanmugakrish45033 жыл бұрын
@@SimplilearnOfficial my mailid is Shanmugakrish96@gmail.com
@saib72313 жыл бұрын
Very very useful video.
@SimplilearnOfficial3 жыл бұрын
Glad it was helpful!
@salmanayyoob53823 жыл бұрын
Its vary amazing video and very much helpful thankyou sir for this very valuable video sir , BUT i think vlookup file is missing in database can you please upload this file too so we learn very quickly.
@SimplilearnOfficial3 жыл бұрын
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.
@salmanayyoob53823 жыл бұрын
@@SimplilearnOfficial Sir please make a video on , Data science roadmap.
@salmanayyoob53823 жыл бұрын
@@SimplilearnOfficial sir I have completed this video , how can I get certificate??
@localtoglobal7433 жыл бұрын
Amazing video..really very helpful for beginners..plz share the dataset for practice more
@SimplilearnOfficial3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@soumenpati58653 жыл бұрын
This is video is super cool 😎😎😎👍 and thank you so much for creating this❤️❤️❤️. Can I get excel file for practicing on my pc?🙏
@SimplilearnOfficial3 жыл бұрын
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.
@soumenpati58653 жыл бұрын
@@SimplilearnOfficial sir you have not provided the file. I have already given my email in the above. Please send me the file
@GenTalk163 жыл бұрын
Hello simplilearn, thanks for this amazing tutorial can u please send the excel sheet to practice... please
@SimplilearnOfficial3 жыл бұрын
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.
@santoshhospet50253 жыл бұрын
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.
@SimplilearnOfficial3 жыл бұрын
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.
@moresources3 жыл бұрын
@@SimplilearnOfficial hi! youre vedio really healpful. Could you share me also the dataset for my practices? yatiememories@gmail.com TQ!
@manjunathhipparagi84933 жыл бұрын
@@moresources if you have that data sample could you mail that me as well
@subhodhks18793 жыл бұрын
@@manjunathhipparagi8493 Hi could you please mail me the data set here: kssubhodh99@gmail.com
@subhodhks18793 жыл бұрын
@@moresources Hi could you please mail me the data set here: kssubhodh99@gmail.com
@sayedbaqai55243 жыл бұрын
Great explanation thanks. Can you please share data set
@SimplilearnOfficial3 жыл бұрын
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.
@JesusRamAllahWaheguru3 жыл бұрын
hello there, can you please send me the dataset required for this course at deep.dnr@gmail.com
@SimplilearnOfficial3 жыл бұрын
@@JesusRamAllahWaheguru Sent!
@siddharthrout7382 жыл бұрын
I am very intrested in this analyst job..
@SimplilearnOfficial2 жыл бұрын
Data Analyst career opportunities are on the rise and are in demand due to increasing data collection and usage. . If you are interested in deep-dive into this, please refer to this link: www.simplilearn.com/data-analyst-masters-certification-training-course
@adegbegiibukun87692 жыл бұрын
Good day, thanks for this explicit lecture. can I get the data set used in the course of this lecture. thanks in anticipation.
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@uzairrana2895 Жыл бұрын
Thankyou so much for this tutorial
@shivam2203 жыл бұрын
Part 51:00 it will not sort by S.County, Central, and N.County and I did it exact way
@SimplilearnOfficial3 жыл бұрын
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@abirsengupta27302 жыл бұрын
Yes mine tooo... its in Central, S.County, N.County sequence
@tranthanhnhan6243 жыл бұрын
Thank you so much for sharing this video. Could you please share the data set with me to practice?
@SimplilearnOfficial3 жыл бұрын
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.
@ricksanchez17353 жыл бұрын
@@SimplilearnOfficial me too please
@vairagborad3 жыл бұрын
@@ricksanchez1735 you got that data set???
@ssef133 жыл бұрын
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!
@amanjitkaur94782 жыл бұрын
Can u advise me more on the skillset
@ruparanjanmohapatra7262 жыл бұрын
Have you started your Data Analyst job? How's it going.
@sabinakhan35823 жыл бұрын
Thanks for this video. Can you please share datasheet. It willbe be helpful for me😊
@SimplilearnOfficial3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@fennasolvia Жыл бұрын
Great Work. How can I move annotations from Universal to GA4?
@LivyNt Жыл бұрын
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
@SimplilearnOfficial Жыл бұрын
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
@nainitanandeshwar9512 Жыл бұрын
Nice Video! Can you send the lookup sheets for practice.
@ashwinichinnappa78793 жыл бұрын
It was such an informative video and thank you so much for that. But please do avoid the repetition of the word "Basically" everywhere, use it where it's necessary. Because the video is filled with millions of "Basically" which really creates an irritation!
@SimplilearnOfficial3 жыл бұрын
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@JesusRamAllahWaheguru Жыл бұрын
it is showing "false" even for the sales > 3 as well. According to you it should have shown "true" instead @1:32:50
@ahmedazeem7566 Жыл бұрын
Any short term course available for MBA finance students ? share it please.
@arshadibrahim7652 жыл бұрын
Thanks for the video.
@SimplilearnOfficial2 жыл бұрын
You are welcome!
@NidhiBMehta3 жыл бұрын
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.
@SimplilearnOfficial3 жыл бұрын
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.
@Perspective88473 жыл бұрын
@@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
@ambowchannel62193 жыл бұрын
@@SimplilearnOfficial I will appreciate if the dataset can be send to me too investorambow@gmail.com
@subhodhks18793 жыл бұрын
@@Perspective8847 Hi could you please mail me the data set here: kssubhodh99@gmail.com
@subhodhks18793 жыл бұрын
@P20CC010_VISHAL KUMAR KORIYA SVNIT Hi could you please mail me the data set here: kssubhodh99@gmail.com
@amirhusseinfarahmand2209 Жыл бұрын
Amazing tutorial!
@AdeKaryadi3 жыл бұрын
nice tutorial, thanks
@SimplilearnOfficial3 жыл бұрын
You're welcome!
@smiles7749 Жыл бұрын
Hi @Simplilearn thank you for the tutorial. Is there a way I can get the data set for practice.
@rohan2767 Жыл бұрын
Simplilearn!!Thank you so much...please check in the data base look up excel sheet is missing ,would be grateful if somebody can provide the same. Thank you