@amoeba5547
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
@waliahad8239
it takes 8 hours to complete this with practice thank you @simplilearn for such a wonderful session
@mrCetus
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
@marcuslkms
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.
@SimplilearnOfficial
We hope this video was useful. The link for the dataset used in the video is provided in the description. Thanks!
@showkathali8911
i am shocked ,this very useful content is available on youtube for free,thanks simplilearn team.
@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.
@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
This video is very useful for data entry setup. Thanks for your support.
@fifthcarcrash
this is incredible! i come back everytime i forget something thanks a lott
@rubin949
Amazing bro I hope you get all you want in life ! Human kind is amazing when people like you exist. Thank you so much !
@adejimiadeolu437
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.
@funkygoobermelon
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!
@jahanshuvo
Basically a great course! No fun! This is really amazingly instructive. Thanks for your hard work!
@ahmed8asim
I learnt a lot from this generous course! Thanks a lot
@syedmuhammadshazanalirizvi6992
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
@JiluJoseph-em5gc
It was very effective and informative, thank you very much👍
@shrutiomatic
0:40 topics 11:05 sum 12:21 new sum 14:36 split 17:31 delimiter split
@Pawvani
Excellent explanation ..... Tq for uploading this video
@SimplilearnOfficial