Excel: Power Pivot
Excel: Power Pivot
With this course, you will take another step in your data processing training. Power Pivot is a powerful and essential tool to work with external data sources or large amounts of data.
Specific goals | Temary
OBJECTIVES
- Build complex data models
- Perform advanced calculations
- Establish relationships between tables
- Create custom measures
SYLLABUS
- Introduction to Power Pivot and Basic Concepts
- Introduction to Power Pivot
- Connections to different data sources
- Data model
- Data refresh
- Data Exploration and Visualization with Power Pivot
- Pivot tables with more than one data source
- Filtering and data selection
- Creation of dynamic charts
- Introduction to measures
EXCEL POWER PIVOT LEARNING PATH
Level 0
Excel: Power Pivot - Online
Level 1
Excel: Create data models with Power Pivot
Editions
General information
>> Online activities are asynchronous. You can enroll at any time.
>> During the enrollment period, you can find the activity in your Personal Space or by directly accessing it through the virtual campus link.
>> You will receive a certificate of completion once you complete at least one of the training modules. You can download it in your personal space.
Course ratings
Lesson taught by
FERRER MARTÍNEZ
Related courses
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.