10 worst mistakes

[Michiel van der Blonk]

I thought someone might learn something from my post:
http://michiel.wordpress.com/2009/04/05/10-worst-microsoft-excel-practices/

Michiel

 

[T. Valko]

I disagree with #2.

I only use names for long complex formulas. It's much easier to look at a
formula that uses cell references and tell where the referenced data can be
found. Also, you can tell what the formula does because there are already
descriptive headers near the formula that explain what the formula is for.

 

[Kassie]

Biff, I tend to rather agree with Michiel and with you. Some formulae really
do not need range names, but many do. especially when they refer to info on
another sheet.
--
HTH

Kassie

Replace xxx with hotmail

 

[T. Valko]

It all comes down to personal preference. My preference is to use names
sparingly.

One thing that does "bug" me is long sheet names, long file names and long
paths to the file!

 

[Kassie]

And I say Amen to that one Biff!!!!! Highly frustrating and senseless.

--
HTH

Kassie

Replace xxx with hotmail

 

[Roger Govier]

But easily overcome with Names <vbg>

 

[Kassie]

You're so right! lol

--
HTH

Kassie

Replace xxx with hotmail

 

[T. Valko]

But easily overcome with Names <vbg>

I knew that was coming!

 

[Ken Wright]

Unless of course they are very long names..................

Regards
Ken..................


<snip>

 

[genehunter]

Very nice article.
here is something I came across a while earlier.
http://discover.nci.nih.gov/symbolmutation/
This describes how people formatted the gene names wrongly and ended up
with Oct11 and so on.
See screenshot
http://www.biomedcentral.com/1471-2105/5/80/figure/F1
-GH