Microsoft Excel: A Turorial
DR7 Help
 Site News
 Cooking with Sloan
 Search Form Guide
 SQL Tutorial
 SQL in SkyServer
 Sample SQL Queries
 Query Limits
 Searching Advice
 Archive Intro
 Table Descriptions
 Schema Browser
 Web Browsers
 Data Publications
 SkyServer Sites
 Contact Help Desk

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 that contains the value of the color (difference in magnitudes) 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.