• January 13, 2012
• February 22, 2012
  
• March 8, 2012
• April 30, 2012
  

COURSE DESCRIPTION
Lists of data are commonly kept in Excel. What few Excel users realize
is the amount of data manipulation capability that is built into the
program. This course will introduce the learner to the data form,
sorting, filtering, subtotals, validation, and PivotTable analysis that can
be carried out with a data list.

Pre-requisite: Excel Basics and Intermediate or equivalent experience

Half Day Class Only: $90.00 (Unless otherwise specified half day
classes are weekdays from 9am to 12pm.)

COURSE HIGHLIGHTS

• Data Form
  
• Add and Edit Data Using the Form
  
• Search With the Data Form
  
• Data Sort
  
• Push Button Sorting
  
• Multiple Level Sorting
  
• Custom Sort Orders
  
• Autofiltering Data
  
• Exact Value Autofilter
  
• Custom Autofilter
  
• Top 10 Autofilter
  
• Clearing Autofilters
  
• Automatic Subtotals
  
• Multiple Level Subtotals
  
• Removing Subtotals
  
• Creating Data Validation
  
• Data Validation Types
  
• Extending Data Validation
  
• PivotTables (and PivotCharts)
  
• Creating a PivotTable
  
• Rearranging the PivotTable Layout
  
• Utilizing the PivotTable Toolbar
  
• Adding and Removing Fields
  
• Refresh Data
  
• Format PivotTable Fields