Revealed: Excel Power Query One Hour Bootcamp (Great Stuff)
The Short And Sweet Beginners Guide To Using Power Query In Real Life
4.35 (83 reviews)

812
students
1 hour
content
Feb 2019
last update
$39.99
regular price
What you will learn
You will control your data - - instead of letting it control you. Invest an hour and get a lifetime of benefits.
You will build fast, repeatable data transformations that improve your Excel analysis and reporting
You will use the Power Query Editor and its many push-button, formula and multi-query functions
Import Excel file, remove top rows, use first row as header, remove columns, change type, split columns by delimiter, rename columns, close & load, merge columns, conditional columns, reorder columns, rename steps, move steps, view 'M' code, sort rows, filter rows, rename query, reference, group-by, duplicate, refresh, merge
You will take a big career step forward as a professional data analyst who understands the importance of 'clean' data
Screenshots




Related Topics
1031266
udemy ID
12/4/2016
course created date
11/22/2019
course indexed date
Bot
course submited by