How to Use Excel 2003 With Map Coordinates

1. Start Excel and enter the following text into the following cells:'LatA' in cell A1'LonA' in cell C1'LatB' in cell A2'LonB' in cell C2These will be the labels that appear to the left of the cells in which you'll be entering the latitude and longitude pairs of your map coordinates.
2. Now you will name the contents of cells B1, D1, B2 and D2 with names corresponding to the labels you entered in Step 1. These names will be used in two complex formulas rather than direct cell references, to make them easier to understand. Name cell B1 as 'LatA' by clicking B1 and entering 'LatA' into the cell name drop-down, located to the left of the formula bar in Excel. Repeat this process for cell D1, naming the cell 'LonA,' for cell B2, naming it 'LatB' and cell D2, naming it 'LonB.'
3. Enter 'Bearing' into cell A3, and copy and paste the following formula into cell B3:=MOD(ATAN2(SIN(LonB-LonA)*COS(LatB),COS(LatA*SIN(LatB)-SIN(LatA)*COS(LonB-LonA))),6.30318)This formula returns the angle to the east of North between the coordinates in row 1 and the coordinates in row 2, in degrees. The last term, '6.30318,' is two times pi.
4. Enter 'Distance' in cell A4, and copy and paste the following formula into cell B4:=ACOS(COS(RADIANS(90-LatA)) *COS(RADIANS(90-LatB)) SIN(RADIANS(90-LatA)) *SIN(RADIANS(90-LatB)) *COS(RADIANS(LonA-LonB))) *3959This formula returns the distance between the coordinates in row 1 and the coordinates in row 2, in miles. The last term, '3949,' is the radius of the Earth, in miles. To convert the distance to kilometers, change the last term to '6371.'
5. Enter the latitude and longitude pair of your first map coordinate into cells B1 and D1 respectively. Enter the latitude and longitude pair of your second map coordinate into cells B2 and D2. The bearing between the two points will appear in cell B3, in degrees, and the distance between the two coordinate pairs will appear in cell B4.