Microsoft Excel Tutorial for Beginners | Excel Training | Excel Formulas and Functions | Edureka

[@edurekaIN]

Stay updated in trending technologies with Edureka KZbin Channel, Subscribe now: bit.ly/2JIfN5O Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎" to get Flat 20% Off on this training. 🔴Subscribe to Edureka KZbin 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 Debuggingkzbin.infogaming/emoji/7ff574f2/emoji_u1f534.svg

[@malteshkumar421]

You guys are doing a great job, keep up the good work !!

[@KartikeyRiyal]

you all are the best thanks for providing the video in youtube and please inform "Saurabh" that I am his biggest fan.

[@edurekaIN]

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!

[@nokunato]

Hi. How do we get the materials used so we can practice too

[@edurekaIN]

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.

[@qasehnoor476]

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

[@Ninja-iq2xt]

thanks

[@nikolemagliano2967]

THANK YOU

[@sisiragudapati122]

Very helpful.Thankyou

[@shridhart4306]

Thank you so much

[@shivangikumari2871]

You people are gems on the KZbin who channelises every topic..... A Big thanks

[@statmaxxer]

ive learnt so much from indian youtube educators than i have anywhere else. thank you india, i love u. 🧡

[@anaida53]

This a life saver if you wanna learn MS-EXCEL!

[@jeslyjoseph3472]

Am in just love with the Contents of Edureka.. Simple but powerful explanations.. thanks you

[@nyanlinnhtet9082]

The best things in life are always FREE. Thank you Edurika

[@czaratejohn]

Biggest thanks to this channel. I'm learning a lot from you!

[@pragyamahadule6598]

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.

[@edurekaIN]

Thanks for the compliment! We are glad we could help. Do subscribe to our channel to stay posted on upcoming tutorials.

[@ginujohn4894]

"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!

[@mennahesham2612]

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

[@edurekaIN]

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

[@shaikniyaz7042]

Thank you sooo much I learnt excel in a good way and I got knowledge through your valuable time

[@edurekaIN]

You are welcome. We hope we keep encouraging you.

[@utsavjain2219]

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

[@pratik9296]

Excellent tutorial !!! But in regression, y is called response variable while x is predictor or regressor variable.

[@paragjoshipsj]

Thanks for saving several bucks for me!!! Great work.

[@vinuthomas91]

Great Job....really helpful, could you please share the spreadsheet for practice?

[@TSSACADEMY]

good job by edureka and this lady also.

[@callenhiroetarenk2068]

edureka is better than university

[@HitovMoustache]

Thank you for this course, very easy to follow and practical.

[@nwachukwudavidc8874]

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.

[@premmehta7555]

Please can you share the excel file so that people can perform it simultaneously and it will be very helpful.

[@ankitsoni1869]

Wonderful... Course.. It is amazing. One who is starting this course can easily learned a lot... Thanks

[@accountingdean5152]

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.

[@edurekaIN]

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

[@Ak-qn9iu]

Please give nobel prize to these guys....

[@icedwater9763]

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

[@edurekaIN]

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

[@shefalimandal7415]

Waaoo! Amazing! This video covers already everything Which can help us better. Thank you for this video

[@edurekaIN]

Glad it was helpful!

[@bonalaharika7869]

VERY USEFUL AND CLEAR EXPLANATION THANKS MAM AND THANKS TO EDUREKA

[@edurekaIN]

You're Welcome 😊 Glad it was helpful!! Keep learning with us..

[@reddyvishnu66]

After watching this video I came to know that excel is an ocean the more you explore the more you can learn

[@priyankajain288]

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.

[@nixsoftofficial]

I wish more and more people can watch your informative videos.

[@edurekaIN]

Thank you 😊 Glad it was helpful!! Keep learning with us...

[@amishachauhan6848]

Thanks for this video. It's really helped me in course ✌

[@sourabhparit5491]

Thank you for such a informative session 😃 There are very less people who offer free knowledge

[@edurekaIN]

You are welcome👍 Do subscribe to our channel to stay posted on upcoming tutorials: kzbin.info.

[@rahuldev8823]

Your Voice So Comfortable and Speaking Style Confidential Excel Complementry free .Good Job.

[@sajidulahmed7972]

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! ❤️💯

[@edurekaIN]

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

[@prakashrajn5339]

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.

[@edurekaIN]

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

[@nehapatil9127]

@@edurekaIN Can you please provide me the worksheets to practice?

[@Thehopefullone]

Thankyou edureka..You are doing a good job❤️

[@raisarahman5712]

excellent video thank u. helping in my job preparation

[@FaysalEasyExcel]

This is truly an amazing video. almost all topic covered. well explained. thankyou so much.

[@rajeevnaidu5338]

fantastic course....thanks for giving it free.....great job!

[@akshayjain6778]

sir can u plz share exercise file to practice with video

[@edurekaIN]

Please share your email id with us (it will not be published). We will forward the files to your email address.

[@Mahesh-nu4hi]

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

[@mohammadsameer7576]

This tutorial helped me to a great extent. Thanks for the video, appreciated your effort.

[@amritasewani1293]

This video helped me alot. Worth watching..Great job...👍🏻👍🏻

[@neok1161]

This video is the holy grail for Excel !!! big thanks

[@digitalagencyprodigitaly6459]

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.

[@microgp6041]

Good, The voice and accent of the teacher is really great.

[@Elizabeth0512]

Thanks for Excel video in English. Liked and subscribed..👍

[@senthilmuruganrajendiran4416]

Excellent

[@manishrawat211]

Thanks for a great beginner's lesson!

[@safwanmujawar9102]

I've learnt so much from this video , great video , so much informative in East language . Thank you edureka for this video .

[@chandanroy9597]

Thank you very much for this informative and technical session.

[@edurekaIN]

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 .

[@davidcerezo5184]

Great content!!! It would be lovely to have the dataset in order to keep practicing.

[@nainagupta1126]

Can you please share the excel file.

[@alekhyapawar570]

Can't thank enough Eudreka 🙌

[@edurekaIN]

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 .

[@RahulKumar-bi5dn]

can you provide me the Excel file on which you made this video?

[@karansharma130]

Excellent Mam I have Realised That What is the Importance of Excel Thankyou

[@deepthidas9370]

Hii..very good video..i want ur excel worksheet for practice. Im requesting to share ...

[@edurekaIN]

Please mention your email id (it will not be published). We will forward the file to your email address.

[@shubhamsalvi115]

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

[@edurekaIN]

Thanks for the compliment! We are glad we could help. Do subscribe to our channel to stay posted on upcoming tutorials.

[@tahsincetinkaya7970]

One of the best excel learning videos

[@karangulareddy]

EXCELLENT Training on EXCEL!!!!!! THANKS ALOT FOR THE TRAINER FOR THE DETAILED EXPLANATION ..thanks again

[@edurekaIN]

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

[@nombutter]

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 😊🙏

[@edurekaIN]

Hey Naomi, thanks for the wonderful feedback! We are glad we could help. Do subscribe to our channel to stay posted on upcoming tutorials.

[@kailasdurgisht1882]

Thank you edureka for making knowledge video for free🙏

[@edurekaIN]

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

[@ravindersinghbisht1223]

Can anyone tell me how can I highlight cells if that is 10 % greater than from total average.

[@edurekaIN]

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!

[@priyanksri007]

This is the best of all videos I have seen on KZbin to learn excel. Great efforts by Trisha.

[@edurekaIN]

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

[@vaibhavsharma5226]

Thanks for the hard work

[@hashmathashu]

Hey endureka! it is so amazing to follow this videos. Would request share those sheets so that we can practice on that simultaneously.

[@edurekaIN]

Please mention your email id (it will not be published). We will forward the files to your email address.

[@ashutosh3858]

@@edurekaIN can you share the sheets for the practice

[@dhananjaychaurasiyaarmy432]

Nice explanation....

[@waradkar3078]

Excellent Video to learn EXCEL Explained in easy way

[@chefsharan4241]

great job guys , very helpful

[@saqin123]

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.

[@edurekaIN]

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

[@muhammedsuhair5071]

Thank you for this video It really helped me

[@rahulekhe3514]

Great job 4 hrs presentation ....great job

[@shivamgarg7034]

perfect exposure and platform to learn.

[@sabujali83]

Thanks

[@chowdhuryazizul8699]

Thanks for such useful tutorial. Could you please send me your spreadsheet.

[@waqaskhan-zi4ub]

Thanks for upload This Video.

[@CromaCampusOfficial]

Thanks for sharing this video of advance excel really helpful for the new students to master excel.

[@travelblrvlogs4783]

learnt a lot

[@theartgallery5662]

Loved it... Easy and simple explanation.

[@MrDotnet123]

thank you @edureka

[@bidurkhanal67]

Excellent tutorial

[@Vgghhgfddd]

I loved the voice... By the way it was great session..finished in 2 days

[@anooop1]

edureka no one can beat

[@Mohammad-zv6rl]

Great video

[@rahultalar]

Eureka !!! Feeling blessed after finding Edureka 🙏

[@edurekaIN]

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!

[@sathyasayaj8272]

superb edureka u did great thing keep do it

[@edurekaIN]

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!

[@jeralenem6984]

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.

[@edurekaIN]

Thanks for the compliment! Please mention your email id (it will not be published). We will forward the dataset to your email address.

[@tundeolaoye1065]

Nice one. Please provide the excel file for this course.

[@dsahera]

Thank you very much for the tutorial

[@edurekaIN]

You are welcome! Keep learning with us :)

[@menonsree1985]

Fantastic Video.. Explanations with with examples

[@chocolateboy8643]

U r teaching method awesome pls send practise File

[@rabotlhokotlhabane9546]

Thanks for the Video, Team 👍

[@subbarajd8979]

We can do the excel 2010 versions.

[@edurekaIN]

Sure, you certainly could.

[@nikhilgs1204]

Thank you for uploading quality content with no advertisements

[@edurekaIN]

Good To know our videos are helping you learn better 😊 Stay connected with us and keep learning ! Do subscribe the channel for more updates : )

[@SATISHKUMAR-ky1nb]

Hindi main bhi bna do video

[@edurekaIN]

Hi Satish, thanks for watching the video. We will process your request as soon as possible. Here's a link to our Hindi channel kzbin.info/door/ywyZ4r4FTKExrPl9rf-ggw Do subscribe and stay tuned for future updates. Cheers!

[@MuradWrite55]

everything is contain in this vedio

[@killerdiamond2618]

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.

[@AtifAslamUE]

Please provide data set sheets so that I can practice to learn maximum by practicing.

[@nawazeeshali4340]

Excellent video Madam, this has helped me a lot to remember all the important functions and has been very helpful in my work life.

[@worldnewstv3140]

great job thanks

[@huzefachokla9084]

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

[@edurekaIN]

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