Data Magic with Excel

Jul 29
8:00 - 4:00 p.m.

Pennsylvania Institute of CPAs
Philadelphia - Map

8-Other
CPE Credits

Navigate the world of automatically linking data to Excel. Examine opportunities for analyzing, reporting, and preparing visualizations. Examine tools such as Power Query and Power Pivot to navigate large volumes of data. Create compelling visualizations.
Highlights
  • Manage links from external data sources into Excel for the automatic acquisition of data
  • Data models
  • Define, build, and manage data models and build PivotTables
  • Data Analysis Expressions and other tools to add calculations to PivotTables
  • Add features such as key performance indicators, dimensions, and hierarchies
  • Power Pivot PivotTables using PivotCharts and Power View Advanced

Registration

PICPA Member: $299
Nonmember: $399

More Information

Course No. 766000

Level: Advanced

Prerequisites: Intermediate to advanced understanding of PivotTables

Notes
This course is hands-on training with a group demo and discussion.

Speaker(s)

Steven Phelan

K2 Enterprises