Course Overview
- Course Title: Power Pivot in Excel: Erstelle leistungsstarke Datenmodelle
- Instructor: Sebastian Glöckner
- Target Audience:
- Excel users with basic knowledge
- Beginners looking to learn Power Pivot
- Users with experience in creating simple pivot tables
- Prerequisites:
- Basic knowledge of Excel functions such as cell formatting, simple calculations, and working with tables
- Power Pivot is available in specific Excel versions and does not work on Mac
Curriculum Highlights
- Key Topics Covered:
- Setting up and activating Power Pivot in Excel
- Importing data from various sources into Power Pivot
- Creating dynamic pivot tables
- Logically linking tables within the data model
- Using slicers to enhance report interactivity
- Working with calculated columns and simple DAX functions
- Creating implicit and explicit measures
- Key Skills Learned:
- Managing and analyzing large datasets in Excel
- Integrating multiple data sources into a single model
- Creating dynamic and interactive reports
- Performing complex calculations and analyses
- Automating data updates
- Improving report performance
Course Format
- Duration: 3.5 hours on-demand video
- Format: Self-paced online course
- Resources:
- 1 article
- 20 downloadable resources
- Access on mobile and TV
- Certificate of completion