Now, instead of calculating the total marks of each student one by one, you can record a macro by performing the task on one student and then you can easily automate the same thing with other students by simply running the macro. For instance, you have a spreadsheet consisting of a list of students with their scores listed in different subjects.

In simple terms, a macro lets you automate repeated tasks such as calculating the sum total of marks of students in different subjects.

Before we tell you how to enable macros, it is important to know what a macro is in Microsoft Excel.