With great-looking templates, easy-to-create formulas, and dynamic tables and charts, spreadsheets suddenly make perfect sense.
Plan a wedding. Save for retirement. Track your workouts. Keep a baby journal. Spreadsheets can help you organize and plan, and great-looking Apple-designed templates will help you get started. With the Template Chooser, you can preview over 30 templates to use for home, work, and school. Tables are already made. Formulas have been figured out. Fonts are in place. They’re all ready to go. Just find something you like and make it your own.
In Numbers, spreadsheets are built on a flexible, free-form canvas. So you can move tables, charts, graphics, and text anywhere you want on the page. As tables resize, objects automatically adjust to fit around them. Create as many tables as you want. Change fonts, sizes, colors, styles, and borders. With graphics tools, alignment guides, and rulers, spreadsheet-making becomes a surprisingly creative endeavor. And suddenly, spreadsheets make more sense.
The Media Browser adds some excitement to your spreadsheet. With a click, you can access your photos from iPhoto, your movies, and your video. The Sheet Navigator lists every table, chart, and sheet in your spreadsheet so you can quickly jump to any part of your project and make changes.
It all adds up beautifully.
Creating formulas may seem complex, but Numbers makes it uncomplicated. Using the intuitive browser, you can choose from over 250 functions. Tooltips and built-in help provide clear and concise explanations of each variable. The Formula List view shows you every calculation on your spreadsheet at once. And with a few clicks on the toolbar, you can create tables and charts and add images and graphics. Easily find fonts and format text styles in the format bar.
Brilliance in every cell.
Numbers is a blank canvas for tables. You can create as many as you want and resize them as needed. The layout of each table is independent, so whatever you do to one table won’t affect the others. Move tables anywhere — even to a different sheet — and the calculations remain intact. You can also share content between tables. WIth intuitive tools, Numbers helps you analyze data. Enter data and change values within the cells and use sliders, checkboxes, steppers, and pop-up lists to explore the results. With every change, formulas and charts instantly update and give you a new data scenario.
When there’s almost too much data to decipher, Numbers lets you create categories based on information from any column. It automatically generates a summary row for each category. By using just the summary row, you can collapse, expand, and rearrange categories to organize your data any way you want. The Reorganize button in the toolbar lets you filter by category and gives you other advanced sorting and filtering options.
Transform your data into compelling 2D or 3D bar, line, area, or pie charts. Combine line, column, and area series in a single mixed chart. Create 2-axis charts with different value scales. Even apply trendlines and error bars. The charts you create in Numbers can be linked to your Pages documents and Keynote presentations, so you can easily keep all your documents up to date.
It’s the universal language.
Numbers makes it easy to share your spreadsheets with colleagues and friends. Send Numbers, Excel, or PDF files right from Numbers using Mac OS X Mail. You can also open Microsoft Excel files in Numbers and save your Numbers spreadsheets as Excel files. With powerful graphics and formatting tools, it’s easy to make Excel spreadsheets look great in Numbers. You can even export your Numbers spreadsheets as PDF files. Numbers lets you import documents in other common formats as well, including comma-separated-value or tab-delimited files, Open Financial Exchange files from Quicken, files from bank or credit card providers, vCards, and more. Printing spreadsheets in Numbers is surprisingly simple, too. Use the interactive Print view to see how big your spreadsheet will print. Then scale it up or down with a slider.