Power Query

One Day Workshhop

  1. Power Query and When to Use It
  2. Data Sources
  3. Connect to a web data source
  4. Connect to a spreadsheet
  5. Connect to a database
  6. Add a Wikipedia page data source
  7. Organizing Data
  8. Build repeatable processes to filter, clean, aggregate, and transform your data.
  9. Shape data in the subject table
  10. Remove Other Columns to only display columns of interest
  11. Replace Values to clean up values in a selected column
  12. Filter values in a column
  13. Queries
  14. Name a query
  15. Load the query to a worksheet
  16. Share queries and their data with other users in your organization.
  17. Common Problems Solved