Power Query's "Advanced" Options Aren't Advanced

★ Get the example file ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/insiders-signup/
File Reference for this video: 0321 PQ Advanced Options

★ JOIN THE FREE COURSE ★
Want to get the free Modern Excel Formulas course? Click here:
https://exceloffthegrid.com/modern-excel-formulas/

★ Want to become an Excel ninja? Check out our training academy ★
https://exceloffthegrid.com/

★ About this video ★
The word "Advanced" in Power Query can be misleading.

Many dialog boxes contain "Advanced" options, but they often hide simple, practical features rather than complex functionality.

In fact, some of the most useful features are tucked away in those sections.

So if you've been skipping them because they sounded intimidating, this week's video may change your mind.

00:00 Introduction
00:34 Example file
01:08 Group By
02:49 Replace Values
04:50 Pivot
06:20 Subscribe
06:42 Split Column
08:39 Delimiters
09:59 Wrap-up

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: / exceloffthegrid

#msexcel #PowerQuery #Advanced