Breadcrumb

ActivitatsDetall

Excel: Power Pivot

Description
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.
Content

OBJECTIVES

  • Build complex data models
  • Perform advanced calculations
  • Establish relationships between tables
  • Create custom measures

SYLLABUS

  1. Introduction to Power Pivot and Basic Concepts
    • Introduction to Power Pivot
    • Connections to different data sources
    • Data model
    • Data refresh
  2. 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
Teachers
FERRER MARTÍNEZ, ENRIC
Driving
Docent Barcelona Activa

Calendar

Days and times
Venue
Language of instruction
Registration
Online
1 Jan, 2025
31 Mar, 2025
Language of instruction:Catalan
Opening of registration 31/12/2024 to 23:59 h.

Find out more

Learn at your own pace
Online training is self-training, quarterly and you can register at any time.
Enjoy learning from wherever you want, at your own pace and without schedules.

Access
The activities are available at the Virtual Campus of Barcelona Activa 

Certificate
To obtain the certificate of completion, the final questionnaire of the course must be completed. Once passed, you can download it in the Personal Area 

ActivitatsAnnexos