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 • Top 15 Advanced Excel ... .
Another 15 Excel 2016 Tips & Tricks: • Another 15 Excel 2016 ...
Introduction to Excel for Beginners: • Excel Tutorial - Beginner
Don't miss the latest Ultimate 50 Excel Tips and Tricks: • 50 Ultimate Excel Tips...
Support me with your Amazon purchases, click here: amzn.to/2Kxp533
Contents 0:00
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
#seletraining #excel #tipsandtricks

[@simon6namsguy]

Rumor has it, when this vid came out, productivity across the corporate world increased by 15% overall

[@SeleTraining]

I hope so!

[@atullondhe8432]

: )

[@alexchan6121]

@@atullondhe8432 k8

[@futuredr.monamarie1370]

🤣❤️

[@alberto-sama2022]

Don't mind me this is for personal use 👍 0:49 Quick Analysis Tool 1:45 Filter 2:27 Drop Down List 3:13 Auto fit Column Width 3:47 Transpose (reversed column) 4:13 Remove Duplicates 5:22 Goal Seek 6:55 Vlookup 9:08 Flash and Autofill 10:47 Paste and Special Value 11:50 Images in Chart 12:29 If Function 13:39 Insert Screenshots 14:17 Absolute Cell Reference (Put a dollar sign) 15:57 Show Formulas (CTRL + ~) 16:57 Text to Column 18:12 Conditional Formatting 20:48 Freeze Panes 21:41 Ctrl Arrow keys 21:59 3D References 23:44 Forecast Sheet 24:16 SUMIFS Function 25:39 IFError Function 26:30 Filled Maps Thanks

[@SeleTraining]

Thanks to you loyal viewers we hit the first 1 Million views on this individual video. Much appreciated!

[@SeleTraining]

Don't miss the new video 50 Ultimate Excel Tips and Tricks: kzbin.info/www/bejne/fInWZIp9bLJgp80

[@vandanaupadhyay6538]

Very useful tips which we can use in day to day work.Thank you so much!

[@davitbeliashvili2500]

1. Quick Analysis Tool 0:50 2. Filter 1:47 3. Drop-Down List 2:27 4. AutoFit Column Width 3:13 5. Transpose 3:48 6. Remove Duplicates 4:13 7. Goal Seek 5:20 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:29 13. Insert Screenshot 13:41 14. Absolute Cell Reference 14:15 15. Show Formulas 15:54 16. Text to Columns 16:57 17. Conditional Formatting 18:12 18. PowerPivot 19:36 19. Freeze Panes 20:47 20. Ctrl-Arrow Keys 21:40 21. 3D References 21:59 22. Forecast Sheet 23:44 23. SUMIFS Function 24:16 24. IFERROR Function 25:38 25. Filled Maps 26:30

[@SeleTraining]

Thanks for the info. I'll add that to the video.

[@farhansaeed2145]

You da real MVP :D

[@GrassyKnoll]

Excellent idea! Thanks!

[@GrassyKnoll]

This would be good to have at the beginning of the videos because it's going to disappear down the list as more comments are added.

[@vasileccdragomir6660]

Davit beliashvili OQ

[@HamidHamid-pj8ty]

I have never seen like it before,no words to express my gratitude

[@doing4]

The learning never ends. This video makes Excel possibilities fun and exciting.

[@SeleTraining]

Be sure to check out the latest Excel Functions Video at kzbin.info/www/bejne/boGXXp2FpL51oNE

[@aberdeenmeadows]

*WOW! Thanks so much for these tips and tricks. Fascinating!!!! I learned a few tricks from watching your tutorial and I have been using Excel for a very, very long time!*

[@bensimpson9175]

Thank you, Jason. I’m 45 and switching careers. Your videos are giving me the Microsoft literacy that I desperately need. Hat’s off. 👍

[@AllAboutRaps]

thanks, as a student this video helped me passing my computing test based on excel,

[@SeleTraining]

Excellent!

[@sumanthmattukoyya5372]

Pnbb bba gf I’m r

[@ayesshasidiiqui1268]

I am compelled to write that your video is the best of all excel videos I have seen! What I loved about the video other than content is clarity in instructions, the pace, neutral accent and voice has bass and so clear! Thanks again for this video!

[@sallycorpuz7186]

cool presentation, precise and informative. It was interesting to see the shorter versions of the functions I have used for the longest time. #21 is also my fave. I agree with Michael that it will be cool to have a downloadable file for us to practice. Hope you will consider. thanks and all the best

[@theofficelab]

Awesome tutorial! Straight to the point and great to listen to. Keep it up.

[@daviddurkee1960]

Nice to see the Goal Seek function. We had that in 1987 in PFS:Plan, a spreadsheet software product of Software Publishing Corporation, now defunct. It was one of the big three manufacturers in the early days of Silicon Valley.

[@SandipanNaths]

Five Star! A simple explanation for everyday-use formulas.

[@miamibr18rodriguez41]

Extremely helpful and I am continuing with your tips and tricks on Excel,

[@bogdanbaciu5381]

I have said this before and I will say it again: the entire team at Microsoft should have been given some equivalent of the Nobel Prize for inventing Excel. Sir, you did a great job and thank you for sharing it with us. I use excel a lot and I'm stunned when I remember how difficult my life used to be prior to applying such tips & tricks.

[@SeleTraining]

Don't miss out on the latest Excel Tutorial for Beginners: kzbin.info/www/bejne/jam4gn9-f9NqbbM

[@pushpendravashishth58]

I am an intermediate level excel user and I found this nothing shorter than the coolest stuff. Thanks from India. 🙏🙏

[@nigelmtb]

Very very useful! It's amazing how there are solutions to problems I didn't even know I had. Thanks for posting this.

[@muruganvinayagan1157]

very nice understandable presentation. Thankyou very much

[@janstozek4850]

Thank you. I considered some of the tips really basic functionality - like filling areas or freezing panes - but some were really mind opening - like the pivots, forecasts and maps. Definitely, I learned a lot.

[@rahmanrahmani2896]

Thank you Sir, Very helpful with an outstanding commentary. You are a living legend !

[@connierobinson2175]

These videos are AMAZING I have learned more in two hours of watching these videos about excel than I have in years of trial and error on my own. THANK YOU SO MUCH!

[@SeleTraining]

Excellent.

[@icpool]

Very much appreciated !!

[@sassouusasoo3607]

Sumifs and 3D ref is giving me life !!!Wow thank you !!

[@pushpendraverma1554]

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

[@manarcollection6019]

Thank you soooo much for this great job you have done!

[@joshuaabella8831]

This video was very, very, very helpful. I enjoyed watching this video

[@mdc9583]

Very helpful. Thank you for doing the video.

[@ScholasticaOkoye]

Amazing - the cell copy shortcut will change my life. Thank you so much!

[@randomimmigrant348]

Good day. I'm a water engineer in South Africa, these tips will surely speed up my workflow. Thank u and God bless

[@ejigayehuadnew1075]

Thank you this very helpful tips!

[@PremKumar-ut7kv]

Great video, very informative, easy to follow. Thank you for presenting and sharing.

[@TheAdeptGuitarist]

This got me a raise. Thank you.

[@NTDOfficialxyz]

Excel tips is good, thanks for sharing

[@trucvunguyen]

Thank you so much for amazing and helpful tips which helped me work productively

[@camerongray7767]

Thanks so much for this video I can’t get over how helpful it is, covers so many things that are sooooo useful. Thankyou

[@hassanbakhsh2440]

Hands down the best tips and tricks video i have seen for excel yet !

[@atishranjansensharma7960]

Have no words how to thank you Sir.

[@ajithdesilva411]

One of the best training that I see in youtube. No question about that. Thanks for your contribution.

[@SeleTraining]

Thanks!

[@bullseye3597]

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!

[@tesshart1053]

love how you make it so clear and easy. thanks

[@sachinkishore4115]

Hi Thank you very much for useful tips

[@trishaharrison8285]

This is fantastic; thank you!!!

[@gayletrunfio7872]

THANK YOU for this fantastic tutorial! Learned a lot and extremely helpful.

[@enriefraire2558]

These tips are fabulous. Thank you very much!

[@mesharinasrullah]

14:15 Number 14 - Absolute Cell Reference Quicker way to do it is select the cell reference, then press the F4 key. Also, you can lock either the row (e.g., A$1) or column (e.g., $A1) by pressing F4 once or twice (F4 scrolls through the options). Nice work! Thanks for the great video, Sele Training.

[@soniarivera2076]

Excellent tips. Learned a lot. Thank you!

[@paull.6026]

Tons of great Excel insight and knowledge gained just now. Thanks for posting this!

[@cplm2009]

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

[@debbygreene9993]

Thank you for putting your time into this tutorial. It is SO helpful.

[@SeleTraining]

Glad it was helpful!

[@dave14647]

this was really helpful thank you

[@gnssexpert]

Really useful set of tutorials on Office, Thanks.

[@YuliaMeshcheryakova]

Thank you! Very helpful tips and easy to follow! The best video on Excel I've watched so far.

[@sssussse]

I'd like your way of explain it. Very calm thanks a lot.

[@shanexu453]

I appreciate your explanation !!!! love your voice too

[@flosamus]

What a fantastic revision/overview. Thank you very much for this - it's proving exceptionally helpful in refreshing some of my very long-forgotten Excel skills in a big hurry (as well as listing a few great tips I never knew in the first place).

[@SeleTraining]

Thanks.

[@nielstenhave4355]

Thank you very much for your time and effort! I really learned some cool new stuff that I will definitely use in the future!

[@masterpepin]

This has helped me in so many ways, thank you so much

[@Kaunas-rx3qv]

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!

[@kathyzinnecker8700]

I've taken Excell before, but it's then probably 4 to 6 years ago. So this is very helpful in making my memory click, thank you so much for your tutorial!!♡♡♡

[@NJHeart2Heart]

One of the best tip videos; covers a wide variety of great tips and also provides some of the nuances for context.

[@SeleTraining]

Thanks

[@lindapoindexter4326]

This was very thorough. I had several WHAT?! moments while listening to this. Thank you.

[@Jawsh.official]

Amazing help, thank you, sir!

[@denniskahuria7395]

Best Video ever, Men I was only going to watch and skip but your ability to simply these tips saw me watch till the end, most importantly I learned everything while practising. Thank you lots

[@trevorchunga4518]

Very useful, simple explanation and easy to follow. Thank you.

[@syedaislamabad183]

the most easy to understand Video and important daily used excel functions, excellent way of describing and Precise.

[@sakhimuhammad3183]

@syeda u r right dear

[@michaelspeakman8924]

Thanks !

[@susanmayberry5966]

Loves this! Thank you for making my life easier!

[@mohsinfareed1797]

Thanks. I am lucky to find your videos on Excel. The clearest well explained and easy to follow very informative instructions.

[@ElizaTimcu]

Thank you !

[@nazianahid8266]

Very very useful! Thank you for sharing :)

[@tusharvashist9566]

Nazia you are beautiful

[@prezbiteros]

Thank you very much for the sharing tips!

[@SA-nb2df]

BRILLIANT ! Thankyou so much.

[@habibparacha4916]

Very helpful and easy to understand, highly recommended for excel lovers Thank you soo much Love form Pakistan

[@n-sh2014]

Loved your tutorial video. So to the point and informative

[@SeleTraining]

Glad it was helpful!

[@hollyannthyagarajan2919]

One of the best excel videos i have seen. Clear , Precise, Simple , Easy to apply , Apt Examples .... so well done. Thank you for posting and sharing this knowledge.

[@SeleTraining]

Glad it was helpful!

[@rducut]

I recently did a excel presentation for my colleagues on tips and tricks and i used a few of your examples. Thank you very much!

[@SeleTraining]

Glad it was helpful!

[@gujjenaut]

Learning a lot your tips and tricks!! Thankyou

[@SeleTraining]

Happy to hear that!

[@lpeless1]

I learned about half of these new. Some are super useful. Thank you so much!

[@ottomulder7279]

Extremely well explaned. Thank you.

[@TOTOOCanada2023]

very helpful. Thank you!

[@frankmayer7119]

This is a great video!! The narration is concise and well-rehearsed and flows naturally with the images on the screen...awesome!

[@bajoobiecuzican]

Very helpful. Soothing voice. Thanks!

[@mrCetus]

This is amazing.Thanks!

[@osamujijohnmicheal1711]

I really appreciate what you do for our success. God bless you abandantly! Otherwise, wishing you Success in life.

[@SeleTraining]

Thanks!

[@reanexcel8618]

thanks

[@francismwangi2624]

Very Helpful! The quick tips very useful in my work. Big Thanks!

[@jieliu8644]

Thank you so much! You explained so much clearer than the other site.

[@javiporras3396]

great video

[@Diva9000x]

That was great! New subbie.

[@alnashirchampsi6682]

Thanks, excellent presenter - very clear instructions!

[@simpleexcelexamples9619]

Very clear and concise way of explaining things, thank you for that! This video gave me inspiration for my own classes (I give Excel training to students) 😊

[@hirenpanot7421]

Very much helpful.

[@KamalSingh-dn7gv]

Nice video. Learned a lot

[@phinsanavilailack8898]

Very Informative, helpful, and easy to follow. Thank You

[@dufo4766]

Amazing, Excellent, I am bookmarking this video! Thanks!

[@mobr.]

Great video, it was very informative.