🔥 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://pub-ed-inquiry.org/

Xem thêm bài viết: https://pub-ed-inquiry.org/category/cong-nghe

## edureka! says:

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

## Madhav Pokharel says:

very nice video

## Tahsin Cetinkaya says:

One of the best excel learning videos

## Amrit Kumar says:

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

## Fardin Alam says:

awesome guide

## chocolate boy says:

U r teaching method awesome pls send practise File

## praise amarachi Udeze says:

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

## Sajid Ilyas says:

100000 Likes

## Priya S says:

Please provide the spreadsheet. Thanks.

## HARISH TR says:

Can i get the Practise files

## Evan Hems says:

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

## Joel Daniel says:

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

## Mahesh says:

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

## jeralene m says:

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.

## Tech_SOIL says:

can u plz provide the datasheet

## AMIT BHANDARI says:

how do i get the dataset for practice ?

## saleh mohamed says:

hi,

thank you for the excellent lesson.

can you please share the excel file

## neelima satta says:

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

## Abhilash Jacob Mathew says:

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.

## vp vignesh says:

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

## Jie Dong says:

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

## SUJIT DESHMUKH says:

Can you please send the excel file to practice?

## akshaya mahadevan says:

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

## ravi says:

can u send me the excel sheet

## Niall O'Donohue says:

Hi,

Could I get the data set for this video please

## Amit Gautam says:

can you send me excel sheet for practice

## AZAM says:

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

## monika raghuwanshi says:

love this video

## SATISH SAVALIYA says:

BEST SPEECH AND VOICE

## harjeet singh says:

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

## vishnu reddy says:

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

## Sàñkét Vèrmá says:

#Osm yrr

## WAK Knowledge says:

Great work

Thanks bro

## Roy Simon says:

Can you help me with the worksheet

## mylene beaulieu says:

Very informative.i love it ! If you could share an Excel file to practice then it would be more helpful.

## zaheer afsar says:

You got the new Subscriber 😊

## sachin tiwari says:

Thank you guys

## Deepthi Das says:

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

## zimasa Molapisane says:

Hi, please i need the template, kindly share your mail add

## Rakesh Poyam says:

Maidam can you make videos in hindi language ?

## ILLUSION world says:

Too good to follow… the clarity of the voice and content.Keep the good work on.Pl send me the file if possible.

## naveen says:

Can I have practice sheets which were displayed in this video