14. Extra Resources → Skills → Power Query

Introduction to Power Query Part 1


Description
This course will introduce you to Excel Power query, a data manipulation tool that is perfect for non-technical users looking to manipulate small datasets. Ideal for excel files and the ability to automate repetitive data manipulation tasks. This module focuses on introductory features such as loading datasets and formatting columns.

Type: Video

Content
  • Introduction to Power Query
  • Loading Datasets
  • Data Types and Column Headers
  • Duplicate and Reference Queries
  • Remove Columns and Rows
  • Format and Duplicate Columns
Completion rules
  • All units must be completed