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

Instructors

Loading...

Enroll Now - Select a section to enroll in

Section Title
Excel Power Pivot
Type
In-Class
Days
T
Time
1:00PM to 4:15PM
Dates
Feb 18, 2020
Schedule and Location
Contact Hours
3.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $195.00
Instructors