Also new are a few Web service functions for referencing existing Representational State Transfer (REST)-compliant Web services. You’ll find several new functions in the math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function categories. It also makes life easier when you’re working on two monitors. In Excel 2013 each workbook has in its own window, making it easier to work on two workbooks at once. Simpler to set up and use, slicers show the current filter so you’ll know exactly what data you’re looking at. Filter table data by using slicersįirst introduced in Excel 2010 as an interactive way to filter PivotTable data, slicers can now also filter data in Excel tables, query tables, and other data tables. Give this feature a try when you create a chart from start to finish. Get a quick peek to see how your data looks in the different charts, and then simply pick the one that shows the insights you want to present. With Chart recommendations, Excel recommends the most suitable charts for your data. To see when this feature comes in handy, see Split a column of data based on what you type. As soon as it detects what you want to do, Flash Fill enters the rest of your data in one fell swoop, following the pattern it recognizes in your data. Fill out an entire column of data in a flashįlash Fill is like a data assistant that finishes your work for you. To use this new feature, see Analyze your data instantly. Preview your data with conditional formatting, sparklines, or charts, and make your choice stick in just one click. The new Quick Analysis tool lets you convert your data into a chart or table in two steps or less. When you open Excel 2013, you’ll see templates for budgets, calendars, forms, and reports, and more.

Templates do most of the set-up and design work for you, so you can focus on your data.

Top features to explore Get started quickly

Tip: To learn how you can get started creating a basic Excel workbook quickly, see Basic tasks in Excel.

Ms excel 2013