Excel - trucos avanzados con CAD - GIS y Macros
What you'll learn
- Uso de excel para facilitar el trabajo con AutoCAD, Microstation y Excel
- Trucos Google Earth con Excel
- Fórmulas para transformación de coordenadas utm - geográficas
- Generación de ficheros kml desde excel
- Conversión de coordenadas a rumbos / derroteros y distancias
- Trabajo con macros y código Visual Basic
- Formularios y filtros avanzados
Requirements
- El curso es de cero, pero los usuarios que ya conocen Excel básico le tomarán más provecho
Description
El mundo está cambiando, al igual que el lugar de trabajo. Para mantenernos al día, debemos aprender y progresar constantemente. Con Excel, puede realizar un seguimiento de sus proyectos, administrar su presupuesto, calcular cuánto dinero necesita para jubilarse cómodamente e incluso averiguar cuánto café queda en la máquina de café de su oficina.
Excel es una poderosa herramienta para empresas, particulares y profesionales. Pero hay tantos trucos ocultos que la mayoría no conoce. ¡No te quedes atrás en la era digital!
Si usted es una de esas personas que trabaja con Excel, debe saber que procesar mucha cantidad de información puede ser estresante. Con la ayuda de nuestros #exceltips podrás convertir información y obtener tu trabajo de forma más rápida y sencilla. Excel es más que una herramienta para procesar números. Es un motor poderoso para crear y administrar datos, y con los trucos correctos, ¡puede hacer que trabaje para usted!
¿Cómo puede ayudarte este curso?
En este curso aprenderás a sacar más provecho de Excel, aplicado a trucos con AutoCAD, Google Earth y Microstation, ya sea que sea un profesional experimentado o un principiante, le encantarán estos consejos y trucos que se han recopilado especialmente para ustedes.
Incluye: Conversión de coordenadas de geográficas a proyectadas en UTM, decimales a grados, minutos y segundos, coordenadas planas a rumbos y distancias. También enviar datos de Excel a Google Earth,, AutoCAD y Microstation, todo, usando fórmulas de Excel.
Adicionalmente, conoce cómo trabajar funciones avanzadas de Excel utilizando Macros
· Filtros de escala de tiempo y segmentación de Datos,
· Grabar macros,
· Crear formulario,
· Formularios desde Visual Basic,
· Crear listas usando ComboBox,
· Decisions usando Función IF, Else mediante CheckBox,
· Imprimir formulario,
· Credenciales de acceso para ingresar a tu hoja de excel,
¿Cual es el contenido?
· Lectura 1: Convertir coordenadas UTM a coordenadas Geográficas
· Lectura 2: Convertir coordenadas UTM a Rumbos (derroteros) y distancias
· Lectura 3: Coordenadas geográficas a coordenadas UTM
· Lectura 4: Convertir grados sexagesimales a grados decimales
· Lectura 5: Convertir coordenadas geográficas decimales a coordenadas UTM
· Lectura 6: Crear polígono en AutoCAD a partir de un cuadro de rumbos de Excel
· Lectura 7: Convertir coordenadas geográficas a un fichero kml de Google Earth
· Lectura 8: Convertir coordenadas UTM a un fichero kml de Google Earth
· Lectura 9: Convertir de Google Earth excel a UTM
· Lectura 10: Enviar a Microstation a partir de UTM o rumbos y distancias
· Lectura 11: Filtros de escala de tiempo y segmentación de Datos
· Lectura 12: Grabar macros
· Lectura 13: Formularios desde Visual Basic
· Lectura 14: Crear listas usando ComboBox
· Lectura 15: Decisions usando Función IF, Else mediante CheckBox
· Lectura 16: Imprimir formulario
· Lectura 17: Credenciales de acceso para ingresar a tu hoja de excel
Domine el potencial de Excel con estos tutoriales fáciles de entender. Desde libros de trabajo hasta macros y automatización, verá cómo es posible hacer más con menos esfuerzo. Además, nunca más tendrás que preocuparte, ya que tendrás a tu disposición todas las plantillas y recursos descargables para ser usados en tu día a día. #AulaGEO
Who this course is for:
- Usuarios de AutoCAD
- Usuarios de Microstation
- Usuarios de herramientas GIS
- Entusiastas de Google Earth
- Usuarios de Excel que quieren sacar más provecho
Instructors
Welcome to our Academy platform, your ultimate destination for online courses covering a wide range of subjects, including GIS, CAD, BIM and Digital Twins applied to the land development environment. We are committed to providing comprehensive education and empowering individuals to excel in various domains related to infrastructures. Whether you are a student, a professional seeking to expand your knowledge, or an enthusiast passionate about these subjects, our platform offers a diverse selection of courses tailored to meet your specific needs.
At our Academy, we recognize the significance of these disciplines in the infrastructures life cycle, from initial design to project completion. To ensure the highest quality of education, we have collaborated with renowned industry expert Golgi Alvarez and assembled a team of AulaGEO Academy experts to create, adapt to English and/or Spanish languages and curate cutting-edge courses.
Architecture – Engineering – Construction – Operation (AECO) is a harmonious blend of creativity and technical expertise. Our AECO courses encompass a broad range of topics, from Civil design principles to sustainable construction practices. You will gain proficiency in conceptualizing and developing designs that fulfill aesthetic, functional, structural and regulatory requirements. Our instructors, including renowned expert Golgi Alvarez, will guide you through the design process, helping you refine your visualization and communication skills. Furthermore, you will acquire a solid foundation in structural analysis and design, ensuring the safety and stability of your land development creations.
Geographic Information Systems (GIS) have revolutionized the way we collect, analyze, and visualize spatial data. Our GIS courses explore the power of GIS technology for mapping, spatial analysis, and data management. Using software like ArcGIS Pro and QGIS you will gain insights into interpreting and manipulating geospatial data, designing interactive maps, conducting spatial queries, and leveraging GIS for various applications, including land management, environmental analysis, and urban planning. Our GIS courses provide a competitive advantage in fields that rely on spatial data analysis and informed decision-making.
Civil Engineering plays a pivotal role in the design and construction of infrastructure. Our engineering courses cover a broad spectrum of topics, including structural engineering, transportation systems, and urban design. Using software like AutoDesk Civil3D and Bentley OpenRoads you will learn the principles and techniques required to design, construct, and maintain buildings, bridges, roads, and more. Our experienced instructors bring their industry expertise to the virtual classroom, providing valuable insights
Computer-Aided Design (CAD) is the backbone of modern design processes, enabling precise and efficient creation of 2D and 3D models. Our CAD courses cover a wide array of software applications, including AutoCAD, Microstation, and CREO Parametric. From fundamental concepts to advanced techniques, you will acquire the skills necessary to create, modify, and analyze complex designs, ensuring accuracy and optimizing workflows. Our courses cater to beginners seeking a solid foundation as well as experienced professionals aiming to enhance their expertise.
Building Information Modeling (BIM) has transformed the architecture, engineering, and construction industries by facilitating collaborative and data-driven project management. Our BIM courses delve into the principles, workflows, and software tools utilized in BIM, such as Revit and SYNCHRO. You will learn to create intelligent 3D models that encompass architectural, structural, and MEP (mechanical, electrical, and plumbing) systems. Additionally, you will discover techniques for accurate quantity extraction, clash detection, and generating construction documents. Mastery of BIM equips you to contribute effectively to multidisciplinary project teams and streamline project delivery.
ARTS & DEVELOPMENT
Additionally, as part of our social responsibility, some of our courses have been made available to development projects in certain countries. This has allowed us to benefit communities and replicate our methodology, leading to the creation of new courses in response to demand in areas such as graphic design, art, and social disciplines.
Copyright:
For copyright management and DMCA purposes, all the content of AulaGEO Academy is managed by Golgi Alvarez.
Researcher, writer and rich content creator.
More than 25 years working int the Geospatial and AEC industries:
-Infrastructure and civil work projects management
-CAD / GIS / Surveying & Construction training
-Land and Cadastre projects
-Land Administration and development projects
Golgi Alvarez is the founder of the Geofumadas website, with more than 1.900 articles about CAD, GIS, Surveying, Cadastre, BIM, Digital Twin and other trend topics. The website is over 170.000 visitors per month and 21.000 followers in twitter.
Golgi Alvarez is the founder of the TwinGeo magazine, attending on site conferences in USA, UK, Netherlands, Singapore, India, Spain, Mexico, Colombia, Chile, Guatemala and other countries.
Golgi Alvarez is the founder of the AulaGEO Academy, with more than 150 courses focused in geospatial, engineering and operation of land and infrastructure projects.
Copyright:
All the content of the AulaGEO Academy it´s owned and managed by Golgi Alvarez. If you have any question, you can cotact to info@zatoca.com