Microsoft Excel 2007 Quick Reference Guide - Excel 203: Sorting, Filters & Pivot Tables A complete guide to learn how to apply sorting and filtering options in your spreadsheets. Use advanced filters to analyze and understand data trends. Apply PivotTable reports to summarize and consolidate large data sets. Use PivotTables and PivotCharts to create custom reports and dashboards. Step by step instructions with examples and illustrations. Part of a series of several quick reference guides for Excel 2007, each focusing on a set of specific and important topics.