Excel Modules 9-12 SAM Capstone Project 1a | W&K Engineering | NP_EX19_CS9-12a

#Shelly #W #New
#Excel_Modules_9-12_SAM_Capstone_Project_1a #NP_EX19_CS9-12a #ExcelModules9-12SAMCapstoneProject1a #Excel_Capstone_Project_9-12 #ExcelCapstoneProject912 #NewPerspectivesExcel2019Modules9-12SAMCapstoneProject1a #Capstone #Excel_Modules_9-12 #New_Perspectives_Excel_2019_Modules_9_12_SAM_Capstone_Project_1a
#W&K_Engineering #W&KEngineering

Contact Us:
WhatsApp no. : +923701472320
direct link:https://wa.me/+923701472320
Email : [email protected]
Instagram id :https://www.instagram.com/malik.imran...




#New_Perspectives_Excel_2019_Modules_9_12_SAM_Capstone_Project_1a
#NewPerspectivesExcel2019Modules9-12SAMCapstoneProject1a
#New Perspectives Excel 2019 Modules 9-12 SAM Capstone Project 1a
#Excel Modules 9-12 SAM Capstone Project 1a
#Excel_Modules_9_12_SAM_Capstone_Project_1a
#ExcelModules9-12SAMCapstoneProject1a
#Excel Capstone Project 9-12
#ExcelCapstoneProject9-12
#Excel_Capstone_Project_9_12
#Excel Capstone Project 9-12 W&K Engineering
#ExcelCapstoneProject9-12W&KEngineering
#Excel_Capstone_Project_9_12_ W&K_Engineering
#NP_EX19_CS9-12a_FirstLastName_1.xlsx
#NP_EX19_CS9-12a_FirstLastName_2.xlsx
#NP_EX19_CS9-12a
#W&K Engineering
#W&KEngineering
#W&K_Engineering
#
#
#Shelly_Cashman_Excel_2019_Modules_9_12_SAM_Capstone_Project_1a
#ShellyCashmanExcel2019Modules9-12SAMCapstoneProject1a
#Shelly Cashman Excel 2019 Modules 9-12 SAM Capstone Project 1a
#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 in the State field.
3. Instead of seeing the data sorted by Estimate amount, Hwan wants to see the projects by date. Sort the table by the Project Start field from oldest to newest.
4. Hwan created a macro named CopyStats to copy the project statistics in the range I3:L22, 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.
b. In the CopyStats macro VBA code, change the range specified in the first line of code after the comments (Range("G3:L22").Select) to use I3:L22 as the range.
c. Save and close the CopyStats macro.
d. Run the CopyStats macro.
e. 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 in the range A4:G37. 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 cell I1 to the left of the Print Stats button.
b. Assign the AddRow macro to the new button.
c. Change the height of the new button to 0.3" and the width to 1".
d. Align the new button to the left side of cell I1, and then align its top and bottom with the top and bottom of the Print Stats button.
e. Edit the text to display Add Project on the new button.
6. In the Projects table, Hwan wants to make sure that everyone entering project information enters the correct project categories, which are listed in the range I4:I7. He asks you to ensure users enter a value from this range. Create a data validation rule as follows:





#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