Learn Power Query for Excel and Power BI
80 free lessons in 20 modules, about 13 hours of reading in all. Each lesson explains one skill with examples that run in our simulator, then links to graded exercises so you practise it straight away. No account is needed to read.
Start at module 1 if you're new to Power Query; the M language lessons (let, records, lists, custom functions) come later and build on the editor skills. Prefer a guided order? Follow the foundations path.
Every lesson ends with Where to find this in Excel: the ribbon path in Excel's Power Query editor, checked against Microsoft's documentation, or a note that the step is written in M.
New to Power Query in Excel? Start here
Four illustrated walkthroughs show where everything is in Excel, from opening the editor to refreshing a finished query.
- 1How to open the Power Query editor in ExcelIn Excel for Windows, open the editor from Data > Get Data > Launch Power Query Editor, from Data > From Table/Range with a table selected, or by editing a query in Data > Queries & Connections.
- 2Your first Power Query in Excel, from table to refreshSelect a cell in an Excel table, choose Data > From Table/Range, shape the data in the editor, then choose Home > Close & Load.
- 3Manage Power Query queries in Excel: load, refresh and editClose & Load To chooses where results go.
- 4Power Query in Excel for Windows, Mac and the webExcel for Windows (Microsoft 365) has every Power Query feature.