{"id":2986,"date":"2019-12-19T22:56:59","date_gmt":"2019-12-19T22:56:59","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=2986"},"modified":"2024-05-16T19:30:35","modified_gmt":"2024-05-16T19:30:35","slug":"macros","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/macros\/","title":{"raw":"Macros","rendered":"Macros"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Use macros to complete actions in Microsoft Excel<\/li>\r\n<\/ul>\r\n<\/div>\r\nMacros are programs used to automate frequently used processes or tasks in Excel. A macro records operations and re-uses the sequence of mouse actions or keystrokes of anything you can do in Excel with keystrokes or a mouse. Some of those actions include; cleaning up data, formatting cells, creating tables or organizing data in an Excel spreadsheet. If you have done repetitive tasks with a spreadsheet before, you may already have discovered macros. If you have not discovered them, learn this advanced Excel tool to speed up your efficiency and save time.\r\n\r\nFirst, watch the following video which gives an overall example of how to program a macro in order to change the formatting on a sales report. After the video, we\u2019ll walk through a macro step by step and highlight a few of the commonly used actions to be program into a macro.\r\n\r\n<iframe src=\"\/\/plugin.3playmedia.com\/show?mf=1578465&amp;p3sdk_version=1.10.1&amp;p=20361&amp;pt=375&amp;video_id=W_PEdMArF0k&amp;video_target=tpm-plugin-m1v80t3w-W_PEdMArF0k\" width=\"800px\" height=\"450px\" frameborder=\"0\" marginwidth=\"0px\" marginheight=\"0px\"><\/iframe>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/690ba1e6-da08-4f17-9dde-4bf45800835e\r\n\r\n<\/div>\r\n<h2>Macro Recording Locations<\/h2>\r\nA macro has three main ways to be recorded. Two are from the ribbon area and one is not. Experiment and find your favorite way to record it.\r\n\r\nHow to record a macro:\r\n<ol>\r\n \t<li>From the <strong>View<\/strong> tab, click the <strong>Macros<\/strong> button, and then the <strong>Record Macro<\/strong> button.\r\n<img class=\"alignnone wp-image-2991 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/19184540\/Module_8_Advanced_Excel_Macros_1_3.png\" alt=\"Excel menu bar displaying the View tab, Macros button with dropdown menu including View Macros, Record Macros, Use Relative References\" width=\"1305\" height=\"244\" \/><\/li>\r\n \t<li>The video demonstrates how to make the developer tab appear in the menu. Here are the steps to follow:\r\n<ul>\r\n \t<li>Go to <strong>File<\/strong>, <strong>Options<\/strong>, <strong>Customize Ribbon<\/strong>, then check the <strong>Developer<\/strong> check box and click <strong>OK<\/strong>.\r\n<img class=\"alignnone wp-image-2989\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/19184443\/Module_8_Advanced_Excel_Macros_1_1.png\" alt=\"Screenshot of Excel Options window highlighting actions to make Developer tab visible.\" width=\"635\" height=\"519\" \/><\/li>\r\n \t<li>Going back to the main menu, the <strong>Developer tab<\/strong> is now visible. Click on it, and go to the <strong>Code<\/strong> group, and select the <strong>Record Macro<\/strong> button.\r\n<img class=\"alignnone wp-image-2988 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/19184416\/Module_8_Advanced_Excel_Macros_1_2.png\" alt=\"Excel menu bar displaying the Developer tab, Macros in Code area on ribbon.\" width=\"1043\" height=\"170\" \/><\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>The last main recording area is for the Macros button is at bottom left of spreadsheet window. Click on the button and a Macro dialog box opens to be filled out to begin recording.\r\n<img class=\"alignnone wp-image-2992 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/19184616\/Module_8_Advanced_Excel_Macros_1_7.png\" alt=\"Excel screenshot of open worksheet filled with data highlighting the small record macro button on bottom lower left of window.\" width=\"1308\" height=\"883\" \/><\/li>\r\n<\/ol>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/ca666fc4-9083-470f-a5a8-54368efcd2b6\r\n\r\n<\/div>\r\nMacros are recorded in a program called Visual Basic. To edit a macro, the developer tab needed to access the Visual Basic program. We will not be diving into Visual Basic this time as an entire course all on its own. For now we will stay with the macro recording basics.","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Use macros to complete actions in Microsoft Excel<\/li>\n<\/ul>\n<\/div>\n<p>Macros are programs used to automate frequently used processes or tasks in Excel. A macro records operations and re-uses the sequence of mouse actions or keystrokes of anything you can do in Excel with keystrokes or a mouse. Some of those actions include; cleaning up data, formatting cells, creating tables or organizing data in an Excel spreadsheet. If you have done repetitive tasks with a spreadsheet before, you may already have discovered macros. If you have not discovered them, learn this advanced Excel tool to speed up your efficiency and save time.<\/p>\n<p>First, watch the following video which gives an overall example of how to program a macro in order to change the formatting on a sales report. After the video, we\u2019ll walk through a macro step by step and highlight a few of the commonly used actions to be program into a macro.<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/plugin.3playmedia.com\/show?mf=1578465&amp;p3sdk_version=1.10.1&amp;p=20361&amp;pt=375&amp;video_id=W_PEdMArF0k&amp;video_target=tpm-plugin-m1v80t3w-W_PEdMArF0k\" width=\"800px\" height=\"450px\" frameborder=\"0\" marginwidth=\"0px\" marginheight=\"0px\"><\/iframe><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_690ba1e6-da08-4f17-9dde-4bf45800835e\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/690ba1e6-da08-4f17-9dde-4bf45800835e?iframe_resize_id=assessment_practice_id_690ba1e6-da08-4f17-9dde-4bf45800835e\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Macro Recording Locations<\/h2>\n<p>A macro has three main ways to be recorded. Two are from the ribbon area and one is not. Experiment and find your favorite way to record it.<\/p>\n<p>How to record a macro:<\/p>\n<ol>\n<li>From the <strong>View<\/strong> tab, click the <strong>Macros<\/strong> button, and then the <strong>Record Macro<\/strong> button.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2991 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/19184540\/Module_8_Advanced_Excel_Macros_1_3.png\" alt=\"Excel menu bar displaying the View tab, Macros button with dropdown menu including View Macros, Record Macros, Use Relative References\" width=\"1305\" height=\"244\" \/><\/li>\n<li>The video demonstrates how to make the developer tab appear in the menu. Here are the steps to follow:\n<ul>\n<li>Go to <strong>File<\/strong>, <strong>Options<\/strong>, <strong>Customize Ribbon<\/strong>, then check the <strong>Developer<\/strong> check box and click <strong>OK<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2989\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/19184443\/Module_8_Advanced_Excel_Macros_1_1.png\" alt=\"Screenshot of Excel Options window highlighting actions to make Developer tab visible.\" width=\"635\" height=\"519\" \/><\/li>\n<li>Going back to the main menu, the <strong>Developer tab<\/strong> is now visible. Click on it, and go to the <strong>Code<\/strong> group, and select the <strong>Record Macro<\/strong> button.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2988 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/19184416\/Module_8_Advanced_Excel_Macros_1_2.png\" alt=\"Excel menu bar displaying the Developer tab, Macros in Code area on ribbon.\" width=\"1043\" height=\"170\" \/><\/li>\n<\/ul>\n<\/li>\n<li>The last main recording area is for the Macros button is at bottom left of spreadsheet window. Click on the button and a Macro dialog box opens to be filled out to begin recording.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2992 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/19184616\/Module_8_Advanced_Excel_Macros_1_7.png\" alt=\"Excel screenshot of open worksheet filled with data highlighting the small record macro button on bottom lower left of window.\" width=\"1308\" height=\"883\" \/><\/li>\n<\/ol>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_ca666fc4-9083-470f-a5a8-54368efcd2b6\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/ca666fc4-9083-470f-a5a8-54368efcd2b6?iframe_resize_id=assessment_practice_id_ca666fc4-9083-470f-a5a8-54368efcd2b6\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p>Macros are recorded in a program called Visual Basic. To edit a macro, the developer tab needed to access the Visual Basic program. We will not be diving into Visual Basic this time as an entire course all on its own. For now we will stay with the macro recording basics.<\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-2986\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Macros. <strong>Authored by<\/strong>: Sherri Pendleton. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Shared previously<\/div><ul class=\"citation-list\"><li>Using Macros | Excel 2016. <strong>Provided by<\/strong>: Burn to Learn. <strong>Located at<\/strong>: <a target=\"_blank\" href=\"https:\/\/youtu.be\/W_PEdMArF0k\">https:\/\/youtu.be\/W_PEdMArF0k<\/a>. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":17,"menu_order":10,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Macros\",\"author\":\"Sherri Pendleton\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"},{\"type\":\"cc\",\"description\":\"Using Macros | Excel 2016\",\"author\":\"\",\"organization\":\"Burn to Learn\",\"url\":\"https:\/\/youtu.be\/W_PEdMArF0k\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"1606d0b3-6f5d-4d9d-ae7e-9fc8fa1a3c76, f6fd36ce-bec7-49a0-8ac9-bcd4ca11ba83","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-2986","chapter","type-chapter","status-publish","hentry"],"part":2771,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/2986","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":8,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/2986\/revisions"}],"predecessor-version":[{"id":5853,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/2986\/revisions\/5853"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/2771"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/2986\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=2986"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=2986"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=2986"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=2986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}