Microsoft Excel Power Pivot Basic training 1 day Level 1

Activate/Install Power Pivot in Microsoft Excel

• Access Power Pivot in Microsoft Excel
• PowerPivot Scherm Screen Layout

Differences between Power Pivot data model and Microsoft Excel Power Pivot

• Advantages of Microsoft Excel tables
• The data model tables
• Benefits of the data model tables
• Tables in Excel and the traditional use of cells
• XLS. and XLSX. Create tables in Microsoft Excel
• Make calculations with Microsoft Excel tables

Import data Microsoft Excel Power Pivot

• Import Microsoft Excel table
• Link Microsoft Excel table
• Import data from Power Query
• Restore or break connections
• csv. link files and text files
• Linking data from other sources, such as Microsoft Access or SQL

 Editing Imported Data with Microsoft Excel Power Pivor

• choose whether or not to import, hide or delete columns.
• Filtering and sorting data
• Change column names and order

Multiple tables with Microsoft Excel Power Pivot

• The foreign key versus the primary key
• Create relationships between tables
• Advantages of multiple tables vs. the VLOOKUP() function in Microsoft Excel
• Dimension tables and fact tables
• Creating a Hierarchy

Create pivot tables with Microsoft Excel Power Pivot

• Create pivot tables using the data model
• Using implicit calculations
• Creating a pivot chart
• Create slicers and connect them to charts and pivot tables
• Pivor Table Timeline
• Using Conditional Formatting in PivotTables

Create Calculated Columns in Microsoft Excel Power Pivot

• Calculated columns using functions
• Calculated columns with operators (arithmetic) and their advantages and disadvantages
• Using the Related() and Relatedtable() functions.

 Create Explicit Calculations and Measures Microsoft Excel Power Pivot

• Measurements and difference with implicit calculations
• The DAX functions
• Distinctcount() / Max() / Min() / IF COUNT() / SUM()
• Calculated columns versus the measurements

Create a KPI Microsoft Excel Power Pivot

• Present and evaluate a measurement by compiling KPI

 Introduction DAX Features Microsoft Excel PowerPivot

• DAX functions: calculate() / All() / Sumx() / countx()

If you do not yet master the basic knowledge, it is better to Microsoft Excel Basic training 1 day Follow.

Other equivalent workouts we recommend are the Microsoft Excel Power Pivot Advanced – DAX (1 day) Level 2 of Microsoft Excel Power Query training (1 Day) workouts.

For more related training, please visit the Microsoft look at overview page, examples are the Microsoft Access Basic training 2 days Level 1, Microsoft Office Powerpoint Basic training 1 day Level 1, Microsoft Word Basic training 1 day level 1 & Basic VBA Excel training (2 days).