Sometimes you have non-consecutive data in Numbers that you wish to chart. For instance, you may have skipped dates or large gaps in time. However, you want to graph the data with a consistent timeline at the bottom of the graph even if all of the dates are not represented. Here is one method for doing that, using a second hidden table that is automatically populated from the main table.
You can use a trick to force a line return in Numbers formulas so they are easier to read and edit. The same trick can be used in some web forms and other apps to add line returns when a regular Return keystroke doesn't work.
If you need a quick random number there are at least three ways to do this on your Mac. You can do it in the Calculator app, but you'll need to perform some extra steps to get a useful value. You can use the RANDBETWEEN function in a temporary Numbers spreadsheet. You can also just ask Siri.
You can use CONVERT to convert numbers from one unit to another. Convert distances from meters to feet, temperatures from Fahrenheit to Celsius, and so on. You can also use cell formatting to attach unit symbols to numbers.
When you open a Pages, Numbers or Keynote document that is missing fonts, you can use a handy new feature to globally replace that font throughout the document. You can also use this to quickly change any font in your document.
A new feature in Numbers is the ability to add leader lines to pie charts. This makes the charts look more professional and easier to follow. This also works with pie charts in Keynote and Pages.
A new feature in Numbers allows you to use live stock prices and other information in your spreadsheets. You can get the current price, volume, change and other data. You can also grab historical data.
See how you can use Numbers to work with basic physics problems like orbital calculations. In this example a table is use to calculate the position of a satellite over time. A scatter chart is then used to show the position of the satellite and a line chart to show the altitude.
The Lookup function in Mac Numbers can be used to find a value based on another value. You can also use numerical and time ranges by simply stating the start of each range. In this example, we look at a rental rate sheet and calendar where the price for each date is populated from the the rates in another table.
A key skill every Mac user should master is how to select multiple items. In icon-based situations like the Finder or Keynote, you can drag a rectangle around items. In icon and list-based situations you can select multiple items using the Command and Shift keys.
Learn how to create a Numbers spreadsheet with a checklist and pie chart that tracks your progress through the checklist. To do this, you'll need the functions COUNTIF and COUNTA.
You can create new shapes by using a set of four commands in Pages, Numbers and Keynote. These commands will combine one or more shapes to make a new shape. This is often easier than drawing your own shape from scratch.
You can sort rows in Numbers using a trick with the rand function. You can also sort or shuffle a single column by copying that column to another table, performing the sort, and then copying it back to the original table.
You can count the number of times a text string appears in a Numbers spreadsheet column using the COUNTIF function. The function can be hard-coded to look for text, or it can use the value of another cell.
Conditional Highlighting in Numbers lets you color a cell based on the contents of that cell. If you need to set a cell to highlight based on the contents of other cells, you can use the IF function first, and then the conditional highlighting based on the results of that IF function.
Trend lines can help you find meaning in what could seem like random data. One example looks at daily sales for a store and finds an upward trend over the course of a year. Another example looks at physics data and converts it to a mathematical formula.
If you are building a spreadsheet in Numbers it can be useful to have sample data to help construct your tables and get things right before you have real data to enter. You can use the RANDBETWEEN function to create random numbers. Then if you copy and paste correctly you can turn those formulas into static numbers that won't change.
With new updates to Pages, Number and Keynote you have new ways to select colors in those apps. This includes an eyedropper tool on the iPad that allows you to select a color from anywhere on the screen and use that to color text, shapes and other objects. This eyedropper tool also exists on the iPhone, but in a different location.
Learn how to sort tables in Numbers. You can sort by a single column, but also by multiple columns. See some techniques for making the tables look better once they are sorted.
The latest version of Numbers restores our ability to use AppleScript to automate some actions in your spreadsheets. You can use AppleScript to create new commands in Numbers and do things that could be difficult or impossible to do otherwise. Take a look at some simple examples that populate cells with random numbers and modify the values of checkboxes.
When you create formulas in Numbers, the references to other cells are relative to the location of the formula. So when you move or copy the formula into another cell, the references follow along. But you can use absolute cell references to force the formula to always refer to the exact same cell, no matter where the formula is placed.
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.