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
Price: $18.99
Excel 2019 All-in-One For Dummies
(as of May 23, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price: $0.00
OfficeSuite Free
View, create and edit complex office documents all from a familiar desktop-style interface Full compatibility with Microsoft formats including DOC, DOCX, DOCM, XLS, XLSX, XLSM, PPT, PPTX, PPS, PPSX, PPTM, PPSM Support for PDF files including PDF came... (as of May 23, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price: $26.99
Excel 2019 Bible
(as of May 23, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price: $4.99
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
Great work mate .
เยี่ยม! อ่านเพิ่มเผยเคล็ดลับเอ็กเซล2 วิธีการเรียก Dialog Box “Find(ค้นหา)”: https://goo.gl/Yfwmhh อ่านฟรีเดี๋ยวนี้ ..Click Like ให้ 100 ขอบคุณครับ
I love this video! Are you going to make any tips and tricks for MS Access?
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
It was a great help. Thanks!
Thanks you Sir
Thks very much
excellent tutorial for beginners and beyond. Thanks
great video, have been working with excel for quite a while now but there was still quite a few things I took from this
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
Your channel looks great, thank you, subscribe to your channel.
Great video. Quick and simple!!
Awesome thank you very much great videos
Awesome!!!
thanks for your wonderful tutorial
Very helpful! Thank you!
Is it possible to put a table in the header of an excel sheet?
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.
This is a wonderful easy to learn course, thank you
So helpful – thanks!!
Great tutorial! Thank you for sharing!
Would I be able to see this as you are on my phone
Wow 🙂 This is fantastic!!!!!!!!!!!!! Learned lots of new tricks 🙂 Mary
Very useful tips to build operations tools for start-ups!
very helpful. Thank you!
Excellent tutor. Your clear impartation and lectures help me improve my excel skills. Thank you very much.
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.
Excellent tips!! Very helpful – Thank you 🙂
informative video gud effert
Grow my channel – #aiitchanel
Could you give an example of when to use trick #3? Thank you
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.
How to convert Text to Column with a data set of 4 unique lines???