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. 21 IS LIFE!!!! I WISH I KNEW THIS YEARS AGO!!!
  2. Oh my God! I said that multiple times out loud during this video, pretty sure my dogs even looked at me a few times. I have been using Excel for several years, but just the basic features, picking up on a few of the suggested tips on the video along the way. I look forward to sharing this video and using the tips provided.
  3. Excellent contribution and recommendations, no doubt should not miss all information worker, greetings!
  4. I am really benefited to get these information for my teaching to ICT students. Otherwise, I had to read excel book or search the help from MS. Thank for this.
  5. i need advanced excel graphs
  6. Good
  7. Great vids. I got a little confused at https://youtu.be/EdnAeqxqdzM?t=281 when you are pointing to rows 3 and 8, but say "column 3 and column 8". Very soothing voice. Nice presentation model also. No glitz, just the steps. no confusion on screen either.
  8. very good explanations. easy to understand :)
  9. 0:47 Quick Analysis Tool
    1:47 Filter
    2:25 Drop Down List
    3:13 Autofill Column Width
    3:48 Transpose
    4:16 Remove Duplicates
    5:25 Goal Seek
    7:01 V- Look Up
    9:12 Flash and AutoFill
    10:49 Paste Special Values
    11:50 Images in Charts
    12:30 If Function
    13:42 Insert Screenshot
    14:18 Absolute Cell Reference
    15:59 Show Formulas
    17:01 Text to Columns
    18:13 Conditional Formatting
    19:42 Power Pivot
    20:48 Freeze Paines
    21:45 Control Arrow keys
    22:00 3D Reference
    23:46 Forecast Sheet
    24:16 Sumifs Function
    25:39 IfError Function
    26:30 Filled Maps
  10. hello firstly thanks for useful video i have one question in 15:38 minutes when i calculate dicount then total doesnt change whydoes
    it happen
  11. I'm using a tablet version is their a way to adjust the paper margins to the fullness of an A4 paper
  12. Thank you this helped a LOT.
  13. awesome video - thank you sir!
  14. Tip 2 : Filter option can be turned on/off using Alt + DFF
  15. Excellent!
  16. Can someone pleas help with the % of numbers rising for 5 months? January 3, February 2, March 7, April 6, May 9. How can I calculate the percentage rise on these please? Thank you.
  17. Have no words how to thank you Sir.
  18. Great tutorial... even the voice is A+.
  19. 14. Absolute Cell Reference 14:15
    If you press button F4 key on the function bar, you can switch to absolute cell reference smarter.
    It you press F4 key again, it changes by 4 -cycles.
  20. Excellent tutorial


Additional Information:

Visibility: 1924290

Duration: 27m 44s

Rating: 23409