Okebiz Video Search



Title:☑️ Top 30 Advanced Excel Tips and Tricks
Duration:01:10:56
Viewed:328,821
Published:20-08-2019
Source:Youtube

Learn the top 30 advanced Microsoft Excel features you need to know to go from beginner to advanced Excel user.

Table of Contents:

1. Get Data from Folders 0:22
2. Text to Columns 5:34
3. Remove Duplicate Values 7:22
4. AutoFill & Fill Handle 8:28
5. Flash Fill 10:41
6. Custom Lists 12:55
7. Freeze Panes 14:36
8. New Window and Arrange 15:48
9. Tables 17:21
10. Ideas 21:37
11. Rich Data Types 23:00
12. Fuzzy Matching 24:53
13. Data Validation Dropdown List 29:28
14. Data Validation Cell Message 32:00
15. Create a Named Constant 33:26
16. IF Function 35:03
17. COUNTIFS Function 36:29
18. SUMIFS Function 37:34
19. VLOOKUP Function 38:54
20. INDEX & MATCH Functions 40:06
21. Dynamic Arrays Functions 42:59
22. Display Formulas 49:14
23. Filters 50:10
24. Advanced Filters 52:55
25. Tables Slicers 56:23
26. PivotTables 57:58
27. Pivot Table Slicers & Timelines 1:02:09
28. Show Values As Calculations 1:03:49
29. Data Model Relationships 1:05:17
30. Data Model Advanced DAX Formulas 1:08:48

Get the workbook used in the video to follow along: https://howtoexcel-my.sharepoint.com/... 👇

Check out my full courses and ebooks here
👉 https://www.howtoexcel.org/courses/

DOWNLOAD the example workbook here
📖 https://www.howtoexcel.org/downloads/

SUBSCRIBE & get my 3 FREE eBooks
📧 https://www.howtoexcel.org/newsletter/

CONNECT with me on social
Facebook: https://www.facebook.com/howtoexcelblog
Twitter: https://twitter.com/howtoexcelblog
LinkedIn: https://www.linkedin.com/in/john-macd...

Thanks for all your support!

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Excel 2016 Advanced Excel 2016 Advanced
38:45 | 112,039
50 Ultimate Excel Tips and Tricks for 2020 50 Ultimate Excel Tips and Tricks for 2020
50:17 | 422,581
30 Ultimate Outlook Tips and Tricks for 2020 30 Ultimate Outlook Tips and Tricks for 2020
37:57 | 405,266
10 Super Neat Ways to Clean Data in Excel 10 Super Neat Ways to Clean Data in Excel
18:47 | 351,536
How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work files How to Pass Excel Assessment Test For Job Appli...
19:48 | 434,861
Excel shortcut keys you SHOULD know! Excel shortcut keys you SHOULD know!
08:48 | 836,812
Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!) Excel Pivot Tables EXPLAINED in 10 Minutes (Pro...
13:22 | 251,580
Deep Learning: A Crash Course Deep Learning: A Crash Course
33:03 | 837,252


coinpayu