Power Up Your PivotTables Webinar
Jun 5
10:00 - 12:00 p.m.
Online
2-Other
CPE Credits
- 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
Highlights
- Creating calculated fields and calculated items
- Formulating calculated items with relative references
- Applying special data summarization techniques
- Dealing with fiscal periods and special accounting calendars, such as 4-4-5 and thirteen 28-day periods
- Using the Excel Data Model for PivotTable reporting
Registration
PICPA Member: $79
Nonmember: $104
More Information
Course No.
WK2-PPT172
Level:
Advanced
Prerequisites:
Good working knowledge of Excel and PivotTables
Notes
Your log-in instructions will be sent by K2 Enterprises at least 24 hours before the webinar.
Speaker(s)
Lawrence McClelland
K2 Enterprises
Course No. WK2-PPT172
Level: Advanced
Prerequisites: Good working knowledge of Excel and PivotTables
Notes
Your log-in instructions will be sent by K2 Enterprises at least 24 hours before the webinar.
Lawrence McClelland
K2 Enterprises
