Excel, a most under used application. Tips that you can use, the series
October 3, 2006 by Tris Hussey
Filed under Jobs
Ah, MS Excel. I remember when it first came out … on the Mac BTW. Spreadsheets are pretty boring, some say, but we seem to use them a lot in our daily business life. The thing is about Excel is that is it such a powerful tool, that a lot great cool (and easy) features get missed.
How many of you only use Excel for a a chart now and then and look at some data? Maybe make a formula? Yeah, thought so. In fact, when I asked my fellow PYW contributors about a couple of the things I’m going to tell you about they said “Huh? Really?!?! You can do that?!?!”
So here are the tips I’m going to talk about over three posts:
- Sorting. Might sound boring, but I think most people don’t know how easy it is to do complex, multi-column sorts
- Auto-filter. OMG, this is the coolest feature, and frankly I don’t think it gets nearly enough credit or use
- Pivot tables. Okay this is going to be a tough one to explain. I have to scan the help file now and then using them, and I’ve been using them for a couple years now! Undaunted I’m going to try to take the pain out of them and at least get you playing with them.
So without further ado …
Tags: MS Office, MS Excel, Excel tips and trips, PimpYourWork, PYW
Comments
3 Responses to “Excel, a most under used application. Tips that you can use, the series”Trackbacks
Check out what others are saying about this post...[...] pimpyourwork.com Putting some shizzle into your work « Excel, a most under used application. Tips that you can use, the series [...]
[...] Okay, I’ve got this Excel series going in full swing now. Last night (yawn) I talked about sorting. Okay, okay sorting multiple columns isn’t very exciting or sexy (I guess it might depend on what you’re sorting) and you might be thinking, oh that’s so yesterday. Fine. How about Auto-filtering? [...]
[...] I want to take a little break from talking about Excel (my brain can’t handle writing about Pivot Tables until later, I think), to talk about one of my favourite ways to work better and more efficiently: mind mapping. [...]