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 https://youtu.be/PU8ACyYxJBk.

Another 15 Excel 2016 Tips & Tricks: https://youtu.be/L9SKTj2gevA

Contents:
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

Comments

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(ค้นหา)”: https://goo.gl/Yfwmhh อ่านฟรีเดี๋ยวนี้ ..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

CYNTHIA SheDoinIt HUGHES says:

Awesome!!!

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:

GREAT STUFF, VERY SIMPLE BREAK DOWN FOR THE MOST PART. I’M TRYING TO LEARN SOME THINGS SINK IN, SOME THINGS JUST GO RIGHT BY ME. BUT I’LL BE HERE.

MARIA LANHAM 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

*

Human Verification: In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.


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

Please click below to support us on Facebook!

Send this to a friend

▷ Other ReviewsVehicles▷ Show Cars▷ Motorbikes▷ Scooters▷ Bicycles▷ Rims & Tires▷ Luxury BoatsFashion▷ Sunglasses▷ Luxury Watches▷ Luxury Purses▷ Jeans Wear▷ High Heels▷ Kinis Swimwear▷ Perfumes▷ Jewellery▷ Cosmetics▷ Shaving Helpers▷ Fashion HatsFooding▷ Chef Club▷ Fooding Helpers▷ Coktails & LiquorsSports▷ Sport Shoes▷ Fitness & Detox▷ Golf Gear▷ Racquets▷ Hiking & Trek Gear▷ Diving Equipment▷ Ski Gear▷ Snowboards▷ Surf Boards▷ Rollers & SkatesEntertainment▷ DIY Guides▷ Zik Instruments▷ Published Books▷ Music Albums▷ Cine Movies▷ Trading Helpers▷ Make Money▷ Fishing Equipment▷ Paintball Supplies▷ Trading Card Games▷ Telescopes▷ Knives▷ VapesHigh Tech▷ Flat Screens▷ Tech Devices▷ Camera Lenses▷ Audio HiFi▷ Printers▷ USB Devices▷ PC Hardware▷ Network Gear▷ Cloud Servers▷ Software Helpers▷ Programmer Helpers▷ Mobile Apps▷ Hearing AidsHome▷ Home Furniture▷ Home Appliances▷ Tools Workshop▷ Beddings▷ Floor Layings▷ Barbecues▷ Aquarium Gear▷ Safe Boxes▷ Office Supplies▷ Security Locks▷ Cleaning ProductsKids▷ Baby Strollers▷ Child Car Seats▷ Remote ControlledTravel▷ Luggages & Bags▷ Airlines Seats▷ Hotel Rooms▷ Fun Trips▷ Cruise Ships▷ Mexico Tours