Create an interactive excel sheet

Reference no: EM132625312

Assignment -

You are a HR manager for a convenient store and you have been asked to create an interactive excel sheet that will allow you to input the data about the staff's performance and automatically create analysis of the same data.

Must have details:

1. Minimum of three excel sheets need to be created within one excel file.

2. Sheet one (Data Sheet) should contain 7 fields: 1. first name 2. last name 3. gender 4. age 5. e-mail, 6. education 7. salary.

3. Assume you need the following analysis in sheet two.

Firstly, you need their full name.

Secondly, you need their Initials

Thirdly, because your company need to give staff who's age is over 25 special training, therefore, you need to excel sheet to show you whether the individual is over the age of 25 or not. Highlight the one that not.

lf they are over the age of 25, you need the sheet to display their email address, because you need to contact them. If not, display the word 'None Applicable'.

In addition, education level is important for the company, and those whose education level is only 'primary' need to be displayed.

Then, because all female staff whose age is 30 is eligible for social support funds, your excel must be able to display either 'Eligible for social support funds' or 'Not applicable'.

Lastly, the table must have filter.

4. Assume you need the following analysis in sheet three:

Have a graph and a table that allow you to see how much salary you pay between different education level.

Have a graph and a table that show how much salary you pay between different age (with gender as filter).

Create a table that count how many "Eligible for social support funds" you have, as well as how many people need special training.

Please note there is various ways for you to complete sheet three. If you manage to create an efficient and functioning display, then you may choose to use any excel functions at your disposal.

Create a table with header as Education and Average Salary, and ONLY in row below. The cell under education should be a dropdown list of all the education options. Depend on the selection, the cell under salary should reflect your selection.

5. Addition mark will be awarded to student who done the following optional objective(s):

Add whatever formatting you feel you needed to make the interactive worksheet presentable. Use the attached material as inspiration.

Add extra column to the data and do additional analysis you would be interested in. Note: If you just add extra column but does not show how you would use the data, then it will not be counted.

Use Marco to auto refresh the date.

Create a dashboard for user.

Attachment:- Excel Sheet Assignment Files.rar

Reference no: EM132625312

Questions Cloud

How knowledge of managerial accounting can assist : How knowledge of managerial accounting can assist a manager with regard to the He is deciding whether to push through with a project.

Make a memo to a fraud examination team : Memo to a fraud examination team regarding how they can use horizontal and vertical financial statement analysis to identify potential fraudulent activities

Evaluate the degree you achieved the course outcomes : Now is the time that the rubber hits the road so to speak. Evaluate the degree you achieved the course outcomes relative to the above statement and your score.

Show the effect of each event on the elements : Show the effect of each event on the elements of the financial statements, using a horizontal statements model like the one shown

Create an interactive excel sheet : Create an interactive excel sheet that will allow you to input the data about the staff's performance and automatically create analysis of the same data

What comments would you make in your critique : The results and discussion areas of the study are very important. Suppose the researcher stated that the significant findings of the study "proved.

What is the role of a nurse leader related to research : What is the role of a nurse leader related to research? How does this apply to you? How can you be a leader to help overcome the problem of barriers.

Discuss the factors that have contributed to the growth : Zambian context, discuss the factors that have contributed to the growth of integrated marketing communications in the country.

How create the journal entry to record the impairment : Prepare the journal entry (if any) to record the impairment at December 31, 2020. (If no entry is required, select "No entry" for the account titles)

User Account

All Pages