IS320 Advanced Business Applications Spring 2021 Excel Macro Assignment Reporting Template

IS320 Advanced Business Applications Spring 2021 Excel Macro Assignment Reporting Template. a. Open an Excel workbook, save as follows: File Name: MDVolunteers Save As Type: Excel Macro-Enabled Workbook b. Sheet tabs should be changed to the months of the year, and one tab to say “Year Totals”. There should be 13 tabs in all. You may want to practice creating the template below before recording the macro. c. On the January sheet, click cell B3. To record a macro, click View/Macros/Record Macro Record a macro named “setup” with short-cut key “ctrl+shift+T” and create the following template. Be very careful; every keystroke will be recorded!!! You may select different colors, font styles, etc... , but the text information should be as shown. Totals are the sum of the row or column (Use the sum function). Don’t forget to “stop recording” when you are finished with the design. View/Macros/Stop Recording d. Test your work by switching to the February tab, click B3 and run your macro. (View/Macros/View Macros/Run) Then manually change the month on the spreadsheet to February. e. Edit program code, view/macros/view macros/edit, and examine VBA code. Locate line of code to edit and change month to March. Close code editor. f. On the March tab cell B3, run the macro. Check for accuracy. Don’t forget to Save excel workbook; save as type “Excel Macro Enabled Workbook". Keep for next week. IS320 – Advanced Business Applications Exam 2 topics covered Exam study suggestions; study slides, solutions, tutorial D, SBA.gov, SQL, Macro code, Case study designs Topics covered. 1. SQL statements - using SELECT, FROM, WHERE, ORDER BY, INNER JOIN, - Examples 2. Database design - Dog hikes - Parks and Recs - Senior Concierge - Baltimore Furniture Warehouse 3.Excel - Solver; purpose of this Excel feature -Easy formulas - Hard formulas - Solver Constraints 4. Excel Macros - Examine and modify code 5. SBA.gov Business Plan - Importance of plan - Executive summary - Company Description - Market Analysis - Organization and Management - Service or Product line - Marketing and Sales 6. Entrepreneurship -Failure links https://www.entrepreneur.com/article/244581 https://smallbiztrends.com/2016/01/entrepreneurs-who-failed.html https://www.entrepreneur.com/article/240492 7. CRM, customer relationship management