"🔥Business Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/business-analyst-certification-training-course?W3vrMSah3rc&Comments&RUclips 🔥CBAP® Certification Training - www.simplilearn.com/project-management/cbap-preparatory-course-training?W3vrMSah3rc&Comments&RUclips 🔥Purdue - Post Graduate Program in Business Analysis - www.simplilearn.com/pgp-business-analysis-certification-training-course?W3vrMSah3rc&Comments&RUclips"
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.
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?
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 :)
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!
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!
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
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??
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!
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: ruclips.net/video/X3paOmcrTjQ/видео.html. 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.
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!
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, Oh man. You are the best. Thank you so much for such a valuable info. I've just signed up ExcellsFun RUclips channel and it looks like everthing I ever need for have my Excel knowledge base improved. Once again, thanks a lot.
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 :)
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.
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.
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.
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.
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
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.
"🔥Business Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/business-analyst-certification-training-course?W3vrMSah3rc&Comments&RUclips
🔥CBAP® Certification Training - www.simplilearn.com/project-management/cbap-preparatory-course-training?W3vrMSah3rc&Comments&RUclips
🔥Purdue - Post Graduate Program in Business Analysis - www.simplilearn.com/pgp-business-analysis-certification-training-course?W3vrMSah3rc&Comments&RUclips"
This is great course on excel for business analyst. Thank you.
You're very welcome!
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.
Helpful for beginners
Glad to hear that
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?
You’re good , nice clean and clear, thanks
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 :)
VERY HELPFUL!! KEEP UP THE GOOD WORK! THANKS
You're welcome!
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!
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!
hello, where did you get the sample data?
@simplelearn where is the dataset link
18:46 I already tried that but the cells which became green was randomly not =if 4000 value, how to fix?
Do you have a Test Data used in this video for download?
How can I get the master dataset used in it .
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)
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
$ They are used for fixing that particular cell....
Mam which stream is required to become business analyst
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
Hello. Is there any chance to get the excel sample files to complete de excercises? Thank you in advance.
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
hey simplilearn can you please provide me with the link to download the excel file to practise the skills learned
Hi Anurag, we regret to say that we don't have the dataset for this particular video. Thanks.
@@SimplilearnOfficial Could you please inform where I can find the mentioned datasets? Thanks in advance
Thank you!
Glad you enjoyed it! Thank you for watching!
Thanks a TON.. very Clear and easy to understand. Great video
Hey Vikram, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
Hoping to learn more of deep learning.
Great to hear it. Check this playlist for more info: ruclips.net/video/6M5VXKLf4D4/видео.html
where the data can download
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
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??
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!
Keep doing great work guys
Hey, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
I am a beginner in data science as well as excel so where should I start.
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: ruclips.net/video/X3paOmcrTjQ/видео.html. 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.
Where can I get the dataset to follow along?
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!
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.
Hey man you should check the ExcelIsFun channel on RUclips. It's free and it's what I'm watching to learn some excel stuff
@@kra3525, Oh man. You are the best. Thank you so much for such a valuable info. I've just signed up ExcellsFun RUclips channel and it looks like everthing I ever need for have my Excel knowledge base improved. Once again, thanks a lot.
@@kra3525 thank you, brother 🤝
thanks for the knowledge!
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 :)
Atleast give the link of data set for practicing above tutorial
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.
Much better if u could provide the worksheet u use for us to practice
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.
@@SimplilearnOfficial otimoses6@gmail.com
For the dataset
you lost me after 28:00. I'm confused how you got those values.
Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better
Our most beloved godfather Shivbaba bless you always
What is bi ppl?
BI means Business Intelligence. THanks.
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.
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.
good but too basics
Thanks for the honest feedback. We will be updating this topic soon. Thanks.
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
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.
This is a very nice course, I enjoy it. Can you please provide us with the dataset used in the course #simplilearn @simplolearn
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.