Google sheets data validation vlookup jobs
I need a skilled data analyst to help with daily updates of my product, customer, and regional sales data in Excel. The job involves using SUM and AVERAGE, VLOOKUP or HLOOKUP, PivotTables Excel functions and formulas for accurate and up-to-date data representation and analysis. Key Points: - Daily sales data update: The job will involve ensuring that the sales data for products, customers, and regions are updated daily. - Excel functions and formulas: The successful candidate should be well-versed in using Excel functions such as SUM and AVERAGE, VLOOKUP or HLOOKUP, and PivotTables to handle large sets of data accurately and efficiently. Ideal Skills and Experience: - Proficiency in Excel with a strong understanding of formulas and ...
I've created an Android app and now I'm seeking a skilled developer who has experience with Google Play Console to deploy this app for me. Key Project Requirements: - The app is ready for deployment, so the main task is publishing it on the Google Play Store. - The developer should have a deep understanding of Google's app deployment process and the ability to navigate the Google Play Console efficiently. Ideal Skills: - Proficient in Android app development and deployment. - Prior experience with Google Play Console. - A good understanding of app store policies and guidelines. - Strong communication skills to ensure a smooth deployment process. Please note that I currently don't need assistance with creating promotional materials for ...
I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.
I need to scrape data from a website. I'm stuck with an error. I used improtxml to scrape data from a class in a website I know. However, the fact that this website has classes has a problem: . While on page 1 there will be that text data, but on many pages, that text data is not there and it is accidentally pushed up to insert the class data below into the previous class data. To make it easier to imagine, there will be 4 rows. I will need to get a fix for each row into the google sheet. However, there are pages where I insert the link and there will be no row 3 or row 2 and then row number 4 will be inserted into row number 3, making the data incorrect. I need improxml to automatically check the syntax, if it is correct, it wil...
Dear translator, We are a company that develops live streaming and video chat apps. We are looking for native translators in various languages for a localization project regarding the FAQ sections of our apps. We will be sharing a Sheets file with the texts that contains HTML codes and placeholders, Therefore, this project requires a lot of close attention to detail and preferably, past experience working with HTML codes. The file has two tabs. The first one needs to be localized, while the second tab needs to be proofread. The tone of the translations should be friendly, inviting, and informal. The first tab is 1800-words-long, but a considerable amount of the answers has repetitions. The second tab is 932 words-long in English. Ideally, we will be asking you to install at lea...
I'm looking for an SEO expert to optimize my website for Google search engine rankings. The primary focus will be on improving the visibility and ranking of our product pages. Key requirements: - Demonstrable experience in SEO, particularly with a focus on Google. - Strong understanding of on-page optimization techniques. - Proven track record of improving search engine rankings for product pages.
...comparing my website to a competitor's on Google. This is an urgent task that needs to be completed ASAP. Key Aspects to Compare: - **Keyword Rankings**: I want to know where my website stands in comparison to my competitor's in terms of keyword rankings. - **Backlink Profiles**: A thorough analysis of backlink profiles for both websites is crucial. - **Site Structure and Content Quality**: Lastly, the report should assess the site structure and the quality of content on both sites. Experience and Skills: - **SEO Specialist**: I'm looking for someone with a strong background in SEO, particularly in competitor analysis. - **Data Analysis**: The ideal candidate should be proficient in data analysis to draw meaningful insights from the SEO tools and...
...professional familiar with Google Ads, Google Analytics, and Clickfunnels to assist with setting up conversion tracking on my Clickfunnels funnel. - Your primary task will be to configure Google Ads conversion tracking through Google Analytics and Google Tag Manager on my Clickfunnels website. - I've already set up Google Analytics on my Clickfunnels website, so the main focus is on the conversion tracking aspect. - The specific event I'd like to track is Calendly bookings on my funnel. It's crucial for me to monitor the number of Calendly bookings generated through my Google Ads campaigns. Your expertise in the following areas is essential for this project: - Proficiency in Google Ads and Google Analytics...
...expert to enhance my Google profile. Here's the full scope of the project: - **Keyword Optimization**: My website currently has a moderate ranking on relevant keywords. I need you to optimize the keywords for better search engine visibility. - **Profile Updation**: I'm looking to update my Google profile to better cater to local customers. This may involve changes in the description, contact information, or other details to make it more appealing to my local audience. Ideal candidates for this project should have: - Proven experience in SEO and Google profile optimization - A strong understanding of keyword research and optimization - The ability to analyze and act on the current state of my website's search engine ranking - A creative approach to t...
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world ...
...Firewall settings - HTTPS redirect I've identified these elements as potential causes for the issue. The platform my website utilizes is WordPress, and the SSL certificate in current use is Extended Validation (EV). Ideal skills and expertise for the project would be: - Extensive experience in web security, particularly WordPress platforms - Familiarity with HTML, CSS, JavaScript – particularly, comfort with altering WordPress settings related to these languages - Ability to perform cybersecurity audits and suggest improvements - Hands-on experience with SSL certificates, specifically Extended Validation (EV) - Past examples of successful security enhancements for websites - Familiarity with HTTPS redirect and Firewall settings. This project requires immed...
I need a professional and impactful Google Slides presentation designed for an information memorandum. The aim of this presentation is to effectively represent: - Our company's business and main history milestone - Our mission and core values - Our company's business performance data - Our future business strategies A broad understanding of business analytics is essential as business performance data will be central to the presentation. Expertise in chart and graphics creations within Google Slides would be useful—it's important that the data is easy to digest and visually appealing. A creative outlook would also be beneficial to deliver our strategies in an engaging way and to help articulate our company values. Previous experience...
...website is already up and running. I'm looking for a freelancer who can assist me with optimizing my existing Google Ads campaigns. The main goal of my website is to increase online sales, so I need someone who can help me ensure that my ads are performing as effectively as possible. The key responsibilities for this project include: - Analyzing my current Google Ads campaigns for potential improvements. - Making necessary adjustments to optimize the campaigns. - Providing recommendations for improving ad performance. The ideal freelancer for this project should have: - Proven experience with Google Ads and previous success in optimizing ecommerce campaigns. - The ability to analyze data and provide actionable insights. - Strong communication skills to...
I'm looking to boost the visibility of a video on my YouTube channel by obtaining 1 Lakh views. I'm aiming to target a general audience across the globe. I need someone with expertise in Google Ads and YouTube promotional strategies. The ideal freelancer should be able to: - Set up a targeted, but global campaign to reach as many viewers as possible. - Ensure the views are genuine and do not violate any YouTube terms of service. - Optimize the campaign for maximum reach and engagement. The primary goal of this project is to increase the visibility of my video among the Youtube audience and potentially increase engagement. The views should not be temporary or bot-generated. Please provide a proposal detailing your strategy and expected outcomes. Prior experience with ...
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
...experienced Google Ads specialist to manage a campaign promoting our company. The ideal professional should possess a good understanding of both Google Search and Display networks, as well as experience in video advertising on YouTube. Key Requirements: - Proficiency in Google Ads: Extensive experience in setting up, managing and optimizing campaigns across Google Search, Display, and Youtube is crucial. - Creative approach: Ability to create compelling ad copy and engaging video content. - Results-driven: Capable of increasing website traffic, generating leads, and improving brand awareness through the campaign. - Weekly updates on the ads. - Time-management: The project should be completed within a month. Ideal Skills and Experience: - Proven track rec...
I require the expertise of a proficient Odoo ERP freelancer to assist in migrating data from an old system to a new one. Key Requirements: - Expertise with Odoo version 15. Familiarity with the ins and outs of this system version is crucial to successfully migrate the data without loss or corruption. - Extensive experience is paramount. I'm eager to hear about the similar data migration projects you've handled in the past and the results you've achieved. - A deep understanding of the Accounting module which the data is primarily focused on. Ensure you are adept at dealing with figures, financial data, balance sheets and other financial reports. Best suited freelancers would be detail-oriented, meticulous, and possess a proven tr...
I have a Microsoft Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
I need an employee time tracking system on Google Sheets. The system should automatically calculate total hours worked, allow for marking employees as present or absent, and have fields for project number and name. Key Features: - Automatic Calculation: The system should calculate the total hours worked by every employee within the specified date range. - Attendance Tracking: There should be an option to mark employees as present or absent. - Project Details: Each row should contain fields for the project number and name. - Multi-employee Handling: The system should accommodate multiple employees' data in a combined sheet. Skills and Experience: - Proficient in Google Sheets - Experienced in creating automated time tracking systems - Familiarity wi...
...someone with excellent IT skills and a very good command and understanding of written English with the ability to fluently understand oral and written instructions in English. Also report writing is a major requirement. Typically, I would require someone with at least 1-year experience in the software testing field. Knowledge or experience in finance and business IT would be a plus. Knowledge of Google Sheets and GSuite overall is a huge plus. I would prefer someone with an ITQSB certificate or any similar certificate, although this is not a requirement. Bonuses for new bug finds while testing are available as encouragement and motivation for your work but will be subject to approval. I AM LOOKING FOR TESTERS AVAILABLE ON WEEKENDS mainly, although you can also work on w...
I need a plugin that includes Apple Pay, Google Pay, and Link payment methods. This plugin should offer a dynamic button to facilitate these transactions based on Stripe's documentation. Please view the documentation here: The app that uses the plugin should also be able to customize the 'statement description', which is a capability provided by the Stripe API (createPaymentIntent). The suitable person would have experience in creating Bubble plugins, and hopefully would be easy for the person to make a quick and simple payment integration.
House plans to be completed. Mark ups provided in 2 stages. DWG provided. You need to have experience in completing drawings for building approval. This job may need revisions once submitted for building permit. After revisions the job will be complete. Mark ups need to be reflected on entire set of plans (10 sheets in all) We will need to have at least one phone call to clarify the job.
I'm seeking a skilled freelancer to assist me with leveraging the free tier of Google Cloud ($300 credit) . I am a Google Cloud Platform account holder who wants to install and configure S/4HANA 2024. The primary goal for this project is development and testing. I'm looking for a freelancer who has a good understanding of both SAP S/4HANA 2020 and Google Cloud Platform. Your role will be to install and configure the software, ensuring it runs smoothly on the cloud platform. Key requirements include: - Expertise in SAP S/4HANA 2024 - Proficiency in Google Cloud Platform - Experience with installation and configuration processes - Ability to troubleshoot and offer post-installation support if necessary. Your assistance in this project will be hig...
...who will design an AI chatbot that works hand-in-hand with Google Assistant. This chatbot will be programmed to carry out multiple tasks: - Answer typical queries - Offer relevant advice - Schedule meetings - Perform any function that is currently possible for it to do verbally The AI chatbot should be compatible with Slack and eventually extend to all phone applications. The chatbot should integrate with a database. We could explore other data integration requirements during our discussions. Ideal applicants are those familiar with AI chatbot programming, Google Assistant integration, and broad-reaching app compatibility. Database integration knowledge is essential, with bonus points for those who can offer a variety of data integration possibilities. P...
Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract
...existing Google Sheet with Tranferz API. We need the API to retrieve and update data on our sheet based on the following specifications: - Fetching and updating Driver Information: The API will need to fetch and update data related to drivers. This includes their availability, current location, and other relevant details. - Displaying Ride Details: The API should be able to fetch and display ride details for each driver. This information is crucial for the drivers to efficiently manage their schedule and assignments. - Updating Payment Information: It is essential that the API updates payment information in our Google Sheet. This includes payments received, pending payments, and other financial details. I'm looking for a professional who can ensure tha...
...within each company. This could be anywhere between 10 to 30 people per company. - The information should be accurate and up to date. - If you have a strategy for obtaining this data, please share it in your bid. Skills/Experience: - Strong research skills - Data entry and data mining expertise - Proficient in Saudi Arabian business landscape - Attention to detail and accuracy - Web scraping - Web search - Leads Results should be in an excel sheet format, outlining the name, position, email address for each contact. Contacts for each company should be grouped together, end file should be in 1 sheet, not separate sheets. Send me: 1- Your strategy in finding those companies and collecting names and emails of relevant employees, 2- Total number of expected V...
Create a simple Sheets spreadsheet that tracks dates, deadlines, categories of tasks, and tasks. Needed by tomorrow morning us time. Should take under 2 hours.
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuousl...a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately...
Validation of Sample implementation of One Loan product (Business Loan) created by Transdigital team. - Help Transdigital team in End to end testing of the system after product configuration - Creation of Roles and Users - Generation of Reports - Conducting on the job training for Trasdigital Business Analysts
...separated on multiple phases but the first one and the most important is to build our dashboard on ERPNext by copy pasting what we have in the in-house built dashboard and creating DocTypes. After that, we'll create a new request for the other phases. Key features: - Custom field creation: The ability to create custom fields tailored to our specific needs. The system should allow for various data types, validation rules, and labels. - Custom form creation: The option to design custom forms with the ability to drag and drop fields where needed. The form should be easily modifiable to accommodate changing requirements. The primary users of this tool will be warehouse/fulfilment team, accounting, and catalogue . They are not developers and, therefore, the interface...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuousl...a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately...
I'm in need of a seasoned Google Ads professional who can help me with both setting up new Google Ads campaigns and optimizing my existing ones. The main goal of these campaigns is to generate leads from a B2C audience. Key Requirements: - Proven experience in setting up successful Google Ads campaigns - Ability to optimize existing campaigns to improve lead generation - Strong understanding of B2C lead generation strategies - Prior experience working with both B2C and B2B audiences on Google Ads is a plus - Excellent analytical skills to monitor and improve campaign performance
I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel
I'm looking for a seasoned specialist in Google Ads, specifically skilled in generating consumer leads. The primary goal of this campaign is to effectively generate consumer leads for a business operating within the food industry. - **Objective**: Generate a significant number of consumer leads. If a consumer searches my food category, my number should show up. - **Industry**: Food. The ideal freelancer for this project would have: - Substantial experience with Google Ads. Setting up ads and fine tuning to get desired results. - A proven track record in creating successful lead generation campaigns. - Basic understanding of the food industry and its audience.
I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.
Project Description: We are seeking an experienced Google Ads expert to manage and optimize multiple Google Ads accounts targeting the niche of dog owners. The selected freelancer will be responsible for managing 10 different Google Ads accounts and optimizing a total of 15 different campaigns over the course of one month. Responsibilities: Account Management: Manage and oversee 10 Google Ads accounts effectively. Campaign Optimization: Optimize a total of 15 campaigns within the dog owners niche to improve performance and ROI. Keyword Research: Conduct thorough keyword research to identify high-performing keywords relevant to the niche. Ad Copy Optimization: Continuously optimize ad copies to improve click-through rates and conversions. Bid Management: Monit...
I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.
We are looking for a skilled freelancer to integrate Google Customer Reviews into our Google merchant.
As a real estate professional, I'm in need of a Certified SEM Expert with extensive experience in Google Ads to help me boost my product sales. Key Responsibilities: - Implement creative and strategic Google Ads campaigns to drive qualified leads - Optimize ad spend and conversions to ensure a high ROI - Monitor and analyze campaign performance and provide regular reports Ideal Candidate: - Proven track record in managing real estate-focused Google Ads campaigns - In-depth understanding of the real estate market - Google Ads certification - Strong analytical and problem-solving skills - Excellent communication and reporting abilities Please include examples of your past work in your proposal, particularly those that have led to an increase in sales for r...
...letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help
We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and Digital Marketing
I am looking for an expert in Google Ads to manage a campaign aimed at boosting sales nationally. The campaign's primary goal is to increase the sales of our medium-priced products, ranging between $50 to $200. The ideal candidate for the job should: - Be a Google Ads certified professional - Have a demonstrable track record in running successful sales campaigns, preferably at the national level. - Have excellent knowledge of Google Ads strategies and algorithms to target the right customers efficiently. My goal is to increase our sales significantly and ensure our ads get the best visibility and result in higher conversions. Your expertise in driving traffic and generating leads will be key to the success of this project.
I'm seeking an experienced professional adept at developing and managing Google Ads, particularly within the realm of Display Network campaigns. Your key responsibility will be to increase website traffic to help boost our online presence. Proficiency in analyzing performance reports, monitoring bid management, and optimizing adverts for best ROI is required. To apply, please share: - Your level of expertise and knowledge with Google Display Network - Proven experience in successfully increasing website traffic through Google Ads - Certification in Google Ads will be a plus Only freelancers with extensive experience working with Google Ads are encouraged to apply.
I'm in need of a Google Ads expert to help me boost my product sales through Google Search. I have a list of specific keywords in mind that I'd like to incorporate into the campaign. Key requirements: - Proven experience in Google ads, particularly on Google Search - Ability to develop and optimize campaigns to achieve sales goals - Familiarity with keyword selection and management Your main responsibilities will include: - Reviewing and refining my existing list of keywords - Creating and implementing effective Google Search campaigns - Monitoring the campaign performance and making necessary adjustments - Providing regular reports on the progress and suggesting further optimizations If you have a solid track record of boosting product sales...
...skilled professional to assist in our Google Ads marketing campaign with the primary goal of generating leads at a national level. Key Requirements: - Experience in designing and implementing Google Ads campaigns focused on lead generation - Ability to target national audiences effectively - Proven track record of delivering on lead generation targets - Experience in the Healthcare industry (preferred but not mandatory) Your tasks will include: - Setting up the campaign to focus on lead generation - Designing highly effective ad copy and visuals - Continuously monitoring and optimizing the campaign to maximize lead generation - Providing regular reports on campaign performance If you have a proven record of helping businesses generate leads through Google Ads, p...
I'm looking for a freelancer who can help optimize my text and image-based daily news blog for Google Discover. Key Points: - The blog is updated daily and covers news content. - The main goal is to make the content more visible on Google Discover. The ideal candidate should have a strong understanding of Google's Discover algorithm and proven experience in optimizing blogs for the platform. Familiarity with news content and SEO strategies for news websites is a big plus.
