Loading...

Course Description

Power Pivot is a half-day seminar designed to show participants how to analyze data that could be housed in different source formats. The course teaches participants to import the data, create functions with the data, and finally to turn the data into an easy-to-analyze PivotTable format complete with calculations and slicers.

See specific content information below in sections "Expected Outcomes" and "Attend and You Will Learn."

Related Courses

Why You Should Attend

This course will teach participants how to efficiently create eye-pleasing pivottables from "Big Data."

Who Should Attend

Any Excel user eager to learn how to use power pivottables to display data that is combined from many different sources.

Attend and You Will Receive

Participants who successfully complete this course will receive a certificate of completion from NC State University.

Prerequisites

Users attending this course should have completed Excel Levels 1 and 2 or have equivalent experience.

Attend and You Will Learn / Expected Outcome

Expected Outcomes

The participant should use the learned skills as soon as possible on their return to work.  With continued use and practice, the participant will be able to efficiently and effectively create easy-to-analyze pivottables from many data sources.

 

Attend And You Will Learn

Introduction

  • What is Power Pivot
  • How it Works
  • Benefits and Limitations

Installing Power Pivot

  • Versions and Installation
  • Compatibility between Versions
  • Tour of Power Pivot Window

Getting Your Data into Power Pivot

  • Preparing Your Data
  • Excel Tables
  • Importing Data from Access
  • Importing Data from Linked Excel Tables
  • Importing Data from external Excel Files
  • Importing a Text File
  • Copying and Pasting Data
  • Importing from Other Sources
  • Date/Calendar Table

Power Pivot Window

  • Data Formats
  • Sheets and Columns
  • Editing and Adding Data
  • Table Properties
  • Filtering and Sorting

Calculated Columns

  • Referencing Columns
  • Using Functions
  • Referencing another Calculated Column
  • RELATED Function
  • Aggregation Functions
  • Formula Errors
  • Calculated Columns Recap & Rules

Relationships

  • Introduction and Rules
  • Defining Relationships
  • AutoDetect Relationships
  • Editing Relationships
  • Multiple Relationships
  • Working in Diagram View
  • Ideal Data Structure
  • Optimizing Data Models

Power Pivot PivotTables

  • Inserting a Power Pivot PivotTable
  • Filters and Slicers
  • Sorting Options
  • Sorting and Grouping Dates
  • Show Values As
  • Formatting PivotTables
  • Chart & Table Combos
  • Flattened PivotTable
  • Arranging and Formatting Slicers
  • GETPIVOTDATA Function

Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.