Numbers

From Digi Wiki
Jump to: navigation, search

Benefits and Wonder of Numbers

Numbers is a great place to create charts, collect data, and streamline calculating data.

Getting Started

Similar to Apples other programs, the Inspector will be one of the most important tools for editing and formatting your data.

Familiar Features

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
Onspedto.png
  • The main menu of the program

Good practice

  • 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

Inserting Formulas

  • 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
Screen shot 2012-05-31 at 11.26.49 AM.png
  • 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
Screen shot 2012-05-31 at 11.31.42 AM.png
  • After you use a formula it will show up on your Formula List which attempts streamline your workflow
Screen shot 2012-05-31 at 11.34.02 AM.png
  • Formula List Also functions similar to Track Changes in Pages

Writing Equations

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))


Note:

  • When working this way don't forget PEMDAS/Please Excuse My Dear Aunt Sally
  • Parenthesis, Exponentials, Multiplication, Division, Addition, Subtraction

Formatting Cells

Cells can be formated using the Inspector

Onspedto.png

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.

Cell Functions

Creating Charts

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
Screen shot 2012-05-31 at 12.00.05 PM.png
  • When you choose to create a chart a list of chart types will appear. Choose wisely.

Customizing Charts

Much of the chart customization occurs in the Inspector

  • You can edit the Axis individually (labeling, and adjusting their scale)
Screen shot 2012-05-31 at 12.02.00 PM.png