Course Outline

 

Learning Method: Instructor-led Classroom Learning         Duration: 1.0 Day

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 PowerPivot to help you organize, manipulate, and report on your data in the best way possible. PowerPivot add-in allows you to import data from various sources and create dynamic reports.

Who Should Attend: 

This course is for Power Users of Microsoft Excel who are seeking to advance their data analysis capabilities by using PowerPivot, including those who will be using Excel to make business decisions. It is recommended that these individuals have already taken Excel Level 1, Level 2, Level 3, and Excel PivotTables or have equivalent knowledge. 


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

  • Become familiar with the PowerPivot application and import data
  • Manipulate data in a PowerPivot worksheet
  • Create reports using PowerPivot data
  • Use DAX functions in PowerPivot
  • Distribute PowerPivot Data

Course Outline: 

Lesson 1: Getting Started with PowerPivot
  • Explore the PowerPivot Application
  • Import Data from Various Data Sources
  • Refresh Data from a Data Source
  • Create Linked Tables

Lesson 2: Manipulating PowerPivot Data

  • Organize and Format Tables
  • Create Calculated Columns
  • Sort and Filter PowerPivot Data
  • Create and Manage Table Relationships

Lesson 3: Creating PowerPivot Reports

  • Create a PivotTable
  • Create PivotCharts
  • Filter Data Using Slicers
  • Present PivotTable Data Visually

Lesson 4: Using DAX Functions in PowerPivot

  • Manipulate PowerPivot Data Using DAX Functions
  • Extract Data from Tables Using Functions
  • Work with Time Dependent Data

Lesson 5: Distributing PowerPivot Data

  • Protect Reports
  • Save Reports in Different File Formats

Contact/ Locate Us   Request Information     Enrollment Policies    Why Alliance?    Our Campus