• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Excel: Quick Start! > Building a Sample Workbook and Worksheet

Building a Sample Workbook and Worksheet

There are four basic aspects to creating a worksheet: entering data, applying formulas, utilizing functions, and formatting the data to look its best. There are special techniques for accomplishing each of these worksheet tasks. In this section, you'll find instructions for constructing a worksheet in the quickest way possible. For more detailed information on entering data, formulas, and formatting, see Chapters 2, 3, and 4.

Basic Data Entry

To begin entering data into a worksheet, click inside a cell and start typing. It's usually a good idea to plan out where you want data placed in a worksheet. To help you create your first sample workbook and worksheet, let's build a sheet that records 1st quarter sales for a fictional company called "Hales Hardware," a hardware supplier. Let's say there are four sales people. The sheet will record the name of each sales person, one name per row. There are three months in one sales quarter, so the worksheet will include January, February, and March in three columns. The data will look something like this:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint