The two key tools for filtering and summarizing small data sets are filters and pivot tables. Filters let you see just the items you want, without changing the underlying data. Pivot tables are powerful summary tools, much like statistical software for large databases. PivotTables allow you to create multidimensional data views by dragging and dropping column headings to move data around.
Microsoft online Pivot Tables Tutorial
Filter data in a Pivot Table
Filter data in a range or table
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment