Share an Excel worksheet in an online meeting Other people can then work with the data in Excel for the web or open the embedded data in Excel. To share part of your worksheet on the web, you can simply embed it on your web page. No matter what device they’re using or where they are, everyone works with the latest version of a worksheet- and you can even work together in real time. It’s also simpler to share your worksheets with other people. Save and share files onlineĮxcel makes it easier to save your workbooks to your own online location, like your free OneDrive or your organization’s Microsoft 365 service. Look for details in New functions in Excel 2013.
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.
0 kommentar(er)
