Must have details:
Minimum of three excel sheets need to be created within one excel file
Sheet one (Data Sheet) should contain 7 fields:
first name
last name
gender
age
e-mail,
education
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 are.
>If 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
I can perfectly help you in developing such a dynamic, analytical and interactive Excel based tool. I am an advance level Excel user and Data Scientist holding years of experience. I will be happy to discuss in detail.
$90 AUD v 1 dnevu
4,7 (83 ocen)
5,9
5,9
6 freelancerjev je oddalo ponudbo s povprečno vrednostjo $82 AUD za to delo
Hi
I have experienced in data entry field Also, I have several good records in this field as I have been working in this field for about 5 long years.I am an expertise on Data entry and excel, also have proficiency in MS office, Google analytics and QuickBooks and 10-Key KPH typing speed with zero errors. I have done MBA in finance Working with me will surely bring you many good as I am very creative and persuasive in nature. Also, I can handle things diplomatically with full professionalism. With full guarantee, I can assure you the deliverables you have asked for in the job description
Hello, i have read your requirements and with respect to your work involved i think i am the suitable one for this. I am very excited for the upcoming project. I have experience of more than 2 years in this field and i have good knowledge of computer as well as ms word, excel, sheets, power point and also with great typing skills. I would like to know you that i am very hard working and dedicated towards my duty or job whatever you will give me. I am new on this freelance platform but i want to make you sure on that i will complete the work to your satisfication. I have both the skills and as well as educational qualifications for this. I will complete the work on or before your deadline with ease and prefection.
Thank You
Hello,
With respect to your work involved,i believe i am the best pick for it.I have over 5+ years extensive knowledge in microsoft office applications.I would like to let you know that I’m a very hardworking and dedicated person. Even though i am new of this freelance platform I will complete the work to your satisfaction. My educational background with focused on Mathematics and Economics made me skilled in data entry works as well as typing.
I will be able to complete this work within your time frame with ease and perfection.I hope you will consider me for this work as i can promise you that you will get value for your money.
Thank you