Microsoft Excel 2016: (D) PowerPivot - EOD

Back to List

Course: 2112891 - Microsoft Excel 2016: (D) PowerPivot - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn how to import and manipulate data using PowerPivot. Create linked tables, organize and format tables, implement calculated columns, as well as create and manage table relationships. Discover how to insert PivotTables and PivotCharts. Find out how to use DAX functions, extract data, protect reports, and save into different file formats.

Prerequisites

Course Outline

  • Enabling and Navigating PowerPivot
  • Importing Data from Various Data Sources
  • Refreshing Data from a Data Source
  • Creating Linked Tables
  • Organizing and Formatting Tables
  • Creating Calculated Columns
  • Sorting and Filtering PowerPivot Data
  • Creating and Managing Table Relationships
  • Creating PivotTables
  • Creating PivotCharts
  • Creating Power Views
  • Filtering Data Using Slicers
  • Presenting PivotTable Data Visually
Course Type: In Classroom
CEU: 0.30
Sections:
Section#: 3957
Section Meeting Dates and Times:
8/15/2017: 1:30 PM - 4:30 PM

Location:
Suite 2201 - Lab 2203
General Services Complex (GSC)
750 Agronomy Rd.
Description:

Category: Technology Training - Spreadsheets

Register and View Schedule

Add to Course Waitlist