Cool Power Query Tips

If you are new to Power Query – also known as Get & Transform – then let us welcome you in with this session that shows how you can become so much more efficient in this Excel extract, transform and load (“ETL”) add-in.  This session will show you:

  • How to get it if you don’t have it
  • How to pull in data from various sources, clean it up, and produce reports in minutes
  • Explain the difference between merging and appending and why these operations can be really useful (e.g. bank recs, summary reports, PivotTables from multiple sources
  • Learn how to write powerful formulae in Power Query’s M language – without knowing how to program.
Data Modelling & Formulas