Easy formulas
What comes naturally to some now comes automatically to everyone. Writing formulas is easy in Numbers ’09. Over 250 functions are included; just click and choose one. Along with each function is a clear explanation of the formula and built-in help. You can even assemble formulas using visual placeholders for each variable. Just click a placeholder, then choose a value to include in your formula.
One-click formulas.
Over 250 functions with built-in help are included. Just click and choose one. Use visual placeholders for each variable.
Formula List view
A spreadsheet contains many sheets, tables, numbers, and formulas. How do you keep track of them all? With the new Formula List view, you can see every calculation in your spreadsheet at one time. Click the Formula List button in the toolbar to see the list, and then jump to a specific formula. You can also search for formulas, functions, or cell references.
Table categories
When there are large sets of data in one spreadsheet, it can be difficult to make sense of it all. With one click, you can now group rows based on data in any column and create table categories. Each category includes a summary row. Using just the summary row, it’s easy to collapse, expand, and rearrange the categories. Add functions to each summary row — subtotals, averages, count, miniumum, and maximum — to organize your data even more.
Make sense your data.
Group your data into table categories. Collapse, expand, and arrange the categories by using just a summary row.
Advanced charts
Numbers ’09 features even more impressive options for 2D charts. Combine line, column, and area series in a single mixed chart. Create 2-axis charts with different value scales. Easily apply trendlines and error bars. With just one click, your data is more compelling.
New chart options.
Numbers lets you create impressive 2D charts. You can choose from many options, and easily edit the data.
Linked charts
Now Numbers, Pages, and Keynote work together to keep all your data on the same page. Create charts in Numbers and paste them into Pages documents or Keynote presentations. They’ll stay linked to the original data in Numbers. Even if the chart styles, textures, colors, and fonts are different, the data is the same. When you make a change to your data, update your linked charts with a click. In Pages and Keynote, you can easily access your original Numbers document or unlink the data at any time.
Enhanced Template Chooser
Need some spreadsheet-making inspiration? Professional-looking, Apple-designed templates make it easy to start. Numbers ’09 brings you 12 new ideas and designs — 30 templates total. Choose a checking register, savings calculator, or retirement savings template. Create a baby record or garden journal. Keep track of your weight and workouts. Explore the possibilities.
Explore new templates.
Use the enhanced Template Chooser to create a great-looking spreadsheet in minutes.
More ways to share
Share your Numbers spreadsheets with anyone on a Mac or PC. You can open Microsoft Excel files in Numbers and save your Numbers spreadsheets as Excel files. Thanks to powerful graphics tools in Numbers, it's easy to make Excel spreadsheets look great. Numbers also lets you export your spreadsheets as PDF files. With the new email option, send Numbers, Excel, or PDF files right from Numbers using Mac OS X Mail. Or upload your work to iWork.com Public Beta1, Apple’s new document-sharing service. Reviewers can view your spreadsheet on the web, make comments, and download it in a format that’s right for them.
Share your spreadsheets.
Open and save as Microsoft Excel files. Email your spreadsheets right from Numbers. And share with everyone on the web.
