🔥 Post Graduate Program In Business Analysis: www.simplilearn.com/pgp-data-analytics-certification-training-course?BusinessAnalysis-W3vrMSah3rc&Comment& 🔥Business Analyst Program (Discount Coupon: YTBE15) : www.simplilearn.com/business-analyst-certification-training-course?BusinessAnalysis-W3vrMSah3rc&Comment&
@cottondai3 жыл бұрын
This is great course on excel for business analyst. Thank you.
@SimplilearnOfficial3 жыл бұрын
You're very welcome!
@bboysaolee4 жыл бұрын
Thanks for the great tutorial. Very useful! The clicking sounds and the repetition of the each cell, comma, and value when doing formulas is a bit annoying in my opinion. But I get how it might be useful to some people, I guess. Really nice tutorial either way!
@SimplilearnOfficial4 жыл бұрын
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
@TruthofDilly5 жыл бұрын
You’re good , nice clean and clear, thanks
@SimplilearnOfficial5 жыл бұрын
Hello, 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 :)
@marceljurica65284 жыл бұрын
Hello. Really great video but I have a question about the Match function.I want to find the position of the date, let´s say 2-jan-12. As we see, the date 2-jan-12 is in the 3rd (19th of the sheet) row of the table. But i noticed, that it is also in the 208th row of the sheet, at 28:43. It´s a little bit confusing for me that the Match function choose only the first position in the 19th row, when obviously there is more than one date like that. Is it supposed to be like that and i just don´t understand? Thank you.
@anamitraghosh67372 жыл бұрын
Helpful for beginners
@SimplilearnOfficial2 жыл бұрын
Glad to hear that
@footballmaniacs3903 жыл бұрын
VERY HELPFUL!! KEEP UP THE GOOD WORK! THANKS
@SimplilearnOfficial3 жыл бұрын
You're welcome!
@sbidikar8 ай бұрын
can you possibly also include a sample dataset that is being used in the video or just any sample having similar details for anyone to practice while going through the video?
@vinaywadhwa996 жыл бұрын
Simplilearn, can you please provide the link to other videos to complete this course. I can't find it on your channel. Or this is enough for Analytics using Excel??
@SimplilearnOfficial6 жыл бұрын
Hi Vinay, thanks for checking out our videos. we are afraid to say that we do not have more videos regarding business analytics using Excel. However, we do have structured and certification course in Business Analytics using excel. So, if you are interested in signing up for the course, click this link: www.simplilearn.com/big-data-and-analytics/business-analytics-certification-training. Hope that helps!
@NinaC3 жыл бұрын
What is the purpose of adding $ to some of the cells? Like I notice for example cell H4 some formulas use $H$4? (Or something like that)
@SimplilearnOfficial3 жыл бұрын
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@YASHGUPTA-hf3ii3 жыл бұрын
$ They are used for fixing that particular cell....
@DiscoverTalent1434 жыл бұрын
Keep doing great work guys
@SimplilearnOfficial4 жыл бұрын
Hey, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
@anuraggarg52435 жыл бұрын
hey simplilearn can you please provide me with the link to download the excel file to practise the skills learned
@SimplilearnOfficial5 жыл бұрын
Hi Anurag, we regret to say that we don't have the dataset for this particular video. Thanks.
@paulohsgoes19594 жыл бұрын
@@SimplilearnOfficial Could you please inform where I can find the mentioned datasets? Thanks in advance
@vikramnadal4 жыл бұрын
Thanks a TON.. very Clear and easy to understand. Great video
@SimplilearnOfficial4 жыл бұрын
Hey Vikram, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
@captainayaan3 жыл бұрын
Thank you!
@SimplilearnOfficial3 жыл бұрын
Glad you enjoyed it! Thank you for watching!
@mynnacobaalts96584 жыл бұрын
Hoping to learn more of deep learning.
@SimplilearnOfficial3 жыл бұрын
Great to hear it. Check this playlist for more info: kzbin.info/www/bejne/bH6Yh4uBgctnepY
@sunnysharma47533 жыл бұрын
Mam which stream is required to become business analyst
@SimplilearnOfficial3 жыл бұрын
Business analysts are in-demand across a wide range of industries. Business analysis can be an exciting and rewarding career for people who possess the requisite skills-helping struggling companies thrive and make good companies great. If you are interested in deep-dive into this, please refer to this link: www.simplilearn.com/business-analyst-certification-training-course
@kumarankit85032 жыл бұрын
@simplelearn where is the dataset link
@brandonspiegel22934 жыл бұрын
thanks for the knowledge!
@SimplilearnOfficial4 жыл бұрын
Hey Brandon, 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 :)
@zuko8033 жыл бұрын
18:46 I already tried that but the cells which became green was randomly not =if 4000 value, how to fix?
@user-ys6pt3wn6t5 жыл бұрын
Hi Simplilearn, I was wondering what the need for the '$' was in some equations and not others. I read an article saying it was for relative and absolute cell references, but even with the '$' it seemed to use the relative reference when filling the rest of the column.
@kra35255 жыл бұрын
Hey man you should check the ExcelIsFun channel on KZbin. It's free and it's what I'm watching to learn some excel stuff
@paulohsgoes19594 жыл бұрын
@@kra3525, Oh man. You are the best. Thank you so much for such a valuable info. I've just signed up ExcellsFun KZbin channel and it looks like everthing I ever need for have my Excel knowledge base improved. Once again, thanks a lot.
@FaizanKhan-cv1ur2 жыл бұрын
@@kra3525 thank you, brother 🤝
@AbcDef-ei6oc3 жыл бұрын
Much better if u could provide the worksheet u use for us 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 could 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 also. Hope that helps.
@mosessire57653 жыл бұрын
@@SimplilearnOfficial otimoses6@gmail.com For the dataset
@robertoguzman63472 жыл бұрын
Hello. Is there any chance to get the excel sample files to complete de excercises? Thank you in advance.
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@user-qk1wk7rn2e Жыл бұрын
hello, where did you get the sample data?
@imranwalli48064 жыл бұрын
you lost me after 28:00. I'm confused how you got those values.
@SimplilearnOfficial4 жыл бұрын
Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better
@bhanusharma14424 жыл бұрын
I am a beginner in data science as well as excel so where should I start.
@SimplilearnOfficial4 жыл бұрын
Hi Bhanu, you can definitely pursue a career in Data Science. To kickstart, you can check out the Data Science playlist for learning the basics: kzbin.info/www/bejne/jmTTkoKjmNeHoLM. If you are interested to take up a more structured and formal course, you can find the details here: www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training.
@Dydgl2 жыл бұрын
How can I get the master dataset used in it .
@DanAlvard7 ай бұрын
Do you have a Test Data used in this video for download?
@ManishKumar-ym9uk2 жыл бұрын
where the data can download
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@nameetmankar98063 жыл бұрын
Atleast give the link of data set for practicing above tutorial
@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.
@mosessire57653 жыл бұрын
Where can I get the dataset to follow along?
@SimplilearnOfficial3 жыл бұрын
Hi Moses, we regret to say that we don't have dataset apparently since it is an outdated video. However, we will be uploading a new video on the same soon. Thanks!
@maometto68124 жыл бұрын
What is bi ppl?
@SimplilearnOfficial4 жыл бұрын
BI means Business Intelligence. THanks.
@user-God-s-child-01018 ай бұрын
Our most beloved godfather Shivbaba bless you always
@somdebmazumder94074 жыл бұрын
good but too basics
@SimplilearnOfficial4 жыл бұрын
Thanks for the honest feedback. We will be updating this topic soon. Thanks.
@jayantarianster4 жыл бұрын
Why put up a course when you don't provide the dataset used in the video? Is it a bait to lure people into buying the course? In case you're unaware, there are better Excel data analysis courses available, that are more comprehensive and give away the used file for each topic.
@SimplilearnOfficial4 жыл бұрын
Sorry about that. Since it is an old video, we don't have the dataset with us apparently. However, we always send the datasets of latest videos. Thanks.
@selimcanpolat86644 жыл бұрын
this video makes it seem like excel is the most powerful and efficient business tool out there, which is not true. there are at least four that i can state
@SimplilearnOfficial4 жыл бұрын
Hi Selim, Excel is one of the most powerful business tool without any doubts. For more detailed info, click here: www.investopedia.com/articles/personal-finance/032415/importance-excel-business.asp.
@opeyemiajayi11642 жыл бұрын
This is a very nice course, I enjoy it. Can you please provide us with the dataset used in the course #simplilearn @simplolearn
@SimplilearnOfficial2 жыл бұрын
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.