50 Ultimate Excel Tips and Tricks for 2020
The ultimate compilation of Excel tips and tricks to enhance your productivity using Excel. Updated for 2020! I've combined long-established tips and tricks with new ones Microsoft added in 2019 and 2020. You'll find solutions to the most common challenges you face in Excel.
Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533
Contents 0:00
1. Move Data 0:35
2. XLOOKUP() 1:04
3. Filter List 2:24
4. Ideas 3:04
5. Remove Blanks 3:54
6. Quick Analysis Tool 4:28
7. AutoFit Column Width 5:27
8. Absolute Cell Reference 5:57
9. Paste Special Values 7:19
10. Drop-Down List 8:05
11. FILTER() 9:15
12. Remove Duplicates 10:43
13. Difference Between Lists 11:31
14. Flash Fill 12:15
15. AutoFill 13:06
16. Data Types 13:53
17. Transpose 15:11
18. Freeze Panes 15:37
19. Text to Columns 16:27
20. Recommended Pivot table 17:25
21. Slicers 18:04
22. Conditional Formatting 19:01
23. IF() 20:29
24. 3D References 21:12
25. Forecast Sheet 22:45
26. SUMIFS() 24:00
27. IFERROR() 25:15
28. Ctrl-Arrow Keys 26:03
29. Filled Maps 26:26
30. PMT() 27:13
31. Show Formulas 28:20
32. Advanced Select 29:10
33. Named Range Shortcut 29:56
34. Hide Cells 30:47
35. COUNTBLANK() 31:30
36. Natural Language Query 31:59
37. Goal Seek 33:08
38. Insert Screenshot 34:30
39. Power Pivot 35:14
40. 3D Maps 36:16
41. ISBLANK() 39:08
42. Analysis ToolPak 39:45
43. CONVERT() 40:48
44. Get Data from Web 41:24
45. People Graph 42:59
46. SORT() 44:18
47. Status Bar Info 45:36
48. Insert Multiple Rows 46:22
49. CHOOSE() 46:53
50. UNIQUE() 48:50
Видео 50 Ultimate Excel Tips and Tricks for 2020 канала Sele Training
Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533
Contents 0:00
1. Move Data 0:35
2. XLOOKUP() 1:04
3. Filter List 2:24
4. Ideas 3:04
5. Remove Blanks 3:54
6. Quick Analysis Tool 4:28
7. AutoFit Column Width 5:27
8. Absolute Cell Reference 5:57
9. Paste Special Values 7:19
10. Drop-Down List 8:05
11. FILTER() 9:15
12. Remove Duplicates 10:43
13. Difference Between Lists 11:31
14. Flash Fill 12:15
15. AutoFill 13:06
16. Data Types 13:53
17. Transpose 15:11
18. Freeze Panes 15:37
19. Text to Columns 16:27
20. Recommended Pivot table 17:25
21. Slicers 18:04
22. Conditional Formatting 19:01
23. IF() 20:29
24. 3D References 21:12
25. Forecast Sheet 22:45
26. SUMIFS() 24:00
27. IFERROR() 25:15
28. Ctrl-Arrow Keys 26:03
29. Filled Maps 26:26
30. PMT() 27:13
31. Show Formulas 28:20
32. Advanced Select 29:10
33. Named Range Shortcut 29:56
34. Hide Cells 30:47
35. COUNTBLANK() 31:30
36. Natural Language Query 31:59
37. Goal Seek 33:08
38. Insert Screenshot 34:30
39. Power Pivot 35:14
40. 3D Maps 36:16
41. ISBLANK() 39:08
42. Analysis ToolPak 39:45
43. CONVERT() 40:48
44. Get Data from Web 41:24
45. People Graph 42:59
46. SORT() 44:18
47. Status Bar Info 45:36
48. Insert Multiple Rows 46:22
49. CHOOSE() 46:53
50. UNIQUE() 48:50
Видео 50 Ultimate Excel Tips and Tricks for 2020 канала Sele Training
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel 2016 Advanced☑️ Top 30 Advanced Excel Tips and Tricks40 Ultimate Word Tips and Tricks for 2020Excel LAMBDA Function15 Amazing Shortcuts You Aren't Using30 Ultimate Outlook Tips and Tricks for 2020Creating Easy Data Entry Forms in ExcelExcel shortcut keys you SHOULD know!How to easily automate boring Excel tasks with Power Query!10 Amazing (Less Known) Excel Tricks You Should KnowTop 10 Most Important Excel Formulas - Made Easy!Top 15 Microsoft Word Tips & TricksLearn Macros in 7 Minutes (Microsoft Excel)Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners!Excel 2016 Intermediate10 Excel formatting tricks *ONLY* experts know30 Ultimate PowerPoint Tips and Tricks for 2020Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)VLOOKUP Tutorial for Excel - Everything You Need To KnowTop 20 Windows 10 Tips and Tricks