Introduction

In addition to using a worksheet to calculate values, you can also use it to manage and analyze a table of information. For example, you can create an inventory list, a school grade book, or a customer database. You can quickly turn a range of cells into a table (previously referred to as an Excel list), and then format the data using Quick Styles. Additionally, you can insert and delete rows and columns, create a calculation column, display and calculate data totals, and reference a table by name instead of by cells.

Controlling how data is entered decreases errors and makes a worksheet more reliable. Data entry in a table is enhanced by features such as a pick list to ensure restricted field entry, and adding data validation rules which will restrict the entry of data into certain fields. You can also create a drop-down list of entries you define to help provide consistent, accurate data entry.