EXCEL POWER QUERY – ONE DAY WORKSHOP

Prerequisites

To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Intermediate Level.

Goal

Get data where ever it exists, clean it and transform it, combine it and analyze it all together.

Excel Power Query Topics

  1. What is Power Query?
  2. DataSources
  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.
  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
Share This Post
Have your say!
0 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>