• views: 419
• date: 15 June 2022
• posted by: voska89

Automate your tasks by creating macros using Excel VBA
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
Requirements
Basic Excel Knowledge
A valid version of Microsoft Excel. Microsoft Excel 365 is preferred although not necessary.
No programming experience needed
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
Homepage

https://www.udemy.com/course/automate-tasks-excel-vba-macros-for-chemical-process-engineers/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.