🔥 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

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://marishka-moi.com/

Xem thêm bài viết: https://marishka-moi.com/category/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

Thanks you sharing such a wonderful video …Please provide link for the worksheet used in this tutorial

awesome guide

U r teaching method awesome pls send practise File

I love your video and you just have a new subscriber. But please, can you share your worksheet. I really want to know how it's done from the beginning. Thanks

100000 Likes

Please provide the spreadsheet. Thanks.

Can i get the Practise files

Thanks for the video may you share spreadsheet sheet which you used

Thank you for the video. Can I get the spreadsheet for practice?

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

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.

can u plz provide the datasheet

how do i get the dataset for practice ?

hi,

thank you for the excellent lesson.

can you please share the excel file

Super explanation mam. Plz share me data document to practice.

Thank you to both important persons who give very good explanation in excel and become more convenient to listen and view and learn quickly to both voice. I was happy with this learning for 3 days I spare time for this. Thanks a Lot for helping me comfortable with the work I handle.

It is really helpful video…if you upload the excel file which is more useful for beginners to practice….

Hi, Thank you for the video. Could I get the data set for this video please?

Can you please send the excel file to practice?

hey.. great video… thanks a lot. 🙂 …. could you please share the spreadsheet for practice?

can u send me the excel sheet

Hi,

Could I get the data set for this video please

can you send me excel sheet for practice

Thank you for the tutorial.. can I get the spreadsheet for practice?

love this video

BEST SPEECH AND VOICE

Great video by Edureka. its helping many to understand the Excel better.

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

#Osm yrr