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.
Jumpstart your design
Show your style and professionalism with templates, plus save time. Browse Excel templates in over 40 categories.
Connect with experts
See what’s new and get classic tips and editors' tricks to help you create, edit, and polish documents like a pro.