Excel for AutoCAD, Google Earth, and Microstation - AulaGEO

Race Overview

This advanced Excel course will teach you how to leverage the full potential of Excel to integrate with AutoCAD, Google Earthand Microstation. By mastering these skills, you will be able to enhance your workflow and automate tasks, making your work more efficient and productive.

In this course, you will learn how to perform essential geographic and coordinate transformations using Excel formulas. Additionally, we will dive into advanced Excel functions, Including Macros, Visual Basicand form controls to streamline data processing and improve user interaction.

By the end of the course, you will be able to perform conversions, automate processes, and send data from Excel directly to other software like AutoCAD, Google Earth, and Microstation.

What You Will Learn

• Geographic Coordinate Conversions: Convert geographic coordinates to UTM, decimal degrees to degrees, minutes, and seconds, and more.

• Excel Integration: Send data from Excel to Google Earth, AutoCADand Microstation.

• Advanced Excel Functions: Master macros, timeline filtersand data segmentation.

• Form Creation and User Interaction: Learn to create custom forms using Visual Basic and ComboBox for dropdown lists.

• Conditional Logic and Automation: Use IF and CheckBox for decision-making, print forms, and manage access credentials.

Course Content

Coordinate Conversions

1. Converting Geographic Coordinates to UTM

2. Converting Decimal Coordinates to Degrees, Minutes, and Seconds

3. Converting Flat Coordinates to Bearings and Distances

Excel to Google Earth, AutoCAD, and Microstation

4. Send Data from Excel to Google Earth

5. Send Data from Excel to AutoCAD

6. Send Data from Excel to Microstation

Advanced Excel Functions

7. Using Timeline Filters and Data Segmentation

8. Recording Macros to Automate Tasks

9. Creating Forms in Excel

10. Creating Forms from Visual Basic

11. Using ComboBox to Create Lists

12. Making Decisions with IF Function and CheckBox

13. Printing Forms in Excel

14. Setting Access Credentials for Excel Sheets

Putting it all together

15. Final Project: Apply all learned skills to integrate Excel with AutoCAD, Google Earth, and Microstation.

Software Used:

• Microsoft Excel

• AutoCAD

• Google Earth

• Microstation

Who Should Take This Course?

• Professionals in Geographic Information Systems (GIS) looking to automate tasks and integrate Excel with other tools.

• Engineers and Designers who frequently work with AutoCAD, Google Earth, and Microstation.

• Excel Users who want to expand their knowledge and automate their workflows with advanced features and macros.

Why Enroll?

• Boost your productivity by automating geographic and engineering tasks with Excel

• Master integration between Excel and industry-leading software like AutoCAD, Google Earth, and Microstation

• Become proficient in Excel Macros, Visual Basic, and form creation to streamline your data management

• Get lifetime access to course materials and updates

• Complete a final project that showcases your expertise in using Excel for real-world applications

Enroll now and become an expert in Excel for AutoCAD, Google Earth, and Microstation integration!