Скачать или смотреть Shelly Cashman Excel 365 | Module 5 SAM Project A | York Medical Center

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

https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

PROJECT STEPS
1. Veda Chandra is a nursing manager for York Medical Center, a hospital with three locations in Texas. York requires nurses and other health professionals to complete a certain number of continuing education hours per month. Veda is tracking these hours for the first quarter and asks for your help in consolidating the data and setting attendance goals.

Go to the Houston worksheet. The Contact Hours by Department totals need to be completed in the range F20:F26.

Copy the formula in cell F19 and then paste it into the range F20:F26, pasting only formulas and number formatting.
2. The Houston, Dallas, and San Antonio worksheets have the same structure and contain similar data. Group the Houston, Dallas, and San Antonio worksheets to make changes to the three worksheets at the same time. The first change is to display today's date.

In cell G3 of the Houston worksheet, enter a formula using the TODAY function to display today's date.
3. Veda asks you to display the date with an abbreviated day name and no year, as in Thu 4/13.

Apply a custom format to cell G3 that displays a three-character day name (ddd), a space, and the standard short date month and day numbers (m/d).
4. Use the month name in cell H6 to fill the range I6:M6 with the month names for the next two quarters.
5. Veda has set a goal of having 1,600 nurses attend continuing education sessions in September. For April, she estimates 1,426 nurses will attend sessions, which is the average attendance from January to March.

Project the monthly attendance in May to September by filling the series for the first projection (range H8:M8) with a linear trend.
6. Veda asks you to determine how the attendance would increase if nurses attended 2.5% more continuing education sessions each month from May to September.

Project the monthly attendance in May to September for the second projection (range H10:M10) based on a growth series using 1.025 as the step value.
7. Ungroup the worksheets, go to the All Centers worksheet, and then consolidate the data from the Houston, Dallas, and San Antonio locations as follows:
a. In cell C7, enter a formula using the SUM function and a 3-D reference to total the Cardiology Department attendance (cell C7) for the Houston, Dallas, and San Antonio locations.
b. Copy the formula in cell C7 to calculate the first-quarter attendance for the other departments (ranges C8:C14 and D7:E14), pasting the formula only.
c. In cell C19, enter a formula using the SUM function and a 3-D reference to total the contact hours of the Cardiology Department in January (cell C19) for the Houston, Dallas, and San Antonio locations.
d. Copy the formula in cell C19 to calculate the first-quarter contact hours for the other departments (ranges C20:C26 and D19:E26), pasting the formula only.
8. Round the total contact hour values so that they are easier to remember.
a. In cell C27, add the ROUNDUP function to display the total contact hours for January rounded up to 0 decimal places.
b. Fill the range D27:F27 with the formula in cell C27.
9. In cell F29, Veda asks you to display the total contact hours from the previous year for the same period. This data is stored in another workbook. Insert the total as follows:
a. Open the file Support_EX365_5A_Hours.xlsx.
b. In cell F29 of Veda's workbook, insert a formula using an external reference to cell F27 in the Quarter 1 worksheet in the Support_EX365_5A_Hours.xlsx workbook.
10. Veda wants you to determine the start date of the next continuing education session, which is seven workdays after the date of the last session.

In cell J6, insert a formula using the WORKDAY function that displays the date 7 workdays after the date of the last session (cell J5).
11. Veda also wants you to show how the contact hours in the Cardiology, Critical Care, Emergency, General Surgery, and Maternity Departments contributed to the total hours for January to March.

Create a chart as follows to illustrate this information:
a. Create a 3-D pie chart that shows how the first five departments (range B19:B23) contributed to the corresponding total contact hours (range F19:F23).
b. Move and resize the chart so that the upper-left corner is in cell H17 and the lower-right corner is in cell L29.
#samproject1a #samprojects #cengageassignments #SC_EX365_5a #SC_EXCEL #excel_assignments #excel_sam_projects #Module5SamProjecta #york_medical_center #shelly_cashman_excel #SC_EX365_5a_FirstLastName_1.xlsx #SC_EX365_5a_FirstLastName_2.xlsx