Excel tips and tricks with CAD - GIS and macros
What you'll learn
- 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
Requirements
- The course is from scratch, but users who already know basic Excel will take more advantage of it
Description
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,
Who this course is for:
- AutoCAD users
- Microstation users
- GIS Tool Users
- Google Earth enthusiasts
- Excel users who want to get more out of it
Instructor
![AulaGEO Academy](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.0 Instructor Rating
- 2,266 Reviews
- 22,949 Students
- 128 Courses
We choose the best courses and make them available to new audiences.
Our training offer covers the entire spectrum of data intelligence:
Art - Capture - Modeling - Design - Construction - Operation. Using technological development and process improvement as a transverse thread.
The creators of courses with which we have decided to work have been carefully selected, to offer a complementary set of knowledge. We firmly believe that today people do not seek courses to fill their walls with diplomas; but to make their abilities more productive.