Microsoft Excel 2013 PowerPivot
€295, aangeboden door Master it Training
Power Pivot is een Excelinvoegtoepassing waarmee je krachtige gegevensanalyses kunt uitvoeren en geavanceerde gegevensmodellen kunt maken. In Power Pivot kun je grote hoeveelheden gegevens uit diverse bronnen verzamelen, snel gegevensanalyses uitvoeren en eenvoudig inzichten delen.In deze eendaagse handson Microsoft Excel 2013 PowerPivot training leer je hoe je PowerPivot kunt gebruiken om data uit verschillende bronnen te importeren en te wijzigen, het maken van PowerPivot rapporten, het gebruik van de DAX functies, het maken van key performance indicators (KPI) en het gebruik van slicers en hiërarchieën om de visualisatie van de data te verbeteren.LET OP! Bij deze training maken wij gebruik van Engelstalig lesmateriaal.Bij afronding van de training: Ben je bekend met de PowerPivot applicatie; Kun je Data modellen maken vanuit verschillende importeerde bronnen; Kun je Data aanpassen in een PowerPivot worksheet; Kun je Rapporten creëren met gebruik van PowerPivot data; Maak je gebruik van DAX functies in PowerPivot; Kun je KPI’s definiëren; Maak je gebruik van slicers om data te visualiseren.Geef je de voorkeur voor onze locatie in Amsterdam dan hoor je 2 weken voor aanvang of de training in Amsterdam of in Utrecht plaats gaat vinden. Dit is afhankelijk van het aantal inschrijvingen.
Let op. Deze training is exclusief het examen.
Doelgroep
De doelgroep van deze training zijn studenten met een flink wat werkervaring op het gebied van Excel 2013 en algemene computerkennis.
Voorkennis voor de Microsoft Excel 2013 PowerPivot training
Goede ervaring in Microsoft Excel 2013 inclusief het maken en gebruiken van formules.
Onderwerpen in de Microsoft Excel 2013 PowerPivot training
Module 1: Introduction to PowerPivot 2013This module explains how to enable PowerPivot in Excel 2013. It also reviews the PowerPivot workspace and gives a brief explanation of the various actions available in the workspace.LessonsLab 1: Enable PowerPivot Enable PowerPivot within Microsoft Excel 2013 After completing this module, students will be able to: Enable PowerPivotModule 2: Building Data ModelsThis module begins with defining a data model and how it is used to create PivotTables and PivotCharts. The Manage Data Model window is discussed in detail in this module. In addition, the various methods for adding data to the model are covered.Lessons Review Data Models Create Data ModelsLab 1: Create a data model Import data from multiple data sources. Use the manage data model tab to maintain the data model. Refresh data used in PivotTables and PivotCharts.After completing this module, students will be able to:Import data from multiple data sources.Use the manage data model tab to maintain the data model.Refresh data used in PivotTables and PivotCharts.Module 3: Create a PivotTable and PivotChartThis module covers the difference between tables and charts and the various options that are available. In addition, this module will walk the user through creating a basic PivotTable and PivotChart. PivotTable Tools and PivotChart Tools contextual tabs are covered in this module. These tabs allow further customization to the basic PivotChart and PivotTable.Lessons Determine chart or table Create a PivotTable Create a PivotChartLab 1: Create a basic PivotTable Insert a PivotTable Add field to values drop zone Add field to columns drop zone Add fields to rows drop zoneLab 2: Use the analyze tab to change your PivotTableLab 3: Use the analyze tab to change your PivotTable Change the name of the PivotTable Change the way amounts display Explore the Show group and its effects on your PivotTableLab 4: Create a basic PivotChart Insert a PivotChart Add field to values drop zone Add field to legend drop zone Add fields to axis drop zoneLab 5: Use the analyze tab to change your PivotChart Change the name of the PivotChart Explore the Show group and its effects on your PivotTableLab 6: Use the design tab to change your PivotChart Apply Chart Layouts Apply Chart Styles Apply Chart TypeLab 7: Use the format tab to change your PivotChart Apply Shape Fill format Apply Shape Effects format Apply WordArt Style formatAfter completing this module, students will be able to: Create and update a PivotTable. Create and update a PivotChart. Use the contextual tabs to customize PivotTables and PivotCharts.Module 4: Use DAX in PowerPivotThis module introduces DAX Data Analysis eXpressions language and its use in creating complex calculations to be used in PivotTables or PivotCharts. DAX operators and formulas are discussed. Calculated columns and calculated fields are defined and used in this module.Lessons Review and define DAX Discuss context used in DAX Define calculated columns Define calculated fieldsLab 1: Create a calculated column with data from the same table Create a calculated column Enter formula Rename the column from the default name Review the effect of the column on the PivotTableLab 2: Create a calculated column with data from a different table Create a calculated column Use Related expression to link data from another table Rename the column from the default name Review the effect of the column on the PivotTableLab 3: Create a calculated field Add calculated field using AutoSum Add calculated field by entering formulaAfter completing this module, students will be able to: Use DAX to create complex calculations. Create and use a calculated column in a PivotTable/PivotChart. Create and use a calculated field in a PivotTable/PivotChart. Understand the various functions that DAX provides.Module 5: Enhance PivotTables and PivotChartsThis module covers using KPIs (Key Performance Indicators), slicers and hierarchies to further enhance your PivotCharts and PivotTables. In addition the slicer tools options contextual tab is covered. This tab allows customization to the display of the slicers.Lessons Define key performance indicators (KPIs) Define slicers Define hierarchiesLab 1: Create a KPI Create a new KPI Create a new PivotTable to use the KPILab 2: Create slicers Create a new slicer Move the slicer Use the slicer to update the PivotTable Review the interaction of two slicers on the PivotTableLab 3: Create hierarchies Create a new hierarchy using two different methods Add the hierarchies to the PivotTable Review the effect of the hierarchies on the PivotTableAfter completing this module, students will be able to: Create and use KPIs in a PivotTable/PivotChart. Create and use slicers in a PivotTable/PivotChart. Create and use hierarchies in a PivotTable/PivotChart.