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. thank you excellent.
  2. I am so glad that I have found your series on Excel. I have been out of the work force for 4 years and to put it mildly....I am rusty. You speak very clearly and concisely. I can understand and easily follow what I need to know. Thank you and I look forward to viewing your videos on other Office applications.
  3. where is the tilda on the keyboard?
  4. Learned a few nice new tricks. Many already known, but Sparklines, Conditional Formatting Data Bars (and other) are new and pretty cool. Also appreciate ISERROR. Damned "#DIV BY ZERO" drove me nuts! Spent hours with multi-layered IF commands. This is just so sweet and short. Thanks.
  5. Great man. very well explained and very imformative.
  6. Sele Training, some great tips thank you. I am trying to adapt a database, its on one sheet, date details product etc I want to creat an invoice using some of that data on a separate sheet, can it all be done in excel or do i need to revert to somethign else? I was hoping just to put an invooice number in the invoice sheet and it woulr return specific information from the raw data sheet?
  7. Nicely presented.
  8. helpful tips
  9. this is very useful!
  10. Thank you this very helpful tips!
  11. Very Helpful and provides a good over view of excel. Well Done !
  12. I just stumbled across you channel, what a great resource of a powerful tool. Thanks!
  13. Thank you very much. Regards
  14. Excellent
  15. I'm having a problem with navigating through my active cells. Initially I would be able to navigate using the arrow keys but for some reason, at present, when I use the arrow keys it shifts the entire worksheet one cell in the selected direction. Eg. If I want to use the up arrow it shifts the worksheet an entire row up instead of moving up by one cell. Any assistance ?
  16. #FAVE 06:00 whatIF
  17. Awesome video!!! Never knew about a lot of these! Great job on making them easy to understand! Subscribed!
  18. Quite useless for basic user
  19. Thanks For your video it's big help
  20. Thank you for the big help with regards to vlookup. easy to understand for beginners like me. Thank you so much for sharing. will definitely study those functions :-)


Additional Information:

Visibility: 1578700

Duration: 27m 44s

Rating: 20395