- Excel is NOT a database program; don't try to make it into one
- The formula bar NEVER lies
- Let Excel do the heavy lifting
- There's a function for that
- If you have a list, then you should have a table
- Scroll down when possible, scroll across only when necessary
- Separate data, analysis, and presentation
- Macros are the nuclear option – compiled code is more effective than interpreted code
- Excel help SUCKS
- I may be wrong about all of this…you need to find out for yourself
Sunday, August 14, 2011
Geoff's 10 Commandments of Excel
Subscribe to:
Posts (Atom)