Spreadsheet Projects
Looking for freelance Spreadsheet jobs and project work? PeoplePerHour has you covered.
Data 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
13 days ago52 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.
15 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?
2 days 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.
24 days ago59 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.
a day ago20 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!).
4 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.
12 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 ago73 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
17 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.
14 days ago44 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.
22 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,
23 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
opportunity
Power BI replication of excel spreadsheet
I need a replication of the attached xls into Power BI (columns K:AD). I would also like that the data feed will be automatic into Power BI from web query (https://www.youtube.com/watch?v=o5y0m4zF6VU) via a dynamic stock quote, I will scrape via Yahoo Finance. Thus, the data and statistic analysis will update for whichever stocks I maintain in the backtable/xls. In DoR worksheet, all cells in yellow will feed from the above scraping, the orange cells need to be calculated in the query. For the visual in BI, something close to layout in columns (K:AD) is needed - which includes some statistical calculations (formula shown in xls). Ideally I would be able to toggle between the 3 data sets within the same sheet i.e. calculated for i) close-close returns, ii)high-low returns and iii) open-close returns.
Create Spreadsheet of email addresses and names from Facebook
I need someone who will help me with an admin task to collect email address from our Facebook group and make a spreadsheet of them. Everyone that joins our Facebook group is asked if they want to sign up to our newsletter and puts their email address in the answer if they do. We would make you an admin of the Facebook group and you would go through each person that joins and collect name and email address into a spreadsheet for us. This is the Facebook Group: https://www.facebook.com/groups/rebelfinance We need to go back to February the 15th 2024. There is about 1000 people in total to go through.
opportunity
Copying details onto a spreadsheet.
I have a database of company names and employee counts on 1 tab and on the 2nd tab the company names but with contact details. Tab 1 is split into 2 colour groups. What I need is someone to copy company line 1 and see if it appears in tab 2, if it does change that line into yellow or green to match that line in tab 1 and on the line in tab 2 add a new column 'URL with their website address from tab 1 . There are lots of lines. how long will this take you please?
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