IN THIS CHAPTER
Creating a spreadsheet from a template
Designing a spreadsheet from scratch
Understanding the different types of cell entries
Knowing the different ways of entering data in the worksheet
Using Data Validation to restrict the data entries in cells
Before you can begin building a new spreadsheet in Excel, you must have the design in mind. As it turns out, the design aspect of the creative process is often the easiest part because you can borrow the design from other workbooks that you’ve already created or from special workbook files, called templates, which provide you with the new spreadsheet’s form along with some of the standard, or boilerplate, data entries.
After you’ve settled upon the design of your new spreadsheet, you’re ready to begin entering its data. In doing the data entry in a new worksheet, you have several ...