Excel tips and tricks with CAD - GIS and macros

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,