Power Query Summary

[For beginners] How to use Power Query in Excel

・I used to use Excel functions, but there was no one who knew more about it, so I couldn't add more functions.
・I do the same sales report every month, but it takes several hours to create graphs and tables.

If you are having trouble with the above, learn Power Query and become a DX person who can analyze data yourself!
It's not difficult to operate. Let's learn the basics from "data import to graph creation".

Ingest data

Get data from file

Change (update) the import destination file

Change how data sources are ingested

Process data

combine strings

extract string

Create a custom column that outputs values ​​according to multiple conditions

Remove and extract duplicate rows

Process the query

Merge (join) tables

Merge (join) tables

Turn data into graphs and tables

Automatically update graphs and tables with filter functionality

Create your own function and reuse the process

Create a custom function

Convert full-width numbers to half-width numbers

Generate PowerQuery functions using EXCEL