Tutorial Playlist
68 Lessons1. Excel Tutorial
2. Excel Worksheet for Practice
3. Google Sheets Vs. Excel
4. Excel Shortcut Keys
5. Excel Keyboard Shortcuts
6. Excel AutoSum Shortcut
7. Redo Shortcut in Excel
8. Charts in Excel
9. Pivot Charts in Excel
10. Excel Sum Formula
11. Excel Percentage Formula
12. Excel Age Calculation Formula
13. Excel Range Formula
14. Round Off Formula in Excel
15. VLOOKUP Formula in Excel
16. Excel Transpose Formula
17. Average Equation in Excel
18. How to Use DATEDIF Formula in Excel
19. IRR Formula in Excel
20. Standard Deviation Formula
21. Excel Age Calculation Formula
22. Excel MAX Function
23. Excel LEFT Function
24. Excel RIGHT Function
25. Trim Function In Excel
26. LookUp function in Excel
27. Columns in Excel
28. How To Sort Data In Excel
29. How To Freeze Panes in Excel
30. Page Setup in Excel
31. How to Recover an Unsaved Excel File
32. Concatenate in Excel
33. Count In Excel
34. IF Condition In Excel
35. H LOOK UP in Excel
36. How Do You Move Columns in Excel
37. Split Cells in Excel
38. Remove Blank Rows in Excel
39. How To Lock Cells in Excel
40. Data Validation in Excel
41. How to Insert Checkbox in Excel
42. How To Highlight Duplicates in Excel
43. Fill Series in Excel
44. How to Create Excel Drop-Down List
45. What-If Analysis in Excel
46. How to Use SUMIFS Function in Excel
47. INDIRECT Function in Excel
48. Pivot Table in Excel
49. Slicers in Excel
50. How to Create a Dashboard in Excel
51. Excel Data Cleaning
52. Data Analysis In Excel
53. Goal Seek in Excel
54. Solver in Excel
55. Power Query in Excel
56. Macros In Excel
Now Reading
57. How To Make Graph in Excel
58. How To Make Histogram In Excel
59. How To Convert PDF to Excel Without Software
60. Barcode Font For Excel
61. Gantt Chart in Excel
62. Excel RANK function
63. AND Function in Excel
64. How to Calculate NPV
65. Format Painter in Excel
66. Count Colored Cells in Excel
67. Amortization Schedule in Excel
68. Master Cell References in Excel
Macros in Excel are object-oriented programs (Macros can be called Subroutine, Procedure, Program, or Code). It is mainly a set of actions that you can run as many times as you want. A macro is a piece of code, written in a programming language i.e. VBA, or Visual Basic for Applications, serves as the embedded programming language in Excel and other Microsoft Office applications like Word and PowerPoint. It provides a powerful platform for automating tasks, enhancing functionality, and extending the capabilities of these programs.
In my experience, macros in Excel have been instrumental in simplifying complex tasks such as data analysis and project management. I generally use macros for repetitive and complex tasks, but, you can also curate new formulas to automate any other task of choice in Excel.
I’ve created an easy guide addressing questions like “what are macros in Excel”, “how to enable macros in Excel”, “what is the use of macro in Excel”. Keep reading to know more.
Learn how to enable macros in Excel with the steps I’ve provided below:
It takes hardly a minute to create a Macro.
Here you learn basically how to use macros in Excel. If you forget the Shortcut Key, you can still go and run the Macro from the Developer tab, here is a button called “Macros,” if you click on it a window will open, where you can see the Macro you had created, here you need to click on this “Run” button to run the Macro.
Learn how to create macros in Excel:
If you are an Excel user you might be acquainted with the term “Absolute” and “Relative” References. In case you are not, let me explain here!
If you put some random numbers in an Excel sheet and make a sum of those just by using the Sum formula, put Enter, and copy that formula down, you can notice that by default, the initial Cells are using Relative Cell referencing. That means Excel knows that if I drag a formula down, it needs to modify those Sum references and move each one down one.
However, there is something called Absolute Referencing. If I type ‘Tax’ in one cell and ‘15%’ in the next cell, and choose some random numbers to calculate 15% of those, I will do the calculation in a slightly different way, as in SUM ( value 1 * 15% ) here the value is multiplied by the absolute figure (15%) of the cell where ‘15%’ is written, so I’m making that cell absolute by locking the cell. When I’m going to drag this formula down, Excel is going to adjust the cell reference where we have a percentage (15%) because we were effectively locked to that cell.
When you record a Macro in Excel, it defaults to Absolute Referencing. This means that if you run the Macro in Cell A1, it will always start from Cell A1, which can be limiting. To overcome this, ensure that you activate "Use Relative References" from the Developer tab before recording your Macro. Also, be sure to select a different cell to conclude your Macro. This enables greater flexibility and adaptability when executing your Macros.
In the “Macro” window if you click on the “Edit” button, the VBA editor will open in a new window, where, whatever changes I have done, will be recorded as coding.
When you record a Macro in Excel, it defaults to Absolute Referencing. This means that if you run the Macro in Cell A1, it will always start from Cell A1, which can be limiting. To overcome this, ensure that you activate "Use Relative References" from the Developer tab before recording your Macro.
Also, be sure to select a different cell to conclude your Macro. This enables greater flexibility and adaptability when executing your Macros.
When attempting to save the file, you'll receive a message indicating that you cannot save a file containing Macros in a Macro-free workbook. If you wish to retain these features, select "No" when prompted.
Then choose a Macro Enabled File Type in the File Type list. In the “Save As” window, choose the “Excel Workbook” option from the ‘Save As type’ section. Then choose “Excel Macro Enabled Workbook”.
You'll notice a difference in the icons between workbooks with Macros and those without. Workbooks containing Macros will display a slightly distinct icon. Additionally, the file extension for a workbook with Macros is ".xlsm".
To elevate your tech expertise and go further in your career, you can take a look at these top 15 ways to improve your Excel skills.
Macros are undeniably invaluable tools, streamlining analysis and enhancing efficiency. I hope this Macros in Excel tutorial has equipped you with the knowledge you need.
Speaking of which, if you are looking to advance your career further, take a look at the bonafide certificate courses upGrad provides. Affiliated to prestigious universities and with curriculums curated by industry experts, these courses will not only give you the added expertise, but also a better chance at a better job position.
Macros in Excel, also known as subroutines or automated sequences, mimic keystrokes and mouse actions to accomplish repetitive tasks effortlessly. They're invaluable for data analysis in Excel, as well as in MS Word and PowerPoint.
You can easily run your macros by clicking on the ‘Macros’ option under Developer tab.
In order to create a macro in Excel, you can record your macro with necessary details, and then run it using your ‘Shortcut Key’. You can additionally write your own macro in the VBA editing window, where you write your code for your macro, and can run them.
To access macros quickly, use the shortcut Alt + F8, or navigate to the 'Macros' option within the Developer tab.
Macros can be recorded or written in Excel, you can run them using the shortcut key you suggest for each macro. Basically used in data analysis to replace time consuming steps.
Macros in MS Office, much like in Excel, consist of a series of commands or instructions that automate tasks, significantly saving time.
Devesh
Passionate about Transforming Data into Actionable Insights through Analytics, with over 3+ years of experience working in Data Analytics, Data V…Read More
Talk to our experts. We’re available 24/7.
Indian Nationals
1800 210 2020
Foreign Nationals
+918045604032
upGrad does not grant credit; credits are granted, accepted or transferred at the sole discretion of the relevant educational institution offering the diploma or degree. We advise you to enquire further regarding the suitability of this program for your academic, professional requirements and job prospects before enrolling. upGrad does not make any representations regarding the recognition or equivalence of the credits or credentials awarded, unless otherwise expressly stated. Success depends on individual qualifications, experience, and efforts in seeking employment.
upGrad does not grant credit; credits are granted, accepted or transferred at the sole discretion of the relevant educational institution offering the diploma or degree. We advise you to enquire further regarding the suitability of this program for your academic, professional requirements and job prospects before enr...