Excel tips and tricks with CAD - GIS and macros

[mitsumi]

Excel tips and tricks with CAD - GIS and macros
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 1.35 GB
Genre: eLearning Video | Duration: 17 lectures (2 hour, 39 mins) | Language: English

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

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.

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

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction