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 very much, appreciate the tips and well explained, awesome!
  2. good one..thanks
  3. I have an excel book with two tabs. The first contains 2 reference tables with at least 10 numbered items such as roles (ceo, trainer, cook) and industry (banking, IT, healthcare). The second tab contains thousands of people (first, last, email, company, title, etc.) Also, on the second tab are columns for role and industry, where I want to find a formula or something to review the info in tab 2 and check it against tab 1 to populate the two columns on tab 2. Which formula or excel solution should I use?
  4. Very informative and awesome teaching method of yours. Kudos sir
  5. 06:55 how to make VLOOKUP with/use 2 sheets?
  6. Extremely helpful!!!
  7. keep going very good training and useful-thank you.
  8. AWESOME
  9. Hey hope your well. I am a step closer but keep hitting barriers maybe me and want I want to do! The Vlookup worked but I have tried to link it in with a drop down list for the ingredients. I have managed to create a list of ingredients into a drop down menu but my opportunity now is that it only allows you to 'copy' a single column, when I choose ' bread' from my drop down menu I want the whole row of information to carry over? Next issue would be if I achieved that, every time I added a new ingredient to my drop down I would have to update every cell with the drop down in with the new list! Should I be trying ACCESS? chris
  10. Hi there, can you help me how to calculate the end of contract period ?
    eg. Employee start working on October 01, 2010 and will have 3 years contract ... how to know the last date of the contract ?
    what formula can i use ?
  11. Hi great tutorials thank you. I am trying to get sheets to link together in the same workbook. What I am trying to do is create a list of ingredients with cost prices in sheet 1 and then build recipes in sheet 2 and beyond. But I want to be able to type ' olive bread' which would be listed in sheet 1 with its price and have the whole row associated with 'olive bread' link over to sheet 2 as i build it in a recipe. This way if I use 'olive bread' in more than one sandwich I can change the cost price in sheet 1 ingredient list and it will update on all other sheets it is used in? Does that make sense! Chris
  12. Thank you very much indeed!!! very helpful
  13. Really great summary! Thanks
  14. Great tutorial, thanks!
    I have 5 large databases in Lotus Approach and would like to transfer the data, as is, to MS Access. Nobody seems to be able to assist me with this. Any ideas?
  15. Hi,

    Could you please help me with an issue? In my menu I cannot find the option "remove duplicates". Thanks, regards Karla
  16. Hello I need some help. I have a string 10 values long that are labeled “card 1” through to “card 10”. Under each of those is their respective value. (This value changes each time as it is based on a probability). I then have a cell to the side that shows my best probability from those 10. I need to know which card corresponds to the best probability. I think I need to use HLOOKUP but it doesn’t work? Is it because I am searching for a number and returning a word? Please help. I know I am writing the formula correct, I follow all tutorials but still doesn’t work. PLEASE HELP
  17. So many of these are so helpful
  18. Absolute cell reference is very good
  19. Amazing video. Thanks so much.👍
  20. Thanks so much for this video I can’t get over how helpful it is, covers so many things that are sooooo useful. Thankyou


Additional Information:

Visibility: 647201

Duration: 27m 44s

Rating: 8507