Top 25 Excel 2016 Tips and Tricks



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

Comments

  1. awesome man, thank you
  2. Could u plz help in explaining the v lookup tool as I couldn't cash it eating ur replay
  3. NICE TIPS. THANK U MAN.
  4. These Tips and Tricks is very useful, thanks.
  5. This video was very, very, very helpful. I enjoyed watching this video
  6. i love u
  7. How to convert kilograms(Kg) to pounds(lbs)?
  8. Good tips! Thanks much!
  9. nice
  10. this video very good for me
  11. Why the caption doesn't appear?
  12. Thanks a lot sir,really helpful :)
  13. thank god i referred to this......helped me a lot.
  14. What a fantastic revision/overview. Thank you very much for this - it's proving exceptionally helpful in refreshing some of my very long-forgotten Excel skills in a big hurry (as well as listing a few great tips I never knew in the first place).
  15. I think you better make small videos with 5 tips. It is very hard to remember all tips in large video.
  16. Thanks sir
  17. Excellent.
  18. Sele, why would my goal-seek return a negative number? I did a little research and a number of commenters in several blogs do experience the same problem.
  19. "Custom Sort" is also a cool function that comes in handy! I created a cool Excel Text that was inspired by these Tips and Tricks style videos to let everyone see how much they know. The Ctrl + ~ is really cool - I didn't know about that! I know that is going to be super useful thanks!


Additional Information:

Visibility: 1379038

Duration: 27m 44s

Rating: 17421