"🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?Ob8Hre_SnI&Comments&RUclips 🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?Ob8Hre_SnI&Comments&RUclips 🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?Ob8Hre_SnI&Comments&RUclips 🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?Ob8Hre_SnI&Comments&RUclips 🔥IITG - Professional Certificate Program in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitg-generative-ai-data-analytics-program?Ob8Hre_SnI&Comments&RUclips"
Can we take a minute just to appreciate this brother for this selfless efforts Thanku bro.. But bro u can use Hindi a little bit so it understand and help many users
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
Can we get all the datasets that were used in this video please. This is so that we can practice alongside with similar data from the video. Meanwhile, you guys are just the best. Kudos! In anticipation.
I have bought course for Excel from one site, and I can say that this free video contains more valuable content than my course. Also, very easy language and great explanation. Thanks ❤
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
simply awesome, and I appreciate all your team's efforts to provide the valuable training free of cost, for which I can't express my gratitude. I owe it to you. I am aware that some course providers do not provide such knowledge despite charging exorbitant fees. Salute to you guys.
Thankyou for explaining this course in such a easy manner. It would be a great help if you could please provide all the database that you have used in explaining so that I can practice alongside. Thanks again!
Hi, in DAX Date & Time function (01:07:35) u calculated 'Retirement age' . U simply multiplied 65 y to the DOJ but in reality u should "multiply 65 y to dob" and u need to take "year" from that calculation & then "date & month" should be taken from DOJ. (if i am wrong, correct me.)
We are delighted to have been a part of your learning journey! If you want to continue honing your skills and keeping up-to-date with industry trends, check out our course offerings in the description box.
As your new subscriber ,I hope you don't delete this, i have found you change today and i am going to learning day by day because it very long video. Such information for free thank you so much you don't know how much it's means to students like me who don't have money.
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.
Thank you so much sir for providing such quality content for free!! I'm currently in high school learning all this as it would help me in b-school in future.
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
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.
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.
GOD Your already blessed sir ................i wish you all the success......i just started its been 2 min and the content you covered is really awesome, stay blessed sir .
WooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!
THANK YOU SO SO MUCH FOR THIS WONDERFUL AND DETAIL VIDEO IT HAS HELPED ME TO LEARN MANY NEW THINGS. REALLY THANKFUL FOR THIS WONDERFUL VIDEO AND YOUR ENERGY LEVEL ALONG WITH YOUR PATIENCE. THANK YOU
whatever u are writing in the database , make sure it's visible to viewers also and provide some practice worksheets to practice excel if possible it will be implemented whatever you taught. Thanks 👍
At 04:46:57 , how did we get the right results while selecting the bottom 3 entries for the lowest female graduates, when the list had been sorted in ascending order? Also at 04:50:45, according to my calculations, sum of sales for fruits is:16510, and for the vegetables it's:12350, and sales of both sumsup to 28,860(16510+12350).Then why it's displaying different results or did I get it wrong?
Aye big man, I appreciate your time and effort you put into this tutorial. Quick question, can you create more courses in excel that a newbie like me, can just learn everything in one place? Like a beginner cource, since this is an advance course? Thanks.
Dear [ Simplilearn team ], I hope this message finds you well. Firstly, I would like to express my appreciation for your informative video on the topic of standard deviation. I found it to be quite insightful and helpful. However, I did notice something that I believe could potentially improve the viewing experience for your audience. While you were providing information of standard deviation on the right side of the screen, there was an animated video of graphs on the left side. Although it looked cool, I found it to be somewhat distracting from the main content. As a viewer, I am more interested in the information being presented rather than the animation. Therefore, I would like to suggest using a single image instead of the animated videos. I believe this would enhance the clarity and focus of your video, allowing your audience to better comprehend the material being presented. Thank you for your time and consideration. Best regards, Ajay Bhalekar
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
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.
Hello, in the video 46.32 - to convert number to text, you copied the macro from google where the function name was "Spell Number". However when you pasted macro in VBA Module, and you scrolled up to the first line- it read "NumbertoText". How was it?
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.
WooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!
vWooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!
Hi @SimplilearnOfficial. You have shows three methods of comparing the two columns. But in each method the result is different. Don't you think this is wrong. Time around 30 minutes to 33 minutes section
Your satisfaction is our top priority, and we're thrilled to hear that you had a positive learning experience with us! If you're interested in pursuing additional learning opportunities, we encourage you to take a look at certification courses in the description box.
If you're looking for datasets to work on for your data science projects, there are several great resources available. Sites like Kaggle, UCI Machine Learning Repository, and Google Dataset Search offer a wide range of datasets across different domains. These can be excellent for practicing your skills, whether you're working on data cleaning, analysis, or even machine learning models. Check them out and find a dataset that interests you!
We are delighted to have been a part of your learning journey! If you want to continue honing your skills and keeping up-to-date with industry trends, check out our course offerings in the description box.
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
Taking notes is definitely a great strategy to retain what you've learned! It can help reinforce the material and give you a quick reference for future review. Also, consider revisiting the notes regularly and practicing what you've learned through practical applications or quizzes.
i did the same process for activating SPELLNUMBER formula but when I do apply. It says syntas error and takes me to the module sheet where a line { Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2)) } this is in red color. please reply what should I do.
This is a wonderful tutorial, I’m grateful for the resource. Is there a set of learning files to work from, or is the intent to have the student recreate the files before taking the lessons? I’m a little confused on this, as I don’t need practice building spreadsheet data. Help, please!
We're pleased you're excited to learn! The Certification course link can be found in the video description and pinned comment. If you have questions about enrollment or payment options, add your details in the "request more information" section on the course page. Our course guide will assist you. See you soon!
To insert a single row in Google Sheets, click on a cell right beneath where you want to insert the new row. Click "Insert" and "New row" to create a blank row above the selected cell.
"🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?Ob8Hre_SnI&Comments&RUclips
🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?Ob8Hre_SnI&Comments&RUclips
🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?Ob8Hre_SnI&Comments&RUclips
🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?Ob8Hre_SnI&Comments&RUclips
🔥IITG - Professional Certificate Program in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitg-generative-ai-data-analytics-program?Ob8Hre_SnI&Comments&RUclips"
Can we take a minute just to appreciate this brother for this selfless efforts Thanku bro.. But bro u can use Hindi a little bit so it understand and help many users
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
This video was recommended in China, so I came here, I think this video deserves to be seen by more people, thank you very much!❤
Guys am just 7minutes into this video , but am already here to say THANK YOU! for the time taken to explain so deeply and separately.
I can't believe, its free, i would recommend to my every fellow learner to see and appreciate this masterpiece❤
Can we get all the datasets that were used in this video please. This is so that we can practice alongside with similar data from the video. Meanwhile, you guys are just the best. Kudos! In anticipation.
this complete course is more worth then any course on the internet on free basis thank you so much
I'm joining a b-school next month thank you so much for this course i really was looking for this !💗
i am starting this course today from your video hope i will get succeed in completing with the same interest
I have bought course for Excel from one site, and I can say that this free video contains more valuable content than my course. Also, very easy language and great explanation. Thanks ❤
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
Every tutorial like this one is really something that every beginner is dreaming of . God bless you.❤❤❤
Thank you so much 😀
simply awesome, and I appreciate all your team's efforts to provide the valuable training free of cost, for which I can't express my gratitude. I owe it to you. I am aware that some course providers do not provide such knowledge despite charging exorbitant fees. Salute to you guys.
Our pleasure!
I love the enthusiasm, I'll be back as soon as I have some time over the next few weeks.
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
Thankyou for explaining this course in such a easy manner. It would be a great help if you could please provide all the database that you have used in explaining so that I can practice alongside. Thanks again!
Hi,
in DAX Date & Time function (01:07:35) u calculated 'Retirement age' . U simply multiplied 65 y to the DOJ but in reality u should "multiply 65 y to dob" and u need to take "year" from that calculation & then "date & month" should be taken from DOJ.
(if i am wrong, correct me.)
a great headstart for any MBA aspirant a must watch video
We are delighted to have been a part of your learning journey! If you want to continue honing your skills and keeping up-to-date with industry trends, check out our course offerings in the description box.
at 36:00, transpose function is working only for one cell not as in video
As your new subscriber ,I hope you don't delete this, i have found you change today and i am going to learning day by day because it very long video.
Such information for free thank you so much you don't know how much it's means to students like me who don't have money.
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.
Thank you so much sir for providing such quality content for free!! I'm currently in high school learning all this as it would help me in b-school in future.
Why don't you share the Excel Exercise Files here which can save us time to create new files with so many data for every small video tuto ??
You have done a great work but a small thing is we need those data to practice
I appreciate you sir, you covered this course brilliantly and effectively lots of love from Pakistan❤❤❤❤❤
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
Outstanding sir super and excellent teaching i really inspired...
Could you please provide the sample sheets so that we can practice at the same time.
Good information shared....Thank You
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
Sir great video but if you put the pdfs and other materials which you are using in this class it will be really helpful.
its my first vedio i see pateince to see your becasue each day go go intreseted thank you
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
This is great, looking forward to working through this!
Hope you enjoy it!
Thanks for this content free of cost❤
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.
Time series analysis was not clearly understandable . Rest of the video was Great . Thanks alot to Simplilearn for such a teaching !
Thank you for making this video just started to watch it's helpful n can't wait to complete😊
How much efforts this man gave is just speechless 🙏 thanku alot for such fruitful video
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
Respect and love for your invaluable education ❤❤❤
Thanks you all of the team simplilearn for providing more valueable video once again thank you.
Our pleasure!
Super helpful! I appreciate the indexing, especially. I've used super basic excel, but my new job needs advanced skills. This helped me so much!
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.
GOD Your already blessed sir ................i wish you all the success......i just started its been 2 min and the content you covered is really awesome, stay blessed sir .
WooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!
Thank You so much for this...❤🎉
very helpful and very simple to understand thank you .
Thank you sir very useful
THANK YOU SO SO MUCH FOR THIS WONDERFUL AND DETAIL VIDEO IT HAS HELPED ME TO LEARN MANY NEW THINGS. REALLY THANKFUL FOR THIS WONDERFUL VIDEO AND YOUR ENERGY LEVEL ALONG WITH YOUR PATIENCE. THANK YOU
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
Great Video ❤
Thanks man
whatever u are writing in the database , make sure it's visible to viewers also and provide some practice worksheets to practice excel if possible it will be implemented whatever you taught.
Thanks 👍
At 04:46:57 , how did we get the right results while selecting the bottom 3 entries for the lowest female graduates, when the list had been sorted in ascending order?
Also at 04:50:45, according to my calculations, sum of sales for fruits is:16510, and for the vegetables it's:12350, and sales of both sumsup to 28,860(16510+12350).Then why it's displaying different results or did I get it wrong?
can you please provide me with the sample data used in excel dashboards tutorial, it would be a great help.
Nice information 👍
Excellent content!
Aye big man, I appreciate your time and effort you put into this tutorial. Quick question, can you create more courses in excel that a newbie like me, can just learn everything in one place? Like a beginner cource, since this is an advance course? Thanks.
Dear [ Simplilearn team ],
I hope this message finds you well. Firstly, I would like to express my appreciation for your informative video on the topic of standard deviation. I found it to be quite insightful and helpful.
However, I did notice something that I believe could potentially improve the viewing experience for your audience. While you were providing information of standard deviation on the right side of the screen, there was an animated video of graphs on the left side. Although it looked cool, I found it to be somewhat distracting from the main content. As a viewer, I am more interested in the information being presented rather than the animation.
Therefore, I would like to suggest using a single image instead of the animated videos. I believe this would enhance the clarity and focus of your video, allowing your audience to better comprehend the material being presented.
Thank you for your time and consideration.
Best regards,
Ajay Bhalekar
Thank you very much for such a awesome tutorial ❤️ watching from ktm, Nepal 🇳🇵
Great sir...🔥🔥
THIS EFFORT IS APPRICIABLE
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
Nice video sir iam listing daily n noting in book
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.
A big thanks to you bro
Hello, in the video 46.32 - to convert number to text, you copied the macro from google where the function name was "Spell Number". However when you pasted macro in VBA Module, and you scrolled up to the first line- it read "NumbertoText". How was it?
The Macro was from Microsoft's official website. Please have your email address shared with us. We will have it sent out to you at the earliest
Can I directly watch adavaned excelr course video or should I watch excel for beginners video first
Okay sir,
Thank you very much for this video❤❤
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
can you please provide the sheets so that we can practice
🙂
It would be helpful if you could do this detaild on SQL also... The time and topic mentioned in description is highly appreciated.
2:02:58 Sir can you please explain how the sum of deviation answer came 5.6843E-14 ?
Such a amazing work ❤️❤️❤️
Thank you! Cheers!
Thanyou simpliearn this videi is very very excellent so thanks for this video
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
Great brother nicely explain
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.
Only Indians on Excel video tutorials💀
Session was informative welldone (Y)
Thank you so much Simplilearn Good Job
Very informative video❤
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
Thank you so much for the amazing Content
WooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!
It's very nice and help ful thanks for sharing
Very very very nice 😊 finally i got this video ❤
Very good! Thanks!
Thank you so much sir ❤
vWooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!
Tussi great o, thanx bro 😊❤
What an effort
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
Hi @SimplilearnOfficial. You have shows three methods of comparing the two columns. But in each method the result is different. Don't you think this is wrong. Time around 30 minutes to 33 minutes section
Thanks a bunch 🎉🎉🎉
We are glad that you have enjoyed your learning experience with us : )
Thank you so much for this full course🙏
We are glad that you have enjoyed your learning experience with us : )
Great!
That's a good session
4:15:50 Wouldn't you not only delete the duplicates, but also relevant data with this method?
Love 💕💕💕
Your satisfaction is our top priority, and we're thrilled to hear that you had a positive learning experience with us! If you're interested in pursuing additional learning opportunities, we encourage you to take a look at certification courses in the description box.
Thanks for all you do, please can I get the exercise files for me to practice as I'm learning
If you're looking for datasets to work on for your data science projects, there are several great resources available. Sites like Kaggle, UCI Machine Learning Repository, and Google Dataset Search offer a wide range of datasets across different domains. These can be excellent for practicing your skills, whether you're working on data cleaning, analysis, or even machine learning models. Check them out and find a dataset that interests you!
TQ so much ❤❤❤
We are delighted to have been a part of your learning journey! If you want to continue honing your skills and keeping up-to-date with industry trends, check out our course offerings in the description box.
Thank you Sir for this valuable Video 🙂
Most welcome
You need to zoom screen, bcoz mobile user not seen properly
Can i get the data sheets that you used in Excel training tutorial
We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!
How can I remember everything that I've learnt? Should I note these down? It will be helpful? 🙁
Taking notes is definitely a great strategy to retain what you've learned! It can help reinforce the material and give you a quick reference for future review. Also, consider revisiting the notes regularly and practicing what you've learned through practical applications or quizzes.
Thank you so much
Thank you so much sir.
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
thank you 😇
Thank you only this channel provide all Content for free
Sir, I can't understand the agenda of time series, will u provide any other vedio link to understand it clearly
How to get seasonality time
i did the same process for activating SPELLNUMBER formula but when I do apply. It says syntas error and takes me to the module sheet where a line { Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2)) } this is in red color. please reply what should I do.
Very nice 👌
Hello sir, if this video was in Hindi, then we would have got to learn a lot, thank you.
This is a wonderful tutorial, I’m grateful for the resource. Is there a set of learning files to work from, or is the intent to have the student recreate the files before taking the lessons? I’m a little confused on this, as I don’t need practice building spreadsheet data. Help, please!
Good tutorial.
Is there any certification courses provided by simpli learn
We're pleased you're excited to learn! The Certification course link can be found in the video description and pinned comment. If you have questions about enrollment or payment options, add your details in the "request more information" section on the course page. Our course guide will assist you. See you soon!
If we have data in each cell in A colum. Now I want to add 5 blank cells after each cell having data. How to do that at once?
To insert a single row in Google Sheets, click on a cell right beneath where you want to insert the new row. Click "Insert" and "New row" to create a blank row above the selected cell.
Hello,
Is this video enough for advance excel or need to learn more things in advance excel?