Stop copy-pasting: Master Power Query with Excel expert Jon Peltier

Still copying and pasting data from one file after another to build the same report?

Power Query lets you build your data prep process once, then refresh it whenever your data changes. In this free session, Excel Expert Jon Peltier walks through common Power Query scenarios, with a workbook so you can follow along.

You’ll see how to:

• Transform data from a table or range and refresh it when the inputs change

• Import data from a separate workbook and keep it up to date

• Combine multiple CSV files from a folder, even as files are added or removed

• Compare Excel’s legacy Data Consolidation tool with Power Query

Bonus: After Jon’s session, our team will show how AI can watch your numbers for you, flagging when a threshold is crossed and surfacing patterns nobody thought to look for.

Register now to save your seat.

This webinar is available in English.