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 Live3/9/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.002522015
VA McLean3/9/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.002594491
Virtual Live4/6/2018 9: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.002522008
FL Plantation4/6/2018 10: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.002594588
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.002522012
CA Gardena5/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.002594319
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.002522016
NV Reno6/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.002594559
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 8 of 8 items