Learn how to use simple formulas in Numbers to calculate results. You can use basic math operations or complex functions from a library. You can feed these functions single cells or ranges of cells. You can also copy and paste formulas to perform the same calculations on other rows or columns.
Learn how to use conditional highlighting to make cells in your tables stand out. Your can search for a number of different criteria and then change the color or styling of cells depending on the match. You can even have multiple conditions and give them priority. You can also use other cells and formulas as input for the conditions.
When you create a basic table in Numbers, it is important to use Headers and Footers properly. Headers allow you to define the contents of rows and columns, and you will see these labels appear in formulas and charts. Footer rows allow you to perform functions like SUM and AVERAGE on an entire column, with the formula adjusting to the content in between the header and the footer.
Calculating percentages in Numbers is just a matter of dividing two numbers. But you can use cell formatting to display the result as a percentage instead of a decimal fraction. You can also use functions to calculate percentages from lists of numbers or lists of items.
You can use AppleScript to create scripts that control Numbers and Pages. This is similar to how Microsoft Office users use macros to control Word and Excel. In either case, you need some level of programming skill to be able to write scripts. If you can do it, this can be a very powerful way to enhance Numbers and Pages, adding functionality that isn't possible otherwise.
Creating useful spreadsheets is usually a matter of combining several techniques. In this tutorial, you'll learn how to create a table to hold a small database of information. Then, you'll create a second table to count the number of records that have certain criteria. Finally, you'll use the second table to create a pie chart. Each element updates automatically as new records are added or changed.
You can create a chart in Numbers and then copy and paste it into a Pages or Keynote document. When you do so, the chart is linked and changes to the chart data in Numbers can be synced to your Pages or Keynote document. However, only data can be updated. Labels and the table itself cannot sync between apps, though copy and paste is a decent work-around.
Google Drive spreadsheets is a good alternative to using desktop apps like Excel and Numbers. It is a fairly sophisticated number crunching program that has all of the major features seen in those others. All you need is to use your web browser and a free Google account.
You can view the rows in your spreadsheet by category using values in specific rows. This is often better than sorting the entire spreadsheet. You can nest categories and turn them on and off easily. You can also use formats and colors to make categories easier to view.
Export and printing options for Contacts are limited. But you can do almost anything you want with your Contacts data if you know this one trick. By dragging and dropping your Contacts into Numbers, you can then organize, sort and format the information in any way. You can then export it from Numbers, or use Numbers to print a list any way you desire.
When building formulas in Numbers it is important to be able to insert absolute cell references. These are references to cells that will not shift as you copy and paste the formula into new rows or columns. You can use the values in absolute cell references for constants like sales taxes or commission amounts.
There are various ways you can automatically fill cells in Numbers. You can copy and paste to quickly fill cells one time. Or, you can construct your table so cells automatically fill in as you expand the table. You can also fill in cells with a series like months, dates, numbers or letters.
The Lookup function can be useful if you want to automatically populate cells on one table with data from another, based on new data entered. For instance, you can enter products in one column and then have prices fill in automatically by having the Lookup function refer to a list of products and prices in a second table.
You can represent specific times and time durations in cells in iWork Numbers. You can format the cells to display the times and dates in a variety of ways. You can perform calculations on both and get intelligent results, such as the difference between two times.
Learn how to create pie charts in iWork Numbers. You can create beautiful 2D and 3D pie charts from a simple list of numbers. Find out how to break single wedges out of the chart and how to put the chart on a separate page for printing.
Learn to use header and footer rows in iWork Numbers. Footers allow you to easily perform functions, like sums and averages on entire columns. Headers can remain at the top of the screen as you scroll. Both can be used to keep calculations and titles separate from sorted data in the body of a spreadsheet.
You can hide rows and columns in Numbers to effectively filter your data. Hiding can be done one row or column at a time, or by groups of rows and columns. You can also set criteria for rows or columns to be automatically filtered, allowing you to see only the data you need.
If you don't have Numbers, you can use Pages to create simple spreadsheets. Just use the tables inside Pages to create small spreadsheets that can use formulas to perform calculations. You can even sort and use basic and conditional formatting.
You can use the COUNTIF function to count the number of times an item appears in a column. You can also use COUNTIFS to total the number of rows based on several conditions in several columns. The SUMIF and SUMIFS functions will give you the total of the rows in another column based on the same criteria.
You can create nice-looking printouts from Numbers, but the options to do so aren't always obvious. Learn how to view your spreadsheets in layout view, adjust scaling, darken borders and use styles and design elements to create nicer Numbers printouts.
There are many options for formatting cells in iWork Numbers. You can choose the number of decimal places, or use fractions. You can format as currency or choose a different base system. You can choose from a variety of date and time formats. You can also create steppers, sliders and pop-up menus to make it easy to change values to cells. Conditional formatting allows you to have cells that change color and style with certain values or ranges.
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.