Course Description
Do you struggle with formatting data from a variety of sources and file types? Do you struggle with building complex Excel formulas for simple data restructuring and transformation? Gain the foundational understanding of Excel Power Query to solve your data restructuring and transformation needs. Use built-in Power Query automation to clean, organize, validate, import, export, and report on data from internal and external data sources to optimize spreadsheet functionality without requiring complex Macros. See Course Outline.
Required Prerequisite
Excel - Level 2 or equivalent experience.
It is the responsibility of the student to ensure that prerequisites are met. For more information, contact us at 403-777-7550 or email us at chinookconted@cbe.ab.ca.
Textbooks & Materials
All required learning resources and course materials are included in the fee.