Power Query is a powerful tool for automating data imports and transformations, but many solutions become difficult to maintain when file paths, filters or dates are hard-coded into the query. This webinar shows practical techniques for adding user interaction to Power Query solutions from within Excel, so queries can be refreshed with different settings without editing the underlying M code.

• Use range names to capture user selections and pass them into Power Query.

• Build parameter tables to centralise file paths, folder choices and date ranges.

• Create reusable Power Query functions to make interactive queries easier to manage.

• Understand privacy and Formula.Firewall issues that can arise with flexible queries.

• a pdf manual which you can print out and make notes in
• Excel file to work through during the session
• the completed file to review if you need to