Chapter 8. ORGANIZING WORKSHEET DATA
Enter Data with a Form
People often organize data into lists. You can use Excel to manage lists. In Excel, a list is a rectangular section of a worksheet structured as a set of columns and rows. You call each column a field and you give each field a label. Field labels appear on the first row of a list. Each row in a list is called a record. For example, you can have a list of sales people organized as follows: First Name, Last Name, Sales. You label the first column First Name, you label the second column Last Name, and you label the last column Sales. On each row of your list, in the First Name field, first names appear; in the Last Name field, last names appear; and in the Sales field, sales appear.
In Excel, ...
Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
