Excel Power Query Trick

preview_player
Показать описание

Excels Power Query ( or Get and Transform in Excel 216) allows you to carry out transformation on data, such as removing rows and columns, fill down, and unpivot data. These are changes that you might make to an excel spreadsheet on a regular basis.
But with Power Query you can save your transformations and reuse them, saving you loads of time.

Follow my Excel Playlist
  1. Paula's Web3 & Crypto
  2. Excel Power Query
  3. Excel get and transform data
  4. Get and transform excel trick
  5. save time with power query
  6. excel 2016
Рекомендации по теме
You WON'T BELIEVE 0:12:17

You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯

25 Amazing Power 0:32:03

25 Amazing Power Query Tips and Tricks

How to use 0:16:35

How to use Microsoft Power Query

Get a Free 0:11:07

Get a Free Library as you Learn Excel Power Query Tricks (Custom data types, Hyperlink data type!)

Data Loading Tricks 0:10:26

Data Loading Tricks in Power Query

How to Split 0:10:54

How to Split and Transform Text in Excel (Unbelievable Power Query Tricks)

Power Query Tips 0:33:17

Power Query Tips and Tricks - Excel Tutorial for Beginners

AWESOME Excel trick 0:08:43

AWESOME Excel trick to combine data from files with DIFFERENT headers

Power BI | 1:08:41

Power BI | Excel Power Pivot | Power Query Editor | M Code Tutorial | Power BI Tips | M Language

Power Query Running 0:07:25

Power Query Running Count Based on Row Condition – Excel Magic Trick 1588

Copy and Paste 0:01:49

Copy and Paste Power Query Trick in Excel

Learn Power Query 0:18:45

Learn Power Query & Automate Boring Data Tasks in 15 Minutes!

7 Interesting Power 0:06:43

7 Interesting Power Query Tricks

5 Best Practices 0:11:31

5 Best Practices in Power Query

Excel Magic Trick 0:11:35

Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model?

5 Tricks to 0:16:42

5 Tricks to Reduce Steps in Power Query

Excel Magic Trick 0:18:02

Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records

EASY Trick to 0:11:47

EASY Trick to COMBINE Multiple Excel files into ONE with Power Query

Excel Magic Trick 0:18:43

Excel Magic Trick 1357: Power Query Function to Repeat Clean & Transform Steps for Many Excel Fi...

AWESOME Excel trick 0:07:27

AWESOME Excel trick to combine data from multiple sheets

Powerful trick to 0:07:42

Powerful trick to combine all Excel files in a folder AUTOMATICALLY

Excel Magic Trick 0:04:00

Excel Magic Trick 1384: Import Excel Table or Sheet in Power Query or Power BI?

Excel Magic Trick 0:06:56

Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report

Reference an Intermediate 0:13:17

Reference an Intermediate Step from another Query | Power Query Tricks

Комментарии
Автор

Hi Paula.. thanks for the video. Even though it is one of your older ones, I still found it useful.. I'm practicing as much as possible with Power Query problems and solutions. Thanks for sharing. Thumbs up for The Excel Club!

wayneedmondson
Автор

Great example of using PQ, thanks again!

michaeljones
Автор

Hi Paula! Great video, but I recommend filtering out the totals in PQ mode, your final pivot table is double counting.

afedianine
Автор

Hi Paula excellent video. Thank you Is there any other way to apply the same power query to another spreadsheet that is on a different file with a different tab name? The new file does have the same fields as the one I created the power query on but just new set of data.

Robert-uocq
Автор

It would be great if I could download this file from a dropbox. So I could take a crack at it before watching the video. You say you have a blog but there is no link to it?

davidhansen