Working with Excel Data

These instructions assume that you have data already in Excel.

start by typing = into an empty box. This signifies to Excel that you are going to use a function
If you want to add/subtract/divide/multiply, simply type the column letters and row numbers of the boxes you want to do arithmetic with. See example of my gas money calculations ;)

MORE ADVANCED STUFF

To get to the other side of any column or row of data, hold down the command key and use your arrow keys to navigate you. This is especially helpful with large amounts of data.
To count how much a certain character or number appears in a particular column or row type =COUNTIF(range, criteria)

Range refers to how many boxes you are talking about (i.e. A937:I937) and criteria is what you are looking for, which is typed in another box (i.e. I937 for a box, "*F*" for a word). Make sure you include a colon between your range and a comma between the range and criteria.

3. You can count up all the numbers in a row or column using =COUNTA(range)

4. =COUNTBLANK(range) counts the number of blank boxes

Report abuse