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. in the if function: what If the choices is 3, big, medium and small? is there any function to be used for this?
  2. Is the maps icon feature only on the cloud version of Excel?
  3. hi mate this tutorial is pretty nice. but i have a hint for your #9 you can basically spare another amount of time if you hit crtl and drag the corner than ecxel will count 1,2,3,... automatically :) for mac users there should be something as well but due to not having a mac I can't say how :(
  4. very helpful and I have just reached no. 5.... subscribed and liked. Thank you.
  5. Thanks for this helpful, easy to understand video! Quick question: at around 11:03 you mention you had a formula to add columns b and c (first and last names) into a full name -- how would I do that?
  6. Some help please. I have 2 sets of data. Prev day readings and current day readings. Each days readings are averaged and charted. The problem comes with calculating the absolute difference between prev day average and current day average. By rounding off the Average, excel does not calculate the difference on the rounded numbers. I get a different answer compared to what I see.  Set 1 data:  259,290,300,310.  Set 2 data:  312,320,367,390.Ave Set 1=290Ave set 2=347Abs Difference = 58 but it should be 57.Normal formatting does not correct the result.
  7. Great video! In reference to tip #25, I do not have the maps icon, how do I add this? I am using MS Office Professional Plus 2016 version. Thanks in advance.
  8. What is the meaning of life?
  9. hard but i will get used to it i think practice makes perfect
  10. Great Work!
  11. This is really helpful for me. I haven’t used many spreadsheet applications but this will surely make my work a lot easier. Thank you very much!
  12. I appreciate your explanation !!!! love your voice too
  13. Thank you so much Sir
  14. This was so awesome, I learned so many great things!!Jean
  15. 14:20. Excel has 3 types of references :A1(RELATIVE) $A$1(ABSOLUTE) A$1/$A1(MIXED). But in rest much appreciation, it really helped me a lot. BIG LIKE!
  16. Another tip: To make a cell absolute (inserting dollarsigns) just press the F4 button !!
    Multiple times pressing the F4 shows all the possibilities..
    To insert a function: press Shift F3
  17. Can you make goal seek a formula? so whenever other cells(which are used in the target cell formula) are changed, the result found in the goal seek will change accordingly?
  18. Dear sir, it's so important video for me. I am from Bangladesh I am the employee IE sector plz upload more video for us to learn about EXCEL, A LOT OF THANKS TO YOU.
  19. Very helpful. Thank you for doing the video.
  20. Thank you that was awesome


Additional Information:

Visibility: 1138390

Duration: 27m 44s

Rating: 14292