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
Combine Tables in File
In this lesson, you will learn how to combine multiple tables into one using Power Query in Excel. You will also learn how to Load Tables into Power Query
Download the data file below to work along with me.
Company
Course Categories
Copyright © 2024. Tabs & Icons Consulting Limited. All rights reserved. Site by TLC CREW