Teacher's Companion Spreadsheet

Create a spreadsheet for me, teachers companion.

Create an Excel spreadsheet that will be a teacher’s companion. It has to have an 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.

1. The first page should be a cover page with hyperlinks to the other pages and a picture in the background.

2. The second page should be a dashboard.

3. Include relative, absolute and mixed cell reference

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

5. use at least two different instances of date and time functions

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

7. use at least three different instances of nested if functions

8. use vlookup and index/match functions

9. create and use range names and use them in formulas

10. have at least 5 charts with axis names, chart title, etc. describing the data

11. use data bars

12. use at least three instances of conditional formatting, one of which needs to be custom formatted

13. design at least 2 tables

14. freeze panes

15. text boxes to explain

16. name your sheets and give them colors

17. sort the table at two levels or more

18. use the subtotal function

19. have grouped data

20. have at least four relevant pivot tables with at least two calculated fields (measures) and a calculated item

21. have a slicer available for the pivot table

22. create a variable data table

23. use solver (with saved and summarized scenarios)

24. use advanced filters

25. use the database functions

26. use the sumif(s), countif(s), averageif(s) functions

27. use rank, percentrank, quartile, frequency, stdev, and correl functions

28. at least two cases of data validation

29. use dynamic charts connected to lists

30. use some VBA (even just something simple)

31. use at least 2 different types of buttons (non-VBA)

32. use visualizations

Skills: Excel, Data Entry, Data Processing, Word, Excel VBA

See more: excel teacher, excel teacher needed, excel teacher project, excel teacher assessment, best excel teacher in kharghar, i m looking for a excel teacher, freelance teacher of english in val di non area, sourcework academic writing teacher's manual, teacher's aide, teacher's aide jobs, teacher's resume, Creative Writing Teacher\ s Marketing Assistant, project 2 fourth edition teacher's book pdf, project 4 fourth edition teacher's book pdf, project 3 third edition teacher's book pdf, project 5 fourth edition teacher's book pdf, project 3 fourth edition teacher's book pdf, the gospel project teacher's guide, project 5 teacher's book pdf, fix it grammar the nose tree teacher's manual

About the Employer:
( 0 reviews ) Floral Park, United States

Project ID: #30167613

Awarded to:


=========== Excel Expert is here ============= Hi! I am happy to put my bid on this project. I read the description and I am appreciate in your project. I am an expert in Excel as I have built many projects like this. More

$50 USD in 1 day
(3 Reviews)

13 freelancers are bidding on average $116 for this job


(483 Reviews)
(51 Reviews)

Greetings Thanks for checking my proposal. I have understood your project and can start your project immediately. I would develop it with all these required functions, Dashboard, and much more. I would make as many re More

$95 USD in 3 days
(36 Reviews)

Hello, Sir. Expert of Excel VBA is here. I've gone through your project requirement and found my skill best suited in this one. I am familiar with technologies such as C++, VB, MS Office, Database Programming, Data Pro More

$120 USD in 1 day
(18 Reviews)

Hi There, I would love to work on your project. I read through the job details extremely carefully and I absolutely sure that I can do the project very well. I have long experience with the right skills to work on this More

$200 USD in 4 days
(9 Reviews)
(2 Reviews)

Hello, Good day to you, Thank you for sharing very informative description about your project :) It makes easy to understand the exact requirements. I have all the qualifications to complete this task, with the experie More

$75 USD in 7 days
(1 Review)

Hi, I have gone through your project requirements thoroughly and I can definitely deliver this task on time and with great accuracy. I am a data analyst and extensively worked on excel. I have created 100s of excel das More

$130 USD in 4 days
(1 Review)

Hello there I have seen and read your project "Teacher's Companion Spreadsheet" and I am very much interested to help. The skill guiding ,me to handle this work are : Excel, Word, Excel VBA, Data Processing and More

$155 USD in 7 days
(1 Review)

I can complete your work in time because I have experience of the work. I did this before for my clients

$31 USD in 7 days
(0 Reviews)

Hello. I am expert in copywriting and I also can do well the spreadsheet. I have read your description and I believe that I will do the best spreadsheet for you. You can message me for further discussion. Thank you. R More

$140 USD in 3 days
(0 Reviews)

I have a lot of free time, and my expertise is also very supportive of this job, in my opinion this job only needs time, the work is not that difficult but is high in accuracy, so with that I think I am the right perso More

$140 USD in 7 days
(0 Reviews)