By the end of this course, you will be able to determine which of the two tools, PivotTables and PowerPivot, is most effective for your analysis needs. In the context of PowerPivot, you will be able to consider teamwork strategies to centralise your data for analysis. Participants in this course should have a good analytical mind and master the calculation and sorting/filtering tool of Microsoft Excel.
IT Training
Excel 2019/365 Power Pivot
Who should attend this course?
Anyone who wants to create a centralized analysis sheet. PowerPivot is a tool that allows you to stay in constant connection with external data files such as XLSX, CSV, TXT, ACCDB…
Prerequisites
Good analytical skills and proficiency in Excel, Pivot Table calculation and sorting/filtering tools.
PowerPivot is a tool that allows you to stay in constant connection with external data files such as XLSX, CSV, TXT, ACCDB…
- Reminder of the Efficient Method for Creating PivotTables
- The power of Power Pivot
- Import data into Power Pivot
- Create your own data model
- Create calculated columns
Revisions of the Efficient Method for Creating PivotTables
- On unique tables
- Multiple tables to connect
- Les Segments
- PivotCharts
The power of Power Pivot
- The advantages of Power Pivot
Import data into Power Pivot
- Prepare your data
- Import from a relational database
- Import from a text or csv file
- Import from an Excel file
- Import from internal data – Excel table
- Update your data
Create your own data model
- Prepare your data model
- Establish a team strategy to promote data centralization and analysis
- Create relationships
- Create a Power PivotTable analysis
Create calculated columns
- Understanding DAX Functions for Establishing Relationships Between Tables
- Create calculated columns
Practical information
Duration
1 Day
Languages
FR / NL
Price
€ 450 + 21% VAT
Location
Classroom Courses
Schedule
Book your training
Enter your information to confirm your booking.