{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Tutorial","Intro","Part 1","1st Quarter","Part 2","Part 3","2nd Quarter","Summary"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Tutorial","index":0,"n_rows":6,"n_cols":12,"rows_kept":6,"merged":[[0,0,0,13],[1,0,4,13],[5,11,5,13]]}
["Macro Tutorial"]
["In this tutorial, we will:\n        1. Record a macro,\n        2. Change a worksheet based on instructions,\n        3. Apply the same changes to another worksheet by running the macro."]
[]
[]
[]
[{"$nulls":11},"Let's Start! ®"]

{"sheet":"Intro","index":1,"n_rows":8,"n_cols":10,"rows_kept":8,"merged":[[0,0,0,13],[1,0,5,13],[7,1,7,2],[7,9,7,13]]}
["Introduction"]
["This tutorial has 3 parts:\n        1. Recording the macro,\n        2. Saving the Excel file as Excel Macro-Enabled file (.xlsm), and\n        3. Applying the macro on another sheet.\n\nNote: Read the instructions in each part before doing the tasks in that part."]
[]
[]
[]
[]
[]
[null,"¬ Back",{"$nulls":7},"Click to go to Part 1 ®"]

{"sheet":"Part 1","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"merged":[[0,0,0,13],[1,0,6,13],[7,1,7,2],[7,10,7,13]]}
["Part 1: Instructions"]
["1. Open the \"1st Quarter\" sheet.\n2. Click the Developer tab ® 'Record Macro' to start a new macro recording.\n3. Perform the following tasks while the macro is being recorded:\n        a. Add any background (fill) color of your choice to the heading row (A3:E3),\n        b. Add filters to that headings rows,\n        c. Add the SUM function in the empty column (E4:E7) to compute the sums per row.\n4. Click 'Stop Recording' to finish the recording."]
[]
[]
[]
[]
[]
[null,"¬ Back",{"$nulls":8},"To \"1st Quarter\" ®"]

{"sheet":"1st Quarter","index":3,"n_rows":9,"n_cols":9,"rows_kept":9,"merged":[[0,0,0,4],[0,6,0,12],[1,6,6,12],[7,8,7,12],[8,6,8,7]]}
["Montly Expenses: Quarter 1",{"$nulls":5},"Reminders"]
[{"$nulls":6},"Start recording a new macro, and:\n        1. Set a fill color to A3:E3,\n        2. Add filters to A3:E3,\n        3. Add a per-row SUM to E4:E7.\nThen, stop the recording, and click the button below."]
["Type","January","February","March","Total"]
["Rent",{"v":1500,"d":"$1,500.00"},{"v":1500,"d":"$1,500.00"},{"v":1500,"d":"$1,500.00"}]
["Fuel",{"v":245,"d":"$245.00"},{"v":123,"d":"$123.00"},{"v":342,"d":"$342.00"}]
["Food",{"v":564,"d":"$564.00"},{"v":365,"d":"$365.00"},{"v":465,"d":"$465.00"}]
["Trips",{"v":23,"d":"$23.00"},{"v":0,"d":"$0.00"},{"v":560,"d":"$560.00"}]
[{"$nulls":8},"Click to go to Part 2 ®"]
[{"$nulls":6},"¬ Back"]

{"sheet":"Part 2","index":4,"n_rows":8,"n_cols":10,"rows_kept":8,"merged":[[0,0,0,13],[1,0,3,13],[4,0,5,13],[6,0,6,13],[7,1,7,2],[7,9,7,13]]}
["Part 2: Instructions"]
["Now that you sucessfully recorded the macro, you'll save the Excel file as a Macro-Enabled Workbook (.xlsm). Do so now by clicking File ® Save As ® Browse, and then saving it as Excel Macro-Enabled Workbook (*.xlsm)."]
[]
[]
["Warning: If you keep the file as a regular Excel file (.xlsx), the macro will be permanently erased when you close the file, and you'll need to record the macro again!"]
[]
["Once you're done, click below to go to Part 3."]
[null,"¬ Back",{"$nulls":7},"Click to go to Part 3 ®"]

{"sheet":"Part 3","index":5,"n_rows":8,"n_cols":11,"rows_kept":8,"merged":[[0,0,0,13],[1,0,4,13],[5,0,6,13],[7,1,7,2],[7,10,7,13]]}
["Part 3: Instructions"]
["Let's apply the exact same changes to another sheet, \"2nd Quarter\", but this time by activating the macro we created earlier!\n        1. Open the \"2nd Quarter\" spreadsheet,\n        2. Click the Developer tab ® 'Macros' button,\n        3. Click the macro's name ® 'Run' button."]
[]
[]
[]
["If the fill color, the filters, and the SUM function were correctly added, you succeeded in applying the macro! Congrats!!!"]
[]
[null,"¬ Back",{"$nulls":8},"To \"2nd Quarter\" ®"]

{"sheet":"2nd Quarter","index":6,"n_rows":9,"n_cols":9,"rows_kept":9,"merged":[[0,0,0,4],[0,6,0,12],[1,6,3,12],[4,6,6,12],[7,8,7,12],[8,6,8,7]]}
["Montly Expenses: Quarter 2",{"$nulls":5},"Reminders"]
[{"$nulls":6},"        1. Click Developer ® 'Macros',\n        2. Click the macro's name,\n        3. Click the 'Run' button.\n"]
["Type","April","May","June","Total"]
["Rent",{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"}]
["Fuel",{"v":590,"d":"$590.00"},{"v":0,"d":"$0.00"},{"v":123,"d":"$123.00"},null,null,"After all the changes were applied, click to open the activity Summary."]
["Food",{"v":564,"d":"$564.00"},{"v":365,"d":"$365.00"},{"v":465,"d":"$465.00"}]
["Trips",{"v":1002,"d":"$1,002.00"},{"v":347,"d":"$347.00"},{"v":1200,"d":"$1,200.00"}]
[{"$nulls":8},"Open the Summary ®"]
[{"$nulls":6},"¬ Back"]

{"sheet":"Summary","index":7,"n_rows":8,"n_cols":2,"rows_kept":8,"merged":[[0,0,0,13],[1,0,5,13],[7,1,7,2],[7,9,7,13]]}
["Summary"]
["In this tutorial, you learned and practiced the creation of a macro, the saving of the workbook as macro-enabled to prevent the deletion of the macro, and the successful application of the macro to another sheet with data.\n\nYou've just acquired a super-precious tool that you can use for future projects to save a great deal of time! Yay! 🎊🎉👌🤩"]
[]
[]
[]
[]
[]
[null,"¬ Back"]