Excel - Discover Power Query and Dynamically Connect Data

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

Upcoming sessions

Show all sessions
  • Duration: 0.5 days
  • Regular price: $285
  • Preferential price: $255

Course outline

Schedule : 3,5 h

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.

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

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.
Khalil Ben Fadhel
Khalil Ben Fadhel
Trainer, Data Science - AI
Khalil is an artificial intelligence expert working at Leap Conseil. Thanks to its extensive expertise in the managing and conducting artificial intelligence projects, Khalil has co-worked with several public and private sector organizations to carry out innovative projects.
Fazil Chouakri
Fazil Chouakri
VP Technology, Coach and Trainer
Fazil is a coach and trainer with solid experience in the field, which allows him to combine the practical and the theoretical to meet his students’ needs.
Philippe Paradis
Philippe Paradis
Certified Trainer and IT Consultant
Obsessed with the quality of services he provides and the solutions he develops, Philippe always makes sure he delivers more than what people expect, all while ensuring a pleasant learning experience.
Be aware of trends, innovations and best practices, every month.
Confidentiality
Training center accredited by Emploi-Québec, Accreditation : 0051460
GST : 141582528 – QST : 1019557738
© 2022 AFI
AFI Expertise

The AFI experience brought to you by Edgenda

At AFI, our focus is to offer you relevant training and impactful learning experiences in line with your transformation approach. Do you need support for your approach? Check out Edgenda’s services: Edgenda.com