Excel mobile app

View, edit, or create spreadsheets from anywhere. Get up and running quickly with familiar navigation
and formulas, while maintaining the same formatting across all your devices. With the Excel mobile app, your Office moves with you.

Excel 2016—get it now with an Office 365 subscription.

Get & Transform and Power Pivot in Excel

Insights are all in the data

Lay out your data

Organize your numeric or text data in spreadsheets or workbooks. Viewing it in context helps you make more informed decisions.

Reformat and rearrange it

As you look at different configurations, Excel learns and recognizes your pattern and auto-completes the remaining data for
you. No formulas or macros required. The Tell Me search feature guides you to the feature commands
you need to get the results you are looking for.

Do your analysis

Excel will perform complex analyses for you. And it summarizes your data with previews of pivot-table options, so you can
compare them and select the one that tells your story best.

Get a better picture of your data

Flow into charts and graphs

Excel can recommend the charts and graphs that best illustrate your data patterns. Quickly preview your options and pick
those that present your insights most clearly.

Find your best storyline

Discover and compare different ways to represent your data and your intents visually. When you see the one that shows your
data best, apply formatting, sparklines, charts, and tables with a single click. A set of new modern
charts and graphs in Excel 2016 help you to present your data in fresh ways.

Highlight trends and patterns

Make it easy to spot trends and patterns in your data by using bars, colors and icons to visually highlight important values.
The new one-click forecasting feature in Excel 2016 creates forecasts on your data series with one
click to future trends.

Add another set of eyes

Share from the cloud

Make sure everyone has the latest version by sharing your workbooks in the cloud with OneDrive or SharePoint, so others can
view, edit, and collaborate.
Or simply email or instant message as an attachment.

Collaborate in real time

Once you’ve saved your spreadsheet to OneDrive, OneDrive for Business, or SharePoint you and your team can work together
in real-time with Excel Online. As you and your team make edits and changes to your documents, the
improved version history in Excel 2016 allows you to view or go back to earlier
drafts.

Collaborate on shared projects

Office Online combines commonly used Office features and real-time coauthoring capabilities so teams at work and school can collaborate on shared documents, presentations and spreadsheets.

How do Power BIPower B I and Excel work together?

Excel 2016 and Power BIPower B I contain a portfolio of tools that is unique in the industry. Together, they enable business analysts to more easily gather, shape, analyze, and visually explore their data. The new Power BIPower B I service is a business analytics collaboration and delivery environment. It
helps anyone in your organization bring together data from a wide range of sources—Excel workbooks, on-premises corporate data, Azure services, and other popular cloud-based offerings like Salesforce.com or Marketo—to view and share using live dashboards and interactive reports.
Learn more about how Power BI and Excel work together.

What chart types are available in Excel 2016?

In addition to the several classic chart types that have been available in previous versions of Excel, six new chart types were introduced as part of Excel 2016. Additional new charts and visualization feature improvements will continue to be made available to Office 365 subscribers.
Learn about the new chart types available in Excel 2016.

How can I get the advanced business analytics features in Excel?

With select Office plans, Excel 2016 provides additional capabilities that let you further enhance your analytics and modeling capabilities, take advantage of advanced data connectivity options, and effectively share your data across the organization.
See below for a summary of basic and advanced business analytics features. The advanced features are included as part of Office 365 ProPlus and other enterprise subscriptions. You can also take advantage of the advanced features with select one-time purchases of Office, including Office
2016 Professional Plus, Office 2016 Professional, and Excel 2016 standalone.

Basic business analytics features
Get these features with any Office 365 subscription* or any Office 2016 one-time purchase.

Advanced business analytics features
Get these features with an Office 365 ProPlus and other enterprise subscriptions, Office 2016 Professional, Office 2016 Professional Plus, and Excel 2016 standalone one-time purchases.