lmayer@elgin.edu

Lists

Tutorial 5 Objectives:

After completing Tutorial 5, students will be able to:

  • Plan and Create a list
  • Freeze Rows and Columns
  • Use Find and Replace
  • Create a List Range
  • Sort Date
  • Maintain a List
  • Use AutoFilters
  • Use Conditional Formatting
  • Use Subtotals
  • Create and use Pivot Tables
  • Add a field to a Pivot Table
  • Create a Pivot Chart

Click here for Key Terms.

Click here for the PowerPoint Presentation.

Homework:
Case Problem 2 page EX 247 - 248

 

Previous Lecture         Next Lecture