🔥Post Graduate Program In Data Analytics: www.simplilearn.com/pgp-data-analytics-certification-training-course?AdvancedExcelFullCourse2023-8Ob8Hre_SnI&Comments& 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): www.simplilearn.com/iitk-professional-certificate-course-data-analytics?AdvancedExcelFullCourse2023-8Ob8Hre_SnI&Comments& 🔥Caltech Data Analytics Bootcamp(US Only): www.simplilearn.com/data-analytics-bootcamp?AdvancedExcelFullCourse2023-8Ob8Hre_SnI&Comments& 🔥Data Analyst Masters Program (Discount Code - YTBE15): www.simplilearn.com/data-analyst-masters-certification-training-course?AdvancedExcelFullCourse2023-8Ob8Hre_SnI&Comments&
@blossomstar-e3x Жыл бұрын
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
@SimplilearnOfficial Жыл бұрын
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!
@mr.savageryt261311 ай бұрын
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.
@user-mu7ic2ol2y10 ай бұрын
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!❤
@chukwumanwakpa3330 Жыл бұрын
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.
@Naeem2460 Жыл бұрын
I can't believe, its free, i would recommend to my every fellow learner to see and appreciate this masterpiece❤
@shalinisinghania50049 ай бұрын
19:15 lower case upper case formula 21:23 Add rows 1 or more 24:35 select entire row/column 26:13 select column having data only 27:00 disadvantage of selecting whole column
@Nwakaego_9 ай бұрын
Thank you!
@markin_mask5592 Жыл бұрын
I'm joining a b-school next month thank you so much for this course i really was looking for this !💗
@deepakrana7949 Жыл бұрын
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.
@SimplilearnOfficial Жыл бұрын
Our pleasure!
@jayeshkumbhani1531 Жыл бұрын
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 ❤
@SimplilearnOfficial Жыл бұрын
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!
@4signup452 Жыл бұрын
Every tutorial like this one is really something that every beginner is dreaming of . God bless you.❤❤❤
@SimplilearnOfficial Жыл бұрын
Thank you so much 😀
@salikmirza9941 Жыл бұрын
i am starting this course today from your video hope i will get succeed in completing with the same interest
@amritamaheshwari9221 Жыл бұрын
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!
@andiidoode Жыл бұрын
I love the enthusiasm, I'll be back as soon as I have some time over the next few weeks.
@SimplilearnOfficial Жыл бұрын
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
@punjabivlogsbyumer8 ай бұрын
this complete course is more worth then any course on the internet on free basis thank you so much
@shrinivas1086 Жыл бұрын
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.)
@samarrathore6220 Жыл бұрын
a great headstart for any MBA aspirant a must watch video
@SimplilearnOfficial Жыл бұрын
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.
@satka947 ай бұрын
Only Indians on Excel video tutorials💀
@anjalishukla8980 Жыл бұрын
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.
@SimplilearnOfficial Жыл бұрын
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.
@tahirjaved619Ай бұрын
Thank you for your assistance to learn Excel from Basic to Advance this is very amazing course to do. I'll recommend this course to beigners, I also request please also share the sheets for practices So this will be easy for students to practice and learn fast
@SantanuSinhaRoy Жыл бұрын
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 ??
@twstruzik Жыл бұрын
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!
@SimplilearnOfficial Жыл бұрын
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.
@way2happiness163Ай бұрын
You saved me brother. I got a 26000sr( Saudi riyal) job because of you
@honeybee2919 Жыл бұрын
This is great, looking forward to working through this!
@SimplilearnOfficial Жыл бұрын
Hope you enjoy it!
@user-xw5jq4xz2z Жыл бұрын
Time series analysis was not clearly understandable . Rest of the video was Great . Thanks alot to Simplilearn for such a teaching !
@maimisa Жыл бұрын
Great!
@SimplilearnOfficial11 ай бұрын
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.
@Badakash_00925 күн бұрын
2 Hour Video Completed, Just Wow ❤
@ajaybhalekar4622 Жыл бұрын
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
@rajnishranjan_centralunive7604 Жыл бұрын
at 36:00, transpose function is working only for one cell not as in video
@sabikunnaharsaima77282 ай бұрын
How can I remember everything that I've learnt? Should I note these down? It will be helpful? 🙁
@SimplilearnOfficial2 ай бұрын
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.
@JK-ws1el Жыл бұрын
You have done a great work but a small thing is we need those data to practice
@mokyol369711 күн бұрын
Simplilearn is awesome.
@MAwais-kc4cn10 ай бұрын
I appreciate you sir, you covered this course brilliantly and effectively lots of love from Pakistan❤❤❤❤❤
@SimplilearnOfficial10 ай бұрын
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!
@islam-co3reАй бұрын
Hats off to you. This video has a lot to share. It's really appreciating that it's free to access.
@sumankumardas8409 Жыл бұрын
Could you please provide the sample sheets so that we can practice at the same time.
@AbhiisProАй бұрын
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.
@suganraj2662Ай бұрын
its my first vedio i see pateince to see your becasue each day go go intreseted thank you
@SimplilearnOfficialАй бұрын
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
@GOAT3ditz Жыл бұрын
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?
@SimplilearnOfficial Жыл бұрын
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
@kanchanroy3570 Жыл бұрын
Thank you for making this video just started to watch it's helpful n can't wait to complete😊
@SmithAnderson-083 Жыл бұрын
Thanks for this content free of cost❤
@SimplilearnOfficial Жыл бұрын
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.
@dpsp262 ай бұрын
Great Video ❤
@peacefulmindallissetАй бұрын
Thanks you all of the team simplilearn for providing more valueable video once again thank you.
@SimplilearnOfficialАй бұрын
Our pleasure!
@markdavies-ei8sf7 ай бұрын
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.
@nitinparasuram7646Ай бұрын
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
@SimplilearnOfficialАй бұрын
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
@sunitasrivastava2479Ай бұрын
How much efforts this man gave is just speechless 🙏 thanku alot for such fruitful video
@SimplilearnOfficialАй бұрын
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
@pritichanda-lr4vg3 ай бұрын
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 .
@SimplilearnOfficial3 ай бұрын
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!
@wasimmadikhel9378 Жыл бұрын
THIS EFFORT IS APPRICIABLE
@SimplilearnOfficial Жыл бұрын
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!
@user-jl3ck7ox7c Жыл бұрын
can you please provide me with the sample data used in excel dashboards tutorial, it would be a great help.
@mritunjaykumarmani96728 ай бұрын
Sir great video but if you put the pdfs and other materials which you are using in this class it will be really helpful.
@ShahbazKhan-hw4co Жыл бұрын
can you please provide the sheets so that we can practice 🙂
@-Sunshines-girl_Ай бұрын
It would be helpful if you could do this detaild on SQL also... The time and topic mentioned in description is highly appreciated.
@hemlatasakla71749 ай бұрын
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 👍
@nitinparasuram7646Ай бұрын
very helpful and very simple to understand thank you .
@tikshi Жыл бұрын
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
@subashbaral63342 ай бұрын
Thank you very much for such a awesome tutorial ❤️ watching from ktm, Nepal 🇳🇵
@satishmullya40496 ай бұрын
Good information shared....Thank You
@SimplilearnOfficial6 ай бұрын
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!
@market_insights078 ай бұрын
Thanks man
@krushnachandramalla9478 ай бұрын
Outstanding sir super and excellent teaching i really inspired...
@user-po5zr7cd2y7 ай бұрын
Nice information 👍
@MindBlownTidbits Жыл бұрын
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?
@ramakrishnajayanth301 Жыл бұрын
Can I directly watch adavaned excelr course video or should I watch excel for beginners video first
@sauravbhambure294 Жыл бұрын
Great brother nicely explain
@SimplilearnOfficial Жыл бұрын
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.
@pandybalashanmughanandan58516 ай бұрын
Thank you sir very useful
@ashrafulalam862 ай бұрын
Respect and love for your invaluable education ❤❤❤
@WillBockovenCRE7 ай бұрын
Excellent content!
@-Himanshu.Dixit_ Жыл бұрын
Hello sir, if this video was in Hindi, then we would have got to learn a lot, thank you.
@114venkatehrajendiran53 ай бұрын
Sir, I can't understand the agenda of time series, will u provide any other vedio link to understand it clearly
@114venkatehrajendiran53 ай бұрын
How to get seasonality time
@Rods_From_God11 ай бұрын
That's a good session
@sowndaryayadav462 Жыл бұрын
Nice video sir iam listing daily n noting in book
@SimplilearnOfficial Жыл бұрын
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.
@clever4u Жыл бұрын
2:02:58 Sir can you please explain how the sum of deviation answer came 5.6843E-14 ?
@revatimate57116 ай бұрын
Thank You so much for this...❤🎉
@87fybcomasanjivanigupta78 ай бұрын
Great sir...🔥🔥
@srinuyt7312Ай бұрын
MS EXCEL 18:47
@zeetahwrites16409 ай бұрын
It's very nice and help ful thanks for sharing
@KrishnaGarg-qv3twАй бұрын
Okay sir, Thank you very much for this video❤❤
@SimplilearnOfficialАй бұрын
Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)
@kolawolehabeeb34782 ай бұрын
Thanks for all you do, please can I get the exercise files for me to practice as I'm learning
@SimplilearnOfficial2 ай бұрын
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!
@selfmotivated44047 күн бұрын
I love u bro ❤❤❤❤❤❤😢😢 thnks u so much ❤❤❤❤❤❤❤❤❤😊😊😊😊😊
@user-od9wm7tt7j Жыл бұрын
Thanyou simpliearn this videi is very very excellent so thanks for this video
@SimplilearnOfficial Жыл бұрын
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!
@ritushah26738 ай бұрын
You need to zoom screen, bcoz mobile user not seen properly
@jayendrachoudhary53146 ай бұрын
A big thanks to you bro
@nainu96 Жыл бұрын
Thank you Sir for this valuable Video 🙂
@SimplilearnOfficial Жыл бұрын
Most welcome
@aqsaliaqat88179 ай бұрын
Tussi great o, thanx bro 😊❤
@Yu-hc8dd Жыл бұрын
Thank you so much for this full course🙏
@SimplilearnOfficial Жыл бұрын
We are glad that you have enjoyed your learning experience with us : )
@gunjansharma54253 ай бұрын
Thank u so much bhai
@SimplilearnOfficial3 ай бұрын
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!
@SimplilearnOfficial3 ай бұрын
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!
@gcgoku2310 күн бұрын
very helpful ☺
@sohailsheikh19910 ай бұрын
Hats off to your hard work. but you guys should've made this video in full hindi, Your english speaking is too formal to connect with people, if there was an actual uk or usa narrator it would be good in speaking english,
@mdmuzaffarhussain66902 ай бұрын
This indeed a great learning experience for all of us. I still have a doubt. From where we get the data to practice? It's a bit challenging for me especially when it comes to data entry manually. Please help!
@jugnu7222 Жыл бұрын
How did you Calculate the average of respective quarters(St) in time series analysis???
@SimplilearnOfficial Жыл бұрын
To calculate the average of quarters in Excel, you can use the AVERAGEIF function. First, create a table with two columns: one for the quarter and one for the value you want to average. In the cell where you want to display the average, enter the formula: less Copy code =AVERAGEIF(QuarterColumn,"Q"&ROUNDUP(MONTH(DateCell)/3,0),ValueColumn) Here's what each part of the formula means: QuarterColumn: This is the column in your table that contains the quarters (e.g. Q1, Q2, Q3, Q4). "Q"&ROUNDUP(MONTH(DateCell)/3,0): This is a string that concatenates the letter "Q" with the quarter number. The quarter number is calculated by dividing the month number in the DateCell by 3 and rounding up to the nearest integer. ValueColumn: This is the column in your table that contains the values you want to average. Press Enter to calculate the average of the quarters. Note: Make sure the cell references in the formula match the location of your table and data.
@adeotiadebambo9748 ай бұрын
Very good! Thanks!
@jayna74ify6 ай бұрын
Thank u so much for doing selfless work for ppl who want to learn Excel. It’s really helpful. Keep up good work god bless u.
@balajicacs66542 ай бұрын
Thank you so much sir
@YashPatel-bw2ik3 ай бұрын
Thank you so much for the amazing Content
@SimplilearnOfficial3 ай бұрын
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!
@anshrastogi9430Ай бұрын
Thank you so much sir.
@poojaraghuvanshi3845Ай бұрын
Such a amazing work ❤️❤️❤️
@SimplilearnOfficialАй бұрын
Thank you! Cheers!
@AsimKhan-vi6zy9 ай бұрын
Looks awesome
@user-go9fu8zf1o6 ай бұрын
Session was informative welldone (Y)
@161daveveer53 ай бұрын
Very nice 👌
@adityakawade4823 Жыл бұрын
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?
@SimplilearnOfficial Жыл бұрын
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.
@FunFingersWer Жыл бұрын
Thanks a bunch 🎉🎉🎉
@SimplilearnOfficial Жыл бұрын
We are glad that you have enjoyed your learning experience with us : )
@user-fx6eu2uh7t Жыл бұрын
Can i get the data sheets that you used in Excel training tutorial
@SimplilearnOfficial Жыл бұрын
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!