Google sheets formulas average jobs

I need a proficient data analyst to help create a spreadsheet from 24 different lists. I am creating a KANBAN system for stores and have already made the table for each card to be filled out, along with all the lists. The first ...looking for someone to complete the rest. It is a simple copy and paste job. - The lists contain numerical and textual data which the spreadsheet should accurately reflect every time there's a change. - It's imperative that the chosen freelancer has a fine eye for detail, to maintain absolute accuracy throughout the lists. - This project requires you to have strong skills in using Excel, Google Sheets or similar applications, along with a comprehensive understanding of data management techniques. I'm looking for both a quick and ef...

...=(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, instead of getting 19.88%, the result I am seeing is 1987.95%. This suggests there might be an error with the data, cell formatting, or an unnoticed issue in the spreadsheet. Specific Tasks: Review the Spreadsheet: Analyze the provided Excel file to ensure all values, formulas, and cell references are correct. Identify the Issue: Determine why the formula results in 1987.95% instead of the expected 19.88%. Correct the Calculation: Fix the formula or any underlying issues to display the correct profit percentage. Provide Documentation: Explain the issue and the steps taken to resolve it, so I can avoid similar issues in the future. R...

I am looking for a freelancer who can help me with simple copy-paste tasks for my website. Key Responsibilities: - Copying text content from various sources and pasting them onto the website - Ensuring correct placement of the text within the website's structure Ideal Skills and Experience: - Proficiency in basic web browsing...editing - Attention to detail for precise copying and pasting - Prior experience with content management systems (CMS) is a plus, but not required This is a straightforward job that doesn't require any formatting skills, just the ability to accurately copy and paste. The selected freelancer can expect ongoing work based on performance. Here is walkthrough of task. We expect 2-3 Lessons per hour on average for fulltime work.

As a healthcare business, I'm looking for a highly skilled Google Ads expert to help me drive lead generation through our online campaigns. Key Project Details: - **Objective:** I aim to generate a consistent flow of leads to our website based in Delhi NCR Ideal Experience/Skills: - **Proven Track Record:** I'm looking for someone with a strong background in lead generation through Google Ads. Previous experience in the healthcare industry is a plus but not mandatory. - **Analytical Skills:** The ability to analyze ad performance and make data-driven decisions for optimization is crucial. Please be ready to provide examples of successful lead generation campaigns you have run and how you plan to approach this specific project.

I'm currently running Google ads for my business and I want an expert to optimize it. I'm looking for someone who can help me to maximize the effectiveness of my Google Ads campaign.

I'm looking for a professional to verify the phone number for my Google Business profile to enhance its credibility and visibility. Key Requirements: - The verification method should be of Landline number. Ideal Skills and Experience: - Experience in managing Google Business profiles. - Proficiency in verifying phone numbers using SMS. - Knowledge of best practices to increase trust with customers and enhance visibility on Google Business.

I'm looking for a professional WordPress developer who can help me resolve Google Console errors on my website. I'm having trouble with Google Console errors on my WordPress website. I need a skilled developer to solve this issue. They should ensure that I can detect all console errors before submitting to Google. The ideal freelancer should have: - Extensive experience in resolving Google Console errors on WordPress websites If you read the job post carefully mention word #googleconsole on top of the proposal.

...follow a trend of what i do... I worked on 2,000 Continuous improvements projects globally (Iraq, Kuwait, Dubai, Qatar, India, Jordan, Syria, Lebanon, Canda, and USA) - You can use pictures on the web of before and after for relative projects to show how it was before and how it became after. - I expect to see Technical terminologies to demonstrate how i went from 36% Inventory Accuracy to an average of 98% using zone picking, barcoded inventory, and mixed wave picking strategies as an example. (You will need to make points like these for every relevant before and after picture. Your work will be crucial in showcasing my capabilities to potential clients and employers. You will start by making a complete template with your idea of how i can best represent myself. If your delive...

Hello freelancer We are a translation company and we need a lot of Japanese translators. We can deliver projects on a long term basis at an average price per word. We need quality translators to protect our clients. Please enter price per word.

I have a financial plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include ... expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use of formulas will be crucial.

...expert who can help me optimize my video game site for search engines, focusing specifically on Google. My site is dedicated to selling virtual goods for Final Fantasy XI, and I'm looking to enhance visibility and draw in more potential customers. Key Responsibilities: - Conduct a thorough analysis of my website's current SEO situation, pinpointing areas for improvement. - Implement effective SEO strategies to boost my site's ranking on Google. - Optimize keywords and meta tags. - Rectify existing SEO errors, broken links, and other issues that might be hindering my site's visibility. The ideal candidate will have: - Proven experience in SEO, particularly with e-commerce sites. - Expertise in Google SEO strategies. - Strong knowledge of keyword...

Monthly Seo Ongoing With weekly work reports and google ads for

I am seeking a creative and experienced video editor to create a captivating YouTube introduction video to increase the average view duration of my posted content. This video is primarily targeted at young adults and business professionals. - Objective: The aim is to create a video that will hook my viewers, encouraging them to watch more of my posted videos, hence increasing the average view duration. - Video Content: The video will be repurposed from the original recording. - Desired Video Length: The video should be anywhere from 30 seconds to 1 minute long, capturing the audience's interest from the get-go. Ideal Skills: - Experienced with video editing in line with YouTube's format and general style. - Ability to create content that appeals to a mixed audienc...

Upload application on google play console.

I'm doing the google ads setup and have a campaing already but it's not visible Need help through team viewer to set it up and see the clicks as I did earlier.

I'm looking for a skilled Excel expert to create a project ...automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on target. * Data validation for entry consistency: Ensuring that data is entered correctly, preventing errors. *Eligible to insert in google sheets with same formatting The ideal freelancer for this project should have: - Proficiency in Excel formulas and functions for tracking project progress. - Experience in creating automated Excel sheets using conditional formatting and data validation. - Attention to detail to ensure the accuracy and functionality of the sheet. - Good communication skills to understand the project requiremen...

I'm looking for a professional to perform a comprehensive SEO audit, with a focus on Google, for my website. The ideal candidate should have: - Strong expertise in SEO, particularly Google optimization - Experience in identifying and resolving technical SEO issues - Ability to work with minimal analytics and previous SEO reports Key objectives for this project: - Identify technical SEO issues: My website has been live for a while but is not getting any search traffic. I need a thorough review to pinpoint any underlying technical issues that may be hindering its search visibility. - Recommendations for improvement: Based on the findings, I would like actionable recommendations on how to improve the technical SEO of my website. If you have a strong track record of deli...

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 ...

Hi, Looking for a person to create an spread sheet monthly for sales records during that month. Will need to take information off of individual sales order sheets/emails and transfer it onto a spread sheet... buyer/address/item(s) they bought/amount they paid etc. Will be a reoccurring task per month. Will pay per month, expecting 100-200 sales per month. Please show rate per entry.

I need assistance in integrating an automatically generated Order ID within my Google Forms. Many people do it so, AT THE END the form, it will generate an ID number that will go into the Google Sheet where the responses go. In this case, I need it to be in form of a Short Question INSIDE THE GOOGLE FORM, Not at the end. So this way, the number generated will be part of the info the client sunbmits like Name, Phone Number, Zip Code, etc. Please ask questions before agreeing to begin.

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

It is necessary finish a web application in python + django regard the statistic of stocks. So it is necessary: some fetaures of some filter; -. make some change to mysql database and api to datafeed. -. verify the formulas and add some features; -. make better the design. - create an admin page with security login and import stocks manually. Please answer only if you can show similar experiences

I am looking for an expert in Python progra...Python programming to assist me in the creation of a multi-timeframe indicator merge. The project entails the merger of the 4hr, 1hr, 15min, and 5 min timeframes while including specific indicators, namely Moving Average, Relative Strength Index (RSI), ADX, and Webslingers. To make informed bids, it's important to note the following: Ideal Skills & Experience: - Extensive knowledge in Python programming - Proven experience in financial analytics - Expertise in working with listed indicators Project Requirements: - Code the multiple timeframes using Python - Integrate the Moving Average, RSI, ADX, and Webslingers indicators - Generate the deliverable output as a CSV file Please feel free to inquire if you need more cla...

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'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.

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into comprehensib...

I need an in-depth SEO report, 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...

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros ...the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong understanding of Excel formulas, formatting, and data transfer functionalities - Excellent communication skills to ensure clear delivery and understanding of the project requirements Your primary focus will be on making sure the revised macro works seamlessly on Excel for Mac 2018 or later, while incorporating the desired...

...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...

...skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will involve running some simple statistical functions a...

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 in business strategy...

I run an online store and my 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 comm...

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...

...Three different format images for the Facebook ad: Square (1:1): 1080 x 1080 pixels Landscape (16:9): 1200 x 628 pixels Portrait (4:5): 1080 x 1350 pixels Details of the Changes: 1. Text Modifications Original Text: "290€/day (1450€/week) to which is added 0.55€/km" "We reimburse all tolls so that it reaches up to 1.35€/km" "We work with terminals in Germany, France, Italy, and England" "The average distance per day is 500 km" "Fuel surcharge included each week" "DN1, Gilău, Cluj" Revised Text: "1.40€/km" "2000 kms per week guaranteed" "Payment after 65 days" "We work with Terminals in Germany, Italy, Benelux" "Floresti, Cluj" 2. Map Location C...

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. ...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 track record of handling similar tasks successfully. Let’s set the ball rolli...

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 with empl...

...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'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

I need a versatile virtual assistant to manage both calls and emails for my English-speaking customers. On average, I receive between 10-50 calls and emails per day. Key Responsibilities: - Answering incoming calls - Responding to emails in a timely manner - Handling customer inquiries and complaints effectively - Maintaining a high level of professionalism and customer service skills Skills and Experience: - Excellent verbal and written communication skills in English - Previous experience in customer service roles - Ability to multitask and work efficiently under pressure - Proficient in using customer service software - Strong problem-solving skills and a positive attitude Please let me know your availability and your approach to handling peak times.

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...

I seek a professional to construct a sleek and modern musky bait caster reel. Materials: - The reel should be made predominantly from carbon fiber, a lightweight, and durable material. Sp...sleek and modern. Consider ergonomics, intuitive function placement, and clean design lines. Ideal Candidate: - The freelancer should have experience in designing and manufacturing fishing gear. Knowledge in material science, particularly with carbon fiber, is a must. A deep understanding of modern design in the context of fishing tools is necessary. This project is more than just creating an average fishing reel, it's about creating a gear that's both functional and stylish for the modern fisherman. Engineering and design principles need to intertwine precisely to deliver this p...

As a client, I'm in need of a gifted freelancer 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 ...

... 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 the required data and compile it into an Excel file with separate sheets for doctors' information and disease descriptions. Requirements: Programming Language: Preferably Python. Libraries: Experience with web scraping libraries like BeautifulSoup, Selenium, and data processing libraries like Pandas. Output Format: Ability to export data into an Excel file using Pandas or similar libraries. Error Handling: Robust error handling to manage failed requests and parsing