Excel: Power Query for Beginners
Saskia Gießen
Compatible with Excel 2016 / 2019 / 2021 / 365
A structured introduction to the use of the Power Query Excel add-in to extract, transform and load external data to Microsoft Excel.
Power Query is already integrated in Excel and is specialized in importing, transforming and cleansing all kinds of data.
The toolbox of Power Query is well filled. It offers commands such as Delete, Add, Fill, Sort, Filter, Group, Transpose, Pivot and Delete. After transforming and load data Excel, Pivot and PowerPivot are used to analyse the provided data.
A structured introduction to the use of the Power Query Excel add-in to extract, transform and load external data to Microsoft Excel.
Power Query is already integrated in Excel and is specialized in importing, transforming and cleansing all kinds of data.
The toolbox of Power Query is well filled. It offers commands such as Delete, Add, Fill, Sort, Filter, Group, Transpose, Pivot and Delete. After transforming and load data Excel, Pivot and PowerPivot are used to analyse the provided data.
Kategori:
Tahun:
2022
Penerbit:
Bookboon.com Ltd.
Bahasa:
english
Halaman:
101
ISBN 10:
8740342611
ISBN 13:
9788740342611
File:
EPUB, 6.32 MB
IPFS:
,
english, 2022