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.
3.5 hours of theoretical presentation and demonstrations.
Excel 2013 | 2016
Thanks to this training, you will be able to
Converting a normal range into a table
Using Power Query: