4  2 reviews on Udemy

Excel tips and tricks with CAD - GIS and macros

Work macros with macros in Excel and Interact with Google Earth, AutoCAD and Microstation
Course from Udemy
 15 students enrolled
Using excel to make working with AutoCAD, Microstation and Excel easier
Google Earth tips with Excel
Formulas for transformation of utm coordinates - geographic
Generation of kml files from excel
Conversion of coordinates to courses / bearings and distances
Working with macros and Visual Basic code
Advanced forms and filters

In this course you will learn how to get more out of Excel, applied to tricks with AutoCAD, Google Earth and Microstation.

It includes:

  • Conversion of geographic coordinates to projected in UTM,

  • Decimal coordinate conversion to degrees, minutes and seconds,

  • Conversion of flat coordinates to bearings and distances,

  • Send from Excel to Google Earth,

  • Send from Excel to AutoCAD

  • Send from Excel to Microstation

  • Everything, using Excel formulas.

Additionally, learn how to work with advanced Excel functions using Macros.

  • Timeline Filters and Data Segmentation,

  • Record macros,

  • Create form,

  • Forms from Visual Basic,

  • Create lists using ComboBox,

  • Decisions using IF Function, Else using CheckBox,

  • Print form,

  • Access credentials to enter your excel sheet,

Excel tips and tricks with CAD - GIS and macros
$ 74.99
per course
Also check at

FAQs About "Excel tips and tricks with CAD - GIS and macros"


Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.