Although Microsoft Excel is a powerful spreadsheet out of the box, macros make it even more useful. You can create and record macros within the app.

You can easily assign a shortcut to a VBA sub procedure as follows: 1. Click the Developer tab. 2. In the Code group, click Macros. 3. In the resulting dialog, select the procedure and then click ...

Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.

Click the "New Button" in the Assign Macro window. The Microsoft Visual Basic for Applications editor window opens and appears on the screen.