Learn how to use if statements in formulas in iWork Numbers. You can combine these with checkboxes and pop-up menus to create results based on conditions. Useful for solving problems and bookkeeping.
You can share your Pages, Numbers and Keynote documents using Apple's iWork.com service. Others can view your documents right in their browser, and make comments and notes if they are using Safari. You can even upload Keynote presentations and present right from the Safari.
While iWork Numbers doesn't have true pivot tables, you can get similar results using Table Categories. This feature lets you group data together in various ways to reveal the same summaries that you can get with pivot tables.
The simple task of adding a column of numbers in iWork Numbers can be done elegantly using right-sized tables with footer rows. Learn how to easily add a list of amounts and perform other function like averages using iWork 09 Numbers.
Learn how to create simple charts from spreadsheet data in iWork 09 Numbers. You can create pie charts and line graphs and then customize how they look with inspectors and by just dragging elements. You can also put the charts on a separate page for printing.
One interesting feature of Numbers on the iPad is the ability to create forms. You can use forms to fill in the rows of a spreadsheet instead of entering data into the spreadsheet grid.
iWork 09's spreadsheet program Numbers isn't like the old-fashioned spreadsheet programs you may be used to. You can create small tables and design a sheet with each table having its own numbers and formulas and also using numbers from other tables.
Learn how to use basic spreadsheet formulas in iWork 09's Numbers program. You can use basic mathematical functions and also use functions to get the sum or average of a list of numbers.