Milenyals Forum

Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Leak Excel: Power Query (Get & Transform)

rocket 

Ultimate Poster
Contributor
Half Member
Registered
Joined
Feb 25, 2019
Messages
46,439
Reputation
9
Popularity
1,290
Points
223
You must be registered for see images

MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Duration: 2h 28m
Skill Level: Intermediate | Genre: eLearning | Language: English + Subtitles | Size: 355 MB

Power Query is a feature in Excel that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs.​

Follow along with Excel MVP Oz du Soleil as he shows you how to use this powerful, time-saving tool. Oz demonstrates how to import, merge, rearrange, and clean data, as well as how to repeat the process with one click if the data changes. Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets. Oz offers dozens of techniques and tips in this comprehensive training.
What is Power Query (Get & Transform)?
Working with queries
Data types explained
Working with columns and formulas
Pivoting and unpivoting data
Grouping data
Appending queries
Merging data
Drill down to use variables
Fuzzy matching
Sorting and filtering

DOWNLOAD[hide thanked=1]
nitroflare
[/hide]
 
Top