Font size:

Excel provides Power Pivot to help students organize, manipulate, and report on their data in the best way possible. In this course, students gain 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 2016 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
CA Anaheim3/1/2018 7:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day295.002520498
Virtual Live3/1/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.002522407
OH Dublin3/1/2018 9: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.002589025
Virtual Live3/27/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.002522408
TN Nashville3/27/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.002589119
Virtual Live4/17/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.002522412
TX Austin4/17/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.002589226
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.002522401
NV Reno5/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.002589378
Virtual Live5/29/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.002522411
GA Atlanta5/29/2018 9: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.002589057
Virtual Live6/21/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.002522404
CO Aurora6/21/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.002589433
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 13 of 13 items