
Completed
Posted
Paid on delivery
I'm in need of a skilled Google Sheets expert to set up a table for me. The table should utilise tools like VLOOKUP, SUMIF, QUERY, and INDEX/MATCH to pull data from a larger table containing dates, values, and categories. The end goal is to have a summarised data table that is organised by date range, category type, and value range. the data and table are on two tabs of the same google sheet Ideal freelancer should have: - Advanced knowledge in Google Sheets and or EXCEL - Proficiency in using VLOOKUP, SUMIF, QUERY, and INDEX/MATCH - Experience in data handling and summarisation - Ability to deliver clear, summarised data in an organised manner. Link will be provided to the awarded winner.
Project ID: 38861522
17 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
17 freelancers are bidding on average $26 AUD for this job

Greetings, I can start now and will do few samples if you wish. I’m Saravanan, a freelancer with experience in data entry, web scraping, lead generation, Excel, Google Script, and PDF conversion to Excel. I have successfully completed similar projects, ensuring accuracy, timely delivery, and high-quality accuracy. Whether it’s extracting data from PDFs, automating tasks with Google Script, generating leads from LinkedIn, or organizing financial data, I can deliver exactly what you need. I’m ready to start immediately and meet your deadlines. Looking forward to collaborating! Thank you, Saravanan
$30 AUD in 1 day
4.3
4.3

As an experienced freelancer with extensive proficiency in Google Sheets and Excel, I'm confident that I can provide a high-quality solution for your data management needs. Having handled multiple projects that involved data handling and summarisation, I am well-versed in utilizing tools like VLOOKUP, SUMIF, QUERY, and INDEX/MATCH. With my expertise in Data Entry, Data Processing, and Excel, I have developed advanced skills that would be valuable in setting up your required table. This includes organizing data according to specified date ranges, category types, and value ranges for clear and easy interpretation. My aim is to help you maximize the potential of your data through an organized and efficient summary. Furthermore, one of my key aims is building strong working relationships with clients to convert one-time projects into long-term commitments. Thus, not only will I deliver the project as required but also bring added value by consistently offering my skills on future endeavors. Choosing me for the job guarantees you a dedicated professional who will go above and beyond to ensure all your needs are met effectively and efficiently.
$20 AUD in 1 day
4.0
4.0

As an experienced administrative professional with over a decade of experience, I am confident in my abilities to handle your Google Sheets project efficiently and accurately. Excelling in tasks that involve data entry, MS Excel, or Google Sheets management, I bring advanced knowledge and capabilities in using tools like VLOOKUP, SUMIF, QUERY, and INDEX/MATCH to derive the most value from your data. This includes summarising data based on date range, category type, and value range - exactly what you're looking for. My time working within the HR Department particularly honed my skills in data handling and summarisation which translates seamlessly into this project. Timely and precise is my reputation as I've handled many large data sets before while maintaining the quality of my work. My clients appreciate my detail-oriented approach which is crucial when organising complex tables for clear and facile access. Beyond these skills- offer reliability, dedication to results, and timeliness. And finally, as a translator, I can provide clear communication between us should there be any doubt. My goal always is to reduce any administrative burden you might have and push the success of your projects. Let me streamline your operations and ensure we succeed with flying colors together!
$50 AUD in 3 days
2.3
2.3

As an experienced developer and data analyst, I am highly proficient in Google Sheets and EXCEL, with an extensive skill-set including VLOOKUP, SUMIF, QUERY, and INDEX/MATCH. My capacity to work fluidly between large dataset manipulation and its summarisation is exactly what you need for your project. I have a keen eye for subtleties and trends that allow me to deliver clear and organized data summaries. This is evident through my ability to accurately interpret data ranges, categories, and values, comprehensively addressing every factor you've mentioned. I understand the importance of clarity in data representation as it helps decision-making. Therefore, I assure you that the summarised table I'll create for you will effectively organise your data by date range, category type, and value range. Having worked not just as a developer but also in various data handling roles throughout my career, I can confidently say that my experience gives me an advantage - I've had hands-on practice in bringing order to chaotic datasets. Choosing me for your project not only brings an experienced hand but also a guarantee of delivering high-quality results on time. With proficiency from Java to Python, I'm adaptable enough to meet unique project needs efficiently. If awarded this amazing opportunity, rest assured, I'll provide you with an exemplary summary table that gives the power of understanding right at your fingertips! So why wait? Let's unlock the meaningful insights together!
$10 AUD in 1 day
1.4
1.4

Hi !!! With over a decade of experience, I have a proven track record in software development, specially in Data Entry, Visual Basic, Data Processing, PHP and Excel. I am skilled in creating clean and efficient code, ensuring optimal performance and scalability. Additionally, I am familiar with modern development practices, version control systems, and testing methodologies. I am confident in my ability to meet your project requirements and deliver high-quality results within the set timeline. I am dedicated to continuous learning and staying updated with the latest industry trends and technologies. Thank you for your consideration in advance and look forward to hearing back from you.
$25 AUD in 2 days
0.0
0.0

Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on PHP, Visual Basic, Data Processing, Data Entry, Excel Lets connect in chat so that We discuss further. Thank You
$20 AUD in 7 days
0.0
0.0

With an extensive background in business analysis, product management, and digital transformation spanning 17 years, I am equipped with the skills necessary to fulfil your Google Sheets Data Summary Setup needs. I have a profound understanding of data management and possess advanced knowledge in Google Sheets and Excel alike. I constantly leverage powerful tools like VLOOKUP, SUMIF, QUERY, and INDEX/MATCH to extract and organize data to meet precise requirements. Throughout my career, I have handled bulky data sets with ease and have a knack for summarizing them effectively. My understanding of categories, values, and dates would certainly aid in creating a comprehensive table for you that is organized by all three factors. Note: I have mentioned 3 days for project delivery but that can increase or decrease based on the quantum of data. I will be prudent to you in my timelines when I have access to data.
$25 AUD in 3 days
0.0
0.0

Hi I am an experice ex finance and currently work as programmer for a large company, i can help you with this project. I will gaave you an accurrate, quick and satisfation result for your need.
$15 AUD in 7 days
0.0
0.0

Hello, Excel already be my best friend because I used it everyday at work, since of then I have lot of experience in managing and organizing large datasets, and I believe I am the right candidate for your Google Sheets project. In my daily job, I extensively use tools like VLOOKUP, SUMIF, QUERY, and INDEX/MATCH to analyze construction data and make informed decisions. As accuracy and efficiency are paramount in both of our professions, my advanced knowledge in Google Sheets, its similarities with Excel only making me better at it! Please share the necessary files needed for the project through the provided link after our collaboration has begun. Let's get started!
$30 AUD in 3 days
0.0
0.0

Melbourne, Australia
Payment method verified
Member since Aug 26, 2023
$140 AUD
₹750-1250 INR / hour
₹750-1250 INR / hour
$25-50 USD / hour
$10-30 USD
$2-8 USD / hour
£5-10 GBP / hour
$10-30 USD
$15-25 USD / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
€250-750 EUR
₹400-750 INR / hour
₹12500-37500 INR
₹750-1250 INR / hour
$30-250 USD
€6-12 EUR / hour
₹12500-37500 INR
₹12500-37500 INR
₹600-1500 INR
$250-750 USD