Gathering and preparing data can be a tedious, thankless task. Microsoft’s Power Query tool that was added to Excel aims to cut a majority of the time and effort spent on that – and it’s also in all Microsoft’s other data handling applications! In this session, we’ll introduce you to the power that Power Query can bring to your everyday efforts.
Topics include:
- Automating the insertion of new data
- Cleaning problem data
- Replacing macros with button-press automations
- Building a new data culture within your organization