Excel VBA for Chemical Engineers

سرفصل های دوره

Automate your tasks by creating macros using Excel VBA as a chemical engineer

1. Introduction

1. Introduction

2. Basic Programming and VBA Concepts

1. Access the Developers Ribbon and Record your First Macro

2. Data Types Doubles, Strings, Arrays, and Objects

3. Add, subtract, concatenate variables and convert them to other data types

4. Manipulate strings Get substrings and check if specific characters exist

5. Conditionals If and Select Statements

6. Control the output using Excel Input box and if statement

7. Loops For and For Each

8. Combine Conditions with Loops

9. Sub procedures and Functions

3. Excel VBA Objects

1. What are Excel objects

2. Excel Workbook Objects

4. Lets start applying (Re-group tables)

1. Add new worksheets automatically

2. Add the data in the format we need in the new sheets

5. Create custom Excel Formula (Pipe Sizing)

1. How the Pipe Sizing Procedure Works

2. Get Preliminary pipe diameter based on maximum velocity criteria

3. Get final pipe diameter based on pressure drop criteria

6. Add customized external calculation sheets to main sheet based on user input

1. Overview

2. Define variables based on user Input

3. Add customized pipe sizing sheets if they exist

4. Link the original pump sizing sheet with added pipe sizing sheets

7. Automate your copy and paste task from a file to another

1. Macro overview

2. Add data based on fixed cell reference

3. Add data more elegantly using arrays

4. Control the cells to copy and paste from and to depending on user input

8. Copy and paste from multiple files to corresponding new templates

1. Access more than one file and create a new directory if it exists

2. Check the files in the directory add new files or fill existing files

3. Save generated files as pdf

9. Resources

1.1 app 1 group tables.zip

1.2 app 2 pipe sizing.zip

1.3 app 3 add pipe sizing sheets to pump calculation p-1.zip

1.4 app 4 automated copy and paste.zip

1.5 app 5 bulk automated copy and paste.zip

1.6 basics.zip

1. Recources.html

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training