Скачать или смотреть Exp19_Excel_Ch07_HOEAssessment_Employees

To Get this Solution Contact us on Email and WhatsApp is given in Video
WhatsApp no : +923146535108
Email address: [email protected]

In this project, you will enhance your Excel skills by working on various functions and features. The goal is to complete an employee data set, calculate key statistics, and build a loan amortization table. Here’s a breakdown of what you need to do:

Extract Year from Hire Dates

Use the YEAR function to pull the year from each employee's hire date and copy the formula down the column.
Calculate Years Worked

Apply the YEARFRAC function to determine how many years each employee has worked until the end of the year specified.
Determine Hire Day of the Week

Utilize the WEEKDAY function to find out the day of the week each employee was hired.
Display Weekday Name

Use the VLOOKUP function to convert the weekday number to the actual day name.
Assign State Based on City

Implement the SWITCH function to match each city to its state.
Calculate Employee Bonus

Insert the IFS function to compute bonuses based on the employee's hire date.
Ensure Minimum Salary for Representatives

Use IF and AND functions to ensure representatives’ salaries meet the minimum threshold.
Count and Summarize Employees by State

Apply COUNTIF and SUMIF functions to summarize the number and total payroll of employees by state.
Calculate Average, Total, and Extremes

Use AVERAGEIF, COUNTIFS, SUMIFS, MINIFS, and MAXIFS functions for various summary statistics.
Create a Map Visualization

Insert a map chart to display total salaries by state and adjust the chart title.
Build a Loan Amortization Table

Use PV, IPMT, PPMT, CUMIPMT, and CUMPRINC functions to analyze loan payments and amortization.
Footer and Finalize

Add a footer with your name, sheet name code, and file name code to all sheets. Save and close the file.
Total Points: 100

For a detailed walkthrough of each step, stay tuned to our video tutorial series!