Back to Search

Advanced Excel Data Magic: Managing, Analyzing, and Reporting Webcast


Dec. 8
8:00 a.m. - 4:00 p.m.

CPE Credits



PICPA Member: $285 | Nonmember: $385

CLE Credit Add-On: $50

 More Information

Course No.
Fundamental knowledge of Excel 


Advance your reporting processes and minimize your dependence on formulas. Grasp the importance of creating Data Models. Learn to use Power Pivot to quickly summarize data into compelling and interactive statements.


  • Steps for creating Data Models in Excel
  • Linking data from external data sources into Excel using Power Query
  • Creating transformations in Power Query to facilitate simpler and more timely reporting
  • Benefits of using Power Pivot to manage your Data Models
  • PivotTables and PivotCharts


You May Also Like

Advanced Excel
Dec. 7 | Feasterville-Trevose
Learn Excel skills in six key areas: collaborate with other users and secure workbooks; use tables to analyze and report data; integrate and manipulate data from external sources; create and ...
Excel PivotTables for Accountants Webcast
July 30 | Webinar
Consolidate data from multiple sources and analyze large data sets in a fraction of the time. Design multiple PivotTables from a single data source while grouping data into fiscal reporting ...
Budgeting and Forecasting Tools and Techniques 
Nov. 6 | Cranberry
Discover how to obtain budget data and collaborate with team members using Excel’s Audit Trail as well as shared and merged workbooks. Master Office Data Connections and Open Database Connectivity. ...