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 Another 15 Excel 2016 Tips & Tricks: Introduction to Excel for Beginners: 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


  1. Very good
  2. Great voice & tutorial! Subbed✔
  3. Hi Sele,
    Thank you for your great Tips, I really gain so much from it. but I am wondering there are more stuff in excel, are you planning to post them as well??
  4. Tons of great Excel insight and knowledge gained just now. Thanks for posting this!
  5. Outstanding Tips and Tricks for Excel 2016.  A must see for those on the bridge to excellence in Excel (Yes, I did.)
  6. because of excel's inability to handle in/out inventory with barcodes without some paid vba or whatever it seems to have limits and slows down when you scan more than 100 or so items. thus 11:00 paste special could come handy as you'd just use paste special for ur stock numbers, which until then has been added or subtracted 1 at a time by the barcode scanning process. u'll replace ur stock numbers with paste special turning it into permanent data which enables you to go and delete the barcode scan sheet so it stops the 100 or so calculations that was slowing it down! otherwise it takes like a minute per scan when it becomes laggy like that. actually you probably need 2 colums where 1 represents the saved stock and another column has the formula with added barcode scans. now if u sell daily over a 100 or so items then something else is warranted unless u wanna go through that hassle multiple times a day, but by then u can probably afford to invest in something more serious anyway.
  7. 6:40 the magic number is not 197 but 196.874686716792. now what if i wanted something that would indeed calculate it as 197 but then the 6000 would be 6000.XX?
    the bad thing with goal seek is also that if you and change any of the other numbers it won't update the 197 with it, so it's not dynamic.
  8. Thank you, for this beautiful explanation, sir.
  9. Does any one know how to keep the ratios between cells the same when one is changed?. For example If 100ml is 50 calories then i change it to 200ml so it automatically changes the 50 to 100 calories....
  10. Nice video. Helpful for learner. I am also a learner. To learn more visit:
  11. Great! Thank you!
  12. Very good presentation!!!!!
  13. Matthew 28: 19-20 Go ye therefore, and teach all nations, baptizing them in the name of the Father and of the Son, and of the Holy Ghost: Teaching them to observe all things whatsoever I have commanded you: and, I am with you always, even unto the end of the world. Amen.
  14. Very good
  15. Hi, I'm working on an excel that took a lot of my time to do. I wonder if I can copy or delete only the unfiltered cell. Coz while I did the filtering I intend to copy the unfiltered cell to another sheet but I ended up copying all including the filtered cell.
    Thank you in advance.
  16. Very helpful guide, thank you and appreciated!
  17. Hi how to merge excel worksheets in a single workbook
  18. No.18 Powerpivot at 19:37 is very useful
  19. Very useful and nicely explained. I have been using excel's lots of feature in my day to day work and still found this very good; learnt something new. Thanks a lot for your effort.

Additional Information:

Visibility: 898267

Duration: 27m 44s

Rating: 11219