Most of the templates include basic calculations some include advanced calculations and visual representations of data. The templates that are available from within Excel for iPad range from a simple to-do list to a complex financial report and include expense reports, sales reports, household budgets, marketing budgets, time sheets, invoices, loan calculators, and ledgers. Excel templates focus more on purpose than on appearance they provide structure and functionality for specific types of information.
Track changes, insert comments, and respond to comments.Īs with other Office files, you can create a blank Excel workbook or a workbook that contains content from a template.Create PivotTables, Power Pivot data models, and Power View sheets.Create data validation rules, consolidate data, and perform conditional analysis.Analyze data by using the Quick Analysis tool.Audit formulas and require manual calculation of formulas.Create and edit three-dimensional charts.Sort and filter data by using slicers and timelines.Apply conditional formatting and sparklines.Use apps and web resources to enhance content.Create SmartArt diagrams, and capture screen images.Insert pictures from local and online sources.Display and edit workbooks from remote storage locations offline.Display multiple views of worksheets, split windows, multiple windows, and very large workbooks.For example, you can use Excel 2013 on a computer running Windows to do the following: The desktop versions of Excel have the most functionality. Display three-dimensional charts, slicers, Power Pivot tables and charts, and Power View sheets.įor more information about Excel Online, visit /en-us/library/excel-online-service-description.aspx.Coauthor workbooks in real time and edit macro-enabled workbooks.You can use Excel Online to do the following: Add custom colors to shapes, and add shadows and reflection styles to pictures.Customize PivotTable styles and layouts.The following premium features require that you sign in by using an account that is associated with a qualified Office 365 subscription:
Insert pictures that are available on your iPad.Format, find, replace, sort, and filter content.Create, manage, and print workbooks and worksheets.You can save and edit workbooks in a shared storage location by using multiple versions.Īfter you sign in by using a Microsoft account, you can do the following: Here is a brief comparison of the features in each version. Excel for iPad has only a subset of the features of the full program.
0 kommentar(er)
