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

  • Duration 1 day
  • Regular fee 350
  • Preferential fee 295?
  • Locations
    • Montreal
    • Quebec City
  • New course
  • 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



Basic knowledge of Excel.


  • Installing and activating the 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

    April 5 2017

  • Quebec City

    April 10 2017

  • Montreal

    July 10 2017

Trainer(s) assigned(s)

Other course(s) in this category