The Top 25 tips and tricks for Excel 2016. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not seen before and others that you have been using incorrectly. My personal favorite is #21. Become more productive using Excel at work, school and home.

Check out the Advanced Excel video at    • Top 15 Advanced Excel 2016 Tips and T...  .
Another 15 Excel 2016 Tips & Tricks:    • Another 15 Excel 2016 Tips and Tricks  
Introduction to Excel for Beginners:    • Excel Tutorial - Beginner  
Don't miss the latest Ultimate 50 Excel Tips and Tricks:    • 50 Ultimate Excel Tips and Tricks for...  

Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533

Contents 0:00
1. Quick Analysis Tool 0:47
2. Filter 1:44
3. Drop-Down List 2:25
4. AutoFit Column Width 3:12
5. Transpose 3:47
6. Remove Duplicates 4:13
7. Goal Seek 5:23
8. VLOOKUP 6:55
9. Flash & Auto Fill 9:06
10. Paste Special Values 10:47
11. Images in Charts 11:50
12. IF Function 12:28
13. Insert Screenshot 13:40
14. Absolute Cell Reference 14:15
15. Show Formulas 15:54
16. Text to Columns 16:57
17. Conditional Formatting 18:11
18. PowerPivot 19:36
19. Freeze Panes 20:46
20. Ctrl-Arrow Keys 21:40
21. 3D References 21:58
22. Forecast Sheet 23:43
23. SUMIFS Function 24:16
24. IFERROR Function 25:38
25. Filled Maps 26:30

#seletraining #excel #tipsandtricks