Excel: Discover, Analyze, and Visualize any data

Now you have a powerful new way to build interactive reports and analyze your data. Excel provides rich data connections, transformation and visual analytics in an unified, seamless experience. All of this while enjoying the familiarity of Excel and features you already love such as pivot tables, slicers, charts and formulas.

Discover and Combine

Easily discover and connect to data from public and corporate data sources with Power Query. This includes new data search capabilities, as well as the ability to easily transform and merge data from multiple data sources so that you can analyze it in Excel.

Connect to all your data

Excel spreadsheets, on-premises data sources, Hadoop datasets, streaming data, and cloud services. Power Query brings all your data together so you can start analyzing it in seconds.

  • Web page
  • Excel or CSV file
  • XML file
  • Text file
  • Folder
  • SQL Server database
  • SQL Server Analysis Services
  • Windows Azure SQL Database
  • HDInsight
  • Access database
  • Oracle database
  • IBM DB2 database
  • MySQL database
  • SharePoint List
  • OData feed
  • Hadoop Distributed File System (HDFS)
  • Windows Azure Marketplace
  • Active Directory
  • Facebook
  • SAP BusinessObjects BI Universe
  • Salesforce

Model and Analyze

With Power Pivot continue to create sophisticated data models with that data in Excel by creating relationships, custom calculated fields, hierarchies, and KPIs—all with the increased performance of in-memory technology. Because Power Pivot models run in memory, you can analyze 100s of millions of rows of data with lightning fast performance.

Visualize

Create reports and analytical views in Power View with interactive charts and graphs to explore and present your data visually in Excel. Perform predictive forecasting, and hindcasting, when visualizing and exploring your data in your browser with Power BI for Office 365. Explore and navigate geospatial data on a 3D map experience with Power Map.

Forecasting with Power View

Forecasting with Power View

Power View and Power Map in action More about Power Map

Share and Collaborate

Upload your Excel reports to a Power BI site and share them with anyone on your organization. Your report readers get the same dashboard interactivity in the browser, making it easier to consume data and unlock insights. Customize your Power BI sites gallery to feature and highlight specific reports and visualizations created in Excel.

Live Visualizations and Power Map tours

Watch Power Map tours and interact with live Power View reports.

Get Started with Excel 2013