Excel Tips
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

Excel is proper great!

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.

Read full article

Authored by Vince Russell on 26 July 2005 at 02:59PM
Current rating: 3 out of 5 stars!
Filed under: Excel Tips | Comment (0)

 

Removing formulas from Excel

Remove formula

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

Read full article

Authored by Vince Russell on 26 July 2005 at 10:05AM
Current rating: 3 out of 5 stars!
Filed under: Excel Tips | Comment (3)

 

Formatting names correctly

Excel is exactly what you need!

Getting Excel to format names is fine, but depending on the source of your data, some of the formatting may have already been done!


Read full article

Authored by Vince Russell on 12 July 2005 at 10:38PM
Current rating: 3 out of 5 stars!
Filed under: Excel Tips | Comment (0)

 

The PROPER function

Excel is proper great!

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!

Read full article

Authored by Vince Russell on 01 July 2005 at 09:09PM
Current rating: 3 out of 5 stars!
Filed under: Excel Tips | Comment (0)