[ Excel ] 25 Excel tips and tricks
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.
Beautiful .. work great from you
I liked the tips
Thanks for sharing
Thank you for your kind comment
Wow, very interesting tips. Some too advanced for me, but I love no.6 remove duplicates. Thank you for sharing.
Yeah, very important
Yes I agree
Thank you
Very cool features, I have been using excel for years as well...my favorite is the pivot feature.
I agree. The pivot table feature is super cool. Thank you for your comment.
Pivot table is too advanced for me. lol
To be candid, I don't know anything about excel, but your post has given some tips about it already, thanks a big time.
Please read about food therapy to control high blood pressure from my blog @andymandy01 thank you
Very interesting @andymandy01 thank you for sharing.
Food therapy, sound good to me. Will have a look later.
You got a 15.84% upvote from @emperorofnaps courtesy of @colinbrazendale!
Want to promote your posts too? Send 0.05+ SBD or STEEM to @emperorofnaps to receive a share of a full upvote every 2.4 hours...Then go relax and take a nap!
Great upvote bot thank you
Another good bot?
Valued video
This post has received a 8.87 % upvote from @booster thanks to: @colinbrazendale.
Thank you @booster upvote bot
This post has received a 15.21% upvote from @msp-bidbot thanks to: @colinbrazendale. Delegate SP to this public bot and get paid daily: 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP Don't delegate so much that you have less than 50SP left on your account.
Great bot, thank you
I need to try this upvote bot too. Just need to get start posting more. :)
Congratulations @colinbrazendale! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on any badge to view your own Board of Honor on SteemitBoard.
To support your work, I also upvoted your post!
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOP
Do not miss the last announcement from @steemitboard!
Well done @colinbrazendale
Send 0.01 SBD/STEEM bids to @minnowbacker with the link to post you would like voted on as the memo! You will receive a guranteed profit.
Nice deal