advanced Excel work needed

Cancelled Posted 6 years ago Paid on delivery
Cancelled

ou work for a company that does educational consulting. Your boss knows that you are a genius when it comes to Excel and decides to impose upon you a little – he assigns you a project to create an Excel spreadsheet that will be a teacher’s companion. It has to have an input area for the grades, rank them, split them into different quartiles, create relevant charts, give all the summary statistics that are relevant, color code grades that need to be looked into, have a conditional format highlighting when a student does better or worse than previous exams, show relevant lookup values for grades according to number and letter, have relevant pivot tables, etc.  The goal is that it is a stand-alone tool for teachers to use to assess everything possible about a student.

Â

You must use every tool at your disposal. You must use clear, concise and appropriate formulas. You must present your information in a detailed and relevant manner. You will be graded on the “levelâ€Â of formulas you used, on your ability to manipulate data, on your ability to present data for the intended audience, on how inventive you employ the tools at your disposal, on how thorough you are in your presentation, etc. Â

Project Grading Rubric

You will be graded on the inclusion of the below ideas (but you should certainly include more). Â You will also be graded on the clarity, neatness, compactness, and overall presentation of the project. Â You will earn a better grade by doing something that utilizes multiple functions, shows your mastery of the tools at hand, and presents the picture in a unifying and non-cluttered [url removed, login to view], you have more than a month to do it, so I will be expecting something professional.

Â

Â

Â

1include relative absolute and mixed cell reference

2use all the summary statistics (sum, average, min, max, count, etc.)

3use at least three different instances of date and time functions

4use at least three different formats such as number, date, custom etc.

5use at least three different instances of nested if functions

6use vlookup and index/match functions

7create and use range names and use them in formulas

8have a chart with axis names, chart title, etc. describing the data

9use data bars

10use at least three instancs of conditional formatting, one of which needs to be custom formatted

11design a table

12sort the table at two levels or more

13use the subtotal function

14have grouped data

15have at least three relevant pivot tables with at least two calculated fields

16have a slicer available for the pivot table

17create a one variable data table

18create a two variable data table

19use scenario manager or solver (with saved and summarized scenarios)

20use advanced filters

21use the database functions

22use the sumif(s), countif(s), averageif(s) functions

23use rank, percentrank, quartile, frequency, stdev, and correl functions

24create a histrogram

25at least three different formulas using arrays

26at least two cases of data validation

Engineering Excel Java Microsoft Office SQL

Project ID: #13948568

About the project

5 proposals Remote project Active 6 years ago

Awarded to:

Ermicho

Hello I am data entry specialist and excel expert I will use excel formulas and I will present information in detail if you want to work with me feel free to contact thank you

₹222 INR / hour
(1 Review)
0.6

5 freelancers are bidding on average ₹255/hour for this job

Iqbal74

Greetings! My name is Iqbal Ali. I am an Excel expert with great customer feedback, excellent Upwork test score, and committed approach to project handling. I am expert with vlookups, pivot tables, pivot charts, graph More

₹500 INR / hour
(10 Reviews)
3.8
vw896424vw

- good in excel vba, macros, functions, data extraction, data manipulation - ensure result accuracy and deliver on time

₹166 INR / hour
(2 Reviews)
1.4
digiterninc

Hi, Greetings from Digitern Inc.! As per your requirement you need data entry work done on excel sheet. Digitern Inc. is here to make that spreadsheet for you in just INR 100/hr. Please trust us once and you will be d More

₹111 INR / hour
(0 Reviews)
0.0