Excel tips and tricks with CAD - GIS and macros

Course

Online

£ 100 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

In this course you will learn how to get more out of Excel, applied to tricks with AutoCAD, Google Earth and Microstation.

About this course

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

AutoCAD users.
Microstation users.
GIS Tool users.
Google Earth enthusiasts.
Excel 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

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

  • Data segmentation
  • Visual Basic
  • Google Earth
  • Excel Sheet
  • KML files

Course programme

Section 1. UTM Coordinate Conversion Transform Geographic Coordinates to UTM Transform UTM Coordinates to Geographic Section 2. Convert Geographic Coordinates Convert degrees/minutes/seconds to decimal degrees Transform decimal geographic Coordinates to UTM Section 3. AutoCAD and Excel Coordinates from Excel to Google Maps Section 4. Google Earth Export geographic coordinates from 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 Section 5. AutoCAD and Microstation Draw a polygon in Microstation software from Excel Section 6. AutoCAD and Microstation Construct bearings and distances from UTM Coordinates in Excel Section 7. Working with macros and advance functions Timeline Filters and Data Segmentation Record macros Form Command Forms from Visual Basic ComBObOX IN fORM vb Print form Acces credentials to enter your excel sheet

Excel tips and tricks with CAD - GIS and macros

£ 100 VAT inc.