Top 25 Excel 2016 Tips and Tricks
Vložit
- čas přidán 8. 07. 2024
- 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 - Věda a technologie
Rumor has it, when this vid came out, productivity across the corporate world increased by 15% overall
I hope so!
: )
@@atullondhe8432 k8
🤣❤️
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
Awesome tutorial! Straight to the point and great to listen to. Keep it up.
The learning never ends.
This video makes Excel possibilities fun and exciting.
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
Thanks for the info. I'll add that to the video.
You da real MVP :D
Excellent idea! Thanks!
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.
Davit beliashvili
OQ
I have never seen like it before,no words to express my gratitude
*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!*
Thank you, Jason. I’m 45 and switching careers. Your videos are giving me the Microsoft literacy that I desperately need. Hat’s off. 👍
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!
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
thanks, as a student this video helped me passing my computing test based on excel,
Excellent!
Pnbb bba gf I’m r
Probably the best video related to excel on youtube, It made my day, thanks man
Very very useful! It's amazing how there are solutions to problems I didn't even know I had. Thanks for posting this.
Very much appreciated !!
Five Star! A simple explanation for everyday-use formulas.
I am an intermediate level excel user and I found this nothing shorter than the coolest stuff. Thanks from India. 🙏🙏
Extremely helpful and I am continuing with your tips and tricks on Excel,
This got me a raise. Thank you.
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.
Hands down the best tips and tricks video i have seen for excel yet !
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.
Good day. I'm a water engineer in South Africa, these tips will surely speed up my workflow. Thank u and God bless
Amazing - the cell copy shortcut will change my life. Thank you so much!
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.
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!
Excellent.
Thank you soooo much for this great job you have done!
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
Thank you Sir, Very helpful with an outstanding commentary. You are a living legend !
This video was very, very, very helpful. I enjoyed watching this video
Excel tips is good, thanks for sharing
Tons of great Excel insight and knowledge gained just now. Thanks for posting this!
Sumifs and 3D ref is giving me life !!!Wow thank you !!
One of the best training that I see in youtube. No question about that. Thanks for your contribution.
Thanks!
This is fantastic; thank you!!!
Thank you! Very helpful tips and easy to follow! The best video on Excel I've watched so far.
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!!♡♡♡
very nice understandable presentation. Thankyou very much
Thank you this very helpful tips!
Thanks so much for this video I can’t get over how helpful it is, covers so many things that are sooooo useful. Thankyou
love how you make it so clear and easy. thanks
Have no words how to thank you Sir.
Excellent tips. Learned a lot. Thank you!
Thank you very much for your time and effort! I really learned some cool new stuff that I will definitely use in the future!
Great video, very informative, easy to follow. Thank you for presenting and sharing.
This was very thorough. I had several WHAT?! moments while listening to this. Thank you.
Thank you so much for amazing and helpful tips which helped me work productively
Very helpful. Thank you for doing the video.
Loves this! Thank you for making my life easier!
I appreciate your explanation !!!! love your voice too
This has helped me in so many ways, thank you so much
Great tips! Lots of love from The Netherlands!
I learned about half of these new. Some are super useful. Thank you so much!
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.
Amazing help, thank you, sir!
Best MS Excel video I have seen in a very long time
Awesome!
This is a great video!! The narration is concise and well-rehearsed and flows naturally with the images on the screen...awesome!
Thank you for putting your time into this tutorial. It is SO helpful.
Glad it was helpful!
Thanks. I am lucky to find your videos on Excel. The clearest well explained and easy to follow very informative instructions.
Pure gold of a video. The quality in this video is what i'm striving for with my channel. Hats off to you, sir.
Thanks
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!
Thank you !
Don't miss the new video 50 Ultimate Excel Tips and Tricks: czcams.com/video/FXs3WG7M-qk/video.html
Very useful tips which we can use in day to day work.Thank you so much!
Very Helpful! The quick tips very useful in my work. Big Thanks!
this was really helpful thank you
I'd like your way of explain it. Very calm thanks a lot.
this is sooo helpful, concise and easy to get your head around. Thanks a lot!!
I am so glad that I have found your series on Excel. I have been out of the work force for 4 years and to put it mildly....I am rusty. You speak very clearly and concisely. I can understand and easily follow what I need to know. Thank you and I look forward to viewing your videos on other Office applications.
Thanks. Glad these videos are helpful to you.
Thanks !
Great content. Very useful tips and tricks!
Great tips, awesome tools! Thanks
Very helpful. Thank you! Nice, short and structured! Love your voice
Very helpful and easy to understand, highly recommended for excel lovers
Thank you soo much
Love form Pakistan
Hi
Thank you very much for useful tips
BRILLIANT ! Thankyou so much.
Just what I was looking for. Thanks.
very helpful. Thank you!
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!
Glad it was helpful!
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.
Glad it was helpful!
Very very useful! Thank you for sharing :)
Nazia you are beautiful
Loved your tutorial video. So to the point and informative
Glad it was helpful!
These tips are fabulous. Thank you very much!
THANK YOU for this fantastic tutorial! Learned a lot and extremely helpful.
Really good!
the most easy to understand Video and important daily used excel functions, excellent way of describing and Precise.
@syeda u r right dear
Well explained and handy functions too ! Looking forward to see more such preparations
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).
Thanks.
Great video, it was very informative.
That was great! New subbie.
This is amazing.Thanks!
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!
Learning a lot your tips and tricks!! Thankyou
Happy to hear that!
Nice video. Learned a lot
I can't thank you enough for this video. It's so useful and you go straight to the point. Excellent! Keep it up!
Excellent! Don't miss out on the updated version of this video: czcams.com/video/FXs3WG7M-qk/video.html
Always wanted to learn more, big thank you for sharing your tips and tricks, will certainly keep learning from you. You make it easy. Once again a big thank you.
Very much helpful.
I really appreciate what you do for our success. God bless you abandantly!
Otherwise, wishing you Success in life.
Thanks!
Very clear and simple to understand! Thanks a lot!
Many thanks for the share! Very enjoyable!
You've got my subscribtion.