Скачать или смотреть Shelly Cashman Excel 2019 | Module 9: SAM Project 1a | Maxwell Training

Shelly Cashman Excel 2019 | Module 9: SAM Project 1a | Maxwell Training #shellycashman

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/4B6NMKKBK...

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
[email protected]

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. DeShawn Washington runs the Florida office of Maxwell Training, a corporate training firm in Tampa. He is using an Excel workbook to analyze the company's financials and asks for your help in correcting errors and solving problems with the data.

Go to the Blended Training worksheet. DeShawn asks you to correct the errors in the worksheet. Correct the first error as follows:
a. Use the Trace Precedents arrows to find the source of the #VALUE! error in cell F7.
b. Use the Trace Dependents arrows to determine whether the formula in cell F7 causes other errors in the worksheet.
c. Correct the formula in cell F7, which should multiply the Mandatory training fee per person (cell F3) by the minimum number of trainees (cell F5), and then add the online access fee (cell F6) to that result.
d. Remove the trace arrows.
2. Correct the Name error in cell B21 as follows:
a. Use any error-checking method to determine the source of the error in cell B21, which should calculate the average income per session.
b. Correct the error by editing the formula in cell B21.
3. Correct the divide-by-zero errors as follows:
a. Evaluate the formula in cell B17 to determine which cell is causing the divide-by-zero error.
b. Correct the formula in cell B17, which should divide the income per program (cell B15) by the minimum number of trainees (cell B5).
c. Fill the range C17:F17 with the formula in cell B17. (Hint: You will correct the new error in cell C17 in the following steps.)
4. DeShawn suspects that the two remaining errors are related to the zero value in cell C5. He wants to make sure that anyone entering the minimum number of trainees enters a number greater than zero.

Add data validation to the range B5:F5 as follows:
a. Set a data validation rule for the range B5:F5 that allows only whole number values greater than 0.
b. Add an Input Message using Number of Trainees as the Input Message title and the following text as the Input message:
Enter the minimum number of trainees for this program.
c. Add an Error Alert using the Stop style, Trainees Error as the Error Alert title, and the following text as the Error message:
The minimum number of trainees must be greater than 0.
5. Identify the invalid data in the worksheet and correct the entry as follows:
a. Circle the invalid data in the worksheet.
b. Type 15 as the minimum number of trainees for the Tech Skills program (cell C5).
c. Verify that this change cleared the remaining errors in the worksheet.
6. Go to the Tutorial Fees worksheet. This worksheet analyzes financial data for small-group training sessions, which Maxwell Training runs throughout the day. DeShawn has already created a scenario named Current Enrollment that calculates profit based on the current number of trainees enrolled for each program. He also wants to calculate profit based on the maximum number of trainees.

Add a new scenario to compare the profit with maximum enrollments as follows:
a. Use Max Attendance as the scenario name.
b. Use the enrolled trainees per day data (range B8:F8) as the changing cells.
c. Enter cell values for the Max Attendance scenario as shown in bold in Table 1, which are the same values as in the range B7:F7.
Table 1: Cell Values for the Max Attendance Scenario

Cell Value
Orientation_Trainees (cell B8) 24
Tech_Skills_Trainees (cell C8) 8
Soft_Skills_Trainees (cell D8) 32
Product_Trainees (cell E8) 24
Mandatory_Trainees (cell F8) 32

7. DeShawn also wants to calculate profit based on the minimum number of trainees.

Add another new scenario to compare the profit with low program enrollment as follows:
a. Add a scenario to the worksheet using Low Attendance as the scenario name.
b. Use the enrolled trainees per day data (range B8:F8) as the changing cells.
c. Enter cell values for the Low Attendance scenario as shown in bold in Table 2.
Table 2: Cell Values for the Low Attendance Scenario

Cell Value
Orientation_Trainees (cell B8) 10
Tech_Skills_Trainees (cell C8) 2
Soft_Skills_Trainees (cell D8) 16
Product_Trainees (cell E8) 10
Mandatory_Trainees (cell F8) 15

8. Show the Low Attendance scenario values in the Tutorial Fees worksheet.