Discover Power Query and Dynamically Connect Data in Excel

Discover the secrets of Excel queries with this training. Learn how to create and manage tables and connect and filter data.
Microsoft Partner
Private session

This training is available in a private or personalized format. It can be provided in one of our training centres or at your offices. Call one of our consultants of submit a request online.

Call now at 1 877 624.2344

  • Duration: 0.5 days
  • Regular price: On request

Course outline

Schedule : 1PM to 4:30pm

Our scheduled sessions are offered in French. Private sessions are available to you in English, contact us for more info.

Since 2013, Power Query’s Query Manager makes it possible to dynamically connect Excel files to all sorts of data sources. No need to become a business intelligence ninja, data queries are easy to use and will help you save a lot of time.
Specifically designed for people who manage lists of data (inventories, sales results, financial statements, marketing results, and contact, product, task, and activities lists, etc.) from external databases or existing Excel files, this training will reveal the secrets of queries in Excel. The result? You will handle your lists more rapidly and produce more effective analyses.

Audience

Anyone who has completed the “Excel Essentials” training.

Duration

3.5 hours of theoretical presentation and demonstrations.
Versions taught

Excel 2013 | 2016

Objectives


Thanks to this training, you will be able to
  • convert a normal range into a table
  • dynamically connect data sources to Excel;
  • manage tables and filter data.
Contents
Converting a normal range into a table
  • organize data in a table
  • understand the advantages of a table
  • understand the advantages of names
Using Power Query:
  • use a query to obtain data
  • understand different data sources
  • combine queries
  • modify a query
    - manage row and columns
    - delete lines in a query
    - delete redundancies
    - split columns
    - add personalized columns with formulas and conditions
    - filter data in the query
  • merge tables in the query

Surround yourself with the best

Sylvain Richer
Sylvain Richer
Trainer and Desktop Application Consultant
Passionate about knowledge transfer and unparalleled in his ability to make complex information easy to understand, Sylvain is a professional efficiency trainer whose expertise is requested again and again.
Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.
Valère Drainville
Valère Drainville
Trainer adn Expert Leader on Office 365 collaboration and efficiency
As the Expert Leader on Office 365 collaboration and efficiency, Valère Drainville specializes in helping you successfully implement and adopt Microsoft tools.
Marc Maisonneuve
Marc Maisonneuve
Trainer and Professional Efficiency Consultant