🔥 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