Technical requirements
Before working through this topic, you should have a solid understanding of the use of Power Query, be proficient at locating and launching Power Query through the Excel 2019 environment and saving a presentation, have a good knowledge of file management (files, folders, and file types), be familiar with the different ribbon options within Excel 2019, be able to navigate with ease around the environment, and be skilled at inserting and formatting graphic elements. It is also preferred for you do have a little database knowledge as some introductory terminology is used throughout this chapter.
The examples used in this chapter can be accessed from https://github.com/PacktPublishing/Learn-Power-Query/.
For Code in Action video of this chapter please visit the following link: https://www.youtube.com/watch?v=yXC8-jqgqXY&list=PLeLcvrwLe186O_GJEZs47WaZXwZjwTN83&index=4&t=1s.