This 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.
This 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.
This 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.
This 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.
This 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.
Locatia de desfasurare a cursului:
Sediul Learning Solution: Str. Transilvaniei nr. 24, Sector 1, Bucuresti
Cine susține cursul?
Familiarity with Microsoft Office applications – particularly Excel
Curs Creare Dashboards Cu PowerPivot Power View Si SharePoint – Curs 55103
Curs 50450 – Curs Excel Creating and Analyzing Database Using Microsoft Excel
Curs 55084 – Curs Excel 2013 Self-Service Analytics with No Code for the End User
Curs Excel 2013 – Advanced Microsoft Excel 2013
Curs Excel 2013 PowerPivot – PowerBI
Curs 50448 Maximizing PivotTable Microsoft Excel
Curs 55143 Microsoft Office Excel Basic Workbooks Formulas and Functions
Curs Microsoft Excel 2016 – Incepator
Curs Microsoft Excel 2016 – Mediu
Curs Microsoft Excel 2016 – Avansat
Curs Microsoft Excel 2013 – Incepator
Curs Microsoft Excel 2013 – Mediu
Curs Microsoft Excel 2013 – Avansat
Curs Microsoft Excel 2010 – Incepator
Curs Microsoft Excel 2010 – Mediu
Curs Microsoft Excel 2010 – Avansat
Curs Microsoft Excel 2007 – Incepator
Curs Microsoft Excel 2007 – Mediu
Curs Microsoft Excel 2007 – Avansat