4 Excel tips that can save you 3.5 hours of work this week!

Picture of keyboard

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.

  1. 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.
  2. To insert a line break within an Excel cell, it’s Apple – Option – Return (Mac) or Alt – Enter (PC).
  3. 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/
  4. 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.

  1. This is a great tutorial on how to make a peeled away look on an image in PowerPoint. http://screenr.com/2tO
  2. Make sure to hit save on your documents. Seriously do it right now!

Photo Credit: Book Glutton

This entry was posted in Excel. Bookmark the permalink.

10 Responses to 4 Excel tips that can save you 3.5 hours of work this week!

  1. Dave Myers says:

    Just stumbled across your site from Twitter. You have some great information here. I just signed up for your newsletter.

  2. 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.

    • admin says:

      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..

  3. Anonymous says:

    Man!!! you are the best. Thanks dude.

  4. 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 !!

  5. Susy Em says:

    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

  6. Good article, keep us updating, you are very good writer!

  7. totomix says:

    I think you got talent in writing articles. Waiting for more posts

  8. anonymous says:

    This site is full of information. Thanks dude. Nice work keep it up.

Comments are closed.