Microsoft Office Tutorials and References
In Depth Information
A list example
Figure 9-1 shows a small list that contains employee information. It consists of a Header row, seven columns,
and 20 rows of data. Notice that the data consists of several different types: text, numerical values, dates, and
logical values. Column E contains a formula that calculates the monthly salary from the value in column D.
Figure 9-1: A typical list.
You can do lots of things with this list. You can sort it, filter it, create a chart from it, create subtotals, summar-
ize it with a pivot table, and even remove duplicate rows (if it had any duplicate rows). A list like this is a com-
mon way to handle structured data.
A table example
Figure 9-2 shows the employee list after I converted it to a table, using Insert ⇒ Tables ⇒ Table. The table looks
very similar to a list, and the most obvious difference is the formatting (which was applied automatically).