185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Microsoft Excel 2016: PowerPivot
Microsoft Excel 2016: PowerPivot

Course Code: 6I | Hours: 8

Our public class schedule has upgraded. Please contact us at (212) 684-5151 or Info@CareerCenters.com to inquire about private tutoring or corporate classes. To view the offerings for current versions, see the links below.

Microsoft Excel PowerPivot 2016 Training Class Overview

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Upon successful completion of this course, students will be able to:

  • Get started with PowerPivot
  • Visualize Power Pivot data
  • Work with advanced functionality in PowerPivot

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Related Classes:

See Also:

Microsoft Excel PowerPivot 2016 Training Course Outline:

Lesson 1: Getting Started with Power Pivot

• Topic 1A: Enable and Navigate PowerPivot
• Topic 1B: Manage Data Relationships

Lesson 2: Visualizing Power Pivot Data

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

Lesson 3: Working with Advanced Functionality in PowerPivot

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

Appendix A: Commonly Used DAX Functions