#Modules_9-12_SAM_Critical_Thinking_Capstone_Project_1c #NP_EX19_CT_CS9-12c #Modules9-12SAMCriticalThinkingCapstoneProject1c #Excel Modules 9-12 #ExcelModules9-12 #NewPerspectivesExcel2019Modules9-12SAMCriticalThinkingCapstoneProject1c #New_Perspectives_Excel_2019_Modules_9_12_SAM_Critical_Thinking_Capstone_Project_1c #W&K_Engineering #W&KEngineering
Contact Me
Email :cengagesolutions@gmail.com
WhatsApp:+923096000718
WhatsApp Direct Chat : wa.link/sspsfs
#New_Perspectives_Excel_2019_Modules_9_12_SAM_Critical_Thinking_Capstone_Project_1c
#NewPerspectivesExcel2019Modules9-12SAMCriticalThinkingCapstoneProject1c
#New Perspectives Excel 2019 Modules 9-12 SAM Critical Thinking Capstone Project 1c
#Excel Modules 9-12 SAM Critical Thinking Capstone Project 1c
#Excel_Modules_9_12_SAM_Critical_Thinking_Capstone_Project_1c
#ExcelModules9-12SAMCriticalThinkingCapstoneProject1c
#Excel Capstone Project 9-12
#ExcelCapstoneProject9-12
#Excel_Capstone_Project_9_12
#Excel Critical Thinking Capstone Project 9-12 W&K Engineering
#ExcelCriticalThinkingCapstoneProject9-12W&KEngineering
#Excel_Critical_Thinking_Capstone_Project_9_12_ W&K_Engineering
#NP_EX19_CT_CS9-12c_FirstLastName_1.xlsx
#NP_EX19_CT_CS9-12c_FirstLastName_2.xlsx
#NP_EX19_CT_CS9-12c
#W&K Engineering
#W&KEngineering
#W&K_Engineering
#ANALYZE DATA AND WORK WITH FINANCIAL TOOLS
#ANALYZE_DATA_AND_WORK_WITH_FINANCIAL_TOOLS
#ANALYZEDATAANDWORKWITHFINANCIALTOOLS
#Shelly_Cashman_Excel_2019_Modules_9_12_SAM_Critical_Thinking_Capstone_Project_1c
#ShellyCashmanExcel2019Modules9-12SAMCriticalThinkingCapstoneProject1c
#Shelly Cashman Excel 2019 Modules 9-12 SAM Critical Thinking Capstone Project 1c
#ShellyCashmanExcel2019
#NewPerspectivesExcel2019
#Capstone
#capstoneproject
PROJECT STEPS
1. Hwan Sung is a financial analyst at W&K Engineering in Bismarck, North Dakota. He is using an Excel workbook to analyze the financial data for engineering projects, recent revenue, and funding for additional construction equipment. He asks for your help in analyzing data, making financial calculations, and correcting errors.
Go to the Projects worksheet and then unprotect it so you can edit the contents.
2. The engineering projects table should show projects from multiple states. Clear the filter from the table.
3. Instead of seeing the data sorted by estimate, Hwan wants to see the table with the oldest projects first. Sort the table.
4. Hwan created a macro named CopyStats to copy the project statistics in columns I to L, and then paste them on a new worksheet. When he runs the CopyStats macro, however, it includes extra data from column G. View and edit the macro as follows:
a. Open the CopyStats macro in the Visual Basic Editor. The macro should select and copy the range I3:L22. In the CopyStats macro VBA code, correct the range specified in the first line of code after the comments.
b. Save, close, and run the CopyStats macro, and use Project Stats as the name of the new worksheet the macro created.
5. Return to the Projects worksheet. Hwan also created a macro named AddRow that inserts a new blank row in the Projects table. He wants to assign the AddRow macro to a new button to make it easy to run the macro and add a new project. Create the button as follows:
a. Insert a Button (Form Control) button in the cell to the left of the Print Stats button. Edit the text to display Add Project on the new button, and assign the AddRow macro to the new button.
b. Change the height of the new button to 0.3" and the width to 1". Align the new button to the left side of the cell, and then top align it with the Print Stats button.
#New_Perspectives_Excel_2019_Modules_1_4_SAM_Capstone_Project_1a
#NewPerspectivesExcel2019Modules1-4SAMCapstoneProject1a
#New Perspectives Excel 2019 | Modules 1-4: SAM Capstone Project 1a
#Shelly_Cashman_Excel_2019_Modules_1_4_SAM_Capstone_Project_1a
#ShellyCashmanExcel2019Modules1-4SAMCapstoneProject1a
#Shelly Cashman Excel 2019 | Modules 1-4: SAM Capstone Project 1a
#New_Perspectives_Excel_2019_Modules_5_8_SAM_Capstone_Project_1a
#NewPerspectivesExcel2019Modules5-8SAMCapstoneProject1a
#New Perspectives Excel 2019 | Modules 5-8: SAM Capstone Project 1a
#Shelly_Cashman_Excel_2019_Modules_5_8_SAM_Capstone_Project_1a
#ShellyCashmanExcel2019Modules5-8SAMCapstoneProject1a
#Shelly Cashman Excel 2019 | Modules 5-8: SAM Capstone Project 1a
#New_Perspectives_Excel_2019_Modules_9_12_SAM_Capstone_Project_1a
#NewPerspectivesExcel2019Modules9-12SAMCapstoneProject1a
#New Perspectives Excel 2019 | Modules 9-12: SAM Capstone Project 1a
#Shelly_Cashman_Excel_2019_Modules_9_12_SAM_Capstone_Project_1a
#ShellyCashmanExcel2019Modules9-12SAMCapstoneProject1a
#Shelly Cashman Excel 2019 | Modules 9-12: SAM Capstone Project 1a