🔥 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/
![[ Review ] Lipice Sheer Color Q | Phiên Bản Thỏ Bảy Màu](https://i.ytimg.com/vi/gdU-fphQYZI/maxresdefault.jpg)
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