best practice?

[hsibbs]

Is there definitive advice on Excel best practice?

 

[Otto Moehrbach]

About what? Narrow your question somewhat. What feature or procedure are
you asking about? HTH Otto

 

[Bob Phillips]

There is definitively no definitive advice on anything.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Harald Staff]

Best thing I've seen on this yet is written by John F Raffensperger:
http://www.mang.canterbury.ac.nz/people/jfraffen/spreadsheets/index.html
it's about spreadsheet design in general.

HTH. Best wishes Harald

 

[Gord Dibben]

And Charles Williams' site has great tips on setting up for maximizing
calculations speeds.

http://www.DecisionModels.com


Gord Dibben Excel MVP

 

[hsibbs]

Being an expert user (not a programmer or developer note!!) I am trying o put
together some advice for users of excel, many of whom have terrible habits,
mostly on the formatting side, eg putting a heading in two cells rather than
in one and wrapping it, snd having blank rows and columns.

 

[JulieD]

okay well my first item on the list would be "don't merge cells" ... causes
problems when you try filtering & sorting etc

 

[Excel Best Practices Resource Center]

You can look at the book: "Excel Best Practices for Business" (ISBN:
076454120X, Wiley Publishing, Inc.).