Not for use in any commercial, nonprofit or revenue generating activities, or by any government organization.
Microsoft Excel 2013 -- The new Excel gives you intuitive ways to explore your data, inspiring you to get to new insights. In one click, discover new ways to visualize your data, and see your information in new depths. Enjoy working with and analyzing your data – the new Excel guides you with charts and tables based on your data, and helps you get the job done faster. With Excel, explore your data at new depths in less time.
What's new in Excel 2013
The first thing you’ll see when you open Excel is a brand new look. It’s cleaner, but it’s also designed to help you get professional-looking results quickly. You’ll find many new features that let you get away from walls of numbers and draw more persuasive pictures of your data, guiding you to better, more informed decisions.
Top features to explore
- Get started quickly
- Instant data analysis
- Fill out an entire column of data in a flash
- Create the right chart for your data
- Filter table data by using slicers
- One workbook, one window
- New Excel functions
- Save and share files online
- Embed worksheet data in a web page
- Share an Excel worksheet in an online meeting
- Save to a new file format
New charting features
- Changes to the ribbon for charts - The new Recommended Charts button on the Insert tab lets you pick from a variety of charts that are right for your data. Related types of charts like scatter and bubble charts are under one umbrella.
- Fine tune charts quickly - Three new chart buttons let you quickly pick and preview changes to chart elements (like titles or labels), the look and style of your chart, or to the data that is shown.
- Richer data labels - Now you can include rich and refreshable text from data points or any other text in your data labels, enhance them with formatting and additional freeform text, and display them in just about any shape.
- View animation in charts - This isn’t just fun to watch—the movement in the chart also makes the changes in your data much clearer.
Powerful data analysis
- Create a PivotTable that suits your data. When you create a PivotTable, Excel recommends several ways to summarize your data, and shows you a quick preview of the field layouts so you can pick the one that gives you the insights you’re looking for.
- Use one Field List to create different types of PivotTables. Revamped to accommodate both single and multi-table PivotTables, the Field List makes it easier to find the fields you want in your PivotTable layout, switch to the new Excel Data Model by adding more tables, and explore and navigate to all of the tables.
- Use multiple tables in your data analysis. By importing different tables, and creating relationships between them, you’ll be able to analyze your data with results you aren’t able to get from traditional PivotTable data.
- Connect to new data sources. To use multiple tables in the Excel Data Model, you can now connect to and import data from additional data sources into Excel as tables or PivotTables
- Create relationships between tables. By using MDX queries, you can further leverage table relationships to create meaningful PivotTable reports.
- Use a timeline to show data for different time periods. You can now simply filter dates interactively or move through data in sequential time periods, like rolling month-to-month performance, in just one click.
- Use Drill Down, Drill Up, and Cross Drill to get to different levels of detail Use Drill Down into a PivotTable or PivotChart hierarchy to see granular levels of detail, Drill Up to go to a higher level for “big picture” insights, or Cross Drill to navigate from one hierarchy to another to get insights about data across one or more hierarchies.
- Use OLAP calculated members and measures
- Create a standalone PivotChart lets you experience new ways to navigate to data details by using the new Drill Down, Drill Up, and Cross Drill features.
- Power View lets you create and interact with charts, slicers, and other data visualizations in a single sheet.
New and imporved add-ins and converters
- PowerPivot for Excel add-in provides an environment for creating more sophisticated models.
- Inquire add-in helps you analyze and review your workbooks to understand their design, function, and data dependencies, and to uncover a variety of problems including formula errors or inconsistencies, hidden information, broken links and others.