CAD Automation Create flexible scripts using Excel

CAD Automation – Create flexible scripts using Excel, available at $44.99, has an average rating of 4.35, with 19 lectures, 3 quizzes, based on 13 reviews, and has 54 subscribers.

You will learn about Basic Excel functions – SUM, MAX, MIN, ROUND and more Advanced Excel Functions – Logic, Lookup & reference Adding Macros in Excel Create scripts to automate CAD using Excel Customising Draftsight user interface Customising AutoCAD user interface Command Macros for Draftsight & AutoCAD This course is ideal for individuals who are Draftsight or AutoCAD users wanting to automate tasks or drawings or Any CAD user wanting to learn how to automate drawings or Anyone wanting to learn Excel functions It is particularly useful for Draftsight or AutoCAD users wanting to automate tasks or drawings or Any CAD user wanting to learn how to automate drawings or Anyone wanting to learn Excel functions.

Enroll now: CAD Automation – Create flexible scripts using Excel

Summary

Title: CAD Automation – Create flexible scripts using Excel

Price: $44.99

Average Rating: 4.35

Number of Lectures: 19

Number of Quizzes: 3

Number of Published Lectures: 19

Number of Published Quizzes: 3

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: R299.99

Quality Status: approved

Status: Live

What You Will Learn

Basic Excel functions – SUM, MAX, MIN, ROUND and more

Advanced Excel Functions – Logic, Lookup & reference

Adding Macros in Excel

Create scripts to automate CAD using Excel

Customising Draftsight user interface

Customising AutoCAD user interface

Command Macros for Draftsight & AutoCAD

Who Should Attend

Draftsight or AutoCAD users wanting to automate tasks or drawings

Any CAD user wanting to learn how to automate drawings

Anyone wanting to learn Excel functions

Target Audiences

Draftsight or AutoCAD users wanting to automate tasks or drawings

Any CAD user wanting to learn how to automate drawings

Anyone wanting to learn Excel functions

A unique approach to CAD automation. This course is aimed at any Draftsight or AutoCAD user wanting to automate drawings or tasks. No programming or even Excel experience is required.

This course gives you an easy Excel based approach to CAD automation. Most CAD users are under the impression that coding or programming experience is required to automate drawings. This method uses one basic VBA code which is already written and provided. Adding this code is a simple copy and paste exercise.

Basic CAD knowledge is required but beginner CAD users should easily be able to follow along and even experienced CAD users will likely learn something new. Every Excel function needed to automate CAD is covered. CAD automation is often associated with high-cost CAD packages, but the approach taken in this course is affordable to all small businesses and even individuals. The software used in this course can generally be run on most computers and requires no special hardware requirements. FREE 30 day trial versions are available for both CAD packages. See system requirements for each within the respective website.

Real world examples and practical applications are shown so you can take the knowledge gained and apply it to your day to day working life. All content has been compiled by a CAD user, for the CAD user.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Overview

Lecture 2: Introduction

Chapter 2: Excel

Lecture 1: Excel introduction

Lecture 2: How to find a function in Excel

Lecture 3: Arithmetic functions

Lecture 4: Round, Max, Min & Average

Lecture 5: Logical functions

Lecture 6: Dropdowns, Sort & Transpose

Lecture 7: VLOOKUP

Lecture 8: Logic & conditional formatting continued

Lecture 9: Concatenate

Chapter 3: Script build & test

Lecture 1: Script Build & Test – Part_1

Lecture 2: Script Build & Test – Part_2

Lecture 3: Script Build & Test – Part_3

Lecture 4: Draftsight & AutoCAD command sequence comparison

Chapter 4: Streamlining the process

Lecture 1: Adding the Macro

Lecture 2: Draftsight – Customising the user interface and Command Macros

Lecture 3: AutoCAD – customising the user interface

Chapter 5: The End

Lecture 1: The End

Instructors

Marc Cooney
Draftsman, Craftsman & CAD fanatic.

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 4 votes

5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!