Part V: Tables and Pivot Tables
This part contains tips that deal with two of Excelâs most useful features: tables and pivot tables. If you work with large amounts of structured data, you owe it to yourself to understand these features.
Tips and Where to Find Them
Tip 75: Using Formulas with a Table
Tip 76: Numbering Table Rows Automatically
Tip 77: Identifying Data Appropriate for a Pivot Table
Tip 78: Using a Pivot Table Instead of Formulas
Tip 79: Controlling References to Cells Within a Pivot Table
Tip 80: Creating a Quick Frequency Tabulation
Tip 81: Grouping Items by Date in a Pivot Table
Get 101 Excel 2013 Tips, Tricks and Timesavers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.