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