Students will make use of the PowerPivot add-in to import data from various sources and create a dynamic report. You learn how to manipulate data in a PowerPivot, how to create reports, use DAX functions, and how to distribute the results.
Microsoft Excel 2010: PowerPivot
Categories: Guaranteed To Run™, Microsoft
Duration: 1 Day
Share it:
Students will learn how to:
- Gett Started with PowerPivot
- Manipulate PowerPivot Data
- Create PowerPivot Reports
- Use DAX Functions in PowerPivot
- Distribute PowerPivot Data
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.
Getting Started with PowerPivot
- Explore the PowerPivot Application
- Import Data from Various Data Sources
- Refresh Data from a Data Source
- Create Linked Tables
Manipulating PowerPivot Data
- Organize and Format Tables
- Create Calculated Columns
- Sort and Filter PowerPivot Data
- Create and Manage Table Relationships
Creating PowerPivot Reports
- Create a PivotTable
- Create PivotCharts
- Filter Data Using Slicers
- Present PivotTable Data Visually
Using DAX Functions in PowerPivot
- Manipulate PowerPivot Data Using DAX Functions
- Extract Data from Tables Using Functions
- Work with Time Dependent Data
Distributing PowerPivot Data
- Protect Reports
- Save Reports in Different File Formats
- Guaranteed to Run™. This ensures you will attend the instructor led class or live online class you want as scheduled without any disruptive cancellations*. You book the training you need, get back to focusing on your job and are sure your training requirements will be met saving time, money and ensuring peace of mind.
- This schedule icon the schedule indicates that this date/time will be conducted as Instructor Led Training (ILT) or a Virtual Instructor Led Training (VILT) depending on the indicated class availablity.