50 Ultimate Excel Tips and Tricks for 2020

The ultimate compilation of Excel tips and tricks to improve your productivity with Excel. Updated for 2020! I've combined long-standing tips and tricks with new ones added by Microsoft 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

Content 0:00
1. Move data 0:35
2. SEARCHXL() 1:04
3. Filter List 2:24
4. Ideas 3:04
5. Remove blanks 3:54
6. Quick Scan Tool 4:28
7. AutoFit Column Width 5:27
8. Absolute Cell Reference 5:57
9. Paste special values 7:19
10. Dropdown 8:05
11. FILTER() 9:15
12. Remove duplicates 10:43
13. Difference between lists 11:31
14. Flash fill 12:15
15. Autofill 1:06 p.m.
16. Data types 13:53
17. Transpose 15:11
18. Freeze the shutters 15:37
19. Text at columns 16:27
20. Recommended Pivot Table 17:25
21. Slicers 18:04
22. Conditional formatting 19:01
23. SI() 20:29
24. 3D References 21:12
25. Forecast sheet 10:45 p.m.
26. SUMIFS() 24h00
27. IFERROR() 25:15
28. Ctrl-Arrow Keys 26:03
29. Completed cards 26:26
30. PMT() 27:13
31. Show formulas 28:20
32. Advanced selection 29:10
33. Named Range Shortcut 29:56
34. Hide cells 30:47
35. BLANK COUNT() 31:30
36. Natural Language Query 31:59
37. Search for purpose 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 the web 41:24
45. People Chart 42:59
46. SORT() 44:18
47. Status Bar Information 45:36
48. Insert multiple lines 46:22
49. CHOOSE() 46:53
50. UNIQUE() 48:50

#seletraining #excel #tipsandtricks

Please take the opportunity to connect and share this video with your friends and family if you find it useful.