Find Jobs
Hire Freelancers

Create a spreadsheet for me, called Teacher's Companion

$30-250 USD

Complété
Publié il y a presque 3 ans

$30-250 USD

Payé lors de la livraison
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
N° de projet : 30156481

Concernant le projet

9 propositions
Projet à distance
Actif à il y a 3 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
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. You will be satisfied with my work and save your time and money. Hope your kind contact. Best regards!
$50 USD en 1 jour
5,0 (1 commentaire)
1,0
1,0
9 freelances proposent en moyenne $124 USD pour ce travail
Avatar de l'utilisateur
✅ Expert on Advanced Excel ✅ Hi there! I can build Excel Template for Teacher's Companion as on project requirements. I meet your required excel skills. I’m expert on VBA, Macro, Nested Formula & Function, Data Validation, Conditional Formatting, Power Pivot, Power MAP, DAX Measures, Pivot Table, Graph and Chart, Dynamic Dashboard, API/JSON/XML Data and Advanced Excel Automation related various administration tasks. Familiar with VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, COUNTIFS, AVERAGEIFS, SUMIFS, IFERROR, NOT, AND, OR, Nested IF, Datedif, Find, Concatinate, Substitute, Left, Right, Mid, Array, PROPER, D COUNTA, ROUND, TRANSPOSE, DEV, ST DEV, IS REF, IS BLANK, UPPER, LOWER, MID, MIN, MAX, MEDIAN, COUNT with 150+ Nested Formula ✅ Dashboard, Graph & Chart • Gantt Chart • PERT Chart • Column Chart • Line Chart • Pie Chart • Doughnut Chart • Bar Chart • Area Chart • XY (Scatter) Chart • Bubble Chart • Stock Chart • Surface Chart • Radar Chart • Combo Chart Knock me over chat. So, we can discuss more about this project and start work. I hope to hear from you soon! Kindest regards, Aquib Javed
$250 USD en 7 jours
4,9 (68 commentaires)
5,7
5,7
Avatar de l'utilisateur
i can create spread sheet please come in inbox ASAP we will discuss there in details. i am ready and full confident to start working on your project. WAITING FOR YOUR RESPONCE THANKS
$333 USD en 12 jours
5,0 (3 commentaires)
2,4
2,4
Avatar de l'utilisateur
============Excel VBA Expert is here ===================== Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. Everyone call me a "Prince of Excel". I promise I will finish this project with high quality on time. I hope you to contact me so that we have a full discuss with the project. Best regard!
$50 USD en 1 jour
5,0 (3 commentaires)
2,2
2,2
Avatar de l'utilisateur
Hello there I have seen and read your project "Create a spreadsheet for me, called Teacher's Companion " and I am very much interested to help. The skill guiding ,me to handle this work are : Excel VBA, Excel and Finance Hire me direct incase project is deleted by by c;licking this link https://www.freelancer.com/u/errandssolution Regards Charity
$155 USD en 7 jours
2,0 (1 commentaire)
2,1
2,1
Avatar de l'utilisateur
MASTERS IN FINANCIAL ACCOUNTING EXCEL EXPERT!! HELLO DEAR CLIENT I have gone through your project details and the work is DOABLE since its within my area of EXPERTISE.I will tackle are required guideline to deliver desired goal Please consider my bid. THANKS
$140 USD en 2 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I read the offer and I could be the best person for your requirement. I have plenty experience in MS Excel.
$56 USD en 10 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hello. I am proficient for this job because I am very good at -VBA- for 7+years. Everything is fit for your project. I just checked your requirement. I can start immediately and will complete this in your correct deadline with high quality. Love to hear back soon. Regards.
$50 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED STATES
Floral Park, United States
0,0
0
Méthode de paiement vérifiée
Membre depuis mai 10, 2021

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.