Here are some of my favourite Excel Sites, in alphabetic order.
 Rob
Bovey MVP - Application
Professionals
- I recommend using Rob's Code Cleaner and Utilities.
Stephen
Bullen MVP - Business
Modelling Solutions
Debra
Dalgleish MVP - Contextures
- Debra has an excellent, simple and clearly
written set of Excel tips and techniques.
IBM
Business Dynamics - Spreadsheet
Modelling Best Practice
- Nick Read and Jonathan Batson's Best Practice Spreadsheet Modelling
Methodology.
- The best guide on developing spreadsheets I know. Strongly recommended.
Available from the EUSPRIG
site.
David
McRitchie MVP -
Excel Pages
- A substantial collection of Excel information.
Peter Noneley -
Excel Function Dictionary
- A wonderfully helpful set of examples for Excel functions.
Chip
Pearson MVP - Pearson Software
Consulting
Jon
Peltier MVP - Peltier
Technical Services
- If you want to know more about Excel Charts this is the place.
Jan
Karel Pieterse MVP - JKP
Application Development Services
- Co-author of Name Manager.
- Learn how to register
VBA UDFs properly with the Function Wizard
John
Walkenbach MVP - The Spreadsheet
Page
- The best spreadsheet author has a great
site. Tips, Links, Downloads, PUP, Jokes and more...
Andrew
Baker - vbusers.com
- Excellent VB and VBA code snippets and downloads.
Dermot
Balson - Insane
Excel
- Interesting things like heavy-duty encryption.
Ole
Erlandsen - Excel
and VBA Tips
Joseph
Moosman - The
Fortress
- Definitely the best music on any Excel site and some interesting
utilities.
Rodney
Powell - Beyond
Technology
- Dynamic Range examples and lots more.
John
Raffensperger - The
new Guidelines for writing Spreadsheets
- Lots of good ideas, particularly for small spreadsheets.
- I disagree with some of John's ideas:
- Using only 1 worksheet: fewer worksheets are better but only
1 can be too few!
- Combining small formulae into a megaformula: only do this
if someone else can understand the result
|
