Font size:

Summary

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But, Excel is capable of doing so much more. Being able to harness the power of advanced PivotTable and Power Pivot features will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Outline

Module 1: Preparing Data and Creating PivotTables• Prepare Data• Create a PivotTable from a Local Data Source• Create a PivotTable from Multiple Local Data Sources• Create a PivotTable from an External Data Source

Module 2: Analyzing Data Using PivotTables• Summarize PivotTable Data• Organize PivotTable Data• TFilter PivotTable Data• Format a PivotTable

Module 3: Working with PivotCharts• Create a PivotChart• Manipulate PivotChart Data• Format a PivotChart

Module 4: Getting Started with Power Pivot• Enable and Navigate Power Pivot• Manage Data Relationships

Module 5: Visualizing Power Pivot Data• Create a Power Pivot Report• Create Calculations in Power Pivot

Module 6: Working with Advanced Functionality in Power Pivot• Create a Key Performance Indicator• 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
KS Wichita4/12/2018 8:30: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.002466723
Virtual Live4/12/2018 8:30: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.002467053
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 2 of 2 items