K2's Data Analysis Using Power Pivot

Wednesday, September 14, 2022
Webcast or Webinar, Online
10:00AM - 11:49AM (opens at 9:30 AM) EST
2Credits
Technical Business

Registration is Closed

Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.

Members
$79.00 Regular Price
Non-Members
$109.00 Regular Price
Course Type: Webcast
Course Code: 22/AC131558
Level: Advanced
Vendor: ACPEN
Field of Study: Accounting

Overview:

With Power Pivot, your PivotTable reports can become even more powerful than you might have thought possible. This powerful tool can connect directly to many external data sources to link data directly into your reports. Alternatively, you can use it in conjunction with Power Query for superior data import and transformation capabilities. Further, DAX functions allow you to create sophisticated calculations in your PivotTables, adding even more analytical capabilities. And the relational database functionality of Power Pivot provides all the tools necessary for building an intermediary database from multiple data sources. Put Power Pivot to use immediately by participating in this session, which surely will help you improve your analytical and reporting processes.

Objectives:

  • Differentiate between ordinary PivotTables and those created with Power Pivot
  • Identify the advantages of working with Power Pivot
  • Explain the procedure for building a PivotTable using Power Pivot
  • Define Data Models, Data Analysis Expressions, and Key Performance Indicators

Major Topics:

  • Connecting to external data sources
  • Relating multiple tables to create Data Models
  • Summarizing and analyzing data
  • Using DAX to create user-defined calculations

Major Topics:

  • Connecting to external data sources
  • Relating multiple tables to create Data Models
  • Summarizing and analyzing data
  • Using DAX to create user-defined calculations

Designed For:

Accountants and business professionals who are seeking to improve financial analysis processes by taking advantage of the Power Pivot feature found in Windows-based versions of Excel

Prerequisties:

Fundamental knowledge of computer operations and Microsoft Office Excel, including creating PivotTables
CPE sponsors

The Florida Institute of Certified Public Accountants (FICPA) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBARegistry.org