Excel Guideline #01: Document your Work
What defines a good spreadsheet? How do I make it better? We have been researching spreadsheets for almost a decade. That’s why we write articles about creating reliable spreadsheets every other week. We are Infotron and the Delft University of Technology, the makers of PerfectXL. Never miss a new guideline!
Guideline #01: Document your Work
What separates the great spreadsheets from the other ones, is documentation! This will help future users of the spreadsheets to really understand your work. Even when the future user is you. Your spreadsheet should contain a ‘Documentation’ sheet as first, or last worksheet. Explain the future reader what the spreadsheet is for, where you obtained the data and where the results may be used. Read more
On perfectxl.com you can Subscribe for free.