
Advanced Excel
Convert Degrees Minutes Seconds to Decimal Degrees in Excel
Learn how to convert degrees, minutes, and seconds to decimal degrees in Excel using TEXT functions, formulas and VBA code.
Read article
3 lessons in order

Learn how to convert degrees, minutes, and seconds to decimal degrees in Excel using TEXT functions, formulas and VBA code.

Learn how to convert latitude and longitude to UTM coordinates in Excel using VBA code, including Easting and Northing values accurately.

Learn how to do reverse geocoding in Excel using native formulas and custom VBA UDFs to convert coordinates into addresses.