
Completed
Posted
Paid on delivery
i have a task excel sheet [login to view URL] I need it modified or new one created... i can give u current excel. i have a course for schools for classes 3 to 10. Each Class consists of 30 sessions (say tasks) that teachers teach. Say i have 6 teachers that teach classes 3 to 8. I want that each teacher who teaches a session for a certain class to go to the excel and check the session he taught under and from dropdown chooses his name. [login to view URL]!222131&resid=92BD1BEB5A202C84... Check your excel that i unprotected and renamed columns to CLASS 7A and CLASS7B. Under each class i write number of sessions as CLASS 7B. i want in this clumn to have next to each session say a check box that once clicked means session 1 say was completed by Teacher James say that he chooses from drop down on the same row and if u want to put date will be nice Now all the graphs will stay the same.. in each column the chart showing percentage of tasks completed and other charts maybe showing the percentage of each teacher completed based on say 30 sessions and chart showing the percentage completed for whole program Final output should be a Google Sheets document.
Project ID: 38839225
24 proposals
Remote project
Active 1 yr ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

As a seasoned data analyst with extensive experience in MS Excel, I am confident that my skills align perfectly with the needs of your project. I possess a wealth of expertise in data entry, processing and working with large amounts of information to extract actionable insights. Moreover, I have a keen eye for detail that will ensure all the modifications and additions you need in your task tracking Excel sheet are accurately implemented. Having completed similar tasks as those outlined in your project description, rest assured that I can create an efficient solution to track the sessions taught by your six teachers across multiple classes. This will involve creating dropdown menus for teachers to easily mark their names against the respective sessions they have taught, along with the option to input the date of completion. I'm also well-versed in using graphs to illustrate statistics and I will maintain all existing charts while incorporating new ones, if needed. Furthermore, being proficient in Google Sheets, I will meticulously transform your existing file into a dynamic yet user-friendly document as per your requirements. My goal is not just manipulation of data but making it easily interpretable and readily accessible to facilitate deeper analysis and aid decision-making processes. Let's collaborate on this project and enhance the efficiency of your course management system together!
$10 USD in 1 day
7.1
7.1
24 freelancers are bidding on average $54 USD for this job

Dear Client, I can help you create or modify your Excel sheet to meet your specific needs. I'll ensure that teachers can easily select their names from dropdowns, check off completed sessions, and optionally input dates. The existing charts will be preserved and enhanced to reflect task completion by teachers and overall progress. I’ll deliver a well-organized Google Sheets file, making it easy for you to track progress seamlessly. Let me know if you’d like me to start with the current file or design a new one from scratch. Looking forward to collaborating! Best Regards, Muhammad H.
$55 USD in 2 days
6.3
6.3

Hello, I have carefully reviewed the details before placing a bid on your project. I am confident that I can complete the task and provide you with an effective solution. With over 14 years of experience in reporting and data analysis, I have designed and delivered multiple dashboards and implemented VBA automation to reduce human intervention which enhance data accuracy. My dashboards and reports are equipped with dynamic features like checkboxes, radio buttons, drop-down lists, and various graphical data representations, including bar charts, pie charts, heat maps, and Gantt charts. Please feel free to check my portfolio for more information. I look forward to discussing the details further in chat. Thank you for your time. Best regards, Jitender Kumar Reporting & Data Analytics EXCEL | VBA | POWER BI | SQL | OCR | Google Sheets
$80 USD in 2 days
4.9
4.9

As someone well-versed in data analysis and management using Excel, Google Sheets, and various data processing tools, I'd very much be a great asset for your project. My skills in extensive data organization and automation will come in handy when it comes to building your modified or new Course Tasks Tracking Excel Sheet. I am quite familiar with creating dynamic formulas on Sheets, including the use of drop-down menus and checkboxes. Moreover, data validation for selecting particular params, like teachers or completion dates, is a regular part of my work too. I understand you would like to retain the current graphs and charts which won't be a problem at all! I can make sure that everything remains intact while effectively carrying out the required modifications. Your project speaks about enhancing productivity and delivering custom solutions, which are both areas I excel in. With my dedication to meeting deadlines without compromising on quality or accuracy of work, I guarantee that the final output will exceed your expectations. Let us get started on turning your course task tracking into an easy and efficient system.
$50 USD in 1 day
4.6
4.6

Building off my extensive experience in data processing and Excel, I can expertly modify your existing sheet or create a brand new one that addresses all your course task tracking needs. Not only you will find me well-versed in Excel's advanced capabilities, such as data management and analysis, but also in other areas like Python, WordPress Development and SEO, which are all advantageous to data handling, extraction, and generating detailed insights. For instance, I can employ my Python prowess to derive information from the raw data, transform it into meaningful datasets and even automate tasks for efficiency. In this case, I can create a dropdown menu according to the teachers' definite names to update the sessions taught as per the specific class, allowing not just easy record keeping but better analyze patterns through various graphs. Moreover, if required I can even generate reports indicating the percentage completion of tasks for each session across different teachers and classes. Having collaborated on several successful data-focused projects, using both Google Sheets and Excel throughout my career, aiding organizations in critical decision-making based on the collated records. Hence with utmost confidence I assure you that I possess the right combination of skills and perspective to perfectly accomplish this task for you. Consider me part of your team and get ready to wield data like never before!
$155 USD in 4 days
3.8
3.8

Greetings! I understand the need for a highly efficient and well-structured tracking system for tasks as complex as your course project. With my extensive background in data processing and Excel in particular, I am certain that I am the best fit for this project. From data entry to visualizing data on charts, I have consistently demonstrated my ability to handle and manipulate data to my clients' specifications. From your project description, I can see that a large part of what you need is an automated system that can adapt dynamically as each task is completed by different teachers across different classes. This is where my skills in Visual Basic come into play; I can create macros specifically tailored to suit your needs. I can design an Excel sheet that contains drop-down menus for easy selection and a mechanism, such as check boxes or date entries, to ensure seamless tracking of progress fitting your unique situation. Moreover, besides having the technical know-how, it’s important to have a 'can-do' attitude throughout the project—a perspective that ensures prompt delivery with no-margin-for-error. And this defines me! My primary goal is building lasting client relationships based on trust and satisfaction. With me onboard, you can expect timely completion, zero errors, and a working partnership that extends beyond this project. May we proceed?
$55 USD in 1 day
4.0
4.0

Elevate your project with my expertise in educational data management. I excel in creating dynamic Excel and Google Sheets solutions tailored to track teacher performance and session completion. Leveraging my experience, I can implement dropdowns, checkboxes, and dynamic charts efficiently. Plus, I'll provide 24/7 support to ensure seamless integration. Let's discuss how I can add value to your project.
$10 USD in 7 days
1.0
1.0

Having worked extensively with Excel and data management, I believe I am the ideal candidate to handle your course tasks tracking project. Utilizing my expertise in data entry, processing and web search, I will enhance your current spreadsheet or create a new one that addresses all your needs. As an out-of-the-box thinker focused on problem solving, I am proficient at developing creative solutions for unique challenges like yours. Your project requires functionality such as dropdown menus and checkboxes, which can be painstaking to set up without appropriate skills and experience. My proficiency in Excel will ensure these features are smoothly integrated into the sheet. Furthermore, I understand the importance of visual representation for data analysis. The graphs you require can be generated successfully to demonstrate the percentage of tasks completed by class, teacher and the entire program. Lastly,I would not only deliver a fully functional sheet but do so promptly, respecting your budgetary constraints. Rest assured that with me onboard, you have a meticulous professional who values precision and accuracy above all else.I look forward to starting on this project and delivering nothing but the best results for you.
$20 USD in 1 day
0.0
0.0

As a digital marketer with a strong background in data management and analysis, I believe my skills make me uniquely qualified for your task tracking project. Over the years, I have worked extensively with Excel and Google Sheets to collect, organize, and analyze data for diverse projects. I'm confident in my ability to modify your existing sheet according to your exact specifications or create a fresh one from scratch if need be. Additionally, my experience with automation and analytics will be a valuable asset for this project. I can ensure that each session taught by a particular teacher is accurately reflected on the sheet through dropdown menus and checkboxes - streamlining the process and eliminating any room for error. Further, I can leverage my analytical skills to generate insightful graphs, including those that present the percentage of task completion per teacher and across the program. What sets me apart is not just my technical prowess but also my dedication to ensuring your satisfaction. I understand that you're looking for a smooth tracking system that delivers prompt insights, and I'm committed to providing just that. Comfortable across multiple platforms like Klaviyo, Mailchimp, Hubspot, Brevo, Zoho, Omnisend, Mailerlite, Sendinblue etc., I am also adept at adapting my skills to your preferred software. Let's join forces in bettering your task-tracking system!
$50 USD in 7 days
0.0
0.0

I am writing to offer my professional data entry services for your project. With a strong background in accurate data handling, I am confident in my ability to efficiently manage and input large volumes of data with attention to detail.
$40 USD in 5 days
0.0
0.0

Hi, I’ve reviewed the attached Excel file and fully understand the modifications you need for your course tracking sheet. I’m ready to start working on it and will ensure that the dropdowns, checkboxes, and charts function seamlessly while maintaining the existing graphs and adding new ones as requested. Could you please share the current Excel sheet so I can begin creating the updated Google Sheets document for you? Looking forward to collaborating on this! Best regards, Syed Rehman Chainzown
$55 USD in 2 days
0.0
0.0

With a proven track record in developing customized Excel solutions, I can enhance your task management system to streamline session tracking for your school courses. My approach will incorporate dropdown selections, checkboxes, and date entries while maintaining your graphs for task completion. I provide 24/7 support to ensure smooth project execution. Let's discuss how this can meet your specific needs!
$10 USD in 7 days
0.0
0.0

My skills, experience, and personal interests make me a strong fit for this project. My expertise aligns closely with your needs, and I have a proven track record of delivering quality work on time.
$65 USD in 7 days
0.0
0.0

As someone who has developed a deep level of expertise in using Excel, particularly in data processing, I believe I would be the best fit for this project. Over the course of my career, I have consistently provided insightful and innovative solutions to my clients—solutions they didn't know they needed until they saw the final product. In line with your needs, I can modify your current excel or create a new sheet from scratch to help you easily track and update the course tasks. In addition to my Excel proficiency, I have significant knowledge and experience in database design and data analysis through various software development languages including SQL Server and Python. This would allow for your desired functions like 'dropdown choices' for the teachers' names throughout your excel, ensuring only the specific teacher assigned can update or track their own class/session's details. My primary goal is your satisfaction. Thus, I am not only used to but perform well under deadlines without forgoing quality. I promise to keep the graphs intact while adding the desired features such as tracking teachers' percentage completions per session and overall program progress. Let me walk you through this journey towards a more organized and efficient task tracking system for your school classes.
$55 USD in 7 days
0.0
0.0

Hello, This would be my first job on Freelancer. I work as an accountant. I work with data every day and I love to do it.
$55 USD in 7 days
0.0
0.0

Hi, I am expert in excel and hard working. I can do this task and give you the updated new excel sheet. Please let me know the next steps. Thank you.
$20 USD in 7 days
0.0
0.0

jerusalem, Israel
Payment method verified
Member since Sep 21, 2009
$20-25 USD
$100-200 USD
$10-30 USD
$50-150 USD
$30-60 USD
₹1500-12500 INR
$15-25 USD / hour
₹100-400 INR / hour
₹750-1250 INR / hour
$30-250 USD
₹400-750 INR / hour
$15-25 USD / hour
$250-750 USD
$30-250 USD
₹1500-12500 INR
$15-25 USD / hour
min £36 GBP / hour
$10-30 USD
₹750-1250 INR / hour
₹600-1500 INR
€30-250 EUR
₹750-1250 INR / hour
€8-30 EUR
$15-25 USD / hour
£250-750 GBP