Return to Main CISD Home Page CISD Schools CISD Departments What's New in CISD CISD Help Desk Services Please Email us your comments. Conroe Independent School District

Conroe Independent School District
Technology Competencies
Advanced Spreadsheets
Description:This class is designed for teachers who want to learn to sort and filter data; display subtotals; create and manipulate pivot tables; work with functions and templates; and perform data projections and data analysis. In addition, teachers will learn to manage, protect, and link workbooks; link and embed objects, and consolidate information.
Prerequisite Skills: Intermediate Spreadsheets
Outline
A. Managing Worksheet Data
  1. Working with the Data Form
  2. Querying Data in the Data Form
  3. Sorting Data
  4. Working with the AutoFilter Feature
  5. Working with Filtered Data
  6. Removing AutoFilter
  7. Working with the Advanced Filter
  8. Setting Up a Criteria Range
  9. Displaying Records that Meet All Criteria
  10. Combining AND/OR Relationships
  11. Executing the Advanced Filter Command
  12. Displaying a Filtered List
  13. Displaying Subtotals
B. Working with Pivot Tables
  1. Working with Pivot Tables
  2. Creating a Pivot Table from an Excel List
  3. Changing a Pivot Table
  4. Hiding Items in a Pivot Table
  5. Working with Page Fields
  6. Adding a Page Field
  7. Displaying a Specific Page
  8. Showing Page Fields on Separate Worksheets
  9. Grouping Pivot Table Data
  10. Grouping Text Items, Dates and Times and Numbers
 C. Using Financial and Logical Functions
  1. Displaying the Absolute Value of a Number
  2. Using the ABS Function
  3. Testing Cells Using IF, OR, and AND Functions
D. Using Lookup and Database Functions
  1. Looking Up Values in a Table
  2. Counting the Occurrences of a Value
  3. Finding the Sum and Average of Specific Records
  4. Finding the Sum of Specific Records
  5. Finding the Average of Specific Records
E. Working with Templates
  1. Using Excel Workbook Templates
  2. Creating Templates
  3. Editing a Template
F. Making Projections and Analyzing Data
  1. Using Data Tables to Solve Problems
  2. Solving What-If Problems
  3. Working with the Scenario Manager
  4. Creating a Scenario
  5. Working with the Goal Seek Feature
  6. Working with Solver