Summarize and Analyze Data Using Microsoft Excel-Version: 2007
Wednesday, November 18th, 2009
9:00am - 12:00pm
Learn to summarize and analyze spreadsheet data with ease. This course is designed for those who manage large amounts of data and wish to do so with a minimal amount of work.
Topics:
- Set up an Excel list
- Sort records by single and multiple fields
- Create custom sort orders
- Generate subtotals
- Use AutoFilter to filter data
- Create a custom filter
- Use the PivotTable wizard
- Create and rearrange a PivotTable layout
- Format a PivotTable report
- Create a PivotChart report
- Prerequisites: The Fundamentals of MS Excel course, or equ exp. This is not for new Excel users.
- Sponsor: Human Resources
- Location: Information Systems 262
- Open to: Faculty, Staff
- Facilitators: The Right Click, Professional Facilitator