Benefits and Wonder of Numbers
Numbers is a great place to create charts, collect data, and streamline calculating data.
Similar to Apples other programs, the Inspector will be one of the most important tools for editing and formatting your data.
There is a lot of built in redundancy within Apple's Products; if you know how to use one it will greatly aid you in the other. Some of the overlap includes:
- The Inspector
- The main menu of the program
- Format your cells to function for your needs
- Set the framework of your document
- Select large groups of cells to make dramatic edits over large areas
- Numbers has a lot of different equations pre-loaded and ready to you
- To use a formula select the data you want to equation to apply to, then select an applicable formula. The result will appear in the cell immediately to the right (unless otherwise designated)
- You can select equations through the Function button on the toolbar
- When you click the function button, a drop down emerges and allows you to find most equations you will need
- At the bottom of the drop down menu there is a selection called Show Function Browser
- After you use a formula it will show up on your Formula List which attempts streamline your workflow
- Formula List Also functions similar to Track Changes in Pages
To write a custom equation: 1. Select the cell that you want the answer to appear, and type an = 2. Select the cells with the data you want to analyze, Numbers defaults to treat data as a Sum 3. To do equations other than Sums, select data points individually by holding Command and clicking the applicable cells one at a time, inserting the mathematical symbols
- Addition (+)
- Subtraction (-)
- Multiplication (*)
- Division (/)
- Exponentials-Powers (^x)
- Exponentials-Roots (^(1/x))
- When working this way don't forget PEMDAS/Please Excuse My Dear Aunt Sally
- Parenthesis, Exponentials, Multiplication, Division, Addition, Subtraction
Cells can be formated using the Inspector
With Formatting Cells you can designate to work with money, dates, fractions and many others. This is similar to choosing a template in Pages, except you can format different cells differently within a document.
To create a chart you want to select the applicable data and press the Chart button on the toolbar or within the Inspector
- The symbol looks like this
- When you choose to create a chart a list of chart types will appear. Choose wisely.
Much of the chart customization occurs in the Inspector
- You can edit the Axis individually (labeling, and adjusting their scale)