I use excel almost every day and I am sure many of you too. Today I was browsing Youtube and found this video on 25 Excel Tips and Tricks by Sele Training.
I was amazed how much I did not know about Excel even though I have been using Excel for more than 19 years.
These tips will help you use excel more efficiently and save you lots of time.
25 Excel Tips and Tricks list:
- Quick Analysis Tool
- Filter
- Drop-Down List
- AutoFit Column Width
- Transpose
- Remove Duplicates
- Goal Seek
- VLOOKUP
- Flash & Auto Fill
- Paste Special Values
- Images in Charts
- IF Function
- Insert Screenshot
- Absolute Cell Reference
- Show Formulas
- Text to Columns
- Conditional Formatting
- PowerPivot
- Freeze Panes
- Ctrl-Arrow Keys
- 3D References
- Forecast Sheet
- SUMIFS Function
- IFERROR Function
- Filled Maps
My favourite was no 1 (Quick Analysis Tool). What is your favourite tip?
Please give us an Upvote if you think this info was helpful. It will help my online business a lot and I hope to return the favour soon.
Thank you. :)
PS. Hot tip 1, Remember don't upvote this post if older than 7 days, you are wasting your voting power!
PPS. Hot tip 2, when buying upvotes, do it in the first 3 to 15 min of posting. You get 90% to 100% of curation rewards.
PPPS. Hot Tip 3, upvote your own post in first 3 min. You will get all of it back.
Thank you for your support.
Regards
Colin Brazendale
Email: [email protected]
Facebook: https://www.facebook.com/colinbrazendalesinternet/
Youtube: https://www.youtube.com/user/czb1972/
Website: http://www.successwithcolin.com
More information about me:
I am a successful bitcoin cloud miner and affiliate of Genesis Mining and USI Tech. I have been mining for the last 19 months. I highly recommend Genesis Mining and USI Tech to earn bitcoin and make money online. I believe it is more important to earn income than hold assets. That is why I recommend mining crypto and blogging on Steemit.