
Closed
Posted
Paid on delivery
I have raw survey data collected with FormSG that now needs to be turned into something teachers can read at a glance. Your task is two-fold: first, reorganise the responses so I can see overall trends through clear bar graphs; second, break the data down by class and save each class on its own worksheet inside a single Excel workbook. Here is exactly what I need you to hand back: • One summary sheet showing all survey questions with clean bar graphs that pull directly from the data range, so the visuals update automatically if figures change. • Individual tabs for every class, each already filtered to only that class’s responses and laid out in a tidy table. The structure should mirror the summary, letting staff compare like-for-like quickly. • All formulas, pivot tables or Power Query steps left intact, documented briefly in cell comments or a short notes sheet so I can trace or refresh the logic later. I will supply the FormSG export as soon as we start. Please keep the file compatible with the latest Microsoft 365 version of Excel, avoid external links, and name sheets clearly (e.g., “Class 3A”, “Class 3B”, etc.). If you have any clarifications on the data headings or graph formatting, let me know early so we stay aligned.
Project ID: 40350620
43 proposals
Remote project
Active 15 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
43 freelancers are bidding on average $376 SGD for this job

Hello, I have done similar tasks many times extracting insights from the survey data (please check my profile). I could help you with this project. I work with the latest Excel 365 also so the versions will be exactly the same. I have time to start today evening or tomorrow (after the hiring) and complete all in 3-4 days. I'll provide an excel workbook according to all requirements you described with clear note sheet to help you in understanding logic of workbook structure and refreshing. If all it will be acceptable for you, please send survey data, hire me and I would start working on this project. I'll be happy to help you. Regards, Alex.
$250 SGD in 7 days
7.9
7.9

Hi there, I’ve carefully reviewed your project and understand you need to transform FormSG survey data into a structured Excel workbook with a clear summary view and class-level breakdowns, along with dynamic visuals that update automatically. My approach begins with cleaning and structuring the raw dataset to ensure consistency across responses. I will then organize the data using Excel features such as tables, pivot tables, and/or Power Query so the dataset remains refreshable and easy to maintain. Next, I will create a dedicated summary sheet that presents all survey questions with clear, well-formatted bar charts linked directly to the source data. These visuals will be dynamic, so any updates to the dataset will automatically reflect in the charts. I will also generate individual worksheets for each class (e.g., Class 3A, Class 3B), each filtered appropriately and formatted in a consistent layout to allow easy comparison across groups. All formulas, pivot structures, and transformation steps will be preserved and briefly documented through a notes sheet or cell comments, ensuring transparency and ease of future updates. Before I begin, do you have a preferred chart style or color scheme for the summary visuals, or should I follow a clean, standard academic layout? Let’s turn your survey data into something clear and immediately actionable for teachers. Warm regards, Aneesa.
$250 SGD in 2 days
6.9
6.9

Hello, I am an advanced Excel specialist who will transform your FormSG raw survey data into a teacher‑friendly workbook. I will create a summary sheet with clear bar graphs that update automatically from the data range, and individual tabs for each class—each filtered to only that class’s responses in a tidy table. I will use pivot tables/Power Query to keep formulas dynamic, document steps in cell comments or a notes sheet, and ensure the file is compatible with Excel 365 (no external links). I will name sheets clearly (e.g., “Class 3A”) and deliver a clean, refreshable workbook. I am ready to start as soon as you share the FormSG export. Regards, Zafar
$250 SGD in 1 day
6.2
6.2

Hi! I can help turn your FormSG raw survey export into a clean, teacher-friendly Excel dashboard that’s easy to read and update. I’ll create a Summary sheet with automated bar charts linked to the underlying data (via pivot tables/Power Query), plus separate worksheets for each class (e.g., Class 3A, Class 3B) formatted consistently for quick comparison. I’ll also keep all formulas and steps intact, with brief documentation in comments or a Notes tab for easy refresh later. Ready to start once you share the export.
$250 SGD in 4 days
5.5
5.5

Hi, I'm a data analyst, statistician, and economist with over six years of experience. I understand the requirements of your project and have the skills to deliver high-quality results. To better tailor my approach, could you please review my profile for more details on my previous work and client feedback. Looking forward to your response. Best regards,
$250 SGD in 2 days
5.5
5.5

Hello, I’d be happy to help turn your survey data into a clear, teacher-friendly Excel workbook. I have strong experience in Excel data analysis, dashboards, and visualization, and I can organize your FormSG data into a clean, structured, and fully dynamic file. What I will deliver: • Summary sheet with all questions and dynamic bar charts linked to data • Separate worksheets per class (e.g., Class 3A, 3B), each cleanly filtered and formatted • Consistent structure across all sheets for easy comparison • Use of pivot tables / formulas / Power Query Extras: • Short notes/comments explaining formulas and logic • Clean, professional layout (easy to read for teachers) • Fully compatible with Excel 365 (no external links) I focus on making the file: • Easy to understand at a glance • Simple to update and reuse • Well-organized and error-free ⏱ Turnaround: 1–2 days after receiving the data Ready to start immediately. Best regards.
$300 SGD in 2 days
5.2
5.2

Hi, I am a data analyst with 8 years of rich experience with a background in Excel reporting and data visualization. I am familiar with Excel, data processing, pivot tables, data analysis, Microsoft 365. For this project, the most important part is structuring the data so graphs and class sheets update automatically and stay easy to maintain. I will organize the dataset, build dynamic bar charts, and create clean class-based tabs with formulas and clear documentation for future updates. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.
$250 SGD in 7 days
5.2
5.2

Hello, I understand you need to transform raw FormSG survey data into a clean, structured Excel workbook with clear visuals and class-wise breakdowns. I specialize in Excel automation, pivot tables, and dynamic dashboards, ensuring data is easy to interpret and maintain. I will create a summary sheet with auto-updating bar graphs linked directly to the data, giving instant visibility into trends. Each class will have its own worksheet, pre-filtered and structured consistently for easy comparison. All formulas, pivot tables, or Power Query steps will be preserved and documented with comments or a notes sheet, ensuring full transparency and easy future updates. Deliverables include a fully organized Excel workbook, dynamic charts, clearly named class tabs, and documented logic for seamless maintenance in Microsoft 365. Clarification Questions: How many classes and survey questions are included in the dataset? Do you prefer charts based on pivot tables or direct formula-driven ranges? Thanks, Asif
$750 SGD in 10 days
4.8
4.8

Hi - Thank you for posting this interesting project! I have an academic background but earn my living as a software developer and your project sounds like an opportunity to put the best of my skills to task. Have you perhaps considered using Microsoft Access as the container for your database/data? What you are asking for describes a database system and Access would be perfect for not only protecting your data, but easily adding to it or editing it if necessary, produce graphs and reports, look at records individually or per class or in any summary format that would be useful. It is also possible to export data to Excel if necessary. I'd love to do a demo for you to illustrate how Access would manage and display your data. Please get in touch if you would like me to work with you on this, or if you have any questions for me. Kind regards - Carolina
$700 SGD in 7 days
4.5
4.5

As a Full Stack Developer with extensive experience in data management and automation, I am confident that I can deliver the outcomes you seek. My proficiency in Excel, including advanced functions, pivot tables, and Power Query steps aligns perfectly with your project requirements. An organized and logical thinker, I understand the importance of clear visual representation for easy data comprehension and informed decision-making. Moreover, my expertise in database scripting ensures all your formulas, pivot tables or Power Query steps will be not only intact but also clearly documented for future reference. I prioritize compatibility, efficiency, and clarity when working with Excel workbooks for the latest Microsoft 365 version in order to create a seamless user experience. Finally, my knack for automation and scripting enables me to efficiently handle large volumes of data without compromising quality. This will translate into faster turnaround times for you without sacrificing accuracy or attention to detail. Trust me with your survey data transformation process, and let's ensure all the survey questions are easily understood through tidy bar graphs, while retaining the class-specific breakdown through filtered tabs - exactly what you're looking for!
$250 SGD in 1 day
4.3
4.3

Hi, I am a certified and experienced Excel expert. Your Excel survey data analysis and cleaning request is perfectly matching with the specialize service offering in my profile. Please feel free to ask any questions if you have. Thanks!
$250 SGD in 7 days
4.4
4.4

With my vast experience in Data Analysis, Data Management, Data Processing, and Data Visualization, I am confident that I can handle your project with utmost quality and efficiency. As a Microsoft Office expert specifically in Excel and proficient in using Microsoft 365 version of Excel, I can expertly reorganize your FormSG raw data into clear bar graphs for better understanding of overall trends. Moreover, I'll make sure these visuals are directly linked to the data range so you don't have to worry about updating them manually. Breaking down the data by class and saving it on separate worksheets is another task I specialize in. As you've mentioned that you need each class's tab filtered to only that class’s responses and laid out neatly in tables; this is something I've done countless times before. Additionally, I'll leave all formulas, pivot tables or Power Query steps intact and provide brief documentation so you can easily trace or refresh the logic when needed. Lastly, with my commitment to fast, accurate, on-time delivery along with my accessibility round-the-clock for professional support, I assure you a top-quality service experience throughout our project journey. Looking forward to discussing further details soon!
$250 SGD in 1 day
4.3
4.3

Hi there, I understand you need a detail-focused specialist to transform your raw FormSG survey data into a teacher-friendly Excel workbook that clearly highlights overall trends while providing class-level insights. I am confident I can ensure both precision in handling your survey data and clarity in the insights presented to staff. My approach will begin by reorganizing the responses into a clean summary sheet with automatically updating bar graphs for each question, ensuring that overall trends are immediately visible. I will then create individual class tabs, each filtered to its responses and laid out consistently for easy comparison. All formulas, pivot tables, and Power Query steps will remain intact and documented so you can trace or refresh the logic effortlessly. Sheet names will be intuitive, visuals clean, and the workbook fully compatible with Microsoft 365. Finally, I will ensure the workbook is easy to navigate, fully functional, and ready for teacher use without further adjustment. Deliverable: A single Excel workbook with a summary sheet featuring dynamic bar graphs, class-specific tabs, fully preserved formulas and pivot logic, and a brief notes sheet explaining methods used. QUESTION: Would you like me to add conditional formatting to highlight particularly low or high responses for quick visual cues, making trends even easier for teachers to spot? Let’s chat and get started now! Regards, Shehwani
$250 SGD in 1 day
4.4
4.4

Dear Client, Greetings!! I have gone through the project description, and found that all of the mentioned requirements fall over my expertise, as I have hands-on experience on python, AI/ML, Data Science, software building, etc. you need raw FormSG survey data turned into a clean structured Excel workbook with dynamic visuals and class level breakdowns that teachers can read instantly, I have strong experience using Python data analysis tools and Excel to clean reorganize and transform messy datasets into structured reports with pivot tables dynamic charts and automated workflows, I will create a summary sheet with bar graphs directly linked to the data so they update automatically and separate worksheets for each class with consistent structure for easy comparison along with clear documentation of formulas and logic so you can refresh or modify it later, quick question are the class labels already standardized in the dataset or will they need cleaning before grouping, I am available to start as soon as you share the fileAlso, I have been coding on Machine Learning and Data Science with python from past 7 years. I have the experience of working with 4 giant tech companies, including freelancing on upwork, fiverr and freelancer. Hope to hear from you soon!!. Regards, Rojan
$400 SGD in 7 days
3.4
3.4

Hello! I'm Jawad, a highly versatile technology professional with vast experience in data science, graphical design/UI-UX and full-stack engineering. I am the best fit for your Survey Graphs and Class Excel Sheets project. In data analysis, visualization and software development, I employ both Python and Visual Basic, which will be necessary for handling your FormSG raw data and creating comprehensive yet comprehensible visuals. My proficiency with different frameworks like Pandas, NumPy, Matplotlib etc., will enable me to swiftly organize your responses, generate extensive bar graphs displaying trends and provide you an overall snapshot of the data at glance on a summary sheet. Moreover, my familiarity with PowerQuery steps will keep everything structured and dynamic, allowing automatic updates even when new figures emerge. In regards to class breakdowns, my grasp on Excel functions like pivot tables paired with efficient filtering techniques ensures that each tab representing a particular class will only show responses from that class, laid out neatly in a comparative manner as desired. Additionally, I'll provide comprehensible documentation in form of cell comments/notes in order to help you follow through the structure of different worksheets making the overall system more traceable.
$250 SGD in 7 days
4.0
4.0

As an experienced and adaptable full stack developer with a specialization in data analysis, I am equipped to handle all aspects of your project, from reorganizing survey responses to creating clean and informative graphs within Excel. I have a strong practical know-how of Excel automation and data analysis, which will be crucial for this task. My proficiency in Python will be useful if any automation via scripting is needed. My ability to work with a wide range of technologies including RESTful APIs, relational databases (like MySQL), and proficiency in using Excel to create pivot tables, complex formulas, etc allows me to provide comprehensive solutions. Additionally, my experience with CMS platforms like WordPress aligns well with the requirement of documenting the workbook steps mentioned by you. Finally, I value clear and concise communication throughout the project to ensure we are aligned in vision and deliverables. My strength lies not just in delivering a functional end result but also in making it robust, scalable, and maintainable - an assurance that I extend wholeheartedly towards your project. I am ready to hit the ground running at your convenience - let's discuss further!
$250 SGD in 7 days
3.4
3.4

Hi, This is a great use case for turning raw survey data into a clear, teacher-friendly reporting workbook. My approach: Clean and structure the FormSG export to ensure consistency across all questions Build a summary sheet with dynamic bar graphs that update automatically when data changes Create separate class-wise tabs, each filtered and formatted consistently for easy comparison Use pivot tables or structured formulas to keep everything flexible and maintainable Add a short notes sheet / comments explaining how the data and charts are connected Why I’m a strong fit: Experience building Excel dashboards and structured reporting systems Focus on clarity and usability (especially for non-technical users) Clean, well-organized work that’s easy to maintain and update Quick questions: Are survey responses mostly multiple-choice, ratings, or mixed types? Do you have a preferred format for graphs (counts vs percentages)? I can deliver a clean, easy-to-use workbook that teachers can quickly understand and reuse. — Deepanshu
$300 SGD in 7 days
3.7
3.7

As a highly skilled and experienced Data Scientist, proficient in Excel, Python, and other relevant programming languages, I believe I'm uniquely qualified to handle your project. I've been intricately involved in data analysis, processing, and visualization for over three years, consistently using such skills to extract valuable insights that drive effective decision-making. This aligns perfectly with your need to have your survey data brought into clear focus through easily adjustable graphs - which is something I specialize in. Moreover, my proficiency with statistical tools like SPSS and AMOS would be instrumental in breaking down your data by class on distinct tabs. My experience in using Excel's advanced functionalities like pivot tables and Power Query not only allows efficient organization but also helps maintain the integrity of the data. My commitment to maintaining compatibility with Microsoft's latest version and avoiding external links is a guarantee that you can rely on the robustness of my work.
$500 SGD in 7 days
3.0
3.0

Hello! I am a Florida-based senior software engineer with about 15 years of experience in data processing and visualization. I carefully read your project description regarding transforming raw survey data into accessible formats for teachers, and I believe I am the right fit for this task. I specialize in Excel and data management, and I have worked on similar projects where I created intuitive dashboards and user-friendly reports. My approach involves understanding the data deeply, structuring it effectively, and presenting it in a way that makes insights easily digestible for educators. Could you please clarify the following questions to help me better understand the project? 1. What specific formats or visualizations do you envision for presenting the survey data? 2. Are there any specific metrics or insights you want to highlight for the teachers? To ensure everything is aligned with your vision, I suggest starting with a data review phase, followed by visualization mock-ups, and finally, the implementation phase where we can fine-tune based on feedback. I'm excited about the opportunity to work on this project and deliver results that meet your needs. Let’s chat soon! -James
$500 SGD in 3 days
3.1
3.1

Hi! I'm Alex, a Data and Surveys Reporting Analyst with 10 years of experience turning raw survey exports into clean, decision-ready reports. I work with survey data daily, including FormSG, Qualtrics, and similar platforms, so I understand the nuances of structuring response data for non-technical audiences like teachers and school staff. Here is exactly what I will deliver: A Summary Sheet with clearly labelled bar graphs linked directly to your data range using dynamic named ranges or structured tables, so charts refresh automatically when data changes. Individual class worksheets (e.g., Class 3A, Class 3B) filtered to each class using Power Query or structured Excel tables, laid out consistently so staff can compare responses side by side without confusion. Full documentation via a short Notes sheet and inline cell comments explaining every formula, Power Query step, or pivot table so you or your team can trace or refresh the logic independently. The workbook will be fully Microsoft 365 compatible, contain no external links, and be built for longevity, not a one-time fix. I will review your FormSG export on day one and flag any heading ambiguities or formatting decisions before building, so we stay aligned and avoid rework. If this sounds like the outcome you need, I am ready to start immediately. Please share the export and we will get moving.
$500 SGD in 7 days
2.1
2.1

Singapore, Singapore
Member since Apr 5, 2026
$250-750 USD
$250-750 USD
$10-30 CAD
₹600-1500 INR
₹100-400 INR / hour
₹600-1500 INR
₹12500-37500 INR
₹12500-37500 INR
$2-8 CAD / hour
$10-30 USD
₹12500-37500 INR
₹100-400 INR / hour
$250-750 USD
$3000-5000 USD
$10-30 USD
₹400-750 INR / hour
€750-1500 EUR
₹100-101 INR / hour
$30-250 USD
$20000-50000 USD