INTRODUCTION TO POWER QUERY
In this course, you will learn how to efficiently import, clean, and reshape data from various sources, including Excel files, databases, and web data. We will cover essential features such as merging, appending, and filtering data. By the end of …
Overview
In this course, you will learn how to efficiently import, clean, and reshape data from various sources, including Excel files, databases, and web data. We will cover essential features such as merging, appending, and filtering data.
By the end of this course, you’ll have the skills to streamline your data workflows, ensuring that your data is accurate, well-structured, and ready for analysis. Whether you’re a beginner or looking to enhance your existing skills, this course equips you with practical knowledge and hands-on exercises to boost your confidence in using Power Query. Join us to transform your data experience and unlock the potential of your datasets!
Curriculum
Curriculum
- 1 Section
- 21 Lessons
- 2 Weeks
- 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. In this course, you will learn how to efficiently import, clean, and reshape data from various sources, including Excel files, databases, and web data. We will cover essential features such as merging, appending, and filtering data. By the end of this course, you'll have the skills to streamline your data workflows, ensuring that your data is accurate, well-structured, and ready for analysis. Whether you're a beginner or looking to enhance your existing skills, this course equips you with practical knowledge and hands-on exercises to boost your confidence in using Power Query. Join us to transform your data experience and unlock the potential of your datasets!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
Instructor
You May Like
INTERMEDIATE EXCEL
This programme is designed for those who have used excel consistently, for a minimum of two years and should be familiar with basic excel...
The Excel Date and Time Functions
Dates and time in Excel are represented as serial numbers. In any environment, these Dates & Times are translated into acceptable and understandable formats...
MS EXCEL FOUNDATION
Our MS Office foundation is a starter programme targeted at fresh and entry level staff of organisations. This programme is highly recommended for the...
Course Features
- Lectures 21
- Quizzes 1
- Duration 2hours 18mins
- Skill level All levels
- Language English
- Students 1
- Certificate No
- Assessments Yes
-
Tabs & icons Consulting,
76 Ikorodu Road,
Fadeyi, Lagos - 08037061602
- info@tabsandicons.com