The information is in the data
It shapes your data
organizes data, numeric or text, spreadsheet worksheets or workbooks. Seeing them in context helps you make more informed decisions.
Reformats and order
As you use different configurations, Excel learns and recognizes your criteria autocomplete the remaining data without formulas or macros. Information search feature guides you through the commands you need to get the results you want.
Excel automatically performs complex analyzes and summarizes data with different PivotTables you can preview to compare them and select the one that best expose your story.
A more complete view of your data
Comfortable with charts and graphs feel
Excel can recommend diagrams and charts that best illustrate the patterns of your data. You can quickly preview and choose alternatives that present information more clearly.
Find the best way to expose
Discover and compare different visual ways to represent your data and your ideas. When you see the best shows your data, apply formatting, sparklines, charts and tables with a single click. The modern set of diagrams and charts Excel 2016 allows you to present data in a renewed way.
Highlights trends and patterns
Use bars, colors and icons to visually highlight important values and highlight trends and patterns in your data. The new feature forecast with a click of Excel 2016 creates forecasts of future trends in your data series.
Four eyes see more than two
Share the cloud
Share your calculus books in the cloud with OneDrive or SharePoint to ensure that everyone has the latest version and allow others to see the edit and collaborate. Or you can send them as attachments in an instant or email message.
Collaborate in real time
when you save your spreadsheet in OneDrive, OneDrive for Business or SharePoint, you and your team can collaborate in real time using Excel Online. As aplicáis edits and changes to the document, the improved version history of Excel 2016 allows you to view or retrieve previous drafts.