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

Another 15 Excel 2016 Tips & Tricks:

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


Abdul Karim says:

Is there any formula in excel to identify data in certain interval. I mean I have a lot of data. I have to divide them first 30 data, then 2nd 30 data and so on….l

Rajiv Ojha says:

Great work mate .

Michael Leng says:

เยี่ยม! อ่านเพิ่มเผยเคล็ดลับเอ็กเซล2 วิธีการเรียก Dialog Box “Find(ค้นหา)”: อ่านฟรีเดี๋ยวนี้ ..Click Like ให้ 100 ขอบคุณครับ

Samuel Rudloff says:

I love this video! Are you going to make any tips and tricks for MS Access?

Carol Rooney says:

At #9, if you right click while dragging down, you will get a whole new set of options, especially useful when working with dates.
Great videos. Thank you

OneDay says:

It was a great help. Thanks!

ganesh kumar Vadrevu says:

Thanks you Sir

chong tf says:

Thks very much

Sharron Leland says:

excellent tutorial for beginners and beyond. Thanks

Marco Paulo says:

great video, have been working with excel for quite a while now but there was still quite a few things I took from this

Subash A says:

Let’s suppose we have User A .
A refer B so A Earn 10rs
Now A refer C so A earn 10rs

Now B refer D and E so A earn (10+10=20)
but B also earn (10+10=20)

Now c refer F and G so again A earn (10+10=20)
but c also earn (10+10=20)

and it’s going and going

can anyone help how to use easily in excel

Nurjamal Bahadur says:

Your channel looks great, thank you, subscribe to your channel.

Jenny Jenson says:

Great video. Quick and simple!!

Joe Di Natale says:

Awesome thank you very much great videos



Hilla Apple says:

thanks for your wonderful tutorial

Kees Stevense says:

Very helpful! Thank you!

Shawn Marshall says:

Is it possible to put a table in the header of an excel sheet?

Stuart of Blyth says:

One facility I’ve found invaluable is the ability to name cells and/or groups of cells. For example, you may want to calculate the selling price of a good given its cost price and markup. You would name a cell (say A1) with “Markup” and enter a value (say 1.25 for a 25% markup). With a cost price of £25 in cell B1 you would use the formula “=B1*Markup” in cell C1 to get the selling price.

In your VLOOKUP example, you could select the table and name it IDs. The formula would then be VLOOKUP(“Nancy”,IDs,2).

Using names makes the formulas more understandable – B1*Markup instead of B1*A1, for example. To enter a name, select the cell(s) and type the name into the box immediately above column A (which usually shows the cell address) followed by .

PS You accidentally said “columns” instead of “rows” at 4:43.

Judy Jones says:

This is a wonderful easy to learn course, thank you

Nick Carrel says:

So helpful – thanks!!

Jeff Zak says:

Great tutorial! Thank you for sharing!

Audrey Snipes Mciver says:

Would I be able to see this as you are on my phone

mare mare says:

Wow 🙂  This is fantastic!!!!!!!!!!!!!  Learned lots of new tricks 🙂  Mary

Valerie Snider says:

Very useful tips to build operations tools for start-ups!

Dan Manalo says:

very helpful. Thank you!

Your average Person says:

Excellent tutor. Your clear impartation and lectures help me improve my excel skills. Thank you very much.

14283622 says:



Excellent tips!!  Very helpful – Thank you 🙂

Liaquat Ali says:

informative video gud effert
Grow my channel – #aiitchanel

Joe Degnan says:

Could you give an example of when to use trick #3? Thank you

jayaxe79 says:

Just a small remark on the vlookup example: before drag down, probably it’s a good idea to use absolute cell reference in this case. Otherwise the reference lookup columns would also shift down accordingly, which is not what we want. Anyway, this video is great and has been quite an enlightening overview even though I know up to basic macros.

James Hermann says:

How to convert Text to Column with a data set of 4 unique lines???

 Write a comment


Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!