New Perspectives Excel 2019 Modules 9-12 SAM Critical Thinking Capstone Project 1c #newperspectives

New Perspectives Excel 2019 Modules 9-12 SAM Critical Thinking Capstone Project 1c #newperspectives

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6NMKKBKUFYN1?autoload=1&app_absent=0

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
singhal.agrawal.bharati@gmail.com

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.

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.
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.
a. Select the data in the Categories column, and create a data validation rule that accepts only List values from the categories in column I. Use a range reference instead of writing the categories themselves.
b. Create an input message that uses Project Category as the title and the following text as the input message:
Enter a project category.
c. Create a Stop style error alert that uses Invalid Category as the title and the following text as the error message:
Enter a category listed in column I.
7. Hwan wants to make sure all of the categories entered in the Category column of the Projects table are valid. Identify and correct any invalid values.
Circle invalid data in the Categories column, and change the invalid entry to Site development to correct the error.
8. Hwan wants to summarize project information in column I. Calculate the number of projects, the total estimates, and the average estimate in each category.
a. Next to the cell labeled "Bridge", use a function to count the number of Bridge projects in the Projects table. Use a cell reference to the cell labeled Bridge.
b. In the appropriate cell, use a function to total the estimates for Bridge projects in the Projects table. Use a cell reference to the cell labeled Bridge.
c. In the appropriate cell, use a function to average the estimates for Bridge projects in the Projects table. Use a cell reference to the cell labeled Bridge.
d. Use these formulas to fill the data for the remaining categories, filling without formatting.
9. Go to the Projects by State worksheet. Hwan has created a PivotTable on this worksheet to list projects by state, start date, and category. Refresh the PivotTable so it displays the changes you made to the Category data on the Projects worksheet.
10. Reduce the clutter in the PivotTable by modifying it.
Change the report layout to show the PivotTable in Outline Form. Group the Project Start values by Months.
11. Hwan occasionally would like to focus on the project data according to the start date.
Insert a Timeline Slicer based on the Project Start field. Move and resize the Timeline Slicer so it covers the range A34:F40. Adjust the Timeline Slicer to view all months.

Видео New Perspectives Excel 2019 Modules 9-12 SAM Critical Thinking Capstone Project 1c #newperspectives канала Homework Help