Power Up Your PivotTables Webinar

Apr 19
3:30 - 5:30 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-PPT171 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