with mcrow
Usual Excel work,
What happens if you leave it to a Macros?
You can experience before and after automating with macros while watching Key Nyan and Mauchu's work. In the final exercise, you will navigate the developer tab, enter code, and run it yourself. Please proceed with the conversation by pressing the Enter key or button.
Creating, formatting, and saving invoices
From posting details to calculating amounts, formatting, and saving PDF. Compare how many minutes it takes to do it manually and how many seconds it takes to do it with a Macros.
View operation image →Case 02Creating and printing graphs
Record the steps from creating a graph to printing it using "Macros Recording" and turn it into a Macros.
View operation image →Case 03Aggregation of multiple files
Read line by line to see what would happen if you wrote VBA code to aggregate the three files received from the branch.
View operation image →Final practiceYour first VBA macro: from setup to execution
Until I go to the developer tab, open the VBE, enter a short piece of code, and run it. Practice everything from preparation to writing code in your browser.
Try it yourself →How macros work and how to learn them"What is Macros function? Work efficiency improvement and career advancement that can be used in the AI era"Introducing.