MS Excel: Power Query, Power Pivot, Power View and Power Map

  • Duration 1 day
  • Regular fee 350
  • Preferential fee 300?
  • Locations
    • Montreal
  • Laboratory

Accreditation and partners association

  • Project Management Institute 6 PDU


To provide the knowledge and skills required to make efficient use of the Power Query, Power Pivot, Power View and Power Map features in Excel.

Targeted audience

Any audience.


Basic knowledge of Excel.


  • Installing and activating features
  • Power Query: importing data, modifying and transforming data via the request editor, request duplication and merge
  • Power Pivot: connecting to data sources, data modeling, dynamic cross tables and graphs, creating new calculated fields and PowerPivot formulas, using segments and chronology
  • Power Map: creating a geospatial map, customizing a guided tour, using layers, recording an animated video of the map
  • Power View: creating visual reports with text and graphics, presenting data, formatting, filtering and updating data


*Unless stated otherwise, all sessions are in French.
  • Montreal

    September 19 2019

Trainer(s) assigned(s)

Other course(s) in this category