6. 15 Tips and Tricks for Using Excel More Effectively

I hope everyone is having a great day. Mine started out on a down note with the Colts losing to the Ravens, plus I am feeling a bit under the weather. I definitely still wanted to get out a blog today and was actually able to learn quite a few things aimlessly surfing the web while stuck in bed with tea all day. Since I am also posting this from my phone (I really do love technology SO much), I figured I would post about something quick that didn’t require much formatting.

20130106-210249.jpg
Aside from the web design business I am trying to get started, I also do quite a bit of freelancing as a writer and as a virtual assistant. As an assistant I do a LOT of work with data entry and data editing, so I use Microsoft Office, especially Excel, on a daily basis. A few weeks ago, one of the tasks I was working on was to convert 100 url’s into hyperlinks within an Excel spreadsheet. As you may or may not know, to covert a URL to a link you highlight the URL, copy it, right click it and then select the hyperlink options, paste the URL into the box and then convert it. A pretty simple process if you are using keyboard shortcuts like Ctrl-c and v, but over a 100 links it was quite a tedious task. I figured there had to be some way to convert them all into links since all of the url’s were right there. Finally after a little but of Googling I found a macro that allowed me to highlight the column and hit one button to make them all links. Ever since then I have been looking for tips an tricks to make these tasks easier and I thought I would share the link of new ones that I learned today.

Some of these I already knew, but a lot of them were really great ideas that I hadn’t thought of and will definitely be using. So without further ado, head on over to TechRadar and see if you can pick up some handy tips and tricks. Also, feel free to leave me a comment/tweet/Facebook post about your favorite time saving or just plain awesome Excel tricks.

Advertisements