Discover and reveal the insights hidden in your data
Flash Fill. Easily reformat and rearrange your data to gain new insight. Excel learns and recognizes your pattern and auto-completes the remaining data for you. No formulas or macros required.
Recommended Pivot Table. Perform complex analyses quickly. Excel summarizes your data with previews of various pivot-table options, so you can compare them and select the option that tells your story best.
Visualize your data to understand it better
Recommended Charts. Let Excel recommend the charts that best illustrate your data's patterns. Quickly preview your chart and graph options, and then pick the ones that present your insights most clearly.
Quick Analysis. Discover and compare different ways to represent your data visually. When you see the one that shows off your data best, apply formatting, sparklines, charts, and tables with a single click.
Chart Formatting Control. Imagine the freedom to fine-tune the look and feel of your charts quickly. Change the title, layout, and other chart elements—all from a new and more interactive formatting interface.
Share workbooks more ways for better results
Simplified Sharing. Share workbooks with ease and confidence. You can be sure that you're all tracking only the latest version, because your presentations are saved online on SkyDrive or SharePoint by default.* Just send everyone a link to the same file.
Post to Social Network. Get a lot of feedback fast. Share selected portions of your spreadsheets on the web by posting them on your social network pages.
Present Online. Collaborate on workbooks with others in real time by sharing your screen in Lync conversations or meetings. When you present online, you can also allow others to take control of your workbook.
* Requires an Internet connection; must be signed in with a Microsoft account or a Microsoft Online Services ID.