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

30 Comments

  1. Online කඩේ

    July 23, 2019 at 5:57 am

    අපගේ ‍YouTube චැනලය සමග එකතුවී නොමිලයේ පරිගණක දැනුම ලබා ගන්න. 👇👇👇👇

    Watch ⭐️⭐️ https://youtu.be/eyxSBG8PYnQ ⭐️⭐️
    Subscribe ⭐️⭐️ http://bit.ly/2O6yeUY ⭐️⭐️

    Reply

  2. Think Excel

    July 23, 2019 at 5:57 am

    Very good video and a lot to learn. Great work

    Reply

  3. Oasis Conaissance

    July 23, 2019 at 5:57 am

  4. Big4Excel

    July 23, 2019 at 5:57 am

    Great list!

    Reply

  5. rexy80

    July 23, 2019 at 5:57 am

    GOAL SEEK is Thug life! Is there a cooler function in Excel?? Love it!!

    Reply

  6. Adrian Lawrence

    July 23, 2019 at 5:57 am

    Very useful video with many helpful tips.

    Reply

  7. Mansingh Jatav

    July 23, 2019 at 5:57 am

    HI i am trying to do goal seek but i am not getting values am you did in video. tips number 7
    please suggest me some ideas. Thank you

    Reply

  8. Denise Hoskins

    July 23, 2019 at 5:57 am

    Very usefull!

    Reply

  9. G

    July 23, 2019 at 5:57 am

    Amazing! Learned a lot in 27:43 mins

    Reply

  10. cplm2009

    July 23, 2019 at 5:57 am

    Learned a lot from this tutorial, thank you very much.

    Reply

  11. onotu yusuf

    July 23, 2019 at 5:57 am

    wow,this is really great and helpful for an intermediate, thanks.

    Reply

  12. Rajiv Rajpurkar

    July 23, 2019 at 5:57 am

    Thank you, Thank you, Thank you & Thank you.

    Reply

  13. Frank Leahy

    July 23, 2019 at 5:57 am

    Great Video and very helpful. Thank you sir for sharing

    Reply

  14. Carola Lueck

    July 23, 2019 at 5:57 am

    Well done – everything easy and clear and can be advised to look at for people knowing the basics only.
    But for my opinion the title is missleading: there was not one single thing which is new in 2016.
    Some are even in since the end of the 90th and some are even easier to find then going to the options.
    I was expecting to find really new things here.

    Reply

  15. Shwe Khine

    July 23, 2019 at 5:57 am

    Thanks.

    Reply

  16. Tess Hart

    July 23, 2019 at 5:57 am

    love how you make it so clear and easy. thanks

    Reply

  17. Chris Kockelkoren

    July 23, 2019 at 5:57 am

    Again nice (some mistakes in rows/columns, and's and or's) but who cares. But there is one thing that I saw that needs some comment. You copied the vlookup formula (VLOOKUP(E3;B3:C12;2;FALSE) down, but be aware that when copying the VLOOKUP changes to VLOOKUP(E4;B4:C13;2;FALSE). As you can see, the table range is changed so if you type John in E4, the answer will not be 18547 but #N/A. Always use a stricted range when using vlookup/hlookup: VLOOKUP(E3;$B$3:$C$12;2;FALSE). When copying the formula it always have the same range. Better though: name the range and use the name instead of the range column and rows VLOOKUP(E3;persons;2;FALSE). It is not only better but also easier to read formulas. But again keep up posting.

    Reply

  18. Chris Kockelkoren

    July 23, 2019 at 5:57 am

    Again nice (some mistakes in rows/columns, and's and or's) but who cares. But there is one thing that I saw that needs some comment. You copied the vlookup formula (VLOOKUP(E3;B3:C12;2;FALSE) down, but be aware that when copying the VLOOKUP changes to VLOOKUP(E4;B4:C13;2;FALSE). As you can see, the table range is changed so if you type John in E4, the answer will not be 18547 but #N/A. Always use a stricted range when using vlookup/hlookup: VLOOKUP(E3;$B$3:$C$12;2;FALSE). When copying the formula it always have the same range. Better though: name the range and use the name instead of the range column and rows VLOOKUP(E3;persons;2;FALSE). It is not only better but also easier to read formulas. But again keep up posting.

    Reply

  19. Storminmormn6

    July 23, 2019 at 5:57 am

    Is this Adulting?

    Reply

  20. Carmel Fernandez

    July 23, 2019 at 5:57 am

    Hi, was trying to practice the very first tip, highlighted a bunch of rows and columns with numbers but did not get the quick analysis tool

    Reply

  21. Unlisted

    July 23, 2019 at 5:57 am

    Wish i could each the other ppl in my office to do more then CTRL-C and CTRL-V. They are the hardest working generation, but only when they are creating that work for themselves.

    Reply

  22. Robert van der heide

    July 23, 2019 at 5:57 am

    Ctrl+ * = select entire table
    Ctrl + shift + direction = select entire kolom/row with data (depends on direction)

    Reply

  23. Pushpendra Verma

    July 23, 2019 at 5:57 am

    Probably the best video related to excel on youtube, It made my day, thanks man

    Reply

  24. Foppish Dandy

    July 23, 2019 at 5:57 am

    4:45 *row

    Reply

  25. OBI CHINEDU

    July 23, 2019 at 5:57 am

    Please how can I approximate/roundup to the nearest hundred.

    Reply

  26. Uma Shankar

    July 23, 2019 at 5:57 am

    Sir, I have a query. Say there are two cells A&B. Both have different values Which changes every second. Now, I want to know the formula which will give me the lowest total of A&B & Highest total of A&B for the day. It can be 2 diff formulas. No issues. Looking forward for a favourable reply from your end Sir. Pls suggest.

    Reply

  27. Velu Samy

    July 23, 2019 at 5:57 am

    thank you so much and very useful video… but i want to ask a question?? please give me some tips ?? how to keep concentrate myself excel learning class sometimes i got bored while watching video 😐😐😔😔

    Reply

  28. Princess Viii

    July 23, 2019 at 5:57 am

    Thanks a lot

    Reply

  29. Rishabh Jain

    July 23, 2019 at 5:57 am

    Superb. Thanks!

    Reply

  30. Cessandra Johnson

    July 23, 2019 at 5:57 am

    Thanks

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

The Craziest Smartphone Yet…

This is the incredible Grand Complications Skeleton iPhone XS from Caviar. https://caviar.…