Power Query 2 - Building an Instant Consolidation

If you find it takes ages to consolidate data from various sources and process them before generating a report, or if your report users always ask you to provide snap-shots of certain entities or periods, and you may want to have a quicker way of consolidation and a one-size-fits-all report for your report consumers, then this course is for you.

Join me in the course:

- to learn the powerful formulas and advanced functions in Power Query

- to learn how to build an instant consolidation model from scratch

- to understand how to automate your Power Query model for Self-service Reporting!

It does not matter if you are an Excel novice, or an Excel Advanced user, everyone is sure to learn something new, I can guarantee you on that, as this happened to me time and time again when I tuned in to other master’s Excel lessons.

PS: Excel 2010 and newer is needed for this course.