You work with queries in PQ desktop, that slightly differs, depending on host application (Excel, Power BI,...). Excel automatically opens PQ desktop when you start a new query. Power Query query is a series of transformations, written in dedicated M language. When you add data transformation in the query, PQ automatically records this action. The final result of query can be extracted to worksheet or left as connection for future use.
It is easy to start to work with PQ, with some experience you will try to modify the recorded code, play with lists, functions, formulas. You can find a lot of tutorials, also from MS. I uploaded some solutions using PQ, for instance thread68-1826627 .
A starting point:
[ul]
[li]you need some data to process, if it Excel, organize them in Excel tables,[/li]
[li]get all tables (one by one) to PQ environment, create queries from external sources or excel tables, with connection only output; if by accident you get the output in new Excel worksheet - delete it,[/li]
[li]you should end up with a series of queries, with one (input only) or two (automatic data transformation) actions, you can rename them if you like,[/li]
[li]start the proper query: create new empty query, start with: =[tt]SourceQueryName[/tt], the result of [tt]SourceQueryName[/tt] will become an input in new query,[/li]
[li]continue transformations (sorting, filtering, rearranging/deleting columns, merging queries etc, using available UI options,[/li]
[li]when you get what you like, simply close PQ desktop and save query (data will be returned to new sheet), or output to selected range.[/li]
[/ul]
It is possible to examine recorded M code in advanced editor (or copy query to notepad).
The code can be modified in some ways: in advanced editor, in selected action command line, or in configuration form for some actions.
M language is case sensitive. At least in Excel, wrong syntax can crash the application, so frequently save the work.
combo