Course Details

Once you've mastered the fundamentals, Power Query becomes an incredibly powerful tool for building scalable reporting processes. This intermediate session focuses on creating flexible, automated workflows that can handle changing data sources and more complex business requirements.

Delegates will learn techniques that reduce maintenance, improve reliability and allow reports to refresh with minimal manual intervention. The session builds on the foundations introduced in Part 1 while introducing features used by experienced Power Query users.


In this session Alan Murray will cover the following topics:

  • Combining and consolidating multiple files into a single automated reporting process. 
  • Creating flexible and resilient Power Query solutions. 
  • Advanced transformation techniques to merge, combine, group and restructure real-world business data. 
  • Improving query performance and building maintainable Power Query solutions. 
  • Best practices for designing reliable data preparation processes that can grow with business requirements.


By attending this session, you will…


  • Build more advanced and flexible Power Query solutions. 
  • Automate multi-file reporting processes. 
  • Understand techniques that improve performance and maintainability. 
  • Create robust queries that adapt to changing data. 
  • Apply best practices used in professional reporting environments.


This session will be of most interest to accountants and finance professionals who already understand the fundamentals of Power Query or have attended Part 1 of this series.

 

Course level: Intermediate

CPD Course Speaker

Computergaga

Alan Murray

Alan Murray is an experienced Excel trainer and Microsoft MVP. With over 23 years of experience as an Excel trainer, he helps users build confidence and expertise in Excel and Power BI - empowering them to solve problems, automate tasks, and work more efficiently.

Alan is the author of the ‘Advanced Excel Formulas’ and ‘Advanced Excel Success’ books and has a YouTube channel – named Computergaga – with 118,000+ subscribers and over 50 million views.

He organises the London Excel Meetup group to provide a community event for professionals to network, share, and develop their Excel skills.

Alan loves showing people what’s possible with the tools they already have. His training approach is relaxed, practical, and always focused on the needs of the people in the room. Everyone should feel confident using Excel and empowered to ask any question - no matter how simple or advanced.