PowerPivot for End Users (50433)
Cours disponible en français ou en anglais - Training available in French or in English
Duration: 2 Days
Objectives :
This 2-day Instructor Led course How to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. You will also explore how PowerPivot workbooks can be integrated with SharePoint
Course details:
In this training, students will learn how to use :
Duration: 2 Days
Objectives :
This 2-day Instructor Led course How to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. You will also explore how PowerPivot workbooks can be integrated with SharePoint
Course details:
In this training, students will learn how to use :
- Install PowerPivot for Excel
- Be able to navigate the PowerPivot windows
- Understand the new features of Excel
- Import various data sources into PowerPivot
- Understand how to clean imported data
- Be able to describe all the new PowerPivot Expressions
- Use and apply many of the PowerPivot Expressions
- Describe the different Report types in PowerPivot
- Be able to create Slicers and Sparklines for more engaging reports
- Describe the integration points between PowerPivot and SharePoint
- Be able to publish and setup workbook data refresh in SharePoint
Prerequisites : Participants must have basic knowledge of Microsoft Windows environment and Excel