Excel 2010: PowerPivot Basics

Excel 2010: PowerPivot Basics

 Learning Outcomes:

  • Create linked tables with 100% accuracy.
  • Successfully sort and filter PowerPivot data using the information in the Lesson Lab.
  • On your own, correctly create a pivot table and present the PivotTable data visually to the satisfaction of the instructor.
  • Use the Data Analysis Expression (DAX) tool, demonstrating proficiency in extracting data from tables using DAX functions.

 

This course is excellent for the business user, analysts, research scientists, CPA’s, IT or Government data analysts needing to crunch massive amounts of data in seconds. Generate rich and interactive analysis with this breakthrough self-service Business Intelligence tool.

  • Getting Started
  • Manipulating PowerPivot Data
  • Creating PowerPivot Reports
  • Using DAX Functions
  • Distributing PowerPivot Data


Excel 2010: PowerPivot Basics

Explore the PowerPivot application. Import Data from Various Data Sources. Refresh data from a data source and create linked tables. Organize and format tables. Create calculated columns. Sort and filter PowerPivot data. Create and manage table relationships. Create a PivotTable and PivotCharts. Filter data using slicers. Present PivotTable data visually. Manipulate PowerPivot data using DAX functions. Extract data from tables using functions. Work with time dependent data. Protect reports and save reports in different file formats. 

 Class targeted to: This course is for students with a sound working knowledge of Microsoft Excel 2010 and general computing proficiency,including those who will be using Excel to make business decisions.

Prerequisites: Good working knowledge of Excel 2010 or previous training in Excel.

Click here for Registration Form


Request More Information