Font size:

In this course, students learn how to organize, manipulate, and report data in the best way possible. This course will provide students with a solid understanding of Power Pivot to maximize their effectiveness when analyzing data.


TARGET AUDIENCE:
Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using Power Pivot.

COURSE OBJECTIVES:
Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2013 to analyze data from a variety of sources. You will: Get started with Power Pivot.Visualize Power Pivot data.Work with advanced functionality in Power Pivot.

COURSE OUTLINE:


Getting Started with Power Pivot

  • Topic A: Enable and Navigate Power Pivot
  • Topic B: Manage Data Relationships

Visualizing Power Pivot Data

  • Topic A: Create a Power Pivot Report
  • Topic B: Create Calculations in Power Pivot

Working with Advanced Functionality in Power Pivot

  • Topic A: Create a Key Performance Indicator
  • Topic B: Work with Dates and Time in Power Pivot
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live5/11/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day295.002890899
FL Miami5/11/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>1 day295.002979208
Virtual Live6/8/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day295.002890902
TX Austin6/8/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>1 day295.002978950
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 4 of 4 items