Excel 2019 Bible

Chapter 38: Introducing Power Query 38 When you’ve finished configuring your Power Query feed, save and output the results. To ...

Part V: Understanding Power Pivot and Power Query Take a moment to appreciate what Power Query allowed you to do just now. With ...

Chapter 38: Introducing Power Query 38 When you click a query step, the data shown in the preview pane is a preview of what the ...

Part V: Understanding Power Pivot and Power Query Viewing the Advanced Query Editor Power Query gives you the option of viewing ...

Chapter 38: Introducing Power Query 38 Managing existing queries As you add various queries to a workbook, you will need a way t ...

Part V: Understanding Power Pivot and Power Query Rename Rename the selected query. Refresh Refresh the data in the selected que ...

Chapter 38: Introducing Power Query 38 FIGURE 38.14 Right-click any column to see the column-level actions that you can use to t ...

Part V: Understanding Power Pivot and Power Query Action Purpose Available with Multiple Columns? Remove Errors Remove rows cont ...

Chapter 38: Introducing Power Query 38 Action Purpose Available with Multiple Columns? Split Column (Ribbon only) Split the valu ...

Part V: Understanding Power Pivot and Power Query TABLE 38.2 Table-Level Actions Action Purpose Copy Entire Table Copy the data ...

Chapter 38: Introducing Power Query 38 Action Purpose Merge Queries Create a new query that merges the current table with anothe ...

Part V: Understanding Power Pivot and Power Query FIGURE 38.16 Power Query has the ability to connect to a wide array of text, d ...

Chapter 38: Introducing Power Query 38 Once you’ve selected your file, the Navigator pane will activate, showing you all of the ...

Part V: Understanding Power Pivot and Power Query To import a text or CSV file, go to the Excel Ribbon and select Data ➪ Get Dat ...

Chapter 38: Introducing Power Query 38 Importing data from database systems In larger organizations, the task of data management ...

Part V: Understanding Power Pivot and Power Query FIGURE 38.19 Other systems Power Query can utilize as data sources To get to t ...

Chapter 38: Introducing Power Query 38 For instance, let’s say you connected to a SQL Server database, entered all of your crede ...

Part V: Understanding Power Pivot and Power Query FIGURE 38.21 The credentials edit screen for your selected data source Click t ...

859 C H A P T E R 39 Transforming Data with Power Query IN THIS CHAPTER Performing common transformations Creating your own cust ...

Part V: Understanding Power Pivot and Power Query you produce. It is for this reason that finding and removing duplicate records ...