Microsoft Office Tutorials and References
In Depth Information
In addition to using a worksheet to calculate values, you can also use it to manage and ana-
lyze 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 consist-
ent, accurate data entry.
Sorting data in your list can be accomplished a few ways: one with the sort ascending
or descending buttons, the other by using Excel’s AutoFilter option. By typing in a set
field to sort by, you can pull all the records in your list that contain a matching field.
PivotTables are also available to pull your data together for easier viewing, filtering, and
reporting. Excel has some designed reports that contain layout formatting to give that ex-
tra touch to your reports. You can also use Power View to visually interact with PivotTable
data. You can create and interact with charts and maps, slicers, and other data visualiza-
tions and filter out the data you want. In addition, you can use PowerPivot to build simple
data models directly in Excel. PowerPivot is helpful when you want to import, filter out,
and quickly process millions of rows of data from multiple data sources.
A table is a series of rows and columns with data you manage separately from other data
in a worksheet. Examples of tables are an address book, a list of customers or products,
and a telephone directory. In Excel 2007, you can turn a range of cells into a table (previ-
ously referred to as an Excel list) to make it easier to manage and analyze a group of data.
You can create more than one table in the same worksheet. However, you cannot create a
table in a shared workbook.
When you create a table, Excel adds filtering in the header row where you can sort
data by order or color, and filter data by criteria. After you create a table, you can easily
format table data using Quick Styles. Additionally, you can insert and delete table rows
and columns, create a calculation column, display and calculate data totals, reference the
table by name instead of by cells, use built-in data validation to ensure data integrity, and
export a table to a SharePoint list.