Top 25 Excel 2016 Tips and Tricks

  Рет қаралды 4,093,190

Sele Training

Sele Training

Күн бұрын

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

Пікірлер: 1 800
@simon6namsguy
@simon6namsguy 4 жыл бұрын
Rumor has it, when this vid came out, productivity across the corporate world increased by 15% overall
@SeleTraining
@SeleTraining 4 жыл бұрын
I hope so!
@atullondhe8432
@atullondhe8432 4 жыл бұрын
: )
@alexchan6121
@alexchan6121 4 жыл бұрын
@@atullondhe8432 k8
@futuredr.monamarie1370
@futuredr.monamarie1370 3 жыл бұрын
🤣❤️
@alberto-sama2022
@alberto-sama2022 4 жыл бұрын
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
@SeleTraining 5 жыл бұрын
Thanks to you loyal viewers we hit the first 1 Million views on this individual video. Much appreciated!
@SeleTraining
@SeleTraining 4 жыл бұрын
Don't miss the new video 50 Ultimate Excel Tips and Tricks: kzbin.info/www/bejne/fInWZIp9bLJgp80
@vandanaupadhyay6538
@vandanaupadhyay6538 4 жыл бұрын
Very useful tips which we can use in day to day work.Thank you so much!
@davitbeliashvili2500
@davitbeliashvili2500 6 жыл бұрын
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
@SeleTraining 6 жыл бұрын
Thanks for the info. I'll add that to the video.
@farhansaeed2145
@farhansaeed2145 6 жыл бұрын
You da real MVP :D
@GrassyKnoll
@GrassyKnoll 6 жыл бұрын
Excellent idea! Thanks!
@GrassyKnoll
@GrassyKnoll 6 жыл бұрын
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
@vasileccdragomir6660 6 жыл бұрын
Davit beliashvili OQ
@HamidHamid-pj8ty
@HamidHamid-pj8ty 6 жыл бұрын
I have never seen like it before,no words to express my gratitude
@doing4
@doing4 4 жыл бұрын
The learning never ends. This video makes Excel possibilities fun and exciting.
@SeleTraining
@SeleTraining 4 жыл бұрын
Be sure to check out the latest Excel Functions Video at kzbin.info/www/bejne/boGXXp2FpL51oNE
@aberdeenmeadows
@aberdeenmeadows 5 жыл бұрын
*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
@bensimpson9175 2 жыл бұрын
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
@AllAboutRaps 3 жыл бұрын
thanks, as a student this video helped me passing my computing test based on excel,
@SeleTraining
@SeleTraining 3 жыл бұрын
Excellent!
@sumanthmattukoyya5372
@sumanthmattukoyya5372 2 жыл бұрын
Pnbb bba gf I’m r
@ayesshasidiiqui1268
@ayesshasidiiqui1268 4 жыл бұрын
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
@sallycorpuz7186 5 жыл бұрын
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
@theofficelab 5 жыл бұрын
Awesome tutorial! Straight to the point and great to listen to. Keep it up.
@daviddurkee1960
@daviddurkee1960 5 жыл бұрын
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
@SandipanNaths 2 жыл бұрын
Five Star! A simple explanation for everyday-use formulas.
@miamibr18rodriguez41
@miamibr18rodriguez41 6 жыл бұрын
Extremely helpful and I am continuing with your tips and tricks on Excel,
@bogdanbaciu5381
@bogdanbaciu5381 4 жыл бұрын
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
@SeleTraining 5 жыл бұрын
Don't miss out on the latest Excel Tutorial for Beginners: kzbin.info/www/bejne/jam4gn9-f9NqbbM
@pushpendravashishth58
@pushpendravashishth58 4 жыл бұрын
I am an intermediate level excel user and I found this nothing shorter than the coolest stuff. Thanks from India. 🙏🙏
@nigelmtb
@nigelmtb 6 жыл бұрын
Very very useful! It's amazing how there are solutions to problems I didn't even know I had. Thanks for posting this.
@muruganvinayagan1157
@muruganvinayagan1157 6 жыл бұрын
very nice understandable presentation. Thankyou very much
@janstozek4850
@janstozek4850 4 жыл бұрын
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
@rahmanrahmani2896 5 жыл бұрын
Thank you Sir, Very helpful with an outstanding commentary. You are a living legend !
@connierobinson2175
@connierobinson2175 4 жыл бұрын
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
@SeleTraining 4 жыл бұрын
Excellent.
@icpool
@icpool 6 жыл бұрын
Very much appreciated !!
@sassouusasoo3607
@sassouusasoo3607 5 жыл бұрын
Sumifs and 3D ref is giving me life !!!Wow thank you !!
@pushpendraverma1554
@pushpendraverma1554 5 жыл бұрын
Probably the best video related to excel on youtube, It made my day, thanks man
@manarcollection6019
@manarcollection6019 5 жыл бұрын
Thank you soooo much for this great job you have done!
@joshuaabella8831
@joshuaabella8831 5 жыл бұрын
This video was very, very, very helpful. I enjoyed watching this video
@mdc9583
@mdc9583 5 жыл бұрын
Very helpful. Thank you for doing the video.
@ScholasticaOkoye
@ScholasticaOkoye 4 жыл бұрын
Amazing - the cell copy shortcut will change my life. Thank you so much!
@randomimmigrant348
@randomimmigrant348 3 жыл бұрын
Good day. I'm a water engineer in South Africa, these tips will surely speed up my workflow. Thank u and God bless
@ejigayehuadnew1075
@ejigayehuadnew1075 5 жыл бұрын
Thank you this very helpful tips!
@PremKumar-ut7kv
@PremKumar-ut7kv 5 жыл бұрын
Great video, very informative, easy to follow. Thank you for presenting and sharing.
@TheAdeptGuitarist
@TheAdeptGuitarist 4 жыл бұрын
This got me a raise. Thank you.
@NTDOfficialxyz
@NTDOfficialxyz 6 жыл бұрын
Excel tips is good, thanks for sharing
@trucvunguyen
@trucvunguyen 6 жыл бұрын
Thank you so much for amazing and helpful tips which helped me work productively
@camerongray7767
@camerongray7767 5 жыл бұрын
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
@hassanbakhsh2440 4 жыл бұрын
Hands down the best tips and tricks video i have seen for excel yet !
@atishranjansensharma7960
@atishranjansensharma7960 4 жыл бұрын
Have no words how to thank you Sir.
@ajithdesilva411
@ajithdesilva411 4 жыл бұрын
One of the best training that I see in youtube. No question about that. Thanks for your contribution.
@SeleTraining
@SeleTraining 4 жыл бұрын
Thanks!
@bullseye3597
@bullseye3597 5 жыл бұрын
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
@tesshart1053 5 жыл бұрын
love how you make it so clear and easy. thanks
@sachinkishore4115
@sachinkishore4115 6 жыл бұрын
Hi Thank you very much for useful tips
@trishaharrison8285
@trishaharrison8285 6 жыл бұрын
This is fantastic; thank you!!!
@gayletrunfio7872
@gayletrunfio7872 5 жыл бұрын
THANK YOU for this fantastic tutorial! Learned a lot and extremely helpful.
@enriefraire2558
@enriefraire2558 4 жыл бұрын
These tips are fabulous. Thank you very much!
@mesharinasrullah
@mesharinasrullah 4 жыл бұрын
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
@soniarivera2076 4 жыл бұрын
Excellent tips. Learned a lot. Thank you!
@paull.6026
@paull.6026 5 жыл бұрын
Tons of great Excel insight and knowledge gained just now. Thanks for posting this!
@cplm2009
@cplm2009 5 жыл бұрын
Learned a lot from this tutorial, thank you very much.
@debbygreene9993
@debbygreene9993 4 жыл бұрын
Thank you for putting your time into this tutorial. It is SO helpful.
@SeleTraining
@SeleTraining 4 жыл бұрын
Glad it was helpful!
@dave14647
@dave14647 6 жыл бұрын
this was really helpful thank you
@gnssexpert
@gnssexpert 4 жыл бұрын
Really useful set of tutorials on Office, Thanks.
@YuliaMeshcheryakova
@YuliaMeshcheryakova 4 жыл бұрын
Thank you! Very helpful tips and easy to follow! The best video on Excel I've watched so far.
@sssussse
@sssussse 4 жыл бұрын
I'd like your way of explain it. Very calm thanks a lot.
@shanexu453
@shanexu453 5 жыл бұрын
I appreciate your explanation !!!! love your voice too
@flosamus
@flosamus 5 жыл бұрын
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
@SeleTraining 5 жыл бұрын
Thanks.
@nielstenhave4355
@nielstenhave4355 4 жыл бұрын
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
@masterpepin 4 жыл бұрын
This has helped me in so many ways, thank you so much
@Kaunas-rx3qv
@Kaunas-rx3qv 5 жыл бұрын
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
@kathyzinnecker8700 3 жыл бұрын
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
@NJHeart2Heart 4 жыл бұрын
One of the best tip videos; covers a wide variety of great tips and also provides some of the nuances for context.
@SeleTraining
@SeleTraining 4 жыл бұрын
Thanks
@lindapoindexter4326
@lindapoindexter4326 4 жыл бұрын
This was very thorough. I had several WHAT?! moments while listening to this. Thank you.
@Jawsh.official
@Jawsh.official 4 жыл бұрын
Amazing help, thank you, sir!
@denniskahuria7395
@denniskahuria7395 4 жыл бұрын
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
@trevorchunga4518 3 жыл бұрын
Very useful, simple explanation and easy to follow. Thank you.
@syedaislamabad183
@syedaislamabad183 4 жыл бұрын
the most easy to understand Video and important daily used excel functions, excellent way of describing and Precise.
@sakhimuhammad3183
@sakhimuhammad3183 4 жыл бұрын
@syeda u r right dear
@michaelspeakman8924
@michaelspeakman8924 6 жыл бұрын
Thanks !
@susanmayberry5966
@susanmayberry5966 5 жыл бұрын
Loves this! Thank you for making my life easier!
@mohsinfareed1797
@mohsinfareed1797 4 жыл бұрын
Thanks. I am lucky to find your videos on Excel. The clearest well explained and easy to follow very informative instructions.
@ElizaTimcu
@ElizaTimcu 6 жыл бұрын
Thank you !
@nazianahid8266
@nazianahid8266 5 жыл бұрын
Very very useful! Thank you for sharing :)
@tusharvashist9566
@tusharvashist9566 5 жыл бұрын
Nazia you are beautiful
@prezbiteros
@prezbiteros 5 жыл бұрын
Thank you very much for the sharing tips!
@SA-nb2df
@SA-nb2df 4 жыл бұрын
BRILLIANT ! Thankyou so much.
@habibparacha4916
@habibparacha4916 4 жыл бұрын
Very helpful and easy to understand, highly recommended for excel lovers Thank you soo much Love form Pakistan
@n-sh2014
@n-sh2014 2 жыл бұрын
Loved your tutorial video. So to the point and informative
@SeleTraining
@SeleTraining 2 жыл бұрын
Glad it was helpful!
@hollyannthyagarajan2919
@hollyannthyagarajan2919 4 жыл бұрын
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
@SeleTraining 4 жыл бұрын
Glad it was helpful!
@rducut
@rducut 4 жыл бұрын
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
@SeleTraining 4 жыл бұрын
Glad it was helpful!
@gujjenaut
@gujjenaut 4 жыл бұрын
Learning a lot your tips and tricks!! Thankyou
@SeleTraining
@SeleTraining 4 жыл бұрын
Happy to hear that!
@lpeless1
@lpeless1 5 жыл бұрын
I learned about half of these new. Some are super useful. Thank you so much!
@ottomulder7279
@ottomulder7279 3 жыл бұрын
Extremely well explaned. Thank you.
@TOTOOCanada2023
@TOTOOCanada2023 6 жыл бұрын
very helpful. Thank you!
@frankmayer7119
@frankmayer7119 4 жыл бұрын
This is a great video!! The narration is concise and well-rehearsed and flows naturally with the images on the screen...awesome!
@bajoobiecuzican
@bajoobiecuzican 4 жыл бұрын
Very helpful. Soothing voice. Thanks!
@mrCetus
@mrCetus 2 жыл бұрын
This is amazing.Thanks!
@osamujijohnmicheal1711
@osamujijohnmicheal1711 4 жыл бұрын
I really appreciate what you do for our success. God bless you abandantly! Otherwise, wishing you Success in life.
@SeleTraining
@SeleTraining 4 жыл бұрын
Thanks!
@reanexcel8618
@reanexcel8618 6 жыл бұрын
thanks
@francismwangi2624
@francismwangi2624 4 жыл бұрын
Very Helpful! The quick tips very useful in my work. Big Thanks!
@jieliu8644
@jieliu8644 Жыл бұрын
Thank you so much! You explained so much clearer than the other site.
@javiporras3396
@javiporras3396 6 жыл бұрын
great video
@Diva9000x
@Diva9000x 6 жыл бұрын
That was great! New subbie.
@alnashirchampsi6682
@alnashirchampsi6682 4 жыл бұрын
Thanks, excellent presenter - very clear instructions!
@simpleexcelexamples9619
@simpleexcelexamples9619 2 жыл бұрын
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
@hirenpanot7421 4 жыл бұрын
Very much helpful.
@KamalSingh-dn7gv
@KamalSingh-dn7gv 4 жыл бұрын
Nice video. Learned a lot
@phinsanavilailack8898
@phinsanavilailack8898 4 жыл бұрын
Very Informative, helpful, and easy to follow. Thank You
@dufo4766
@dufo4766 Жыл бұрын
Amazing, Excellent, I am bookmarking this video! Thanks!
@mobr.
@mobr. 6 жыл бұрын
Great video, it was very informative.
Outlook Mail Merge with Excel and Word
3:55
Sele Training
Рет қаралды 116 М.
Another 15 Excel 2016 Tips and Tricks
13:27
Sele Training
Рет қаралды 399 М.
Why You Should Always Help Others ❤️
00:40
Alan Chikin Chow
Рет қаралды 135 МЛН
Final muy inesperado 🥹
00:48
Juan De Dios Pantoja
Рет қаралды 18 МЛН
The joker's house has been invaded by a pseudo-human#joker #shorts
00:39
Untitled Joker
Рет қаралды 4,5 МЛН
Tom & Jerry !! 😂😂
00:59
Tibo InShape
Рет қаралды 51 МЛН
50 Ultimate Excel Tips and Tricks for 2020
50:17
Sele Training
Рет қаралды 1,8 МЛН
Excel 2016 Intermediate Tutorial
2:36:27
Learnit Training
Рет қаралды 934 М.
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 197 М.
How To Highlight The Current Row In Excel
3:34
Some little tips
Рет қаралды 15 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
Excel Drop Down List Tips and Tricks
11:16
Sele Training
Рет қаралды 65 М.
Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] ⚡
3:02:18
Pragmatic Works
Рет қаралды 2,4 МЛН
Mastering Excel in 2024 - New Functions!
14:01
Sele Training
Рет қаралды 23 М.
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Leila Gharani
Рет қаралды 669 М.
Нашел еще 70+ нововведений в iOS 18!
11:04
Обзор Sonos Ace - лучше б не выпускали...
16:33
Samsung Galaxy 🔥 #shorts  #trending #youtubeshorts  #shortvideo ujjawal4u
0:10
Ujjawal4u. 120k Views . 4 hours ago
Рет қаралды 10 МЛН