Google sheets formulas sumроботи

Табличка буде використовуватись для аналізу конкурентів ринку. Вона має бути зручною для ведення, зі зрозумілим звітом у вигляді графіків на основному дашборді. Показників в різних категоріях які вона має рахувати більше 30, терміни, фінанси, порівняння, відсотки, категорії, середні значення. Чекаю Ваших пропозицій стосовно вартості

Рекламная компания google performance max долго не работала и сейчас после запуска выдает странные результаты, нужно проверить все ли настроено, возможно подкоректировать и дать рекомендации

Ми маємо сайт з торгівлі на форекс біржі, нам треба запустити Адвордс на неї. Потрібна наявність досвіду в цьому

Потрібно налаштувати рекламні компанії у Google Ads! По продажу ноутбуків та сервісному центрі! Наш сайт Пропонуйте свої пропозиції!

Потрібно налаштувати рекламні компанії у Google Ads! По продажу ноутбуків та сервісному центрі! Наш сайт Пропонуйте свої пропозиції!

Потрібна допомога в налаштуванні контекстної реклами. Ми - сервісний центр по ремонту та обслуговуванню комп'ютерів, ноутбуків, телефонів, планшетів у м. Львів. Є недавно створений сайт.

Потрібно налаштувати та запустити рекламну кампанію двох груп товарів в інтернет магазині

Фірма займається легалізацією побуту іноземців на території Євросоузу, організовує мовні курси, допомагає студентам вступити до вузів ЄС. Необхідно створити гарний сайт і позиціонувати його в топ-5 чи 10 в Google для отримання великої кількості клієнтів. Розгляну і інші пропозиції щодо пошуку клієнтів.

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.

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

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 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'm looking for a skilled and detail-oriented professional to assist me with entering handwritten data into a digital format. - The data is simple text-based, so no complex calculations or formulas are involved. - The main task will be to accurately transcribe data from scanned or handwritten documents into a spreadsheet. - Attention to detail is paramount, as even small errors could cause significant issues down the line. Ideal candidates should have a proven track record of accuracy and efficiency in data entry tasks. Prior experience handling handwritten or scanned documents is a definite plus. A keen eye for detail and the ability to maintain focus over extended periods of time will be essential for this project.

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

Necesito migrar toda la info de sheets en Airtable y tener la gestión del negocio en esta plataforma.. Seria gestión de clientes, stock, pedidos, facturación, contabilidad, etc.

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

...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 that this data is...

I'm in need of a skilled freelancer who can assist me in collecting contact information for recruitment companies specifically operating in Saudi Arabia. Those companies are NOT necessarily bas...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 VERIFIED leads, 3- Turnaround time, 4-...

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.

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst ...through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunities. • Well-versed with dynamic loops, data extraction from images. • Work with users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboards using advanced formulas, Advanced Excel, Python and other techniques • Consolidate, sort, organize and summarize data using basic mathematical operations • Interpret data and metrics using charts, tables, Dashboard and other graphics in Micro...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the docum...Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or ...

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations.

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

...days before y or n 1 day after promotion y or n 2 days after promotion y or n 3 day after promotion y or n USA globally holyday y or n USA state holyday y or n Holyday name holyday number of days holyday 1 day before y or n holyday 2 days before y or n holyday 3 days before y or n 1 day after holyday y or n 2 days after holyday y or n 3 day after holyday y or n Store id Store state Store city Sum sold = current price * haw many sold Competitor in the same city y or n data simulation should be done in both 1) python and then python code to upload to SQL DB 2) and also in SQL you provide 1 sql and python code for simulation 2 main table creation code (only sql) for python for simulation provide detailed instructions and code how to run python code and how to upl...

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 in need of a skilled developer to add a custom feature to Invoice Ninja. The following required features need to be developed: 1. Receipt on top of payments module - int...CSS can be given. CSS can also be hard coded, only used for RTL. but should only be enabled if user selected either Hebrew or Arabic as language. 3. Expenses sub category - expenses add a sub category (now only category exists), also define how much % of the expense is approved. For example, in some countries if you report car gas expense, only 45% will be acknowledged as expense from the total sum. so 45% from the total expense should go into the reporting. The ideal candidate will be an individual or team with extensive experience in Invoice Ninja, PHP, Laravel, CSS, HTML and proficient in creating c...

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

We are looking for a skilled freelancer to integrate Google Customer Reviews into our Google merchant.

...days before y or n 1 day after promotion y or n 2 days after promotion y or n 3 day after promotion y or n USA globally holyday y or n USA state holyday y or n Holyday name holyday number of days holyday 1 day before y or n holyday 2 days before y or n holyday 3 days before y or n 1 day after holyday y or n 2 days after holyday y or n 3 day after holyday y or n Store id Store state Store city Sum sold = current price * haw many sold Competitor in the same city y or n Week day – mon, teu, wen, ther, fr, sat, sun Weekend y or n Day after weekend ***** end Main table to calculate ***** data simulation may be done in python and then upload to SQL DB (but better in SQL) you provide both 1 sql or python code for simulation 2 main table creations code (only sql) ...