https://training-course-material.com/index.php?action=history&feed=atom&title=Power_Query_%E2%80%93_Basic 2026-04-23T16:55:49Z Revision history for this page on the wiki MediaWiki 1.45.1 https://training-course-material.com/index.php?title=Power_Query_%E2%80%93_Basic&diff=88868&oldid=prev 2025-06-18T17:48:09Z

<p><span class="autocomment">Course Modules</span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en-GB"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:48, 18 June 2025</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l13">Line 13:</td> <td colspan="2" class="diff-lineno">Line 13:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Course Modules ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Course Modules ==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Introduction|Module 1: Introduction to Power Query]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Introduction|Module 1: Introduction to Power Query]]</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Importing Data|Module 2: Importing and Managing Data]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Importing <ins style="font-weight: bold; text-decoration: none;">and Managing </ins>Data|Module 2: Importing and Managing Data]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Data Transformation|Module 3: Data Transformation Techniques]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Data Transformation|Module 3: Data Transformation Techniques]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Automation and Parameters|Module 4: Automation and Parameters]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Automation and Parameters|Module 4: Automation and Parameters]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Power Pivot Overview|Module 5: Power Pivot Overview]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Power Pivot Overview|Module 5: Power Pivot Overview]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Summary and Exercises|Module 6: Summary and Final Exercises]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Power Query – Summary and Exercises|Module 6: Summary and Final Exercises]]</div></td></tr> </table>

Gpruszczynski1 https://training-course-material.com/index.php?title=Power_Query_%E2%80%93_Basic&diff=88860&oldid=prev 2025-06-18T17:01:13Z

<p>Created page with &quot;{{Cat|Power Query|001}} = Power Query – Basic Level = This beginner-level course introduces Power Query, a powerful data transformation and automation tool available in Microsoft Excel. It is designed for analysts and Excel users who want to streamline data preparation tasks without using complex formulas or macros. == Learning Objectives == By the end of this course, participants will be able to: * Import and combine data from various sources * Perform essential dat...&quot;</p> <p><b>New page</b></p><div>{{Cat|Power Query|001}}<br /> = Power Query – Basic Level =<br /> <br /> This beginner-level course introduces Power Query, a powerful data transformation and automation tool available in Microsoft Excel. It is designed for analysts and Excel users who want to streamline data preparation tasks without using complex formulas or macros.<br /> <br /> == Learning Objectives ==<br /> By the end of this course, participants will be able to:<br /> * Import and combine data from various sources<br /> * Perform essential data cleaning and transformation<br /> * Automate repetitive steps using queries and parameters<br /> * Create a basic data model using Power Pivot<br /> <br /> == Course Modules ==<br /> * [[Power Query – Introduction|Module 1: Introduction to Power Query]]<br /> * [[Power Query – Importing Data|Module 2: Importing and Managing Data]]<br /> * [[Power Query – Data Transformation|Module 3: Data Transformation Techniques]]<br /> * [[Power Query – Automation and Parameters|Module 4: Automation and Parameters]]<br /> * [[Power Query – Power Pivot Overview|Module 5: Power Pivot Overview]]<br /> * [[Power Query – Summary and Exercises|Module 6: Summary and Final Exercises]]</div>

Gpruszczynski1