Click to see a larger image.Ĭategories and sub-categories are created via a pop-up menu in the column header. On the right is the same data, after applying Table Categories and collapsing a couple of the automatically created sections. While everything you need to know is here, it’s hard to see exactly what you’ve got. On the left is a typical collection of columnar data. Create table categories for the Team and Handed columns however, and the data is much easier to read and interpret. Consider a roster of potential bowling team members: In its raw form, it’s not very usable because there’s so much data to look at. Once grouped, you can add totals, averages, counts, and other summary data. Table Categories give you a simple way to group columns. However, the new Table Categories feature is a reasonable substitute, and is superior to pivot tables in some ways.
Numbers still doesn’t include support for pivot tables, a tool that automatically summarizes data from one table and displays it in another table, making it much easier to see hidden relationships in your data. Release the Option key to enter the selected cell reference in the formula. Hold down the Option key before pressing one of the arrow keys while entering a formula and the selection will change as you press the arrow keys. Unlike its predecessor, Numbers ’09 supports keyboard entry of formulas. You can print this view, which helps with both spreadsheet auditing (as you can see exactly which formulas reference which cells) and will aid students turning in assignments (as many classes require formulas to be visible).
A new Formula List feature displays every formula in your project, and shows you the cells used in each formula. This change makes entering formulas much faster than it was in Numbers ’08. When you click or type, the placeholder is replaced by a cell reference or your new content. (If you forget the function of a placeholder, hover your mouse over it to view an explanatory floating tooltip.) To enter a value, click on a placeholder, then click in the table or type in a value. In Numbers ’09, the placeholders are clickable buttons. In Numbers ’08, these placeholders were text, which had to be removed when inserting values. As before, an Insert Function button places the formula on your table, complete with placeholders for the variables. Variable definitions, usage notes, examples, and links to related content can all be found here.Īdding functions to a table has gotten easier. The new Function Browser not only makes it a snap to find any function, but there’s extensive help available.
#How to add standard deviation bars in numbers for mac manual#
If that’s not enough help, there’s an extensive, detailed manual just for formulas and functions that you can access through the Help menu. Where Numbers ’08 provided one line of text for a given function, Numbers ’09 not only offers longer explanations, but also adds sections that describe each variable in the function, usage notes, examples, and links to related topics. A new Function Browser offers greatly expanded help on every function. Mathematical users will find MULTINOMIAL and FACTDOUBLE (and more) in the Numeric section.īut the most notable changes are in the Statistical category, with over 30 new functions, including AVERAGEIF, CHITEST, and many more. NETWORKDAYS, for instance, shows the number of work days between two dates. A new Duration category lets you convert textual durations, such as 3w 1d 5h into actual time units (533 hours, using the DUR2HOURS function, for example).Įxisting categories also gain new functions. Technical types will love the new Engineering category, with over 20 engineering- and computer-related functions. Numbers ’09 features over 90 new functions, bringing the total function count to over 250.
0 kommentar(er)
