🔥 Advanced MS Excel Certification Training (Use Code: YOUTUBE20) :

This Edureka video on “Excel Full Course” is a complete guide for learning Microsoft Excel which covers in-depth knowledge about different excel formulas and functions, conditional formatting, excel Lookup, excel macros & VBA in Ms Excel. Below are the topics covered in this Excel Tutorial:

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

Check out our complete playlist here:

Check out our complete blog list here:

Subscribe to our channel to get video updates. Hit the subscribe button above:

Instagram:

Facebook:

Twitter:

LinkedIn:

Castbox –

– – – – – – – – – – – – – – – – –

#edureka #exceledureka #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse

For more information, Please write back to us at sales@edureka.in or call us at IND: 9606058406 / US: 18338555775 (toll-free).

Nguồn: https://ephraimturner.com

Xem thêm bài viết khác: https://ephraimturner.com/cong-nghe/

Stay updated in trending technologies with Edureka YouTube Channel, Subscribe now: http://bit.ly/2JIfN5O Use code "YOUTUBE20" to get Flat 20% Off on this training. 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 Debugging

best excel anyone can learn even if he/she is a newbie but mam it would be best if you can upload or share the exercise files so that one can practice as well .

Can you please share the workbook ?

plz share practice file

Great tutorial

This is the most detailed excel tutorial I have seen on YouTube. Please can I get the spreadsheet used in the video? I would really appreciate it. Once again, thank you for this tutorial!

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

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

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

very helpful course

thanks for the video…can you please share the excel file??

Hi thank you for the very detailed video. where can i provide my email such that i can get the files to practice as well? thank you!

Wonderful course

How to get files?

wonderful tutorial for beginners.. is it possible to send me the files you used in this tutorial?

thanks alot for this course

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

can you send this excel file for practise purpose

can i get the files used in the tutorial @edureka!

thanks for most wonderful video ever on excel could you please share the files which are use just for sake of practice!!

Great session of excel…almost every concept get cleared…thank you very much…..can you please send these sheet for practice ???

Its really amazing… the teaching technique is fabulous. It would be great if you can share the files so that i can practice Simultaneouslz as i learn

Can you please share the files so I could practice later ?

I love this course can please share the sheet you used

This is a great course. Please how can i get the files used for the course

Can you please share the spreadsheet for the practice. Thank You

Superb. 👍

This is the best Excel course I've seen. How can we download the dataset for practice? Thanks.

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

Hey course session is so amazing.Can i have practice sheets.

Thank you for such an insightful and detailed post. Really loved it. Could you provide the excel spreadsheet so that I could practice on it?

It was a great learning video. Can you please share me the spreadsheets.

Can u share data sheet for practice

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

Thank you for the tutorial. Can i get the spreadsheets template please.

Thanks madam . You have explained very well. The best teaching of excel.

Hey edureka! Thanks for all such amazing videos. Would request share those sheets so that we can practice on that simultaneously.

hi mam request you to please share te exercise files so that we can learn sise by side. this is the best so far . my email id

Can you pls share the spreadsheet.

Amazing video. Thanks a lot for this!

Can you please send the link of the excel file in the video?

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