English | 2022 | ISBN: 978-87-403-4264-2 | 101 pages | EPUB | 7.98 MB

Compatible with Excel 2016 / 2019 / 2021 / 365

Power Query is integrated in Excel and is specialized in importing, transfog 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.