Playing Time |
02h:38m:14s |
Note |
1/13/202012:00:00AM |
Summary |
Learn about the time-saving capabilities of Power Query (Get & Transform) for easily importing, connecting, combining, and refining data in Excel with reusable queries. |
Cast |
Presenter: Oz du Soleil |
Summary |
View Oz's LinkedIn Newsletter 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. |
System Details |
Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection. |
Genre |
Instructional films. |
|
Educational films. |
Added Author |
linkedin.com (Firm)
|
|