I'm a big fan of Microsoft Excel I believe it's much more powerful than people realise!
This category tries to introduce ways in which I think Microsoft Excel can benefit you and save you loads of time.
Removing duplicates values using Excel
I'm not talking about creating a spreadsheet in order to launch a worldwide campaign to eradicate Vince's, I mean you can use it to remove duplicate values from a list.
Removing formulas from Excel
I do like Microsoft Excel, I like it so much that I often create spreadsheets just for fun!
But then someone complains and I have to remove the formulas...
Formatting names correctly
Getting Excel to format names is fine, but depending on the source of your data, some of the formatting may have already been done!
The PROPER function
Formatting peoples names or company names can be painful, but if you get Microsoft Excel to do the hard work for you, it leaves loads of time to talk to squirrels and drink tea...with squirrels!