Are you already juggling with PivotTables in Excel? Then you will undoubtedly go wild with PowerPivot. In this session you will learn how to effortlessly merge an Excel list with an Access database. Or with a table originating from an SQL server. And not only that, this rock-solid tool has masses of new functions that enable you to analyse table data even better. Need to compile complex business reports? In this demo training session, we will be taking a closer look at how to do this.
After this remote training, you can easily:
- Import lists from a variety of data sources
- Create PivotTables with data from different lists
- Optimise a PowerPivot data model
Anyone already familiar with PivotTables, but who would like to find out about an even more powerful analysing tool.
Basic PivotTables operations (the different sections, change calculations, ...) are not new to you.
1. Installing PowerPivot
- Linking an Excel table
- Creating a fixed table in PowerPivot
- Importing an Excel table
- Importing text files
- Importing data from other data sources (Access, SQL, ODBC…)
- Maintaining connections
- Updating data
3. Working in the PowerPivot window
- What are the differences compared to the Excel datasheet?
- The different data types
- Adding and deleting fields/columns
4. Optimizing the PowerPivot data model
- Defining relationships between tables
- Defining Date Table
- Correctly sorting months, weekdays, ...
- Setting standard calculations
- Hiding columns in Excel/data model
- Creating and using a hierarchy
- Creating and using a perspective
5. PowerPivot PivotTables
- Creating a PowerPivot PivotTable
- Differences compared to an Excel PivotTable
- Filtering a PowerPivot PivotTable using slicers