Microsoft Office

Power Query and Power Pivot course

Teacher: Sergio Bazo - Consultant and Instructor - Lernen Capacitaciones

  • Intermediate
  • 35944 students
  • 4.7
Start the course!

Co-certifies:

Online course description

This course is about Power Query and Power Pivot, add-in tools to Excel that will allow you to gather and edit several sources of information to create a single report.

What will I learn?

You will learn how to create reports using pivot tables from a combination of different sources, with files in several different formats: Excel tables, Access databases, CSV text files, etc.

Who is it aimed at?

Students, people doing administrative work, professionals and entrepreneurs.

Professionals, technicians and people in general who need to work with large amounts of information and create reports.

Requirements

Students should have knowledge of Excel at an intermediate level.

Power Query and Power Pivot Course Contents

  • Module 1Introductionto Power Query

    3 Capsules 00:11:28

    • Capsule 1: What is Power Query and what is it for?
      Free View
    • Capsule 2: Downloading, installing and accessing Power Query in old and current versions of Excel
      Premium Access
    • Capsule 3: Power Query Screen Structure
      Premium Access
  • Module 2Processingdata from CSV files

    5 Capsules 00:42:10

    • Capsule 1: Creating a query from a correctly structured CSV file
      Premium Access
    • Capsule 2: Creating a query from a poorly structured CSV file
      Premium Access
    • Capsule 3: Adding queries to an existing query
      Premium Access
    • Capsule 4: Creating a new query from existing queries
      Premium Access
    • Capsule 5: Loading CSV files from one or more folders
      Premium Access
  • Module 3ProcessingExcel Cell Ranges and Tables

    8 Capsules 00:56:44

    • Capsule 1: Processing several ranges of the same sheet
      Premium Access
    • Capsule 2: Processing the Excel tables of the current document
      Premium Access
    • Capsule 3: Processing data from an external Excel workbook sheet
      Premium Access
    • Capsule 4: Processing data from multiple sheets of an external Excel workbook
      Premium Access
    • Capsule 5: Processing multiple tables from an external Excel file
      Premium Access
    • Capsule 6: Processing Excel files from one or more folders
      Premium Access
    • Capsule 7: Dynamization of columns in poorly structured tables
      Premium Access
    • Capsule 8: Processing Excel tables with merged cells
      Premium Access
  • Module 4Creatingand modifying columns in Power Query

    5 Capsules 00:42:57

    • Capsule 1: Text extraction and column merging
      Premium Access
    • Capsule 2: Creating columns using M code
      Premium Access
    • Capsule 3: Creating conditional columns
      Premium Access
    • Capsule 4: Use of OR and AND operators
      Premium Access
    • Capsule 5: Using folder or file names in the query
      Premium Access
  • Module 5Introductionto Data Modeling and Power Pivot

    4 Capsules 00:24:01

    • Capsule 1: What is a data model?
      Premium Access
    • Capsule 2: Downloading, installing and activating Power Pivot in previous and current versions of Excel
      Premium Access
    • Capsule 3: Creating a first data model in Power Pivot
      Premium Access
    • Capsule 4: How to relate tables of a data model
      Premium Access
  • Module 6Creationof Data Models

    3 Capsules 00:22:17

    • Capsule 1: Creating a data model using a CSV file as source
      Premium Access
    • Capsule 2: Creating a data model using external Excel files as a source
      Premium Access
    • Capsule 3: Creating a data model combining several file formats as a source
      Premium Access

Final examTo obtain your course pass certificate, you will have 2 attempts per day to pass a multiple-choice exam with more than 70%.

About our expert

Sergio Bazo professor of Power Query and Power Pivot course

Sergio Bazo

Consultant and Instructor - Lernen Capacitaciones

Sergio Bazo is a Microsoft-certified teacher with more than 25 years of experience. He has worked in leading educational institutions in Lima, such as the Peruvian Scientific Network and the Ricardo Palma, ISIL and CIBERTEC institutes. Currently, he offers Computer Science courses through the Netzun platform and Artificial Intelligence courses for companies live on Zoom. In addition, his YouTube channel has almost 250,000 followers.

Get certified and boost your career

On behalf of Saint Ignatius University
Optional certificate template for our course*San Ignacio University will certify all NETZUN students.

About the institutions

Netzun - online courses
Edtech company, founded in 2015 and specialized in virtual education based on the 'microlearning' methodology. Its purpose is to democratize the knowledge of extraordinary people throughout Latin America.
San Ignacio University certifies our courses
San Ignacio University is a U.S. university that stands out for offering a unique and cutting-edge academic experience. It has a highly qualified faculty committed to academic excellence and the integral development of its students.

Develop your skills with us

Benefits

Full access to course videos

Downloadable materials

Forum with other students

Certificate of Completion

- 81%

BUY COURSE

US$ 2.90Previously US$ 15.00

OFFER EXPIRES ON:

0 :

Dias

00 :

Hrs

00 :

Mins

00

Segs
Add coupon

Forever

Develop your skills with us

- 81%

BUY COURSE

US$ 2.90 Previously US$ 15.00

OFFER EXPIRES ON:

0 :

Dias

00 :

Hrs

00 :

Mins

00

Segs
Add coupon

BENEFITS

  • Full access to course videos
  • Downloadable materials
  • Forum with other students
  • Certificate of Completion
  • Forever
Online education for your professional growth
Short courses applying the micro-learning methodology
Short classes (micro-learning)
Learn with concise courses lasting an average of 2 hours, subdivided into videos of up to 10 minutes.
  • Concise information on specific skills
  • Easier to learn and super practical
Lifetime access to our courses
Lifetime access
If you purchase a course or specialization, you will have lifetime access to the recorded content.
  • Access your classes anytime, without schedules
  • Access your classes as many times as you want
Certified specializations with learning projects
PREMIUM
Project-Based Learning
All courses and specializations will have a final project so you can put your new skills into practice
  • Put your new skills into practice
  • You will have feedback from mentors
  • Create a portfolio of projects, improve your resume.
Certified courses
Get certified upon approval
your courses
Upon completion of a course, you will need to pass an exam, and we will issue you a digital certificate that validates your skills.
  • Certificate with a unique code
  • Improve your resume
  • Boost your professional career