Spreadsheets

Excel 2016/2013 Data Analysis with Power Pivot

In this era of big data, it is becoming increasingly imporant to be able to analyze large amounts of data quickly. This course will provide students with a solid understanding of Excel's PowerPivot feature to help organize, manipulate, and report data.

Dates & Times

CourseDate & TimeLocationCost
Excel 2016/2013 Data Analysis with Power PivotJune 27 - 1:00 - 4:30AlbanyRegister
Excel 2016/2013 Data Analysis with Power PivotAugust 15 - 8:30 - 12:00LathamRegister

Course Outline

This course is appropriate for experienced Excel users who who are seeking to advance their data analysis capabilities by using Power Pivot. Upon successful completion of this course, students will be able to use Power Pivot to analyze data from a variety of sources. Students will get started with Power Pivot, visualize Power Pivot data, and work with advanced functionality in Power Pivot.

Includes:
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Getting Started with Power Pivot

  • Topic A: Enable and Navigate Power Pivot
  • Topic B: Manage Data Relationships

Lesson 2: Visualizing Power Pivot Data

  • Topic A: Create a Power Pivot Report
  • Topic B: Create Calculations in Power Pivot

Lesson 3: Working with Advanced Functionality in Power Pivot

  • Topic A: Create a Key Performance Indicator
  • Topic B: Work with Dates and Time in Power Pivot