Business Analytics with Excel | Data Science Tutorial | Simplilearn

[@SimplilearnOfficial]

🔥 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&

[@cottondai]

This is great course on excel for business analyst. Thank you.

[@SimplilearnOfficial]

You're very welcome!

[@bboysaolee]

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!

[@SimplilearnOfficial]

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!

[@TruthofDilly]

You’re good , nice clean and clear, thanks

[@SimplilearnOfficial]

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 :)

[@marceljurica6528]

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.

[@anamitraghosh6737]

Helpful for beginners

[@SimplilearnOfficial]

Glad to hear that

[@footballmaniacs390]

VERY HELPFUL!! KEEP UP THE GOOD WORK! THANKS

[@SimplilearnOfficial]

You're welcome!

[@sbidikar]

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?

[@vinaywadhwa99]

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??

[@SimplilearnOfficial]

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!

[@NinaC]

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)

[@SimplilearnOfficial]

Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

[@YASHGUPTA-hf3ii]

$ They are used for fixing that particular cell....

[@DiscoverTalent143]

Keep doing great work guys

[@SimplilearnOfficial]

Hey, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)

[@anuraggarg5243]

hey simplilearn can you please provide me with the link to download the excel file to practise the skills learned

[@SimplilearnOfficial]

Hi Anurag, we regret to say that we don't have the dataset for this particular video. Thanks.

[@paulohsgoes1959]

@@SimplilearnOfficial Could you please inform where I can find the mentioned datasets? Thanks in advance

[@vikramnadal]

Thanks a TON.. very Clear and easy to understand. Great video

[@SimplilearnOfficial]

Hey Vikram, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)

[@captainayaan]

Thank you!

[@SimplilearnOfficial]

Glad you enjoyed it! Thank you for watching!

[@mynnacobaalts9658]

Hoping to learn more of deep learning.

[@SimplilearnOfficial]

Great to hear it. Check this playlist for more info: kzbin.info/www/bejne/bH6Yh4uBgctnepY

[@sunnysharma4753]

Mam which stream is required to become business analyst

[@SimplilearnOfficial]

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

[@kumarankit8503]

@simplelearn where is the dataset link

[@brandonspiegel2293]

thanks for the knowledge!

[@SimplilearnOfficial]

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 :)

[@zuko803]

18:46 I already tried that but the cells which became green was randomly not =if 4000 value, how to fix?

[@user-ys6pt3wn6t]

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.

[@kra3525]

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

[@paulohsgoes1959]

@@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-cv1ur]

@@kra3525 thank you, brother 🤝

[@AbcDef-ei6oc]

Much better if u could provide the worksheet u use for us to practice

[@SimplilearnOfficial]

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.

[@mosessire5765]

@@SimplilearnOfficial [e-mail] For the dataset

[@robertoguzman6347]

Hello. Is there any chance to get the excel sample files to complete de excercises? Thank you in advance.

[@SimplilearnOfficial]

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?

[@imranwalli4806]

you lost me after 28:00. I'm confused how you got those values.

[@SimplilearnOfficial]

Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better

[@bhanusharma1442]

I am a beginner in data science as well as excel so where should I start.

[@SimplilearnOfficial]

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.

[@Dydgl]

How can I get the master dataset used in it .

[@DanAlvard]

Do you have a Test Data used in this video for download?

[@ManishKumar-ym9uk]

where the data can download

[@SimplilearnOfficial]

Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.

[@nameetmankar9806]

Atleast give the link of data set for practicing above tutorial

[@SimplilearnOfficial]

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.

[@mosessire5765]

Where can I get the dataset to follow along?

[@SimplilearnOfficial]

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!

[@maometto6812]

What is bi ppl?

[@SimplilearnOfficial]

BI means Business Intelligence. THanks.

[@user-God-s-child-0101]

Our most beloved godfather Shivbaba bless you always

[@somdebmazumder9407]

good but too basics

[@SimplilearnOfficial]

Thanks for the honest feedback. We will be updating this topic soon. Thanks.

[@jayantarianster]

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.

[@SimplilearnOfficial]

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.

[@selimcanpolat8664]

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

[@SimplilearnOfficial]

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.

[@opeyemiajayi1164]

This is a very nice course, I enjoy it. Can you please provide us with the dataset used in the course #simplilearn @simplolearn

[@SimplilearnOfficial]

Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.