Скачать или смотреть Illustrated Excel 2019 | Module 11: End of Module Project 1 | Nimbus Health Center

Illustrated Excel 2019 | Module 11: End of Module Project 1 | Nimbus Health Center #illustratedexcel

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. "Tanisha Carmichael works in the Human Resources Department of Nimbus Health Center in Columbus, Ohio. She is using an Excel workbook to analyze employment data for the health center's Information Technology (IT) services. She asks for your help in completing the analysis and correcting errors.

Go to the Department Heads worksheet, where Tanisha asks you to complete the table of data about the department heads in IT Services. She copied and pasted the department names in the range B14:B20, but needs to list them in the range B4:B10 using title case, where each word is capitalized except for certain small words. In cell B4, enter a formula using the PROPER function to insert the text in cell B14 using title case. Fill the range B5:B10 with the formula in cell B4. "
2. Enter the first and last names of the department heads by typing Travis in cell C4 and typing Campion in cell E4. Use Flash Fill to complete the first names in column C, and then use Flash Fill to complete the last names in column E.
3. In cell D14, enter a formula using the CONCAT function to display the first name in cell C4 with the last name in cell E4, separated by a space. Fill the range D15:D20 with the formula in cell D14. Copy the range D14:D20 to the range D4:D10, pasting values only. Hide columns C & E, which repeats information already included in the table. Hide rows 14:20 to avoid displaying duplicate data.
4. Go to the Clinical Staff worksheet. Tanisha asks you to assign names to ranges so that you can use the names in formulas. Assign the name Hours to the range C4:C12 to identify the Development Hours values. Assign the name Eval to the range D4:D12 to identify the Peer Eval values. Assign the name Salary to the range E4:E12 to identify the Salary & Bonus values.
5. "In the range G3:H6, Tanisha wants to summarize statistics about the IT clinical staff with the highest peer evaluation ratings.
In cell H4, enter a formula using the AVERAGEIF function to average the salaries and bonuses (using the defined name Salary) of employees with a peer evaluation rating (using the defined name Eval) of 5. In cell H5, enter a formula using the SUMIF function to total the salaries and bonuses of employees with a peer evaluation rating of 5. In cell H6, enter a formula using the COUNTIF function to count the number of IT clinical staff with a peer evaluation rating of 5. Use defined names in all of the formulas."
6. "In the range G8:H11, Tanisha wants to calculate statistics about staff using other criteria.
In cell H10, enter a formula using the COUNTIFS function to determine the number of IT clinical staff with a peer evaluation rating of 5 and professional development hours of 10 or more. In cell H11, enter a formula using the SUMIFS function to total the salaries and bonuses of IT clinical staff with a peer evaluation rating of 5 and professional development hours of 10 or more. Use defined names in all of the formulas."
Create a formula using a function.
Create a formula using a function.
7. Go to the Technical Staff worksheet. After entering the peer evaluation data in the range D4:D12, Tanisha applied data validation to the range to make sure she and others entered the correct ratings. She asks you to check for data-entry errors and then correct them. Circle invalid data in the worksheet. Change the circled value to 4.5 to use the correct evaluation rating.
Change a number in a cell.
8. Go to the Overview worksheet, where Tanisha wants to consolidate salary and bonus information about clinical and technical staff. In cell C4, enter a formula using the SUM function and 3-D references to add the salary and bonus totals (cell E13) on the Clinical Staff and Technical Staff worksheets. In cell C5, enter a formula without using a function that returns the value of cell H5 on the Clinical Staff worksheet. In cell C6, enter a formula without using a function that returns the value of cell H4 on the Technical Staff worksheet.