Google sheets formulas sumdela

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

V svoje poslovanje bi radi vključili digitalni marketing in oglaševanje. Radi bi prodrli na izbrane evropske trge in tam razširili našo prepoznavnost.

I am in urgent need of a professional who can build a website for me. This website should be integrated with Google Reviews. Here’s what I’m looking for: - Google Review Integration: The core feature of this website is its integration with Google Reviews. I need the website to display these reviews. Moreover, the website should be able to collect and showcase customer reviews. Customers should also be able to leave reviews directly on the website. - Review Management: It is crucial that the website can manage these reviews effectively. Specifically, the website should have the functionality to hold negative reviews privately and only release positive reviews to the public. This feature is key for maintaining a positive online reputation. Time is of the ...

I'm in need of a Google Sheets scripting expert who can help me create a bidirectional data transfer system in Google Sheets. - The task involves transferring ALL data from one main sheet to multiple other sheets. - The data should be copied as well as linked to the other sheets. - The script should work bidirectionally, meaning any changes made in the source sheet should be reflected accurately in all the other sheets and vice versa. Ideal Skills and Experience: - Proficiency in Google Sheets scripting, specifically working with data transfer and bidirectional systems. - Knowledge of how to copy and link data between sheets. - Experience in creating and maintaining bi-directional data systems. - Ability to ensure...

I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation

I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!

Prosimo, vpišite se ali se prijavite za več podrobnosti.

I'm looking for an experienced professional to boost my Google My Business (GMB) listing through accurate citations. The main goal is to increase online visibility and foster customer trust, ultimately enhancing our brand's digital presence. Key Responsibilities: - Focus on citation that promote my business's products or services. - Ensure all citations are consistent and correct. Ideal Qualifications: - Proficient in managing Google My Business listings. - Solid understanding of local SEO and citation building. - Proven track record in increasing online visibility and customer trust through well-managed citations. Note: My business listing on GMB has already been claimed and verified, so immediate work can begin. If you have the right skills and experien...

I need a Python script to be deployed as a Lambda function and capable of processing tokens and handling verification and info retrieval tasks successfully. The Lambda function will handle both Google Sign-in ID and Access tokens. Summary: "Users creation" will be in DDB. "Endpoint creation" using API gateway. "User Authentication" using JWT "User Login" is via Google Sign-in

I am in need of a virtual assistant who can efficiently handle my Instagram & FB business account. It involves the following: - Fast SEO for startup and ranking them - Proactively DMing and reaching out to my target audience with the goal to enhance leads and ultimately convert them to sales. Initial target 100 DM’s per day - Responding to messages in a prompt and friendly manner. - Managing and moderating comments to ensure a positive experience for my followers. This is a part-time role requiring 1-2 hours of your dedicated service every day. You need to have excellent interpersonal skills and a knack for sales talk. Preferably, you have experience with Instagram's and Facebook business interface and are familiar with its demographics. I look forward to your bid.

I need help rectifying a previous freelancer's error by adjusting what displays in my Google business listing. What is listed in the image below my company name has nothing to do with my business and was due to a template they used. Just needs to be changed to reflect my company and what it does.

I need an efficient and experienced professional who has a good understanding of Google Sheets and data analysis and entry. Specifically, I need: - Creation of PLP by Copying-Paste Data entry. - Searching a Google sheet for specific products that should be on that PLP - Manually adding each product to that specific PLP based on the results from the sheet A full and detailed brief is available.

I'm seeking a specialist in DV360 programmatic advertising and pixel tracking. Key Responsibilities: - Rumning programmatic digital campaigns through DV360 Setting up new pixel tracking for conversion tracking. - Ensuring tracking is properly integrated with our Google Ads campaigns. Ideal Skills: - Proficiency in Google Ads and DV360. - Extensive experience with setting up pixel tracking for conversion tracking. - Strong understanding of how to integrate tracking with DV360. This is a critical project for us. We're looking for someone who can hit the ground running, make sure our tracking is set up correctly, and help us optimize our campaigns.

I'm looking for a skilled digital marketing professional who can set up and manage Google Local Service Ads for my garage door repair business, specifically targeting residential homeowners. Key Project Details: - Target Audience: Residential homeowners in need of professional garage door repair services. - Ad Services: Primarily focusing on garage door repair services, with the potential for expansion based on campaign success. - Experience: Expertise in running Google Local Service Ads and a proven track record in targeting specific demographics. Ideal Skills for This Job: - Proven experience with Google Local Service Ads - Understanding of the garage door repair industry - Ability to target ads towards residential homeowners - Strong analytical skills to tra...

...The business evaluator estimates what your business is worth and offers a blueprint for scaling your business to the next level. The blueprint will establish your business baseline, identify your peer group, and advise you on what you need to do (people and budget) to accelerate to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from this worksheet is utilized for all 8 other reports (worksheets it produces). ii. It uses a “What is your current year...

We are looking for a QA tester capable of identifying error between expected and actual travel times on maps. This is just a quick job for investigating the root cause of timing inconsistencies. Please have a quick look to our android app in playstore - no need for any account or registration Thanks

Google Play Store Reviews and Sentiment Analysis Website- The website offers a user-friendly interface and provide sentiment analysis of reviews from the Google Play Store. 1. User Module a. User Registration Module To get started, users need to register themselves by providing the following details: Username, Password, Email b. User Login Module- Users can log in to their account by providing their email and password. c. Review Submission Module - Users can submit reviews for apps on the Google Play Store. To submit a review, users need to provide: App Name, Review Description, Rating (1-5) d. View Sentiment Analysis Results Module - After submitting a review, users can view the sentiment analysis results and analysis results will provide insights into the sentimen...

I'm seeking an experienced Google Ads expert to help me generate more leads and boost online sales. Key Project Details: - The campaign is targeting a mix of B2B and B2C audiences. You will need to tailor the ads accordingly to ensure the best possible return on investment. - The allocated budget for the project is between $100 and $500. - The aim of the campaign is to not only increase website traffic but to also translate this into tangible leads and sales. Ideal Skills and Experience: - Proven track record of successful Google Ads campaigns, particularly in driving leads and sales. - Strong understanding of both B2B and B2C marketing dynamics. - Ability to work within budget constraints and deliver results. If you're confident in your ability to deliver o...

I have a set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains accurate and up-to-date. Ideal skills and exper...

...I need a custom plugin to effectively integrate these job postings onto my website and subsequently feed them to Google for Jobs. Key Requirements: - Develop a custom plugin that facilitates the regular feed of job postings from Jobg8 to my website - Design the plugin to allow for automatic selection of job postings based on specific criteria - Ensure seamless integration of the selected job postings onto my website - Implement a mechanism to feed the selected postings to Google for Jobs Ideal Skills and Experience: - Excellent proficiency in plugin development and integration - Prior experience working with Jobg8 or similar job feed providers - Familiarity with SEO and Google for Jobs integration - Strong understanding of job board operations and functionalities ...

I need a thorough audit and optimization of my current Google Ads campaign. The aim is to boost sales, target a national audience, and enhance the campaign's overall performance. Key Points: - Current Performance: My campaign is meeting basic expectations, but I'm looking for an expert to take it to the next level. - Sales Boost: The primary goal is to increase sales. Your strategies should be tailored to promote conversions. - Target Audience: The campaign is aimed at a national audience. You should be able to optimize the ads to reach the right people across the country. The ideal freelancer for this project should have: - Proven experience in Google Ads management and optimization. - A track record of boosting sales through Google Ads. - Understanding of...

Google sheet data entry Need experience Have basic english.

I need AWS Lambda function that handles Google signin JWT token and creates a new user in DynamoDB. For Endpoint creation - API Gateway For User auth - Google signin JWT token

We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.

I'm in need of an Excel Spreadsheet expert to help with a few key tasks: - Revamp the Weight Loss Tracking Sheet: The current formula isn't functioning as intended. Your job will be to troubleshoot and fix the problem. - Nutrition Plan...Weight Loss Tracking Sheet with a separate nutrition plan in the same Excel document. The two should have a uniform look, with consistent colours and my branding. - Branding Adjustments: Remove branding from the Weight Loss Tracking Sheet and ensure it matches the nutrition plan in terms of aesthetics. Your expertise in Excel formulas and formatting, as well as design skills will be key in completing this project successfully. Also please make a copy of the tracking sheets below so I have master copies and don’t mess wit...

...spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highlighting of specific details is not required. Wish me a Happy Birthday when responding so I kn...

Looking for someone who is highly knowledgeable in Excel functions, formulas, and formatting. The ideal freelancer will have experience performing the following tasks in Excel spreadsheets in portuguese - Implementing a variety of Excel formulas and functions - Applying diverse formatting techniques Unfortunately, I have not specified the exact functions, formulas, or formatting needed, meaning the freelancer must employ a broad range of knowledge and expertise in these areas. Experience with Excel in Portuguese is a definitive plus. The project requires an adaptable and meticulous individual able to meet changing demands efficiently.

Meta Ads and Google Ads Management. Payment for April Gearhead Motoring LLC / JCERacing Marketing / 3 Seguros JCE

I'm looking to upload a news-related app to the Google Play Console. The app's target audience is the general public, yet carries a unique selling point - a content focus on specialized topics, specifically health, education, and technology. Key expectations include: - Successful upload to Google Play Console. - Understanding of Google Play's upload guidelines. - Knowledge of any roadblocks to successful upload and mitigation strategies. Ideal candidate possesses: - Experience uploading apps to Google Play Console. - Familiarity with news apps. - Awareness of Google Play Store's policies and requirements. - Problem-solving mindset in case of any hurdles during the uploading process. The main objective is to make the app avai...

I'm seeking a skilled professional to set up Google Ads Tag Manager for my e-commerce website. I need to track e-commerce transactions specifically. Key Responsibilities: - Setting up Google Ads Tag Manager for my website, particularly to track e-commerce transactions. - Ensuring that all tracking is configured accurately and triggers correctly. Ideal Candidate: - Prior experience with Google Ads Tag Manager implementation and configuration. - Experience with e-commerce tracking specifically. - Excellent understanding of website analytics and tracking systems. - Strong communication skills and ability to explain the process clearly. Please note that our Google Ads account is already set up, so the primary focus of this project is on the Tag Manager setup...

I'm seeking a Google Adwords expert to create and manage a campaign specifically directed at generating leads for my water supply repairs and maintenance company, looking at local customers. Key Responsibilities: - Create a targeted campaign that can effectively reach out to potential clients in the water industry - Regular monitoring, adjustments and reporting on campaign performance Ideal candidate should possess: - Proven experience executing successful lead-generating AdWords campaigns - Deep understanding of the utility/ water industry and its audience - Expertise in search engine marketing and Google Analytics. I need a full campaign built and managed for the next 3-6 months depending on results. I am keen to discuss and want someone to start immediately. I wou...

I'm seeking a skilled professional to assist me with setting up a conversion tag in Google Ads through Google Tag Manager for my WordPress website. Key Tasks: - Setting up a conversion tag within Google Ads that tracks website purchases - Installing and configuring Google Tag Manager, considering it's my first time using it - Ensuring the tag is correctly implemented, tested, and functioning as it should - Providing any necessary training or documentation for me to understand how the tag works Ideal Skills: - Proficiency in Google Ads and Google Tag Manager - Extensive experience with WordPress website management - Proven track record of setting up conversion tags for eCommerce sites - Strong communication skills to explain processes a...

I have 2 websites. One in shopify and one in wordpress. Both get same error when i try to setup GMC. See printscreen for the exact error. Send me message on what steps you will take to fix my problem. Dont ask me to make new gmc its useless. i have tried already 5 times. Something on the website is missing and Google doesnt approve my GMC. Show me proof of activated GMCs. No time wasters!

I need an expert in Google Ads and On-Page SEO to help drive more traffic to our landing page. The project involves two main components: - **Google Ads Management**: - You should be able to create and manage Google Ads campaigns effectively. - Optimize the campaigns to drive more relevant traffic to our landing page. - Proven track record of increasing website visibility and leads via Google Ads is required. - **On-Page SEO**: - Identify and correct any on-page SEO issues that may be affecting our visibility. - Implement strategies to improve our website's ranking on search engines. - Experience with financial services is a plus. Please note that we have been wrongly tagged as a financial service. However, I am not in need of any financial s...

I'm looking for an experienced freelancer who can convert my Excel sheets into Word documents. The documents need to be in text only and follow a specific format, for which I'll need help in creating a template. Ideal Skills: - Proficiency in Excel and Word to ensure accurate conversion. - Experience in template creation and design to help structure the documents appropriately. - Attention to detail to ensure the final Word documents are error-free and cohesive.

I'm a website owner looking to increase traffic to my company Presentation website (language is ROMANIAN) through Google search engine optimization techniques. Key requirements include: - Enhancing my website's visibility on Google search results. - Implementing SEO strategies that will drive more traffic to my news articles. - Language is ROMANIAN Ideal candidate should have: - Proven experience with SEO strategies that specifically target Google. - A strong understanding of the news publishing industry. - Ability to optimize news content for search engines.

...optimized for Google, but I'm looking to speed up the SEO process without interfering with the work of the current company handling them. My primary aim is to improve search rankings for specific keywords that are relevant to the services I offer. Key points to consider: - SEO Strategy: I'm looking for a professional who can implement a strategic SEO plan that will boost the websites' visibility on Google. - Keyword Optimization: The focus will be on improving search rankings for specific keywords that are related to the services I offer. - Collaborative Work: It's crucial that the freelancer can work in sync with the existing company, ensuring that the current SEO efforts are not disrupted. The ideal candidate: - Should have a proven track record in ...

I am doing SEO for the website I have I would like to have some help with creating and posting adverts on Google and potentially LinkedIn. Objective is to get work through the website. It has been dormant for some time and I have just updated it.

I'm seeking a proficient PHP developer to construct a PDF data sheet generator for products from a...sections within the generated PDFs to maximize efficiency. - Use links to insert pictures for diagrams and product image. Ideal Skills and Experience: - Proficient in PHP Development - Proficient with a PDF generation library, (ideally TCPDF) - Experience in working with databases - Experience in image handling and manipulation for the chosen PDF library. The final product should generate data sheets that are both visually engaging and informative, we have chosen a style we like the look of already. The goal is to enhance our product presentation and simplifying the decision-making process for our customers. Some work has been done on this project already which can be levera...

I'm looking for a freelancer who can create a custom Excel sheet to track the daily attendance of my employees. The sheet should: - Be user-friendly and easy to navigate - Allow for automated c...- Be user-friendly and easy to navigate - Allow for automated calculation of total attendance - Be able to handle multiple employees at once - Have the capacity to expand for future growth I'm not looking for anything too complex, just a simple, efficient tracker that can help me keep tabs on my employees' attendance on a daily basis. Ideal Skills: - Proficiency in Excel, including advanced formulas and functions - Experience in developing user-friendly, automated spreadsheets - Strong organizational and communication skills to ensure the tracker meets my needs and is ea...

I'm looking for an expert in Excel, preferable someone who is adept at managing and organizing large volumes of financial data. The task primarily revolves around: • Data entry and organization: You will be given vast amounts of financial data which I expect you to expertly enter and organize into Excel sheets. • Handling extensive data: You should be adept in working with over 10,000 rows/columns of data. • Using Excel functionalities: You should be familiar with Excel formulas and functions to format, sort, and organize the data effectively. Your experience in dealing with extensive financial data will be highly beneficial. I look forward to working with organized, accurate, and efficient freelancers. Remember, it's all about the details - accur...

I'm in need of an experienced Google Ads expert to drive traffic, generate leads and increase brand awareness among local customers using the Search Network. Key responsibilities include: - Crafting and implementing a comprehensive Google Ads strategy - Focusing on increasing website traffic, generating leads and boosting brand awareness - Targeting local customers specifically Ideal candidates should have: - Proven experience in managing successful Google Ads campaigns - Strong knowledge of Search Network advertising - Ability to strategically target local customers - A track record of boosting website traffic and generating leads - A creative approach to increasing brand awareness through digital advertising This project requires someone who can think strate...

I'm in need of an individual proficient in Excel to streamline data analysis for my sales numbers. The main objective will be to dissect revenue trends within the data, so particular attention to this metric is essential. Ideal qualities include: - Great attention to detail - Previous experience in data analysis ...the data, so particular attention to this metric is essential. Ideal qualities include: - Great attention to detail - Previous experience in data analysis - Proficiency in Excel - Understanding of sales and revenue benchmarks This role will require you to receive raw data and translate it into an easy-to-understand format, highlighting pivotal information. Your focus will be on creating complex formulas to identify revenue trends, which will help inform our future sa...

...dashboard that provides a summary of logs in a user-friendly manner. Stock Management: Button for adding/removing stock. Capability for users to create new stock entries and adjust quantities. Every action should be logged to ensure traceability. Production Planning: Interface for planning and terminating production based on pre-defined formulas. Production orders should reflect real-time usage of ingredients/materials. Formula Management: Functionality to add/edit formulas. Easy selection of ingredients from a pre-populated list. Reporting Tools: Ability to generate reports on stock levels, production status, and other critical metrics. Multi-Location Support: The system must support operations across multiple locations, enabling remote management and data synchronization...

...result, only the numbers will be set from A to Z in one click In the result name date also changes daily , One such project should be made I'm seeking a proficient Excel specialist to take on a project that primarily involves formatting and creating advanced formulas. Key Responsibilities: - Take charge of the spreadsheet's aesthetic and logical formatting - Develop and implement formulas to aid data analysis and interpretation - Arrange numerical data alphabetically from A to Z Ideal Skills: - Proficiency in Excel functions and formulas - Strong attention to detail, particularly regarding formatting - Excellent problem-solving skills Project Timeline: This project needs to be completed within a month, demonstrating your ability to meet deadlines i...

We are looking for an expert in Google Adwords with native command of German who can help us to set up a good-working Adword Campaign for the German market. Our website is www.intertext-uebersetzungen.de. Please quote a fixed price for setting up the campaign and an hourly rate for future changes on the campaign.

I need a developer to build a PHP app using Google Sheets as a database. I want add a text on a field it'll to fetch rest row and column data from sheet. Check attachment. I'll enter only order number. This will involve: - Implementing a User Authentication system. Note that no specific features like social media authentication, two-step verification, or forgot password functionality are required. Just a simple log-in/log-out system will suffice. - Data validation will be key in this project. Each entry must be checked to ensure that it meets certain criteria before being stored in the sheet. - Real-time data synchronization between the app and Google Sheets. This means that any changes made in the app should be instantly reflected in the sheet, an...

I'm looking for a Podia expert who can help me finish my website on podia and start Google Adwords. Key Responsibilities: - Ensure the website works and is visually appealing, engaging, and user-friendly Ideal Skills & Experience: - Proficient in Podia's platform and its various features - Strong background in web design, particularly in creating e-commerce or membership sites - Excellent eye for design and user experience - Experience in graphic design would be a bonus - Experience in Google Adwords

I need a tool that can search multiple sheets in an Excel workbook and copy specific rows to a new sheet based on manual selection. The core requirements of the tool are: - Searching across multiple sheets to find specific data. - Allowing me to manually select a specific number of rows from the search results for copying. Given these criteria, the ideal tool would be: - Capable of working with Excel files. - Providing a user-friendly interface for easy manual selection. If you have experience with these requirements, please reach out.

Hi Quick Website SEO, I noticed your profile and would like to offer you my project. We can discuss any details over chat.