Curriculum
- 1 Section
- 21 Lessons
- 2 Weeks
Expand all sectionsCollapse all sections
- INTRODUCTION TO POWER QUERYWelcome to the "Introduction to Power Query" course! This course is designed for anyone looking to harness the power of Power Query, a robust data transformation and preparation tool integrated within Microsoft Excel and Power BI.22
- 1.1Overview2 Minutes
- 1.2Split Columns8 Minutes
- 1.3Merge Columns7 Minutes
- 1.4Add Columns6 Minutes
- 1.5Data from Web7 Minutes
- 1.6Data from Text File7 Minutes
- 1.7Data from CSV File8 Minutes
- 1.8Export from other Files7 Minutes
- 1.9Combine Tables in File10 Minutes
- 1.10Combine Tables with Formula8 Minutes
- 1.11Merge Tables in Sheet10 Minutes
- 1.12Combine Tables in different files11 Minutes
- 1.13Delete Empty Rows6 Minutes
- 1.14Combine Files in a Folder13 Minutes
- 1.15Dirt Data Cleaning11 Minutes
- 1.16Replace Texts8 Minutes
- 1.17Report Grouping10 Minutes
- 1.18Report Transpose7 Minutes
- 1.19Data Sort6 Minutes
- 1.20Filter4 Minutes
- 1.21Date in PQ9 Minutes
- 1.22INTRODUCTION TO POWER QUERY ASSESSMENT10 Questions
Overview
Welcome to the “Introduction to Power Query” course! This course is designed for anyone looking to harness the power of Power Query, a robust data transformation and preparation tool integrated within Microsoft Excel and Power BI.
Split Columns
Next
Company
Course Categories
Copyright © 2024. Tabs & Icons Consulting Limited. All rights reserved. Site by TLC CREW