Название: Excel: Power Query for Advanced
Автор: Saskia Giessen
Издательство: bookboon.com
Год: 2022
Страниц: 101
Язык: английский
Формат: epub
Размер: 10.1 MB

This manual was written to accompany our seminar on Microsoft Power Query. Its target audience is users who need to import external data into Excel or transform data into Excel before further processing. The exercises in the book are easy to understand and can be adapted with little effort to your own needs. Power Query has very comprehensive feature set which is also easy to use. The software can do a great deal of work for you without requiring any programming skills. The output of Power Query is a list that you can then use for further analysis in Excel or in the data model of PowerPivot.

Power Query is integrated in Excel and is specialized in importing, transforming and cleansing all kinds of data. It offers you many other useful commands for data transformation. The chapter Many useful tools in Power Query teaches you how to detect and remove duplicates. You will find more than 400 functions in Power Query. Some of them are discussed in this manual. You will also learn about the better and faster alternative to the VLOOKUP() function.

Compatible with Excel 2016 / 2019 / 2021 / 365