Excel tips and tricks with CAD – GIS and macros – AulaGEO

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,

Rating Distribution

• 1 stars: 2 votes
• 2 stars: 1 votes
• 3 stars: 2 votes
• 4 stars: 3 votes
• 5 stars: 1 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!