SLV Expert

A course by Stéphanie Perreault, CPA

Excel - Power Query and Power Pivot level 1

Controllers and analystsConsulting EngineeringInformation technology (IT)

Technologies

Microsoft Excel

Discover how to build powerful data solutions with Power Query and Power Pivot.

Discovering Excel Power Query

Overview:

Power Query enhances Excel's capabilities, allowing users to connect to a wide range of data sources, transform and consolidate data to suit specific needs, combine datasets, and create dynamic, efficient reports.

Objectives:

  • Import data from multiple sources
  • Transform data to meet specific requirements
  • Consolidate business data effectively
  • Master the Power Query editor for advanced data management

Curriculum

$480
Lessons

42

Difficulty

Beginner

Modules:9
Language:English
Duration:8h
Format:Online
Certificate:Upon completion of the course
Prerequisites:None — open to all levels

Last updated : May 7, 2025

Book for your team