Power Pivot is a powerful data mashup and data exploration tool based on xVelocity in-memory technologies providing unmatched analytical performance to process billions of rows at the speed of thought.
Conteúdo em destaque:
- Creating and Pivoting PivotTables
- Creating a Recommended PivotTable
- Summarizing PivotTable Data
- Creating a calculated field
- Sorting and Filtering PivotTable Data
- Filtering a PivotTable using a search filter
- Formatting PivotTables
- Applying a PivotTable style
- Applying Conditional Formats to PivotTables
- Formatting cells using icon sets
- Creating and Manipulating PivotCharts
- Pivoting a PivotChart
- Printing PivotTables
- Manipulating PivotTables Using Macros
- Starting with PowerPivot and the Data Model
- Creating a PowerPivot PivotTable
- Introducing Data Analysis Expressions (DAX)
- Visualizing Power View Data Using Matrices, Cards, and Tiles
- Visualizing Power View Data Using Charts and Maps
- Creating a map
REQUISITOS:
General Excel and Report building skills
DESTINATÁRIOS
Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.
OUTRAS INFOS
After completing this course, students will be able to:
- Creating a PivotTable
- Summarizing multiple data fields
- Managing subtotals and grand totals
- Grouping PivotTable fields
- Filtering with selections, rules, slicers, and search filters
- Applying PivotTable styles
- Formatting cells
- Creating PivotCharts
- Enabling PowerPivot
- Using DAX operators
- Visualizing data with matrices, cards, and tiles
- Building charts and maps.
Duração: 14 horas
Local: Lisboa
Date: 09 a 10/abr das 09h30 às 17h30
Preço: 380€ + IVA
Para mais informações, poderá consultar mais detalhes sobre o curso em
http://www.actualtraining.pt/P.aspx?T=2&id=MAE109
ou contactar-nos via formacao@actualtraining.pt
Actual Training 