๐ฅAdvanced MS Excel Certification Training (Use Code “๐๐๐๐๐๐๐๐๐”) : https://www.edureka.co/
๐ดSubscribe to Edureka YouTube channel for latest Excel video updates: http://bit.ly/2ADbbb1
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:
00:00 Introduction
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 & 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 & FILTER
3:00:02 WRAP Text
3:01:22 Merge Cell & Insert Comments
3:11:52 Large Function
3:23:32 Charts In Excel
3:41:32 Pivot Tables
3:56:18 Data Analysis Using Excel
3:58:38 Slicers In Pivot Tables
4:02:09 VBA & Macros
4:15:19 Assign A Macros
4:15:24 Record A Macros
4:15:29 Debugging
Check out Edureka Excel Tutorial playlist here: https://bit.ly/34uWKDA
Check out Edureka Excel Tutorial blog list here: https://bit.ly/2xpc1K7
๐๐๐๐ฅ๐๐ ๐ซ๐๐ฆ: https://t.me/edurekaupdates
๐๐๐ฐ๐ข๐ญ๐ญ๐๐ซ: https://twitter.com/edurekain
๐๐๐ข๐ง๐ค๐๐๐๐ง: https://www.linkedin.com/company/edureka
๐๐๐ง๐ฌ๐ญ๐๐ ๐ซ๐๐ฆ: https://www.instagram.com/edureka_learning/
๐๐
๐๐๐๐๐จ๐จ๐ค: https://www.facebook.com/edurekaIN/
๐๐๐ฅ๐ข๐๐๐๐ก๐๐ซ๐: https://www.slideshare.net/EdurekaIN
๐๐๐๐ฌ๐ญ๐๐จ๐ฑ: https://castbox.fm/networks/505?country=IN
๐๐๐๐๐ญ๐ฎ๐ฉ: https://www.meetup.com/edureka/
๐๐๐จ๐ฆ๐ฆ๐ฎ๐ง๐ข๐ญ๐ฒ: https://www.edureka.co/community/
– – – – – – – – – – – – – – – – –
#edureka #exceledureka #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse
For more information, Please write back to us at [email protected] or call us at IND: 9606058406 / US: 18338555775 (toll-free).
source