Excel Data Analytics Full Course | Essential Skills For Data Analysis In Excel | Simplilearn

  Рет қаралды 1,948,646

Simplilearn

Simplilearn

Күн бұрын

Пікірлер: 1 100
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
🔥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
@kayodeadedeji9232
@kayodeadedeji9232 2 жыл бұрын
Good day - please how do i get a sample of the spreadsheet used in this tutorial?
@amoeba5547
@amoeba5547 3 жыл бұрын
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
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@karthik-qj4bw
@karthik-qj4bw 2 жыл бұрын
@@SimplilearnOfficial shut up!
@Dr.ashwath
@Dr.ashwath 2 жыл бұрын
@@karthik-qj4bw 🙄
@saraswatsaha728
@saraswatsaha728 2 жыл бұрын
@@SimplilearnOfficial Can i get the excel used in the Video to keep it as refrence
@waliahad8239
@waliahad8239 Жыл бұрын
it takes 8 hours to complete this with practice thank you @simplilearn for such a wonderful session
@marcuslkms
@marcuslkms 3 жыл бұрын
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.
@surendra19balco
@surendra19balco 3 жыл бұрын
Yes it was not working can you help me actually I want drop down of cities according to state
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@jemilmangukiya8134
@jemilmangukiya8134 3 жыл бұрын
Bro is it full course for beginner to advanced in Excel ?
@alfredcolemandadson1209
@alfredcolemandadson1209 3 жыл бұрын
thanks so much. I got stuck indeed until I saw your post. thanks again
@adejimiadeolu437
@adejimiadeolu437 2 жыл бұрын
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.
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@mrCetus
@mrCetus 2 жыл бұрын
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
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
@funkygoobermelon
@funkygoobermelon 3 жыл бұрын
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!
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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 :)
@rubin949
@rubin949 3 жыл бұрын
Amazing bro I hope you get all you want in life ! Human kind is amazing when people like you exist. Thank you so much !
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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!
@jemilmangukiya8134
@jemilmangukiya8134 3 жыл бұрын
Bro is it full course for beginner to advanced in Excel ?
@fifthcarcrash
@fifthcarcrash 3 жыл бұрын
this is incredible! i come back everytime i forget something thanks a lott
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Happy to hear that!
@dexxxxxxxx
@dexxxxxxxx 3 жыл бұрын
Is it full Course?
@karthik-qj4bw
@karthik-qj4bw 2 жыл бұрын
@@dexxxxxxxx yes
@jahanshuvo
@jahanshuvo 3 жыл бұрын
Basically a great course! No fun! This is really amazingly instructive. Thanks for your hard work!
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
@showkathali8911
@showkathali8911 3 жыл бұрын
i am shocked ,this very useful content is available on youtube for free,thanks simplilearn team.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
You are most welcome
@yogitasharma4752
@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
@SimplilearnOfficial Жыл бұрын
We are glad that you have enjoyed your learning experience with us : )
@naimamunir1867
@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-Boyd
@Marsha-Boyd 9 ай бұрын
This video is very useful for data entry setup. Thanks for your support.
@saurabhprakashgiri6353
@saurabhprakashgiri6353 3 жыл бұрын
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.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@surajgawade5362
@surajgawade5362 3 жыл бұрын
Can you please sent me the Data sets used in this video My email ID is - surajgawadesg69@gmail.com
@saeenanimationstudio3285
@saeenanimationstudio3285 3 жыл бұрын
@@surajgawade5362 hey suraj can you forward the sample sheets to me. That would be great. Thanks
@shreya6415
@shreya6415 3 жыл бұрын
@@SimplilearnOfficial please send the datasets used in this video on mirrorviewl25@gmail.com
@freyanash6246
@freyanash6246 3 жыл бұрын
@@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
@ahmed8asim Жыл бұрын
I learnt a lot from this generous course! Thanks a lot
@SimplilearnOfficial
@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.
@snehanoolvi6090
@snehanoolvi6090 2 жыл бұрын
I learned a lot from this great video. it is extremely interesting and informative Thank you so much simplilearn team !!
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Our pleasure!
@ojongpaulatakang9252
@ojongpaulatakang9252 Жыл бұрын
Gratitude from Another data analyst in Cameroon.
@famayeisaac4629
@famayeisaac4629 2 жыл бұрын
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
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@tharineeban1464
@tharineeban1464 3 жыл бұрын
Thank you for this incredible useful VDO , during lockdown, this is so meaningful
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Glad it was helpful!
@Asifkhan-of1di
@Asifkhan-of1di 3 жыл бұрын
Amazing video god bless you dear.. Can you please share data set of that project??
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@alhajilawal6854
@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?
@rahulgaikwad4090
@rahulgaikwad4090 3 жыл бұрын
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 🙂
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Our pleasure 😊
@Pawvani
@Pawvani 2 жыл бұрын
Excellent explanation ..... Tq for uploading this video
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
You're most welcome
@noreensayoc59
@noreensayoc59 2 жыл бұрын
Thank you so much! Highly useful and well explained! :)
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
You're very welcome!
@mohammedalam7807
@mohammedalam7807 3 жыл бұрын
This video is very useful for data entry setup. Thanks for your support.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
You are welcome
@Rose798
@Rose798 2 жыл бұрын
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.
@sampsonrichiedoh4868
@sampsonrichiedoh4868 2 жыл бұрын
Thanks for the tutorial sir. Please kindly help me with the data's your using for the tutorial. I'm just a beginner. Thanks
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Hey, thank you for your suggestion. Do check out our other tutorial videos and subscribe to us to stay connected. Cheers :)
@manjweerapura5751
@manjweerapura5751 3 жыл бұрын
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?
@fkhan0767
@fkhan0767 3 жыл бұрын
exactly same doubt
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
"Hi, Yes, you are correct. There is an error in the formula applied. The criteria range should have been static."
@abhishiktasarkar9436
@abhishiktasarkar9436 2 жыл бұрын
sir thank you very much. it is a very wonderful video to understand data analytics in Excel
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
You are most welcome
@saikatghosh90
@saikatghosh90 3 жыл бұрын
You put such great content for free.. whats your business model .?
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Just trying to help our viewers out! Thank you for watching!
@okpalukuwilson9492
@okpalukuwilson9492 2 жыл бұрын
Thanks Simplilearn. Please I'll need the datasets used here to have a hands on practice with the course. Thank you!!!
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@lunistic7220
@lunistic7220 3 жыл бұрын
Hello Simplilearn, This tutorial is filled with learning, but kindly check that there is one dataset(lookup excel) file is missing in the drive.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@momo18valves1
@momo18valves1 3 жыл бұрын
@@SimplilearnOfficial doesn't exist
@anastaysia
@anastaysia 2 жыл бұрын
@@SimplilearnOfficial I do not see it in the description or google drive. please assist
@vinayrudrapure851
@vinayrudrapure851 3 жыл бұрын
Such a great course ... Can get data set for practice..
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@chaitanyathyagi7360
@chaitanyathyagi7360 3 жыл бұрын
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?
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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!
@davida99
@davida99 3 жыл бұрын
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
@successdavid8959
@successdavid8959 3 жыл бұрын
@@davida99 thank you
@aditigujar5922
@aditigujar5922 3 жыл бұрын
Its a really good video...very very helpful....(just one Observation too much use of "BASICALLY" word)
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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 :)
@syedmuhammadshazanalirizvi6992
@syedmuhammadshazanalirizvi6992 2 жыл бұрын
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
@sayedbaqai5524
@sayedbaqai5524 3 жыл бұрын
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. 👍
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@gautamarora423
@gautamarora423 3 жыл бұрын
Could you please send it to me gautamarora436900@gmail.com
@koostrawberry
@koostrawberry 3 жыл бұрын
could you pls share them with me
@NijatHajiyevv
@NijatHajiyevv 3 жыл бұрын
could you please share with me also?
@saurabhprakashgiri6353
@saurabhprakashgiri6353 3 жыл бұрын
Brother can you share the Dataset with me too. My mail id is: saurabhgiri141@gmail.com
@williamsjames4299
@williamsjames4299 2 жыл бұрын
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?
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
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
@adetunjiademola1330
@adetunjiademola1330 3 жыл бұрын
This is beautiful... Where have been all these while? Wow! thank you so much
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
You're welcome 😊
@shrutiomatic
@shrutiomatic 2 жыл бұрын
0:40 topics 11:05 sum 12:21 new sum 14:36 split 17:31 delimiter split
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
@samuelogada6777
@samuelogada6777 Жыл бұрын
Thanks Simplilearn for this awesome video
@SimplilearnOfficial
@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.
@chukwuchinedu793
@chukwuchinedu793 3 жыл бұрын
Thank you simplilearn for a wonderful tutorials, I need help on how years and quarters were created quarterly
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Glad it was helpful!
@lucadiana2226
@lucadiana2226 3 жыл бұрын
Highly recommend this video to anyone who need to sharpen their Excel skills.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@vineethvino03
@vineethvino03 3 жыл бұрын
Thanks a lot for putting out such a course on KZbin! Please, can I have the dataset to practice?
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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!
@vineethvino03
@vineethvino03 3 жыл бұрын
@@SimplilearnOfficial Can you share the datasets with me? It'd of great help to me.
@prernasrivastava2839
@prernasrivastava2839 3 жыл бұрын
For datasets , you can explore kaggle .
@vineethvino03
@vineethvino03 3 жыл бұрын
@@prernasrivastava2839 Thank you!
@JiluJoseph-em5gc
@JiluJoseph-em5gc 8 ай бұрын
It was very effective and informative, thank you very much👍
@adenekanalaminadedeji1137
@adenekanalaminadedeji1137 3 жыл бұрын
Amazing tutorial. Is there any way I can get the sample data sheets to practice? Thank you.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@youngniche1
@youngniche1 3 жыл бұрын
ahmeddimeji58@gmail.com I will need it too
@giftonwunyirigbo7236
@giftonwunyirigbo7236 3 жыл бұрын
@@SimplilearnOfficial giftonwunyirigbo@gmail.com I will need it to thanks
@akshaykalwar4730
@akshaykalwar4730 3 жыл бұрын
@@giftonwunyirigbo7236 did you get the datasets?
@HaiLH_2k1
@HaiLH_2k1 2 жыл бұрын
Respect for the tutorial, thank you very much!
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Glad it was helpful!
@abhinaysingh3315
@abhinaysingh3315 3 жыл бұрын
Awesome content as always. Could you please share the data sheets used in this?
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@hendrixmweema3331
@hendrixmweema3331 2 жыл бұрын
It's there in the description, download it's a zip file
@siddharthn213
@siddharthn213 3 жыл бұрын
Thank you @Simplilearn for sending over the data set to practise!
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Glad it was helpful!
@41dhir
@41dhir 3 жыл бұрын
@@SimplilearnOfficial Hey! I need the dataset for practice too. My email is dhir.3dharankar@gmail.com
@aryanraykar2124
@aryanraykar2124 3 жыл бұрын
@@41dhir hey can you share the excel sheet with me plz aryan.20raykar@gmail.com
@fitwithbsb7433
@fitwithbsb7433 3 жыл бұрын
Bro can you please send me the data sheets pls, bhushanborse20@gmail.com
@downtownpharmacy3669
@downtownpharmacy3669 3 жыл бұрын
please send the sample excel sheet to practice at( roshanguragain90@gmail.com)
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
We hope this video was useful. The link for the dataset used in the video is provided in the description. Thanks!
@selvasubha88
@selvasubha88 3 жыл бұрын
Thank u @Simplilearn for ur dataset.It is helpful.
@wilfredsedofiamassiasta7071
@wilfredsedofiamassiasta7071 3 жыл бұрын
Hello, please can I get the dataset you used in the video, this is my email wilfredmassias.wm@gmail.com
@samwelmasanzu8348
@samwelmasanzu8348 3 жыл бұрын
samwelmasanzu@gmail.com, please send the practice sheets for practical.
@shafayatstorylearning4342
@shafayatstorylearning4342 3 жыл бұрын
@Simplilearn pls send me the data set at sabuz2325@yahoo.com
@datasurfer9958
@datasurfer9958 3 жыл бұрын
Can I get the sheet for the above exercise?
@viralshaha3465
@viralshaha3465 2 жыл бұрын
Subscribed to your channel simply because content is amazing and easily understandable. Thank you for the great work that you are doing.
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Welcome aboard!
@amarpatil108
@amarpatil108 3 жыл бұрын
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
@ashfaquesayyed9229 Жыл бұрын
Great lecture sir , Thank you so much simplilearn
@SimplilearnOfficial
@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.
@DELICANA2001
@DELICANA2001 3 жыл бұрын
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?
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@jitendrakushwah5359
@jitendrakushwah5359 3 жыл бұрын
@@SimplilearnOfficial jitendra7500@gmail.com
@oladimejibamidele1173
@oladimejibamidele1173 3 жыл бұрын
@@SimplilearnOfficial deleoladimeji@yahoo.com I would really appreciate it if I get the data sheets too. Thanks!
@siddheshthavre738
@siddheshthavre738 3 жыл бұрын
@@SimplilearnOfficial siddheshthavre1997@gmail.com
@moresources
@moresources 3 жыл бұрын
@@SimplilearnOfficial yatiememories@gmail.com me too! mind sharing sir? Youre vedio really helpful
@ranajaymin4220
@ranajaymin4220 3 жыл бұрын
Excellent!! Informative and Practical Content Based Video for Beginners
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Glad it was helpful!
@grt-amat
@grt-amat 3 жыл бұрын
Could you please share the Excel sheet so I can practice along? Thanks!
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@kartikaydevsharma3517
@kartikaydevsharma3517 3 жыл бұрын
Can you share it to me also? My email is: sharmakartikaydev@gmail.com
@grt-amat
@grt-amat 3 жыл бұрын
@@SimplilearnOfficial yes sure, my email: gamatdarso@gmail.com thank you very much!
@tuandhtl
@tuandhtl 3 жыл бұрын
@@SimplilearnOfficial can you share it to my email: tuandhtl@gmail.com Thanks alot
@akinbolaakinleye5878
@akinbolaakinleye5878 3 жыл бұрын
@@SimplilearnOfficial can you share it to email too akinleye.akinbola123@gmail.com
@bukupandora
@bukupandora 3 жыл бұрын
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.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
@VIVEK-ld3ey
@VIVEK-ld3ey 3 жыл бұрын
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
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
"Hello, By default, MS Excel copies the count if formula for sales rep greater than 3 and populates in throughout the colum."
@offiongakpabio80
@offiongakpabio80 2 жыл бұрын
@@SimplilearnOfficialsame thing here, i applied it but my excel couldn't figure out which column to apply the greater than criteria
@attaonoja4540
@attaonoja4540 2 жыл бұрын
Thank you so much for this simplified teaching. Can you send me the data for practice?
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@adaiprosperbrou9568
@adaiprosperbrou9568 3 жыл бұрын
You give certificates after having completed courses
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.ashwath
@Dr.ashwath 2 жыл бұрын
Great Sir, and Thank you sir.
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Most welcome
@madhumitasarkar1683
@madhumitasarkar1683 2 жыл бұрын
Sir, It will be helpful, if you share the data set for practice
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@karnajahnavi3279
@karnajahnavi3279 Жыл бұрын
Do we want any prior knowledge.. To start this course?
@ahmadmahadi8827
@ahmadmahadi8827 3 жыл бұрын
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.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@eunx7570
@eunx7570 3 жыл бұрын
@@SimplilearnOfficial please share data set to elsiefunk12@gmail.com for practice. please keep email address hidden. thanks
@mechanicalbrand444
@mechanicalbrand444 2 жыл бұрын
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 🙏🙏🙏
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@kishanbhise4733
@kishanbhise4733 3 жыл бұрын
Thank you so much for this video...god bless this channel..!
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Our pleasure!
@Perspective8847
@Perspective8847 3 жыл бұрын
Could you please share the link to the exercise and example files?
@pragyadangarh3053
@pragyadangarh3053 3 жыл бұрын
Would you please share the data sets for practice?
@karthigalakshmanan7017
@karthigalakshmanan7017 3 жыл бұрын
The content is so informative. could you please share the dataset?
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@krystledianne3707
@krystledianne3707 Жыл бұрын
I love this channel, please continue to make videos
@SimplilearnOfficial
@SimplilearnOfficial Жыл бұрын
We are glad that you have enjoyed your learning experience with us : )
@md.sarfarazhussain4144
@md.sarfarazhussain4144 2 жыл бұрын
Kindly provide all the excel sheets which you are using in the video.
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@ashishthakur5885
@ashishthakur5885 3 жыл бұрын
He explained everything in a very lucid way... Thanks a lot.... Can I get these sheets?
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@ashishthakur5885
@ashishthakur5885 3 жыл бұрын
@@SimplilearnOfficial rudeashishthakur@gmail.com
@viveksankrit5744
@viveksankrit5744 3 жыл бұрын
@@SimplilearnOfficial sankrit97@gmail.com
@shalinijoshi1698
@shalinijoshi1698 3 жыл бұрын
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
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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-eg3sx
@DevSharma-eg3sx 3 жыл бұрын
@@SimplilearnOfficial can I have get some datasets with question like you have in videos for more practicing on PC .
@shanmugakrish4503
@shanmugakrish4503 3 жыл бұрын
Thanks for the video... can you please send the Data set
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@shanmugakrish4503
@shanmugakrish4503 3 жыл бұрын
@@SimplilearnOfficial my mailid is Shanmugakrish96@gmail.com
@saib7231
@saib7231 3 жыл бұрын
Very very useful video.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Glad it was helpful!
@salmanayyoob5382
@salmanayyoob5382 3 жыл бұрын
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.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@salmanayyoob5382
@salmanayyoob5382 3 жыл бұрын
@@SimplilearnOfficial Sir please make a video on , Data science roadmap.
@salmanayyoob5382
@salmanayyoob5382 3 жыл бұрын
@@SimplilearnOfficial sir I have completed this video , how can I get certificate??
@localtoglobal743
@localtoglobal743 3 жыл бұрын
Amazing video..really very helpful for beginners..plz share the dataset for practice more
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@soumenpati5865
@soumenpati5865 3 жыл бұрын
This is video is super cool 😎😎😎👍 and thank you so much for creating this❤️❤️❤️. Can I get excel file for practicing on my pc?🙏
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@soumenpati5865
@soumenpati5865 3 жыл бұрын
@@SimplilearnOfficial sir you have not provided the file. I have already given my email in the above. Please send me the file
@GenTalk16
@GenTalk16 3 жыл бұрын
Hello simplilearn, thanks for this amazing tutorial can u please send the excel sheet to practice... please
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@santoshhospet5025
@santoshhospet5025 3 жыл бұрын
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.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@moresources
@moresources 3 жыл бұрын
@@SimplilearnOfficial hi! youre vedio really healpful. Could you share me also the dataset for my practices? yatiememories@gmail.com TQ!
@manjunathhipparagi8493
@manjunathhipparagi8493 3 жыл бұрын
@@moresources if you have that data sample could you mail that me as well
@subhodhks1879
@subhodhks1879 3 жыл бұрын
@@manjunathhipparagi8493 Hi could you please mail me the data set here: kssubhodh99@gmail.com
@subhodhks1879
@subhodhks1879 3 жыл бұрын
@@moresources Hi could you please mail me the data set here: kssubhodh99@gmail.com
@sayedbaqai5524
@sayedbaqai5524 3 жыл бұрын
Great explanation thanks. Can you please share data set
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@JesusRamAllahWaheguru
@JesusRamAllahWaheguru 3 жыл бұрын
hello there, can you please send me the dataset required for this course at deep.dnr@gmail.com
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
@@JesusRamAllahWaheguru Sent!
@siddharthrout738
@siddharthrout738 2 жыл бұрын
I am very intrested in this analyst job..
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
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
@adegbegiibukun8769
@adegbegiibukun8769 2 жыл бұрын
Good day, thanks for this explicit lecture. can I get the data set used in the course of this lecture. thanks in anticipation.
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@uzairrana2895
@uzairrana2895 Жыл бұрын
Thankyou so much for this tutorial
@shivam220
@shivam220 3 жыл бұрын
Part 51:00 it will not sort by S.County, Central, and N.County and I did it exact way
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@abirsengupta2730
@abirsengupta2730 2 жыл бұрын
Yes mine tooo... its in Central, S.County, N.County sequence
@tranthanhnhan624
@tranthanhnhan624 3 жыл бұрын
Thank you so much for sharing this video. Could you please share the data set with me to practice?
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@ricksanchez1735
@ricksanchez1735 3 жыл бұрын
@@SimplilearnOfficial me too please
@vairagborad
@vairagborad 3 жыл бұрын
@@ricksanchez1735 you got that data set???
@ssef13
@ssef13 3 жыл бұрын
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!
@amanjitkaur9478
@amanjitkaur9478 2 жыл бұрын
Can u advise me more on the skillset
@ruparanjanmohapatra726
@ruparanjanmohapatra726 2 жыл бұрын
Have you started your Data Analyst job? How's it going.
@sabinakhan3582
@sabinakhan3582 3 жыл бұрын
Thanks for this video. Can you please share datasheet. It willbe be helpful for me😊
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@fennasolvia
@fennasolvia Жыл бұрын
Great Work. How can I move annotations from Universal to GA4?
@LivyNt
@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
@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
@nainitanandeshwar9512 Жыл бұрын
Nice Video! Can you send the lookup sheets for practice.
@ashwinichinnappa7879
@ashwinichinnappa7879 3 жыл бұрын
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!
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@JesusRamAllahWaheguru
@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
@ahmedazeem7566 Жыл бұрын
Any short term course available for MBA finance students ? share it please.
@arshadibrahim765
@arshadibrahim765 2 жыл бұрын
Thanks for the video.
@SimplilearnOfficial
@SimplilearnOfficial 2 жыл бұрын
You are welcome!
@NidhiBMehta
@NidhiBMehta 3 жыл бұрын
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.
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
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.
@Perspective8847
@Perspective8847 3 жыл бұрын
@@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
@ambowchannel6219
@ambowchannel6219 3 жыл бұрын
@@SimplilearnOfficial I will appreciate if the dataset can be send to me too investorambow@gmail.com
@subhodhks1879
@subhodhks1879 3 жыл бұрын
@@Perspective8847 Hi could you please mail me the data set here: kssubhodh99@gmail.com
@subhodhks1879
@subhodhks1879 3 жыл бұрын
@P20CC010_VISHAL KUMAR KORIYA SVNIT Hi could you please mail me the data set here: kssubhodh99@gmail.com
@amirhusseinfarahmand2209
@amirhusseinfarahmand2209 Жыл бұрын
Amazing tutorial!
@AdeKaryadi
@AdeKaryadi 3 жыл бұрын
nice tutorial, thanks
@SimplilearnOfficial
@SimplilearnOfficial 3 жыл бұрын
You're welcome!
@smiles7749
@smiles7749 Жыл бұрын
Hi @Simplilearn thank you for the tutorial. Is there a way I can get the data set for practice.
@rohan2767
@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
I Tried 50 Data Analyst Courses. Here Are Top 5
8:41
Stefanovic
Рет қаралды 81 М.
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 7 МЛН
Каха и лужа  #непосредственнокаха
00:15
Can You Find Hulk's True Love? Real vs Fake Girlfriend Challenge | Roblox 3D
00:24
Disrespect or Respect 💔❤️
00:27
Thiago Productions
Рет қаралды 40 МЛН
When u fight over the armrest
00:41
Adam W
Рет қаралды 28 МЛН
Master Data Analysis on Excel in Just 10 Minutes
11:32
Kenji Explains
Рет қаралды 2,2 МЛН
How I'd Learn Data Analytics in 2024 (If I Had to Start Over)
14:08
CareerFoundry
Рет қаралды 816 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 314 М.
Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡
3:02:18
Master Data Cleaning Essentials on Excel in Just 10 Minutes
10:16
Kenji Explains
Рет қаралды 666 М.
Data Analysis with Python for Excel Users - Full Course
3:57:46
freeCodeCamp.org
Рет қаралды 3,2 МЛН
Cleaning Data in Excel | Excel Tutorials for Beginners
21:04
Alex The Analyst
Рет қаралды 581 М.
Каха и лужа  #непосредственнокаха
00:15