Duration: 5 days (25 school hours)
Material: M is for Data Monkey (Ken Puls & Miguel Escobar)
In 2013, without any big announcements, Microsoft released an Excel Add-Inn called Power Query. Despite the almost total absence of large-scale advertising, it soon became clear that Power Query is an incredible tool that upgrades the user experience of Excel and adds incredible value to all Excel users! Power Query quickly became indispensable for everyone who was importing data from different sources into Excel and paramount for Power Pivot Data Model creators. It improved the user experience of importing and transforming data dramatically! The impact of it was obvious as it became THE way to import data in Excel 2016 and replaced all the wizards for importing data that Excel had in previous versions.
The Power Query workshop is suitable for advanced Excel users. As far as Power Query experience goes, those who would see it for the first time and those who are already using it will find something for themselves because within five days we will cover everything from basic queries to the most complex ones.