K2's Data Analysis with Power Pivot

With Power Pivot, your PivotTable reports can become even more powerful than you might have thought possible. This amazing tool can connect directly to many common 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 functionality of Power Pivot provides all the tools necessary for creating an intermediary database from multiple data sources. Put Power Pivot to use immediately by participating in this very practical session, which is sure to help you improve your analytical and reporting processes.

Learning Objectives

Upon completing this course, you should be able to:

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

Course Information

CPE Credits: Recommended for 2 Hours of Accounting

Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.

Prerequisites: Fundamental knowledge of computer operations and Microsoft Office Excel, including creating PivotTables

Program Level: Advanced

Advance Preparation: None

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

Cost: $79.00

If you are interested in this session, you may also be interested in these on-demand sessions:

To learn more about querying and linking data, check out K2’s Accessing and Cleaning Data with Excel, Power Query, and Power BI
If you’re seeking information on combining and consolidating data from multiple sources, consider K2’s Excel Data Models, Combinations, and Consolidations
To learn more about Microsoft’s business intelligence platform, you may want to consider K2’s Microsoft Power BI – Power Reporting for Free!

To register for “K2’s Data Analysis with Power Pivot” click “Start” below, or if you have already registered and wish to resume your course, click “Log In and Resume.” Additionally, please note the you must have cookies enabled in your browser in order to register for and complete an on-demand program.