ADM 2302 Chapter 4: Business Analytics
Document Summary
You have to visualize where you want to finish. Try different trial solutions to check the logic. If there are any problems showing up at this stage, one should go back to the build stage and try to fix the problem. People usually go back and forth between the test and build stage, since you can"t assure everything will go right. The data is always the first thing you enter in a spreadsheet, before the formulas and everything else. This is where you provide yourself with some labels. This can help others understand your spreadsheet without you having to explain everything. Enter each piece of data into one cell only. Every formula using the same piece of data should refer to the same single data cell. To avoid making the spreadsheet messy, you can use the reference labels for the formulas. Formulas should refer to data cells for any needed numbers. Make the spreadsheet as easy to interpret as possible.