Excel tips and tricks with CAD – GIS and macros

Work macros with macros in Excel and Interact with Google Earth, AutoCAD and Microstation
Instructor:
AulaGEO Academy
4 students enrolled
English [Auto]
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,

UTM Coordinate Conversion

1
Transform Geographic Coordinates to UTM
2
Transform UTM Coordinates to Geographic

Convert Geographic Coordinates

1
Convert degrees/minutes/seconds to decimal degrees
2
Transform decimal geographic Coordinates to UTM

AutoCAD and Excel

1
Coordinates from Excel to Google Maps

Google Earth

1
Export geographic coordinates form Excel to Google Earth, with image and rich te
2
Build polygon from bearings and distances in Excel
3
Extract Google Earth Coordinates and visualize them in Excel

AutoCAD and Microstation

1
Draw a polygon in Microstation software from Excel

AutoCAD and Microstation

1
Construct bearings and distances form UTM Coordinates in Excel

Working with macros and advanced functions

1
Timeline Filters and Data Segmentation
2
Record macros
3
Form Command
4
Forms from Visual Basic
5
ComboBox in Form VB
6
Print form
7
Access credentials to enter your excel sheet
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!

Be the first to add a review.

Please, login to leave a review
7d949a4c098b65ba3c97f916719f22bc
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion