Filters let you view portions of data in your tables based on criteria. You can filter a long table by what is found in a column. You can combine multiple filters to drill down into data.
You can use special cell types like checkboxes, ratings, sliders and pop-up menus to represent values in cells in Numbers. These cells can make it easier to enter data, or they can visually represent the data in a better way. You can use the values of these cells just like regular numbers and other data types.
Numbers can automatically fill in cells for you if you want to repeat a value, or create a sequence. You can use Autofill to add a set of sequential numbers or dates to cells. You can also have the cells follow a pattern. If you are using tables properly, formulas included in cells will repeat as you add new rows to the table.
Learn how to use the IF function to perform calculations in Numbers. IF is an important function to learn if you want to graduate to creating more advanced spreadsheets. You can use it to test a value in one cell and return two different values depending on the results of that test. Also learn related functions like SUMIF and COUNTIF.
Numbers lets you create charts that have an extra dimension. You can move through columns of data using a slider or buttons, with the chart changing to reflect the data in each column. This can be useful for showing changes over time.
Sometimes you want to be able to count the number of items in a table and get the total. You can do this with the COUNTIF function. It will return the numbers of items that match a certain criteria. You can also use the COUNTIFS function to match multiple criteria in a more complex table.
You can use data in your spreadsheet tables to create colorful charts of many different types. Learn how to quickly create a chart and modify its look. You can also put charts on separate sheets to make them easier to share and print.
There are many advantages to using multiple tables in a single spreadsheet in Numbers. Take a look at how you can use two tables with the LOOKUP function to make computations easier. The LOOKUP function will grab data from another table by looking up a value in one column and returning the value of another.
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.