Summarize the following:
Macros are a built in function that allow you to automate complex and repetitive tasks. Double-click (or click if you're on a Mac) the Excel app icon, which resembles a white "X" on a green background, then click Blank Workbook on the templates page. On a Mac, you may have to click File and then click New Blank Workbook in the resulting drop-down menu. If you already have an Excel report that you want to automate, you'll instead double-click the report's file to open it in Excel. If you haven't added the column labels and numbers for which you want to automate results, do so before proceeding. By default, the Developer tab doesn't show up at the top of the Excel window. You can enable it by doing the following depending on your operating system: Windows Click File, click Options, click Customize Ribbon on the left side of the window, check the "Developer" box in the lower-right side of the window (you may first have to scroll down), and click OK. Mac Click Excel, click Preferences..., click Ribbon & Toolbar, check the "Developer" box in the "Main Tabs" list, and click Save. This tab should now be at the top of the Excel window. Doing so brings up a toolbar at the top of the Excel window. It's in the toolbar. A pop-up window will appear. In the "Macro name" text box, type in the name for your macro. This will help you identify the macro later. For example, if you're creating a macro that will make a chart out of your available data, you might name it "Chart1" or similar. Press the Shift key along with another key (e.g., the T key) to create the keyboard shortcut. This is what you'll use to run your macro later. On a Mac, the shortcut key combination will end up being Option+ Command and your key (e.g., Option+ Command+T). Click the "Store macro in" drop-down box, then click This Workbook to ensure that the macro will be available for anyone who opens the workbook. You'll have to save the Excel file in a special format for the macro to be saved. It's at the bottom of the window. Doing so will save your macro settings and place you in record mode. Any steps you take from now until you stop the recording will be recorded. Excel will track every click, keystroke, and formatting option you enter and add them to the macro's list. For example, to select data and create a chart out of it, you would highlight your data, click Insert at the top of the Excel window, click a chart type, click the chart format that you want to use, and edit the chart as needed. If you wanted to use the macro to add values from cells A1 through A12, you would click an empty cell, type in =SUM(A1:A12), and press Enter. It's in the Developer tab's toolbar. This will stop your recording and save any steps you took during the recording as an individual macro. Click File, click Save As, and change the file format to xlsm instead of xls. You can then enter a file name, select a file location, and click Save. If you don't do this, the macro won't be saved as part of the spreadsheet, meaning that other people on different computers won't be able to use your macro if you send the workbook to them. Press the key combination which you created as part of the macro to do so. You should see your spreadsheet automate according to your macro's steps. You can also run a macro by clicking Macros in the Developer tab, selecting your macro's name, and clicking Run.
If the data you need to report on is already stored, updated, and maintained in Excel, you can automate reporting workflows using Macros. Open Excel. Enter your spreadsheet's data if necessary. Enable the Developer tab. Click Developer. Click Record Macro. Enter a name for the macro. Create a shortcut key combination for the macro. Store the macro in the current Excel document. Click OK. Perform the steps that you want to automate. Click Stop Recording. Save your Excel sheet as a macro-enabled file. Run your macro.