Wed, Sep 30 2020

Trending
  • Over 2,500 Workplace Professionals listed on OSW List
  • Over 11,000 Coworking locations listed on OSW

Author: ADMIN
Title: Top 25 Excel 2016 Tips and Tricks
Category: Collaboration
Description:

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 https://youtu.be/PU8ACyYxJBk.
 
Another 15 Excel 2016 Tips & Tricks: https://youtu.be/L9SKTj2gevA
 
Introduction to Excel for Beginners: https://youtu.be/WxUQLHJn77Q
 
Contents: 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

Votes: 0
Views: 297

There are no comments.