10. Useful Tools for Tables

In today's class, we continued working on our Silver Photography Sales Rep Table.
We:

• Created a Grade Table
  
• Learned how to use the VLOOKUP function to determine letter grades
  
• Added Conditional Formatting using a Rule with colorful Icons
  
• Used a Table Total Row
  
• Examined the variety of ways to Print the Table
  
• Sorted the List using the Sort and Filter Button
  
• Using Sort on the Data Tab
  
• Sorting with an AutoFilter
  
• Sorting on Multiple Fields
  
• Converting a List to a regular range of cells
  
• Displaying Automatic Sub-Totals for analysis
  
• Using Sub-Total Tools
  
• Removing Sub-Totals
  
• Re-Formatting the Table
  
• We used the Table AUTOFILTER's to find subsets of our records.

Materials Covered: MS Excel - Project 5:
Creating, Sorting & Querying a Table, pp 356-384