Excel tips and tricks with CAD - GIS and macros

AulaGEO Academy

Training

Online

up to £ 100

The best Excel courses

See all

See all

Description

  • Type

    Training

  • Methodology

    Online

  • Class hours

    3h

  • Start date

    Different dates available

"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,"

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

"Using excel to make working with AutoCAD, Microstation and Excel easierGoogle Earth tips with ExcelFormulas for transformation of utm coordinates - geographicGeneration of kml files from excelConversion of coordinates to courses / bearings and distancesWorking with macros and Visual Basic codeAdvanced forms and filters"

"AutoCAD usersMicrostation usersGIS Tool UsersGoogle Earth enthusiastsExcel users who want to get more out of it"

The course is from scratch, but users who already know basic Excel will take more advantage of it

"-100% online -Access to the course for life -30 days warranty money back -Available from desktop or mobile app -Can begin and finish the course any time -Can repeat the course any times"

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2020

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 3 years

Subjects

  • Excel
  • Access
  • Visual Basic training
  • CAD
  • AutoCAD
  • Visual Basic
  • Excel Sheet
  • MS Excel
  • GIS
  • Microsoft Office
  • Microstation
  • Microsoft
  • Geographic
  • Google Earth
  • Google
  • Earth
  • CAD 2D
  • CAD 3D
  • CAD Models
  • CAD tools

Teachers and trainers (1)

AulaGEO Academy

AulaGEO Academy

Specialized center in Geospatial, Engineering and Operations

We choose the best courses and make them available to new audiences in the spectrum CAD - GIS - BIM - Digital Twins Our training offer covers the entire spectrum of data intelligence: Capture - Modeling - Design - Construction - Operation. The creators of courses with which we have decided to work or promote 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.

Course programme

"UTM Coordinate Conversion
Transform Geographic Coordinates to UTM
Transform UTM Coordinates to Geographic
Convert Geographic Coordinates
Convert degrees/minutes/seconds to decimal degrees
Transform decimal geographic Coordinates to UTM
AutoCAD and Excel
Coordinates from Excel to Google Maps
Google Earth
Export geographic coordinates form Excel to Google Earth, with image and rich te
Build polygon from bearings and distances in Excel
Extract Google Earth Coordinates and visualize them in Excel
AutoCAD and Microstation
Draw a polygon in Microstation software from Excel
AutoCAD and Microstation
Construct bearings and distances form UTM Coordinates in Excel
Working with macros and advanced functions
Timeline Filters and Data Segmentation
Record macros
Form Command
Forms from Visual Basic
ComboBox in Form VB
Print form
Access credentials to enter your excel sheet"

See related categories

Excel tips and tricks with CAD - GIS and macros

up to £ 100

The best Excel courses

See all

See all