Excel: Power Query (Get & Transform)

Focused View

Oz du Soleil

2:44:45

0 View

01.01-make your data useful with power query.mp4

01:12

01.02-what to know before starting this course.mp4

00:55

02.01-power query example.mp4

06:48

02.02-differences between excel and power query.mp4

03:55

03.01-data types explained.mp4

04:42

03.02-query data from a table or range.mp4

02:09

03.03-query data from another excel file.mp4

02:28

03.04-load data only as a connection.mp4

03:24

04.01-fill up and fill down.mp4

02:17

04.02-split column by delimiter.mp4

03:09

04.03-split into rows.mp4

01:47

04.04-add conditional and custom columns.mp4

04:51

04.05-add column by example.mp4

04:31

04.06-merging columns.mp4

03:38

04.07-sorting and filtering data in power query.mp4

02:44

05.01-use if formulas.mp4

02:01

05.02-nest if and and.mp4

02:04

05.03-adddays to determine deadline.mp4

02:44

06.01-pivot data in power query.mp4

01:29

06.02-pivot and append data.mp4

02:52

06.03-pivot--dont aggregate.mp4

02:01

06.04-unpivot data in power query.mp4

02:08

07.01-group data.mp4

01:57

08.01-two data sets.mp4

02:17

08.02-multiple tables.mp4

03:18

08.03-query data from a folder and import multiple files.mp4

03:12

08.04-combining table with different headers.mp4

02:18

08.05-append multiple sheets.mp4

02:55

09.01-overview of joins in power query.mp4

03:11

09.02-full outer join.mp4

04:03

09.03-inner join.mp4

02:18

09.04-left anti join.mp4

03:02

09.05-right anti join.mp4

02:31

09.06-left outer join.mp4

01:58

09.07-right outer join.mp4

02:00

09.08-outer join versus vlookup.mp4

02:54

09.09-merge with multiple fields.mp4

03:04

09.10-joins left or right.mp4

02:13

09.11-approximate match equivalent of vlookup binning.mp4

02:38

09.12-approximate match equivalent of vlookup conditional column.mp4

02:31

10.01-drill down to create a variable in power query.mp4

05:26

11.01-matching inconsistent entries by percentage.mp4

05:09

11.02-merging inconsistent data with a transformation table.mp4

04:29

12.01-make and use custom data types.mp4

07:48

13.01-easy real-world challenge 1 pies and prices.mp4

07:19

13.02-easy real-world challenge 2 volunteer hours.mp4

05:08

13.03-monster real-world challenge who missed the mandatory fun.mp4

08:51

13.04-monster real-world challenge tracking donations.mp4

08:26

Ex Files Excel Power Query Get Transform.zip

Glossary ExcelPowerQuery GetTransform.zip

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

Total votes0

Focused display

Power Query

Oz du Soleil

Instructor's Courses

Microsoft 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 Learning

LinkedIn 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.