A spreadsheet that works
with Tables in Excel. This lesson shows how to present data
visually, format data as a Table and calculate the Totals.
Complete the Practice Activity on page 45.
Review the Test questions on page 46.
This lesson demonstrates options on the Table
Tools Ribbon.
1.
Table
Tools->Design ->Table Styles,
page 24
2.
Table
Tools->Design ->Table Style Options->Header Row, page
25
3.
Table
Tools->Design ->Table Style Options -> Total Row, page
27
4.
Table Tools->
Design ->Table Styles -> Clear, page
30
5.
Table Tools->
Design ->Properties-> Resize Table, page
41
6.
Table Tools->
Design ->Tools-> Remove Duplicates, page
42
7.
Table Tools->
Design ->Tools-> Convert to Range, page 44
From the Home Ribbon
Home -> Conditional Formatting, page 31 |
|
|
|
