Create a New Column from a Calculation

To learn how to use Excel to do calculations, let's say we wanted to create a new column which contains the value of the magnitude difference (color) u - g for each star.

First, click on the top cell in your new column and type a label. Next, click on the cell just below the label. Type the equals (=) sign. Next, click on the column for u in the same row. Type the minus (-) sign. Click on the column that contains the g value. The spreadsheet should look like it does below:

Hit Enter and the spreadsheet will calculate u - g for that cell.

Next, select all cells in the u - g column (except for the label). Click the Edit menu. Select Fill and then Down. The entire column will now have the u - g value for the star in its row.