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
    • Data filtering and selection
    • Creation of dynamic charts
    • Introduction to measures

LIVE TRAININGS TO DEEPEN YOUR KNOWLEDGE:

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 Aug, 2024
31 Dec, 2024
Language of instruction:Catalan
I want to sign up →

Find out more

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

ActivitatsAnnexos