Excel VBA for Chemical Engineers

Focused View

Boostrand Training

5:05:07

162 View

1. Introduction

1. Introduction.mp4

01:08

2. Basic Programming and VBA Concepts

1. Access the Developers Ribbon and Record your First Macro.mp4

13:22

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

16:15

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

08:00

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

09:26

5. Conditionals If and Select Statements.mp4

08:58

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

03:40

7. Loops For and For Each.mp4

07:50

8. Combine Conditions with Loops.mp4

06:26

9. Sub procedures and Functions.mp4

08:42

3. Excel VBA Objects

1. What are Excel objects.mp4

03:55

2. Excel Workbook Objects.mp4

09:12

4. Lets start applying (Re-group tables)

1. Add new worksheets automatically.mp4

16:49

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

14:08

5. Create custom Excel Formula (Pipe Sizing)

1. How the Pipe Sizing Procedure Works.mp4

03:45

2. Get Preliminary pipe diameter based on maximum velocity criteria.mp4

21:07

3. Get final pipe diameter based on pressure drop criteria.mp4

14:08

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

1. Overview.mp4

04:19

2. Define variables based on user Input.mp4

14:12

3. Add customized pipe sizing sheets if they exist.mp4

15:33

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

22:25

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

1. Macro overview.mp4

01:57

2. Add data based on fixed cell reference.mp4

17:13

3. Add data more elegantly using arrays.mp4

05:11

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

19:14

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.mp4

10:57

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

25:28

3. Save generated files as pdf.mp4

01:47

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

Description

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

What You'll Learn?

Learn basic programming principles in VBA
Understand how to use Excel macros to automate tasks
See how to create custom functions in Excel using VBA that can be used as Excel formulas
See applications of VBA subroutines and functions in engineering tasks

Who is this for?

Engineers who want to automate their daily tasks using Excel VBA

More details

Description
So maybe you have many repetitive tasks that you are doing manually. These are consuming a lot of time, and are prone to mistakes. If this is the case, then this course is for you.
What if we can automate our tasks? This would save us a lot of time, reduce the probability of making mistakes or even eliminate it, and shall let us focus on tasks that need more thinking. This can be done using Excel VBA macros.
So through this course, we see:
What the Excel developer ribbon looks like, and how to record or write a macro.
Main programming concepts, such as data types, conditions, loops, and functions.
Discover Excel objects, which are the main interface Excel gives us to access its workbook files and worksheets up to cells.
Then we shall start the real fun, we shall start applying the above concepts to create macros that can automate tasks. Examples may be more related to chemical engineering tasks, but the concept still applies to tasks related to any field.

With a button click, we shall:
Display data based on user input on Excel Input Box
See how to group tables in the format we need and add them to different sheets.
Add external sheets to our Excel calculation and link them with the main sheet depending on the user input on specific cells.
Create custom functions that can be used as an Excel formula
Copy data from a file to another automatically
Apply the previous point on a bulk of files, where we shall:
Create a new directory
Generate files format we need
Copy data from each file to the corresponding new file
Save the new file as pdf
All this with a button click.
Through the course, we shall write code step by step, we shall see errors and how to solve them, and how to test the results before applying the macros.
Hope to see you in the course!!
Who this course is for:
Engineers who want to automate their daily tasks using Excel VBA

User Reviews

Rating

average 0

Total votes0

Focused display

Boostrand Training is dedicated to introducing courses aiming to help chemical engineers start their career in Process Engineering. With a chemical engineering background and more than 8 years of experience as a process engineer in oil and gas projects, including in Refining, Petrochemicals, Gas Processing, and Oil Facilities, Boostrand Training hopes it can help new graduates understand how these projects work and how units are designed throughout my courses.Through coding knowledge, Boostrand Training also aims to introduce the concept of automation of tasks of a process engineer through tools that depend on programming.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.