4 Excel tips that can save you 3.5 hours of work this week!
Here are some tips that I’ve been sharing on Twitter. When you use these kinds of tricks in your regular processes, you can save hours of work. There’s no reason to be spending more than 10 minutes on any task. Use these tricks, spend less time on boring stuff, and focus on what you want to do.
- Excel 2007 has a great way to get unique records out of large columns of data. Click the data ribbon and the remove duplicate button. If you are in an old Excel program, there’s a way too: http://bit.ly/czu7qX. The video will show the procedure in both versions of Excel.
- To insert a line break within an Excel cell, it’s Apple – Option – Return (Mac) or Alt – Enter (PC).
- Here is a link to learn how to make a pivot table and chart in Excel http://seogadget.co.uk/how-to-make-a-pivot-table-and-chart-in-excel/
- Use the Alt key on your keyboard to display the hot keys in Excel. These can save you a lot of time by not using your mouse. (For example, Alt + F11 allows you to edit your macros.) That’s a lot faster than navigating the menu.
Here are two BONUS tips.
- This is a great tutorial on how to make a peeled away look on an image in PowerPoint. http://screenr.com/2tO
- Make sure to hit save on your documents. Seriously do it right now!
Photo Credit: Book Glutton
Categories:
Just stumbled across your site from Twitter. You have some great information here. I just signed up for your newsletter.
I am an accountant and using excel since long. There were few things, doing which I used to take a lot of time. Then I came across this article and learnt these tips. Once I applied them, I was so happy to find that it was very easy job and I saved a lot of time. I must say you thanks for sharing such a useful information with all of us.
Thanks for the feedback! I’ve spent time in accounting and I wish someone would have shared these things with me. There’s more to come..
Hello Dave – Glad you found us! If you have any questions, let us know. 🙂
Man!!! you are the best. Thanks dude.
Helpful tips!! I have to work with excel a lot. Wasn’t familiar few of these tricks !! Thanks a lot man. By the way, nice blog !!
Very Nice website. I recently built mine and i was looking for some design ideas and you gave me a few. May i ask you whether you developed the website by youself?
Thank you
Good article, keep us updating, you are very good writer!
I think you got talent in writing articles. Waiting for more posts
This site is full of information. Thanks dude. Nice work keep it up.