K2's Data Analysis with Power Pivot
Earn 2 CPE Credits!
Exam price $89.
OR

All of our materials/exams are NASBA and the AICPA approved the revisions to the Statement on Standards for Continuing Professional Education (CPE) Programs (Standards).

Your Exam purchase includes

  • Course materials (video & PDF version)
  • Unlimited attempts to complete exam
  • Instant grading & certificate of completion
  • One year access to complete your CPE
  • Instructor discussion forum



Overview

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

  • 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
  • None
  • Fundamental knowledge of computer operations and Microsoft Office Excel, including creating PivotTables
  • Advanced
  • 103648

No Reviews