PivotTables have never been easier to build than they are in the latest versions of Excel. But, how do you handle calculated fields and calculated items, data grouping, simple data summaries, and special "show values as" data summaries? And how do you deal with non-calendar fiscal years or 4-4-5 calendar periods? What problems does the Excel Data Model present to experienced PivotTable users, and how do you workaround these problems? Get the answer to these questions and more in this session on mastering PivotTable calculations and data summaries.
- Create calculated fields and calculated items for better data analysis
- Calculate between-period differences using special data summaries
- Demonstrate how to calculate fiscal months, fiscal quarters, and fiscal years for use with non-calendar fiscal periods
- Describe how to summarize data when working with 4-4-5 and thirteen 28-day calendars
- Identify the advantages and disadvantages of using the Excel Data Model as a PivotTable data source
- Explain how to relate multiple data sources using VLOOKUP or Data Relationships
- Good working knowledge of Excel and PivotTables