Excel tips and tricks with CAD - GIS and macros

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.

#AulaGEO

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,

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,

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,

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,

Work macros with macros in Excel and Interact with Google Earth, AutoCAD and Microstation

Url: View Details

What you will learn

• Using excel to make working with AutoCAD, Microstation and Excel easier
• Google Earth tips with Excel
• Formulas for transformation of utm coordinates - geographic

Rating: 3.14286

Level: Intermediate Level

Duration: 2.5 hours

Instructor: AulaGEO Academy