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.
About the Author
I had my first contact with a computer in 1980 and I was immediately fascinated. This enthusiasm has never left me. In 1988 I wrote my first book on Framework II. Today, I have published over 140 books on many Microsoft Office topics in over 30 years. I have been teaching IT training on Office applications since 1989. In all these years I have taught thousands of users how to use computers. I know exactly where the shoe pinches and can communicate it verbally and in writing. I have been certified by Microsoft as a Microsoft Office Specialist Master.