Numbers
Use Numbers to create attractive and powerful spreadsheets on your Mac. More than 30 Apple-designed templates give you a head start when you create budgets, invoices, team rosters, and more. Numbers can also open and export Microsoft Excel spreadsheets. With Activity Stream, it’s easier than ever to collaborate on a Numbers spreadsheet and keep track of every change along the way.
Start with a template—then add what you want. Select the sample text in the template, then type new text. To add images, drag a graphic file from your Mac to the placeholder image.
Collaborate with Messages. You can send an invitation to collaborate in Messages, and everyone on the thread is automatically added to the Numbers spreadsheet. Click the Share button in the menu bar, make sure Collaborate is selected, and then click Messages. Choose the name of the group you want to add as participants.
Work together in real time. With Activity Stream, a detailed list in the sidebar allows you to see edits and comments made by collaborators on a Numbers spreadsheet. It’s easy to follow each change, as well as who has been added to the spreadsheet or what file management updates have occurred.
Get organized with sheets. Use multiple sheets or tabs to show different views of your information. For example, use one sheet for your budget, another for a table, and a third for notes. Click 
to add a new sheet. Drag a tab left or right to reorder sheets.
Formulas are a snap. Get built-in help for more than 250 powerful functions—just type the equal sign (=) in a cell, and you see a list of all the functions and their descriptions in the sidebar. Start typing a formula to get instant suggestions.
Tip: To get instant calculations for a series of values, select the range of cells containing the values. At the bottom of the window you’ll see the sum, average, minimum, maximum, and count of the selected values. Click the Menu button 
at the bottom right to see even more options.
Create pivot tables. Create a pivot table using a table or range of cells in a spreadsheet as your source data, then use it to analyze any set of data, quickly group and summarize values, and identify interesting patterns and trends. You can edit the cell range of your source data, add and arrange pivot table data, create a snapshot of a pivot table that you can copy to other apps, and more.
Learn more. See the Numbers User Guide.