We move! Starting September 1st, our QUEBEC CITY training center will be located at 5400, des Galeries Blvd, Suite 500, 5th Floor, Québec (Quebec) G2K 2B4
CH205

MS Excel: Power Query, Power Pivot and 3D Map

See the training dates
  • Duration 1 day
  • Regular fee 350
  • Preferential fee 300?
  • Locations
    • Quebec City
    • Montreal
  • Laboratory
    course

Accreditation and partners association

  • Project Management Institute 6 PDU

Objectives

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

Targeted audience

Any audience.

Prerequisite

Basic knowledge of Excel.

Training Details

Content

  • Power Query: importing data, modifying and transforming data via the request editor, request duplication and merge, combine tables and data pivoting, introduction to language M
  • Power Pivot: connecting to data sources, data modeling, dynamic cross tables and graphs, creating new calculated fields and PowerPivot formulas, using segments and chronology
  • 3D Map: creating a geospatial map, customizing a guided tour, using layers, recording an animated video of the map

Select the training date*

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

    October 10 2019

  • Montreal

    November 26 2019

  • Montreal

    March 24 2020

  • Quebec City

    April 15 2020

Trainer(s) assigned(s)

Other course(s) in this category