Excel: Power Query (Get & Transform)
Focused View
Oz du Soleil
3:43:14
771 View
01 - Make your data useful with Power Query.mp4
00:47
01 - Power Query example.mp4
09:57
02 - Differences between Excel and Power Query.mp4
09:04
01 - Data types explained.mp4
06:44
02 - Query data from a table or range.mp4
03:26
03 - Query data from another Excel file.mp4
03:05
04 - Load data only as a connection.mp4
04:03
01 - Fill up and fill down.mp4
04:05
02 - Split column by delimiter.mp4
05:29
03 - Split into rows.mp4
04:38
04 - Add conditional and custom columns.mp4
05:29
05 - Add column by example.mp4
10:14
06 - Merge columns.mp4
03:56
07 - Sort and filter data in Power Query.mp4
04:49
01 - Use IF formulas.mp4
02:56
02 - Nest IF and AND.mp4
03:35
03 - AddDays to determine the deadline.mp4
03:45
01 - Pivot data in Power Query.mp4
02:44
02 - Pivot and append data.mp4
04:26
03 - Pivot and dont aggregate.mp4
03:14
04 - Unpivot data in Power Query.mp4
05:52
05 - Unpivot warnings.mp4
03:06
01 - Group By feature.mp4
05:17
01 - Two data sets.mp4
03:03
02 - Multiple tables.mp4
06:27
03 - Query data from a folder and import multiple files.mp4
08:46
04 - Append multiple sheets.mp4
05:07
01 - Midterm challenge Get a count of all colors.mp4
07:11
01 - Overview of joins in Power Query.mp4
06:18
02 - Walk through all six joins.mp4
13:29
03 - Joins Left or right.mp4
02:31
04 - Outer join versus XLOOKUP.mp4
02:41
05 - Merge with multiple fields.mp4
03:24
06 - Approximate match equivalent of VLOOKUP Binning.mp4
05:47
07 - Approximate match equivalent of VLOOKUP Conditional column.mp4
03:04
08 - Cross Join.mp4
03:17
01 - Drill down to create a variable in Power Query.mp4
06:49
01 - Fuzzy matching by percentage.mp4
07:28
02 - Merging inconsistent data with a transformation table.mp4
06:07
01 - Challenge setup.mp4
01:02
02 - Real-world challenge 1 Projects.mp4
05:56
03 - Real-world challenge 2 Donors.mp4
06:21
04 - Real-world challenge 3 Soccer team.mp4
06:50
01 - Next steps.mp4
00:55
Description
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.
More details
User Reviews
Rating
average 0
Focused display
Category
Oz du Soleil
Instructor's CoursesMicrosoft Excel MVP | YouTube Channel: Excel on Fire | Author, Guerrilla Data Analysis Version 2. Co-authored with Mr Excel, Bill Jelen | Excel Trainer & Instructor | Speaker.
I've been working with data and Excel for many years, and have developed a passion for clean data and reliable reporting. An even greater passion is that of teaching, sharing knowledge and empowering people to do handle their data more efficiently and with greater skill to turn their data into useful information.
Presented at:
#Northwestern University
#University of Illinois at Chicago
#IgniteChicago
#ExcelTV
Courses taught:
Excel Formulas
Data Visualization in Excel 2013
Pivot Tables & Dashboards
Excel for Nonprofits: Measuring Fundraising Effectiveness
Introduction to Programming VBA
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 44
- duration 3:43:14
- English subtitles has
- Release Date 2024/06/22
