Excel 2019/365 Power Pivot
- Durée totale
Excel 2019/365 Power Pivot
Dates et lieux de début
Description
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.
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 cal…
Foire aux questions (FAQ)
Il n'y a pour le moment aucune question fréquente sur ce produit. Si vous avez besoin d'aide ou une question, contactez notre équipe support.
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.
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
Rester à jour sur les nouveaux avi
Partagez vos avis
Avez-vous participé à cours? Partagez votre expérience et aider d'autres personnes à faire le bon choix. Pour vous remercier, nous donnerons 1,00 € à la fondation Stichting Edukans.Il n'y a pour le moment aucune question fréquente sur ce produit. Si vous avez besoin d'aide ou une question, contactez notre équipe support.