EXCEL WORKSHOP: CREATING TABLES
OBJECTIVES
- Create and manage tables
- Manage table styles and options
- Filter and sort tables
- Pivot tables
An Excel table has functionality beyond that of a simple data range, including the ability to:
- Sort and filter columns
- Automatically apply formatting
- Quickly insert column totals or other mathematical results
PRACTICE TASKS
Open the workbook. On the Sales worksheet, do the following:
1. Convert the data range A2:M23 to a table that includes a header row and uses the default
table style.
- Click anywhere in the data range
- On the insert tab, in the Tables group, click Table.
- Verify that the cell range in the Where is the data for your table box is the cell range
you want to convert to a table.
- In the Create Table dialog box, click OK.
2. Move the July column so that it is between the June and August columns.
3. Move the Linda, Max, and Nancy rows at one time so that they are between the Kay and
Olivia rows.
4. Add a row to the table for a salesperson named Ryan, between the Quentin and Steve rows.
5. Add a row to the end of the table for a salesperson named William.
6. Add a column named Dec to the right end of the table.
7. Delete column M from the table.
➤ Display the Complete Sales worksheet, and do the following:
8. Add a total row to the table.
● clicking in any cell displays a list of functions for processing the numeric contents of
the table column. These include Average, Count, Count Numbers, Max, Min, Sum,
StdDev, Var
9. Modify the cells in the row to calculate the average sales for each month and for the year