Microsoft 365 always comes with a set of software that can make the work of its users easier. Among others there are ExcelWord, PowerPoint, One Drive, One Note, Project, Outlook and Microsoft Teams.
Interestingly, Microsoft 365 software is also very possible to connect with each other. For example, any files or archives you create can be placed in One Drive, which is Microsoft’s storage service. You can store up to 5GB of files for free.
This time, Katadata.co.id will discuss more about Excel. Software spreadsheet it first appeared for computers running Windows in 1987.
Up to now, Excel is still at the peak of application popularity spreadsheet commonly used. In addition, Microsoft also frequently makes updates that fit today’s needs.
Likewise with Excel which can be linked to One Drive. One of the features that can be used is the editing of documents online by multiple users. You have to upload file in One Drive and share it with colleagues.
But on this occasion, we will focus on the discussion of Macro Excel. Quoted from the site Microsoft support, Macros or Macros are a set of constraints that can be used to automate repetitive tasks and can be executed when a task is required. Macros can automate frequently used tasks. The goal is to save time by not always pressing keys, sliders, or mouse.
It can be concluded that Macro Excel is a system that can automate the tasks performed in Excel which are often performed repeatedly. Due to its repetitive nature, Macro Excel offers automated features to make it simple and concise.
Excel macros using a programming language Visual Basic for the application (VBA). Macros in Excel are User defined function (UDF). Macros are capable of recording tasks or work that you do often.
To enable macros in Excel, you can check in the tools section, then enter macros and security. Then, enable the Macro setting. More in detail, here’s how to create a function with UDF successfully launched by the site Training solutions.
Creating functions in Excel with user-defined functions
1. Open it Visual Basic Editor (VBE) on Tape
2. click on the tab Developer and the Visual Basic for Application (VBA) window will appear.
3. Click on Menu Module
4. Enter the code on Module For example, you will calculate speed=distance/time, the excel formula is =20/10. This can change to =speed(distance, time) or =speed(20,10). Then the formula Function speed (distance As Whole number, we time Whole number)
5. Click on ‘Save as‘
6. Select the file type/formatMacro-enabled Excel Workbook.’
Like this only, apparently there’s an easier way to run Excel macros. Summary by Microsoft Support, below the steps.
How to run Excel macros
1. Open an Excel file
2. Click on the “View” tab o ‘view’
3. On the far left, click “Macros”
4. Select the “Show macro” option.
5. Select Workbook you want to apply the Macro to
6. Enter the task for which you want to create a macro
7. Click “Run” or ‘Run.’
How to Record Excel Macros with Buttons
As explained earlier, macros can record frequently performed jobs or tasks. But you can also register manually.
1. Open an Excel file
2. Click on the “View” tab o ‘view’
3. On the far left, click “Macros”
4. Select the “Record Macro” option.
5. Enter the name of the Macro
6. Select the document to apply the Macro to
7. Click “Button”
8. Click on the new Macro
9. Click “Change”
10. Select the button icon when you want to change
11. Type the desired name
12. Click “OK”.
13. Click on “Macros” in the tab ‘view’
14. Click “Stop Recording”.
15. Use Macro by pressing the button icon in the Quick Access Toolbar row in the upper left corner.
How to record Excel macros with keyboard
Different from the above method, you can trigger macros with hotkeys or keyboard.
1. Open an Excel file
2. Click on the “View” tab o ‘view’
3. On the far left, click “Macros”
4. Select the “Record Macro” option.
5. Enter the name of the Macro
6. Select the document to apply the Macro to
7. Click ‘Keyboard’
8. Type the key combination in the “Press new hotkey” field.
9. Make sure the key combination has never been used before
10. When “Save Changes To” shows “Normal.dotm”, it means the macro was successfully recorded
11. Click on “Assign” or ‘Run’
12. Click “Macros” in the tab ‘view’
13. Click “Stop Recording”
14. Tap the button combination when you want to use Macro
Then a complete explanation of Macro Excel and its methods. Basically, macros are a feature that can save you time while using Excel. However, the above methods can also be applied to Microsoft Word. The method is exactly the same because the button layout is also similar.
