Pivot Table: Developing Pivot Table Pivot Table Analyzing data using goal seek and solver Scenarios Create named scenarios Creating a scenario summary report Validating Auditing Trace precedent dependent cells Identify cells with missing dependents Creating applications in Spreadsheet Macros