Spend less time gathering data and more time analyzing it
Applies ToExcel for Microsoft 365 Excel 2021 Excel 2019 Power BI Microsoft Teams

Compiling data takes time that can hold up a project. You need a fast, easy way to gather and sync your data, so you can focus on analysis and forecasting.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Details  

Use “Get Data” in Excel or Power BI to immediately connect to various internal and external data sources, quickly transform data in a trackable/refreshable manner, and jump directly into your analysis. 

Save your analysis in Microsoft Teams to ensure one file acts as the source of truth for your colleagues. Work together in real time without having to worry about locked files or confusion around version control.

Highlights

  • Spend less time compiling data.

  • Ensure your analysis is always connected to up-to-date information.

  • Save your analysis in one file as the source of truth for colleagues.

Learn More

About Power Query in Excel

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.