• Open Power Query
• Configure Power Query
• Add Power Pivot
• Modify the Quick Access Toolbar
• Configure Power Query

• Import Data from:
     - CSV File
     - Excel Table, List, Pivoted          Data
     - Folder
     - PDF File
• Type in the Data
• Load the Data to Excel

• Applied Steps
• Deleting Applied Steps
• Adding Applied Steps
• Editing Data using
     - Fill Down
     - Trim
     - Replace Values
• Filters
• Modify the Filter Manually
• Format
• Removing Errors
• Unpivoting Data

• Deleting Columns
• Renaming Columns
• Adding Columns
• Standard and Custom Date Columns
• Renaming Applied Steps
• Create a Conditional Column

• Grouping Queries: Creating Query Groups
• Appending Queries
• View the Loaded Queries
• Rename Queries
• Reloading the Queries
• View the Re-loaded Queries

• Data Model
• Add Tables to a Data Model
• Arrange the Data Model
• Connect the Data Model using Create
• Connect the Data Model using Manage
• Connect the Data Model using Click and Drag
• Pivot Table
• Pivot Table from Excel
• Pivot Table from Power Pivot

• Standard Data Types
• Stock Data Type
• Uploading Stock Data Type
• Displaying Extra Data
• Custom Data Type - Get Data
• Custom Data Type - Transform Department Data

• Load file into OneDrive
• Office Script
• Before You Record a Script
• Start Recording
• Edit the Script
• Rename the Script
• Change the Chart Title
• Script a Dynamic Range

• The Setup 104
• Start Desktop from Online
• Working with Excel
• Launch Excel Action
• Read from Excel Action
• Create new List Action
• Write to Excel Worksheet Action
• Working with the Browser
• Get the Converter Page
• Looping Through Currencies
• Create a For Each Action
• Retrieving the Rates