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.

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

[davitbeliashvili]

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

[simonnamsguy]

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

[alberto-sama]

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

[doing]

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

[HamidHamid-pjty]

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

[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!*

[ayesshasidiiqui]

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!

[sallycorpuz]

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

[bensimpson]

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

[miamibrrodriguez]

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

[daviddurkee]

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.

[nigelmtb]

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

[bogdanbaciu]

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.

[janstozek]

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.

[pushpendravashishth]

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

[randomimmigrant]

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

[muruganvinayagan]

very nice understandable presentation. Thankyou very much

[rahmanrahmani]

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

[joshuaabella]

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