Stay updated in trending technologies with Edureka RUclips Channel, Subscribe now: bit.ly/2JIfN5O Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎" to get Flat 20% Off on this training. 🔴Subscribe to Edureka RUclips channel for latest video updates: bit.ly/2ADbbb1 Below is the timestamp: 1:08 Excel Functions 1:08 SUM Function 3:58 SUMIF Function 13:27 COUNT Function 17:27 COUNTIF Function 19:37 COUNTIFS Function 22:22 AVERAGE Function 27:17 ROUND Function 31:52 CONCATENATE Function 37:17 INDEX Function 40:02 OFFSET Function 44:57 MATCH Function 51:07 MAX Function 51:12 TRIM Function 53:57 LEN Function 55:07 SQRT Function 56:12 IF Function 1:07:42 AND Function 1:12:32 TODAY Function 1:13:17 Quick Access Bar 1:18:37 Conditional Fomatting 1:37:58 Color Scale 1:38:33 Using Formulas for Conditional Formatting 1:47:48 Logical Excel Functions 1:57:58 IFERROR Function 2:00:43 IFNA Function 2:03:41 NESTED IF Function 1:11:46 TEXT Functions 2:11:56 LOWER Function 2:13:16 UPPER Function 2:16:46 RANDBETWEEN Function 2:17:31 NAME RANGEs IN Excel 2:20:11 Lookup Functions 2:20:26 VLOOKUP Function 2:22:51 HLOOKUP Function 2:23:56 Formula Auditing 2:24:01Trace Precedents & Dependents 2:25:26 Error Checking 2:26:46 Show Formulas 2:27:16 Text To Column 2:29:51 Data Validation 2:40:16 What-if Tools 2:49:42 Scenario Manager 2:54:27 Data Table 2:56:17 SORT 2:56:27 Filter 3:00:02 WRAP Text 3:01:22 Merge Cell 3:01:27 Insert Comments 3:11:52 Large Function 3:23:32 Charts In Excel 3:41:12 Pie Charts In Excel 3:41:32 Pivot Tables 3:58:38 Slicers In Pivot Tables 3:56:18 Data Analysis Using Excel 4:02:09 VBA & Macros 4:15:19 Assign A Macros 4:15:24 Record A Macros 4:15:29 Debuggingruclips.net/user/sgaming/emoji/7ff574f2/emoji_u1f534.svg
Hey Kartikey, thanks for the compliment! We are delighted to have learners like you on-board with us. Do subscribe and stay tuned for future updates. Cheers!
1:08 Excel Functions 1:08 SUM Function 3:58 SUMIF Function 13:27 COUNT Function 17:27 COUNTIF Function 19:37 COUNTIFS Function 22:22 AVERAGE Function 27:17 ROUND Function 31:52 CONCATENATE Function 37:17 INDEX Function 40:02 OFFSET Function 44:57 MATCH Function 51:07 MAX Function 51:12 TRIM Function 53:57 LEN Function 55:07 SQRT Function 56:12 IF Function 1:07:42 AND Function 1:12:32 TODAY Function 1:13:17 Quick Access Bar 1:18:37 Conditional Fomatting 1:37:58 Color Scale 1:38:33 Using Formulas for Conditional Formatting 1:47:48 Logical Excel Functions 1:57:58 IFERROR Function 2:00:43 IFNA Function 2:03:41 NESTED IF Function 1:11:46 TEXT Functions 2:11:56 LOWER Function 2:13:16 UPPER Function 2:16:46 RANDBETWEEN Function 2:17:31 NAME RANGEs IN Excel 2:20:11 Lookup Functions 2:20:26 VLOOKUP Function 2:22:51 HLOOKUP Function 2:23:56 Formula Auditing 2:24:01Trace Precedents & Dependents 2:25:26 Error Checking 2:26:46 Show Formulas 2:27:16 Text To Column 2:29:51 Data Validation 2:40:16 What-if Tools 2:49:42 Scenario Manager 2:54:27 Data Table 2:56:17 SORT 2:56:27 Filter 3:00:02 WRAP Text 3:01:22 Merge Cell 3:01:27 Insert Comments 3:11:52 Large Function 3:23:32 Charts In Excel 3:41:12 Pie Charts In Excel 3:41:32 Pivot Tables 3:58:38 Slicers In Pivot Tables 3:56:18 Data Analysis Using Excel 4:02:09 VBA & Macros 4:15:19 Assign A Macros 4:15:24 Record A Macros 4:15:29 Debugging
"Thank you for this content, was finding for a comprehensive course entailing step by step details to work in excel without getting confused. " Thank you edureka!
This is the best Excel Tutorial i have ever seen, i have gone through many channels but never found content like this, thanks edureka for making such great learning videos. It would be really great if you could share the sheet used in this tutorial for practice, i would highly appreciate!!
We are glad to have learners like you. Please do share your mail id so that we can send the notes or source codes. Do subscribe our channel and hit that bell icon to never miss an video from our channel
This was a very comprehensive session. I didn't find any such video, with the kind of examples and explanations, which were given here. Thank you so much for posting this.
Awesome!! Before coming to this video i had tried several others but could not find the quality of knowldege and clarity imparted elsewhere. thankyou for the wondeful video!!
I'm learning Advanced Excel for the first time, but the way in which you are explaining this course is helpful. I hope this course will provide me with an opportunity to excel in MS Excel. Thank you very much for this video. I don't have even words to thank you for this valuable resource.
You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
This is the best video on excel. The previous ones I watched weren't any bit comprehensive and were so short. This is a gem. Also, could you please share your workbook sample for easier practice? thank you!!!!!!!!!
I am really learning a lot here. This is unarguably the best video on Excell I have come across. Can you please share the source files so I can practice alongside.
Amazing video👍👍.. Everything is explained in simple terms with proper examples.... Simply loved it. I had a great learning experience. Thank you for this guide on excel.
I have to thank 'edureka' channel. Thank you so much for taught us more clearly and gave a more information about Excel. Now, I got more information about Excel. It took me 17 days to watch this video completely. I appreciate your work.
Great to see that our videos and contents are making you perform better and understand better :) We are glad that you've enjoyed your learning experience with us .Thank you for being a part of Edureka's team:) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Quite happy that I have subscribed your channel! Explanation is really so much professional & covering even the small points is really commendable! Keep it up! ❤️💯
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
MS Excel is a very basic but important tool. It is important to learn it as it's a skill that help in data analyzing, data visualizations. Now a days, many people export data from SAP to Excels.
Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thank you for the compliment !Glad our channel is helping you . Do subscribe our channel and hit that bell icon to never miss an video from our channel .
Hi, Edureka team, thanks for the outstanding Excel training. Could you be kind to share the practice exercises (the Excel sheets with examples) explained in the vedio.
We are glad to have learners like you. Please do share your mail id so that we can send the notes or source codes. Do subscribe our channel and hit that bell icon to never miss an video from our channel
Thank you for this video ❤️ It really open my mind and gain more knowledge about Ms. excel 😊😊 and thank you for put the time stamp too. Really apreaciated 😊🙏
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Here is the lists 1:08 Excel Functions 1:08 SUM Function 3:58 SUMIF Function 13:27 COUNT Function 17:27 COUNTIF Function 19:37 COUNTIFS Function 22:22 AVERAGE Function 27:17 ROUND Function 31:52 CONCATENATE Function 37:17 INDEX Function 40:02 OFFSET Function 44:57 MATCH Function 51:07 MAX Function 51:12 TRIM Function 53:57 LEN Function 55:07 SQRT Function 56:12 IF Function 1:07:42 AND Function 1:12:32 TODAY Function 1:13:17 Quick Access Bar 1:18:37 Conditional Fomatting 1:37:58 Color Scale 1:38:33 Using Excel Formulas for Conditional Formatting 1:47:48 Logical Excel Functions 1:57:58 IFERROR Function 2:00:43 IFNA Function 2:03:41 NESTED IF Function 1:11:46 TEXT Functions 2:11:56 LOWER Function 2:13:16 UPPER Function 2:16:46 RANDBETWEEN Function 2:17:31 NAME RANGEs IN Excel 2:20:11 Lookup Functions 2:20:26 VLOOKUP Function 2:22:51 HLOOKUP Function 2:23:56 Formula Auditing 2:24:01 Trace Precedents & Dependents 2:25:26 Error Checking 2:26:46 Show Formulas 2:27:16 Text To Column 2:29:51 Data Validation 2:40:16 What-if Tools 2:49:42 Scenario Manager 2:54:27 Data Table 2:56:17 SORT 2:56:27 Filter 3:00:02 WRAP Text 3:01:22 Merge Cell 3:01:27 Insert Comments 3:11:52 Large Function 3:23:32 Charts In Excel 3:41:12 Pie Charts In Excel 3:41:32 Pivot Tables 3:58:38 Slicers In Pivot Tables 3:56:18 Data Analysis Using Excel 4:02:09 VBA & Macros 4:15:19 Assign A Macros 4:15:24 Record A Macros 4:15:29 Debugging
Hi Ravinder, You can go to home >> styles >> conditional formatting >> highlight cells rules >> greater than that opens up a new window which had a field in which you can fill the number and choose the highlight colour. Hope this helps!
Very good video for basic learners to pick up Excel. The trainer is very good in explaining ! Is there possibility of the Excel sheet which is shown in this video can be send that will be helpful for the practice.
Thank u for this video. excell is such a powerful tool and very few peoples know its all functions and i am one of them. so i have to improved my skill. now i can improve it ,thanks for your special effort
Thank you so much for providing this video. It is so helpful to understand everything from basics. just a small request to edureka that can you please provide the link of this excel sheet which you are using so that we can revise the formulas and methods along side. or if its already available can somebody reply me with that link. Thanks Edureka!!
Hi Huzefa ! Thank You so much for watching the video :) Glad you like it :) Share your mail id with us .We'll update the data sheet and source codes soon :) Do subscribe the channel for update from our channel
I have done the paid course from my neighbour institute of advance excel but this vedio is far better than that institute. I really appreciate it . And i can make the notes of this , but it would be better if you could provide the pdf or ppt of this vedio (*If you can) . Thank you.
Good to know our contents and videos are helping you learn better . We are glad to have you with us ! Please share your mail id to send the data sheets to help you learn better :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thank you so much for this amazing video, never seen such simplified explaination about excel, it would be really helpful if you could share the workbook for practice, thanks again!
Great teaching you provided The way of your teaching is excellent💯 I appreciate your performance. Have a Greatful life and give more helping videos for all.
Hi Satish, thanks for watching the video. We will process your request as soon as possible. Here's a link to our Hindi channel ruclips.net/channel/UCywyZ4r4FTKExrPl9rf-ggw Do subscribe and stay tuned for future updates. Cheers!
This is the most detailed excel tutorial I have seen on RUclips. Please can I get the spreadsheet used in the video? I would really appreciate it. Once again, thank you for this tutorial!
Your video are very details and easy to understand I'm glad to have found the channel, I have since subscribed to get latest updates.Well done and keep up the excellent work.
Hi, thanks for an comprehensive tutorial. It has been highly beneficial. Can you please share the data set in order for me to practice. Thanks in advance.
Hey there :) We are glad to have you with us :) and more glad to have learners like you with us ! We are happy to share the source code ,please do drop your mail id to share the same :) Thank You for being a part of our Edureka team : ) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Stay updated in trending technologies with Edureka RUclips Channel, Subscribe now: bit.ly/2JIfN5O Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎" to get Flat 20% Off on this training. 🔴Subscribe to Edureka RUclips channel for latest video updates: bit.ly/2ADbbb1
Below is the timestamp:
1:08 Excel Functions
1:08 SUM Function
3:58 SUMIF Function
13:27 COUNT Function
17:27 COUNTIF Function
19:37 COUNTIFS Function
22:22 AVERAGE Function
27:17 ROUND Function
31:52 CONCATENATE Function
37:17 INDEX Function
40:02 OFFSET Function
44:57 MATCH Function
51:07 MAX Function
51:12 TRIM Function
53:57 LEN Function
55:07 SQRT Function
56:12 IF Function
1:07:42 AND Function
1:12:32 TODAY Function
1:13:17 Quick Access Bar
1:18:37 Conditional Fomatting
1:37:58 Color Scale
1:38:33 Using Formulas for Conditional Formatting
1:47:48 Logical Excel Functions
1:57:58 IFERROR Function
2:00:43 IFNA Function
2:03:41 NESTED IF Function
1:11:46 TEXT Functions
2:11:56 LOWER Function
2:13:16 UPPER Function
2:16:46 RANDBETWEEN Function
2:17:31 NAME RANGEs IN Excel
2:20:11 Lookup Functions
2:20:26 VLOOKUP Function
2:22:51 HLOOKUP Function
2:23:56 Formula Auditing
2:24:01Trace Precedents & Dependents
2:25:26 Error Checking
2:26:46 Show Formulas
2:27:16 Text To Column
2:29:51 Data Validation
2:40:16 What-if Tools
2:49:42 Scenario Manager
2:54:27 Data Table
2:56:17 SORT
2:56:27 Filter
3:00:02 WRAP Text
3:01:22 Merge Cell
3:01:27 Insert Comments
3:11:52 Large Function
3:23:32 Charts In Excel
3:41:12 Pie Charts In Excel
3:41:32 Pivot Tables
3:58:38 Slicers In Pivot Tables
3:56:18 Data Analysis Using Excel
4:02:09 VBA & Macros
4:15:19 Assign A Macros
4:15:24 Record A Macros
4:15:29 Debuggingruclips.net/user/sgaming/emoji/7ff574f2/emoji_u1f534.svg
You guys are doing a great job, keep up the good work !!
you all are the best thanks for providing the video in youtube and please inform "Saurabh" that I am his biggest fan.
Hey Kartikey, thanks for the compliment! We are delighted to have learners like you
on-board with us. Do subscribe and stay tuned for future updates. Cheers!
Hi. How do we get the materials used so we can practice too
Hi Mahender, thanks for the compliment! Please mention your email id (it will not be published). We will forward the dataset to your email address.
1:08 Excel Functions
1:08 SUM Function
3:58 SUMIF Function
13:27 COUNT Function
17:27 COUNTIF Function
19:37 COUNTIFS Function
22:22 AVERAGE Function 27:17 ROUND Function 31:52 CONCATENATE Function 37:17 INDEX Function 40:02 OFFSET Function 44:57 MATCH Function 51:07 MAX Function 51:12 TRIM Function 53:57 LEN Function 55:07 SQRT Function 56:12 IF Function 1:07:42 AND Function 1:12:32 TODAY Function 1:13:17 Quick Access Bar 1:18:37 Conditional Fomatting 1:37:58 Color Scale 1:38:33 Using Formulas for Conditional Formatting 1:47:48 Logical Excel Functions 1:57:58 IFERROR Function 2:00:43 IFNA Function 2:03:41 NESTED IF Function 1:11:46 TEXT Functions 2:11:56 LOWER Function 2:13:16 UPPER Function 2:16:46 RANDBETWEEN Function 2:17:31 NAME RANGEs IN Excel 2:20:11 Lookup Functions 2:20:26 VLOOKUP Function 2:22:51 HLOOKUP Function 2:23:56 Formula Auditing 2:24:01Trace Precedents & Dependents 2:25:26 Error Checking 2:26:46 Show Formulas 2:27:16 Text To Column 2:29:51 Data Validation 2:40:16 What-if Tools 2:49:42 Scenario Manager 2:54:27 Data Table 2:56:17 SORT 2:56:27 Filter 3:00:02 WRAP Text 3:01:22 Merge Cell 3:01:27 Insert Comments 3:11:52 Large Function 3:23:32 Charts In Excel 3:41:12 Pie Charts In Excel 3:41:32 Pivot Tables 3:58:38 Slicers In Pivot Tables 3:56:18 Data Analysis Using Excel 4:02:09 VBA & Macros 4:15:19 Assign A Macros 4:15:24 Record A Macros 4:15:29 Debugging
thanks
THANK YOU
Very helpful.Thankyou
Thank you so much
You people are gems on the RUclips who channelises every topic..... A Big thanks
ive learnt so much from indian youtube educators than i have anywhere else. thank you india, i love u. 🧡
The best things in life are always FREE. Thank you Edurika
This a life saver if you wanna learn MS-EXCEL!
Am in just love with the Contents of Edureka.. Simple but powerful explanations.. thanks you
"Thank you for this content, was finding for a comprehensive course entailing step by step details to work in excel without getting confused. "
Thank you edureka!
This is the best Excel Tutorial i have ever seen, i have gone through many channels but never found content like this, thanks edureka for making such great learning videos.
It would be really great if you could share the sheet used in this tutorial for practice, i would highly appreciate!!
We are glad to have learners like you. Please do share your mail id so that we can send the notes or source codes. Do subscribe our channel and hit that bell icon to never miss an video from our channel
Biggest thanks to this channel. I'm learning a lot from you!
This was a very comprehensive session. I didn't find any such video, with the kind of examples and explanations, which were given here. Thank you so much for posting this.
Thanks for the compliment! We are glad we could help. Do subscribe to our channel to stay posted on upcoming tutorials.
Thank you sooo much I learnt excel in a good way and I got knowledge through your valuable time
You are welcome. We hope we keep encouraging you.
Please can you share the excel file so that people can perform it simultaneously and it will be very helpful.
Awesome!!
Before coming to this video i had tried several others but could not find the quality of knowldege and clarity imparted elsewhere.
thankyou for the wondeful video!!
Excellent tutorial !!!
But in regression, y is called response variable while x is predictor or regressor variable.
Great Job....really helpful, could you please share the spreadsheet for practice?
I'm learning Advanced Excel for the first time, but the way in which you are explaining this course is helpful. I hope this course will provide me with an opportunity to excel in MS Excel. Thank you very much for this video. I don't have even words to thank you for this valuable resource.
You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thanks for saving several bucks for me!!! Great work.
This is the best video on excel. The previous ones I watched weren't any bit comprehensive and were so short. This is a gem. Also, could you please share your workbook sample for easier practice? thank you!!!!!!!!!
Thanks for showing interest in edureka! Kindly share your mail id for us to share the datasheet/ source code :) Do subscribe for more videos & updates
I am really learning a lot here. This is unarguably the best video on Excell I have come across. Can you please share the source files so I can practice alongside.
Amazing video👍👍.. Everything is explained in simple terms with proper examples.... Simply loved it. I had a great learning experience. Thank you for this guide on excel.
After watching this video I came to know that excel is an ocean the more you explore the more you can learn
Your Voice So Comfortable and Speaking Style Confidential Excel Complementry free .Good Job.
Waaoo! Amazing! This video covers already everything Which can help us better. Thank you for this video
Glad it was helpful!
I have to thank 'edureka' channel. Thank you so much for taught us more clearly and gave a more information about Excel. Now, I got more information about Excel. It took me 17 days to watch this video completely. I appreciate your work.
Great to see that our videos and contents are making you perform better and understand better :) We are glad that you've enjoyed your learning experience with us .Thank you for being a part of Edureka's team:) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@@edurekaIN Can you please provide me the worksheets to practice?
Thank you for this course, very easy to follow and practical.
Thank you for such a informative session 😃 There are very less people who offer free knowledge
You are welcome👍
Do subscribe to our channel to stay posted on upcoming tutorials: ruclips.net/user/edurekaIN.
good job by edureka and this lady also.
Wonderful... Course.. It is amazing. One who is starting this course can easily learned a lot... Thanks
Please give nobel prize to these guys....
I wish more and more people can watch your informative videos.
Thank you 😊 Glad it was helpful!! Keep learning with us...
Quite happy that I have subscribed your channel! Explanation is really so much professional & covering even the small points is really commendable! Keep it up! ❤️💯
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
excellent video thank u. helping in my job preparation
Thanks for this video. It's really helped me in course ✌
MS Excel is a very basic but important tool. It is important to learn it as it's a skill that help in data analyzing, data visualizations. Now a days, many people export data from SAP to Excels.
edureka is better than university
Great content!!!
It would be lovely to have the dataset in order to keep practicing.
EXCELLENT Training on EXCEL!!!!!! THANKS ALOT FOR THE TRAINER FOR THE DETAILED EXPLANATION ..thanks again
Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)
This is truly an amazing video. almost all topic covered. well explained. thankyou so much.
I've learnt so much from this video , great video , so much informative in East language . Thank you edureka for this video .
Thankyou edureka..You are doing a good job❤️
This is the best of all videos I have seen on RUclips to learn excel. Great efforts by Trisha.
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
This tutorial helped me to a great extent. Thanks for the video, appreciated your effort.
Thank you for uploading quality content with no advertisements
Good To know our videos are helping you learn better 😊 Stay connected with us and keep learning ! Do subscribe the channel for more updates : )
Thanks for Excel video in English. Liked and subscribed..👍
fantastic course....thanks for giving it free.....great job!
Good, The voice and accent of the teacher is really great.
Excellent Mam I have Realised That What is the Importance of Excel Thankyou
Thank you very much for this informative and technical session.
Thank you for the compliment !Glad our channel is helping you . Do subscribe our channel and hit that bell icon to never miss an video from our channel .
sir can u plz share exercise file to practice with video
Please share your email id with us (it will not be published). We will forward the files to your email address.
Hi, Edureka team, thanks for the outstanding Excel training. Could you be kind to share the practice exercises (the Excel sheets with examples) explained in the vedio.
We are glad to have learners like you. Please do share your mail id so that we can send the notes or source codes. Do subscribe our channel and hit that bell icon to never miss an video from our channel
Thank you for this video ❤️ It really open my mind and gain more knowledge about Ms. excel 😊😊 and thank you for put the time stamp too. Really apreaciated 😊🙏
Hey Naomi, thanks for the wonderful feedback! We are glad we could help. Do subscribe to our channel to stay posted on upcoming tutorials.
Hey endureka! it is so amazing to follow this videos. Would request share those sheets so that we can practice on that simultaneously.
Please mention your email id (it will not be published). We will forward the files to your email address.
@@edurekaIN can you share the sheets for the practice
Thanks for a great beginner's lesson!
thanks a lot edureka until now no platform has provided such great knowledge for free thanks once again i learnt a lot....
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Hii..very good video..i want ur excel worksheet for practice. Im requesting to share ...
Please mention your email id (it will not be published). We will forward the file to your email address.
Can't thank enough Eudreka 🙌
Glad you liked it ! We are glad to have learners like you . Do subscribe our channel and hit that bell icon to never miss an video from our channel .
perfect exposure and platform to learn.
Here is the lists
1:08 Excel Functions 1:08 SUM Function 3:58 SUMIF Function 13:27 COUNT Function 17:27 COUNTIF Function 19:37 COUNTIFS Function 22:22 AVERAGE Function 27:17 ROUND Function 31:52 CONCATENATE Function 37:17 INDEX Function 40:02 OFFSET Function 44:57 MATCH Function 51:07 MAX Function 51:12 TRIM Function 53:57 LEN Function 55:07 SQRT Function 56:12 IF Function 1:07:42 AND Function 1:12:32 TODAY Function 1:13:17 Quick Access Bar 1:18:37 Conditional Fomatting 1:37:58 Color Scale 1:38:33 Using Excel Formulas for Conditional Formatting 1:47:48 Logical Excel Functions 1:57:58 IFERROR Function 2:00:43 IFNA Function 2:03:41 NESTED IF Function 1:11:46 TEXT Functions 2:11:56 LOWER Function 2:13:16 UPPER Function 2:16:46 RANDBETWEEN Function 2:17:31 NAME RANGEs IN Excel 2:20:11 Lookup Functions 2:20:26 VLOOKUP Function 2:22:51 HLOOKUP Function 2:23:56 Formula Auditing 2:24:01 Trace Precedents & Dependents 2:25:26 Error Checking 2:26:46 Show Formulas 2:27:16 Text To Column 2:29:51 Data Validation 2:40:16 What-if Tools 2:49:42 Scenario Manager 2:54:27 Data Table 2:56:17 SORT 2:56:27 Filter 3:00:02 WRAP Text 3:01:22 Merge Cell 3:01:27 Insert Comments 3:11:52 Large Function 3:23:32 Charts In Excel 3:41:12 Pie Charts In Excel 3:41:32 Pivot Tables 3:58:38 Slicers In Pivot Tables 3:56:18 Data Analysis Using Excel 4:02:09 VBA & Macros 4:15:19 Assign A Macros 4:15:24 Record A Macros 4:15:29 Debugging
One of the best excel learning videos
This video helped me alot. Worth watching..Great job...👍🏻👍🏻
Can anyone tell me how can I highlight cells if that is 10 % greater than from total average.
Hi Ravinder, You can go to home >> styles >> conditional formatting >> highlight cells rules >> greater than
that opens up a new window which had a field in which you can fill the number and choose the highlight colour. Hope this helps!
Very good video for basic learners to pick up Excel. The trainer is very good in explaining ! Is there possibility of the Excel sheet which is shown in this video can be send that will be helpful for the practice.
Thanks for the compliment! Please mention your email id (it will not be published). We will forward the dataset to your email address.
Can you please share the excel file.
Thank u for this video. excell is such a powerful tool and very few peoples know its all functions and i am one of them. so i have to improved my skill. now i can improve it ,thanks for your special effort
Thanks for the compliment! We are glad we could help. Do subscribe to our channel to stay posted on upcoming tutorials.
Thank you for this video
It really helped me
VERY USEFUL AND CLEAR EXPLANATION THANKS MAM AND THANKS TO EDUREKA
You're Welcome 😊 Glad it was helpful!! Keep learning with us..
can you provide me the Excel file on which you made this video?
Excellent Video to learn EXCEL Explained in easy way
great job guys , very helpful
Thanks for such useful tutorial. Could you please send me your spreadsheet.
Thank you so much for providing this video. It is so helpful to understand everything from basics. just a small request to edureka that can you please provide the link of this excel sheet which you are using so that we can revise the formulas and methods along side. or if its already available can somebody reply me with that link.
Thanks Edureka!!
Hi Huzefa ! Thank You so much for watching the video :) Glad you like it :) Share your mail id with us .We'll update the data sheet and source codes soon :) Do subscribe the channel for update from our channel
I loved the voice...
By the way it was great session..finished in 2 days
I have done the paid course from my neighbour institute of advance excel but this vedio is far better than that institute. I really appreciate it . And i can make the notes of this , but it would be better if you could provide the pdf or ppt of this vedio (*If you can) . Thank you.
Good to know our contents and videos are helping you learn better . We are glad to have you with us ! Please share your mail id to send the data sheets to help you learn better :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Nice explanation....
Thank you edureka for making knowledge video for free🙏
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thanks for the hard work
Hey edureka! Thanks for all such amazing videos. Would request share those sheets so that we can practice on that simultaneously.
Thanks for the compliment! Please share your email id with us (it will not be published). We will forward the files to your email address.
Thanks for upload This Video.
Excellent video Madam, this has helped me a lot to remember all the important functions and has been very helpful in my work life.
Fantastic Video.. Explanations with with examples
Nice one. Please provide the excel file for this course.
learnt a lot
This video is the holy grail for Excel !!! big thanks
superb edureka u did great thing keep do it
Thank you for watching our video. Do subscribe to the channel and hit the bell icon to never miss an update from us in the future. Cheers!
Thank you so much for this amazing video, never seen such simplified explaination about excel, it would be really helpful if you could share the workbook for practice, thanks again!
Glad to hear our contents are helping you ! Please provide your mail id to share the data sheet :) We’ll update you soon
@@edurekaIN hello, i had shared my mail id recently but i dont see it here again, and i havent even recieved the files, can help me out!
thank you @edureka
Great job 4 hrs presentation ....great job
Great video
Great teaching you provided
The way of your teaching is excellent💯
I appreciate your performance.
Have a Greatful life and give more helping videos for all.
Thanks for the Video, Team 👍
Eureka !!! Feeling blessed after finding Edureka 🙏
Thanks Rahul , we are glad you feel this way. We are delighted to have you on our channel. Do stay tuned for future updates. Cheers!
We can do the excel 2010 versions.
Sure, you certainly could.
Thanks for sharing this video of advance excel really helpful for the new students to master excel.
Hindi main bhi bna do video
Hi Satish, thanks for watching the video. We will process your request as soon as possible. Here's a link to our Hindi channel ruclips.net/channel/UCywyZ4r4FTKExrPl9rf-ggw Do subscribe and stay tuned for future updates. Cheers!
This is the most detailed excel tutorial I have seen on RUclips. Please can I get the spreadsheet used in the video? I would really appreciate it. Once again, thank you for this tutorial!
Thanks for the compliment! Please share your email id with us (it will not be published). We will forward the files to your email address.
everything is contain in this vedio
Your video are very details and easy to understand I'm glad to have found the channel, I have since subscribed to get latest updates.Well done and keep up the excellent work.
Please provide data set sheets so that I can practice to learn maximum by practicing.
Hi, thanks for an comprehensive tutorial. It has been highly beneficial. Can you please share the data set in order for me to practice. Thanks in advance.
Hey there :) We are glad to have you with us :) and more glad to have learners like you with us ! We are happy to share the source code ,please do drop your mail id to share the same :) Thank You for being a part of our Edureka team : ) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thank you very much for the tutorial
You are welcome! Keep learning with us :)