Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
Excel 1: Modern ETL with Power Query in Excel
When Power BI was being designed, the developers created a tool for importing and manipulating data. They called this tool Power Query, and they integrated it into Microsoft Excel. Today, Power Query represents one of the most powerful and potentially valuable tools in your everyday spreadsheets. Topics include: Connecting to data sources with Power Query Cleaning improperly structured data Combining and comparing data tables Automating imports Adding data to the Data Model