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
|Course||Date & Time||Location||Cost|
|Excel 2016/2013 Data Analysis with Power Pivot||September 20 - 1:00- 4:30||Latham||Register|
|Excel 2016/2013 Data Analysis with Power Pivot||October 5 - 1:00- 4:30||Latham||Register|
|Excel 2016/2013 Data Analysis with Power Pivot||November 16 - 8:30 - 12:00||Albany||Register|
Corporate and NYS discounts do not apply for this course.
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.
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