Spreadsheet Projects
Looking for freelance Spreadsheet jobs and project work? PeoplePerHour has you covered.
opportunity
Accountant To do up 4 months of Vat returns (Ireland)
We are looking for an accountant who understands the Irish VAT system. We have Jan, Feb, March and April VAT returns to be done up. Our VAT return consists of 20 Sales invoices. Our accountant will submit the VAT return when you have the spreadsheet completed. i can provide a spreadsheet of November and December VAT returns as an example
16 hours ago11 proposalsRemoteData Entry
I work as part of an accountancy firm and we require someone who has good knowledge of using excel & tax calc. we require 2 excel spreadsheets to be transferred from excel to tax calc. these spreadsheets include customer name contact details Etc. the outcome we expect is that all information from the excel spreadsheets is transferred onto tax calc. the deadline we have for this is 2 weeks. we will pay a fixed fee of £102
12 days ago51 proposalsRemoteOperational Metrics Dashboard Design
I'm looking for an expert in analytics to create a compelling dashboard that pulls data from Excel spreadsheets. You would be focussing primarily on reflecting operational stats in a clear and concise way. Key duties: • Integration of Excel spreadsheet data into the dashboard • Showcasing operational metrics, specifically focusing on account monitoring status on a daily basis like inspection due date Perfect for someone who: • Has experience with data integration from Excel spreadsheets • Understands operational metrics and how to present them effectively • Can deliver a user-friendly dashboard for easy understanding of data • Has a keen eye for details and accuracy.
14 days ago20 proposalsRemoteQuickbooks Product Setup
I’m hoping someone can help. I’m after some quickbooks advice regarding tracking stock for an antique business I’ve just started. I've got myself into a bit of a pickle and need some help. I added an eBay sync app to import orders etc from eBay, however I don’t think I played enough attention when setting it up and I’m now a bit confused about how to deal with all the products it has created in QB, as none of them have a cost price. I know I can manually go through each and add a cost price, but this seems long winded, especially as each item is a one off. I have a detailed spreadsheet of items purchased with selling prices etc, would it be possible to wipe my QB data and import the spreadsheet data and then start afresh with a new system to track everything? Ideally some kind of simple system, as some lots I buy have hundreds of individual items in them, so I’d like to avoid making 1000’s of products in QB and then listing each one on eBay/our website. Maybe I’ve overcomplicated the whole situation? Would I be better off recording the overall stock value manually once a month like a stocktake rather than trying to track each individual item in QB? Clearly I’m lost and starting to ramble…. I’m keen to get a solution sorted out sooner rather than later so I don’t make the problem larger by buying and selling more items. Is this something you could help me with?
a day ago20 proposalsRemoteopportunity
Excel analysis and spreadsheet template tracking sheets needed
Excel analysis and spreadsheet template tracking sheets needed for student results data. I require the spreadsheets that I have and some formulas already provided to work how I want them to do that results can be input and student data can be tracked and analysed easily. I need this work done asap.
23 days ago58 proposalsRemoteopportunity
Netsuite - Development
We use Netsuite now for our CRM and need some help with setting up the below list in the system. • Integrate website leads into NetSuite ( with allocation permission remaining with the Sales Manager) our website is on a Shopify platform. • Manual entry of leads received from a direct call. • Visibility of the lead/deal journey • Ability to highlight hot jobs for the month over a certain $$ value. • Reporting matrix ( Spend less time reconciling spreadsheets and more time strategizing) • Set up templates for standard proposals, so that the sales team can add items out of the system and send out of the system.
8 hours ago16 proposalsRemoteWeb scraping
I am looking at Web scraping software, based on input; to produce a spreadsheet of URL, email address and phone numbers extracted from the contact us pages,using legitimate methods. A URL scrapper will also need to be built into the application. To be able to facilitate the above process.
21 days ago30 proposalsRemotepre-funded
Search coverage of my work to look for most viral content
I would like someone to search Google and social media to capture the top examples of my work going viral. You'll need to look for not just people sharing the work from my account / website but also when the press writes stories about it and those go viral. Delivery will be links to the top coverage along with the key numbers in a spreadsheet, and a folder of screenshots of the examples showing the success (i.e. tweets which show the stats at the bottom). The aim is to prove that the public and press pick up my work and then the reach it has. I can supply the top ten pieces of work/stories to look for. I am expecting this to be a full day of work, and I'd like you to start soon after we confirm. Please put "I read the full ad" at the top of your reply or I'll assume it's bot-generated auto-apply and report it as spam (PPH is infested with AI bots!).
3 days ago22 proposalsRemoteopportunity
Companies House API
I am looking to pull data from companies house using their api. (https://developer-specs.company-information.service.gov.uk/companies-house-public-data-api/reference) I would like the script to look up the company name in column A of this gsheet https://docs.google.com/spreadsheets/d/15rRpXZMmf0wUXl0hfQy05HBGifTCAAHl19q_gqzZJNg/edit#gid=0 and return the company number, director and persons of significant control. I would preferably like the script to work in Appscript within the gsheet if possible? It does require an API token so it will require you to register to create a token.
11 days ago44 proposalsRemoteWeb Scraping
I have a series of projects whereby we would like to take the contact data of travel agents from membership directory websites. An example of this, is this site. https://www.abta.com/abta-member-search/results?search=London Another example is this site. https://www.etoa.org/member-search/?term=&type=&country=United+Kingdom&v_s_m=&d_s=&p_s=&c_r_l=&y_e=&c_a_p_s=&c= We need directory data extracted and ideally we would like the data to be in a spreadsheet with name, email address, telephone number, Company name etc. We have 11 websites we would like the data from. And multiple ofther projects too. Kind regards, Nicola
8 days ago72 proposalsRemoteEntering receipts in Excel
I need UK based person for entering receipts on a spreadsheets for bookkeeping purposes. each time this needs doing the batch of receipts will be sent to you and on completion will be randomly checked for accuracy. there will be roughly around 500-700 receipts. Each receipt will require about 8-9 fields e.g. Date, supplier, Desc. Nett amount, VAT, total, method of payment This can be done in the next 2-3 weeks but will have to give a time at before excepting the job my budget is 10p/ entry
16 days ago71 proposalsRemoteOnline Administrative Assistant
We seek an experienced online administrative professional to seamlessly support our virtual business operations. Remote collaboration and multitasking acumen are necessities for managing communications across channels, compiling research, entering financial data, creating presentations and spreadsheets, scheduling conferences, assisting customers, and performing general tasks as assigned. An organized self-starter proficient in Microsoft and Google Suites who reliably meets deadlines is ideal. Applicants should demonstrate proven experience in virtual roles with strong communications and organization/time management capabilities. Bachelor's degree or comparable experience preferred. Prioritization of client service and digital literacy are highly valued.
13 days ago43 proposalsRemoteopportunity
Research for Smartphone stores USA
THE BUDGET IS FIXED I need someone to research and find the names of all independent smartphone/cell/mobile phones in USA. These are phone repair stores or phone accessories stores or just phone stores. Okay so we need all the independent stores. We do not want the stores like Apple Centres or Sony or T Mobile or Orange or Vodafone or 3 etc. We want the smaller stores. So you’ll need to check. We need them all neatly put into an excel spreadsheet We also need the emails to be put into a folder. We need the store name, address, facebook page, website (if they have one) and email address. There are about 170,000 stores in total. All States of the USA required. Data can be found on Google, Facebook, Linkedin and other data resources.
21 days ago29 proposalsRemoteopportunity
Write a year's worth of filler social content
I need to fill 2024's social media calendar with filler content. Sundays - Product Promotions Mondays - Motivation Mondays Tuesdays - Blog Promotions Wednesday - Rewards, Referrals, Newsletter Promos Thursdays - Resource Promotion Fridays - Fun Fact Fridays Saturdays - Product Promotions You can definitely use AI to create them, but want to make sure they're formatted for a US audience and on-brand for us. We're a label printing company. Key highlights are sustainability and eco-friendly, VIP customer service, easy online ordering, etc. If hired, I'll send you all of the links for CTAs, etc and provide a spreadsheet for posts to be logged into. NOTE: You will not need to create any images. This is purely copywriting.
21 days ago40 proposalsRemoteResearch for list of smartphone stores in France and Australia
I need someone to research and find the names of all independent smartphone/cell/mobile phones in both France and Australia. These are phone repair stores or phone accessories stores or just phone stores. Okay so we need all the independent stores. We do not want the stores like Apple Centres or Sony or T Mobile or Orange or Vodafone etc. We want the smaller stores. So you’ll need to check. We need them all neatly put into an excel spreadsheet We also need the emails to be put into a folder. We need the store name, address, facebook page, website (if they have one) and email address. There are about 5,000 stores in France. There are about 1,500 stores in Australia. Here are the regions to search. These can be found on Google, Facebook, Linkedin and other data resources. You will be provided with all the areas to search,
22 days ago35 proposalsRemote20 PAGE ONPAGE SEO OPTIMIZATION KEYWORD
Hello, Straight forward project as i do not have the paid tools such as SEMRUSH / AHREFS / SCREAMING FROG / MOZ / LINKWHISPER / OTHERS 20 url. Need everything from site audit/analysis/ competitor SPYFU/keyword planning/content seo and technical seo. Excel file for job requirements. https://docs.google.com/spreadsheets/d/1lMut4pGMJ8KAPt-sbWF5IQObPDCwMk7LXaGnvq77kYg/edit?usp=sharing For reference only. SEO audit. https://docs.google.com/document/d/13YbdtXqbqEyQlHu_RBd2D16pj1wgja-vep0K2fmy1gs/edit?usp=sharing 7 Days to complete 20 On-Page SEO. Wordpress + Rank Math Pro Please tell me what software you will use to complete these tasks.
a month ago30 proposalsRemoteEducation Admin support
We are a small team of Healthcare Professionals offering a 1-yr Certificate Programme in Psychedelic Practice. This is aimed at Healthcare Professionals worldwide. We will likely be expanding to offer other courses over the coming years(s) Website: https://www.psyedu.co.uk/ Our current Education Admin Lead is leaving in May. We need someone to work flexibly around 3-6 hrs a week (10-20hrs per month) doing basic administrative tasks for our Education Organisation. It will be very busy between June and September (more like 6hrs per week) then will calm down a bit at other times in the year. We are a small start-up in our second year, just beginning to settle into our rhythm and we now need reliable low-level input which will likely slowly increase in workload over the next 3-5yrs. Job Description Skills/knowledge: MUST HAVE: Excellent written and spoken English, Organisational Skills +++, Microsoft office, excellent written and spoken communication skills, an understanding of the course we offer or a willingness to learn about it DESIRABLE: some knowledge of healthcare and how psychedelic practice is starting to be used in healthcare Qualities: flexibility Experience: any role which demonstrates the capacities outlined below Hours: 10-20hrs per month, ideally 1-2hrs on Mon, Wed and Fri each week Job Description: Key Responsibilities: 1. Communication Management: o Serve as a primary point of contact for internal and external communications. o Handle incoming emails, and redirect them as appropriate. o Draft and distribute notices, tutorials, open events and announcements. 2. Administrative Support: o Assist in scheduling appointments, and meetings for management and staff. o Maintain and update company databases, records, and filing systems. o Prepare and distribute documents as required. o Liaising with different organisations 3. Documentation and Recordkeeping: o Ensure accuracy and completeness of documents, contracts, and agreements. o Maintain confidentiality of sensitive information and handle it with discretion. o Organize and archive records in accordance with company policies and regulatory requirements. 4. Team Collaboration: o Collaborate with colleagues and departments to support cross-functional projects and initiatives. o Provide administrative assistance to various teams as needed. o Foster a positive and cooperative work environment through effective communication and teamwork. o Attending meetings once every two weeks 5. Problem Solving and Decision Making: o Identify issues or challenges in administrative processes and propose solutions for improvement. o Prioritize tasks and manage time effectively to meet deadlines and goals. Qualifications and Skills: · Proven experience as an Administrator or similar role. · Proficiency in office software applications, including word processing, spreadsheets, and presentation software. · Strong organizational and multitasking skills with attention to detail. · Excellent verbal and written communication abilities. · Ability to work independently and collaboratively in a fast-paced environment. · Discretion and professionalism when handling confidential information. · Problem-solving and decision-making skills. · Flexibility and adaptability to changing priorities and tasks.
19 days ago41 proposalsRemote
Past "Spreadsheet" Projects
I need a Google Drive Spreadsheet Template Built to Track Deals
Hi all I require a Google Excel sheet created that features a main data page which will have a number of fields populated. One of those fields will have a drop down list with various members of staff displayed. When a member of staff is selected then that row needs to appear in a separate tab that is only for that member of staff to see. As they progress that deal and add notes, those notes are then updated on the main sheet that I am able to view. If I change the member of staff allocated to that record then all details need to transfer over to the new member of staff and be removed from the old member of staff. Ideally I would need a data sheet where I can list members of staff to make it easier to update as staff join or leave the company.
pre-funded
Update Excel Spreadsheet
I need an Excel Spreadsheet repaired and updated so as to make it functional
Data Entry
I need data from receipts and invoices put into an excel spreadsheet. The receipts / invoices will come in batches of 100. The excel template is attached as well as examples of the receipts / invoices. A folder needs to be kept of any invoices where all the data is not available.