Breadcrumb

ActivitatsDetall

Online course - 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 May, 2024
31 May, 2024
Language of instruction:Catalan
I want to sign up →
Online
1 Jun, 2024
30 Jun, 2024
Language of instruction:Catalan
Opening of registration 31/05/2024 to 23:59 h.

Find out more

Enrolment
>> This online activity is available between the first and last day of each month.
>> Registration is possible even if it has already been started.
>> To enroll in any online activity you need to have a web user created. You can create it here.
>> Once enrolled you will find the course in your Personal Space --> Activities --> Activities in progress (barcelonactiva.cat)
>> You can access the materials of the activity while editing is active.
>> This online course is self-training.
>> To view the videos subtitled, click on the CC button you will find in the video playbar and select language.

Certificate
>> You will get a certificate of accomplishment when completing all modules and overcoming the activities/test, of the formation before the end of the editing in which the enrolment was made.
>> Course completion status. Within the same course you will find the Results menu point, you will find the Export option (top right). Clicking will open a document showing a report with the status of each lesson. If there are any lessons that are not approved, the contents need to be re-examined as there is some part left undisplayed/made.
>> Once the training is completed, within 24 to 48 hours you will be able to download the certificate to your Personal Space --> Activities --> Activities performed (barcelonactiva.cat)

Recommendations
>> It is recommended to perform training from a computer and not from mobile or tablets.
>> The most used browsers are: Google Chrome, Safari (for iOS operating systems), Microsoft Edge (for Windows operating systems) and Mozilla Firefox.

ActivitatsAnnexos