Название: 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.
Power Pivot and Power BI, 2nd Edition Название: Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 2nd Edition Автор: Rob...
Excel Power Pivot & Power Query For Dummies Название: Excel Power Pivot & Power Query For Dummies Автор: Michael Alexander Издательство: For Dummies Год: 2016 Формат: PDF, EPUB Размер: 20...
Информация
Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.
Навигация
Вход на сайт
Реклама
Excel: Power Query for Advanced 
Название: Excel: Power Query for Advanced
