
About Course
This short course will give you the base-level introduction, and a few tips and tricks, that will embolden you to explore the new “Power Query” tool. It was first launched in Excel in 2010 and has only gotten better and easier since then. It’s purpose is for redundant data clean-up that will then be used in data analysis, charts, and pivot tables. Set up the clean-up steps once-and-for-all, then just refresh each time you need it.
Course Content
Excel Power Query Crash Course
-
Introduction to Excel Power Query
02:16 -
Get Data and Screen Overview
03:20 -
How to Change the Data Source
04:13 -
How to Fix Mistakes
02:54 -
Intro to Conditional Columns
04:04 -
Edit Query Settings
03:11 -
Close-and-Load to Save
02:12 -
10 Conditions in 1 Step
03:41 -
Format Numbers and Dates
03:44 -
Conditional Col from 3 columns
03:02 -
Advanced Editor
03:29 -
Final Overview and Review
01:48
MUSKAN GUPTA
Asheera Rizwan
Areeba Tahir
Jayanta Das
Areej Imran
Ishmeet Kaur
Nitin Singh
Rakshitha G
Charushila Khot
Shubham Shrivastava