Apple has made great strides with Numbers, but it has some catching up to do if it's going to handle much more than basic spreadsheets and charts. Though you can essentially replicate this in Numbers, the process is complex and not as intuitive as it is in Excel. One capability that Numbers still lacks that's a mainstay in most corporate offices is the ability to create Pivot Tables, which provide Microsoft Excel users a way to create easy reports with big data tables.
Other new Numbers features include better formatting options and enhanced conditional formatting. If you select a bunch of cells, a bar appears at the bottom of the display, with several basic calculations - like sum and average - already completed, making for quick and easy calculations even without formulas. There are several additional formulas Apple has added to its repertoire, and formulas now auto-complete to save time getting the answers you need. In many situations, interactive charts can present information in a much more meaningful and understandable way than typical static charts can, and this feature helps Numbers stand out from the pack.Ĭlick to EnlargeAnother enhancement we really like in Numbers is the beefed-up formula editing. The chart will feature a slider that you can use to scroll through individual months to see how the sales are trending. Simply create a table with the appropriate data, and create an interactive chart. For example, say you're analyzing a product and want to understand its sales trends. When you're working with a series of data, you can create charts that include buttons and scrollbars, which animate your charts to make them come to life on the screen. The interactive-chart tool is one of the more useful features added to Numbers. When you create a chart or insert media, however, the sidebar will let you change the formatting, and how the chart and image look within the larger document, as well as manipulate the data used to create the charts. Click to EnlargeWhen you're working in a table, for example, four tabs are available to help you format the cell, text within the cell, alignment, and the overall look and feel of the table itself.
0 kommentar(er)
