How to insert formula in google sheets for entire columnงาน
ผมต้องการทำ Google data studio เพื่อแสดงข้อมูลรายงานรายได้ ค่าจอดรถของผม ซึ่งผมมี เวป คราวที่สามารถดึง CSV ออกมาได้แล้วก็นำมา สร้างเป็นหน้ารายงานสรุป
ตอนนี้ผมลองเริ่มทำ google ads สำหรับเว็บไซต์ที่ทำด้วย wordpress และ plug-in แต่ติดปัญหาตรงเรื่องการทำ conversion tracking เลยอยากหาคนมาสอนการ set up ให้ครับ นอกเหนือจากนั้นอาจจะให้แนะนำเรื่องการทำ SEO เพื่อให้ติดด้านบน ออฟฟิตอยู่แถวๆกรุงเทพกรีฑาครับ
Please key Thai characters on PDF into word are the past question and answers of exam and total sheets has around 200 letters.
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 wil...
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 ha...
I'm currently in need of a skilled engineer with experience in structural analysis, particularly with steel structures, to help optimize the design of my project. Project involves suggesting furnace column, beams , plates etc sizes as per Australian standard, and material sizes available in Australian market. Key Responsibilities: - Conduct a comprehensive structural analysis of the steel structure - Analyze and interpret the results for optimization recommendations - Make design suggestions based on the analysis - Ensure the structural integrity of the steel structure Ideal Skills: - Proficiency in AutoCAD - Previous experience in structural analysis and design - Knowledge of steel structures - Ability to provide actio...
I'm looking for a 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 pro...
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.
I am looking for an experienced CodeIgniter developer to upgrade my existing CodeIgniter 3 project to CodeIgniter 4. The project is currently live and needs to maintain the same database structure and functionality. The key tasks include: Upgrade CodeIgniter Version: Migrate the entire project from CodeIgniter 3 to CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres...
I am in need of a highly skilled developer who can create an on-demand freight application that will be available on both iOS and Android platforms. The app will offer a wide range of freight services, including local delivery, long-distance shipping, and overnight services. Key functionality: - Real-time Tracking: The app should provide a seamless real-time tracking feature to ensure customers can monitor their shipments throughout the entire process. - In-App Payment: A secure payment gateway integrated into the app is essential for facilitating smooth and hassle-free transactions for our users. - Driver Rating System: I want a driver rating system that allows customers to provide feedback on the service they received, helping us maintain...
Google Ads Month Management. Google AdWords PPC Services
...Needed for Transcribing Storybook into Word Document Description: We are seeking a skilled copywriter to transcribe a storybook into a Word document. The job involves typing out the entire content of a storybook into a digital format. The storybook is approximately 100 pages long and contains a mix of text and illustrations. Responsibilities: - Type out the entire content of the storybook into a Word document. - Ensure accurate transcription of text, including proper formatting and punctuation. - Maintain consistency with the original text and illustrations. - Complete the task within the specified deadline of 1 day. Requirements: - Proficiency in English language and grammar. - Excellent typing speed and accuracy. - Experience in copywriting...
I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculat...Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I wou...
I need a proficient web designer to develop an e-commerce website for book sales, integrated with a blog page. Key requirements include: - Creating an intuitive and user-friendly platform that allows customers to browse and purchase books online. - Incorporating a blog page where users can read, interact through a comment section, and share posts on social media. - The entire project must be completed as soon as possible. Ideal skills for this project include: - Proficiency in e-commerce web design. - Experience with blog implementation. - Fast-paced work ethic without compromising on quality. This project presents an opportunity to create a dynamic, interactive platform that integrates online shopping with valuable literary conte...
I'm looking for a skilled PPC specialist to help me create and manage a PPC campaign on Google Ads. The primary goal of this campaign is to increase my website traffic. The task includes: - Conducting thorough research to identify the best keywords and phrases for the campaign - Crafting compelling ad copies that resonate with my target audience - Setting up and managing the campaign to ensure optimal performance - Regular monitoring and tweaking of the campaign to maximize results Ideal skills and experience for this job include: - Proven track record of successful PPC campaigns, particularly on Google Ads - Strong keyword research capabilities - Proficiency in crafting engaging ad copies - Experience i...
I'm in search of a knowledgeable Google Ads expert to assist me in boosting online sales for my antique store. Key Requirements: - Experience in crafting and managing Google Ads campaigns, particularly for e-commerce or antique businesses, is essential. - Proven track record of delivering increased online sales using Google Ads. - Strong understanding of how to target specific demographics, such as collectors of specific antiques. Target Audience: - My primary target audience consists of collectors of specific antiques. Geographic Targeting: - The ads will be targeted towards specific countries or regions outside my own. If you have the necessary expertise and are equipped to help me achieve m...
I'm looking for a data entry specialist to assist me with entering a mix of numeric, textual and formula-based data into a spreadsheet. The data will be provided in digital format, typically in CSV or Excel files. Key Responsibilities: - Accurately transcribing a mix of text, numbers, and formulas into a spreadsheet - Ensuring that the data is organized and categorized correctly - Delivering the completed spreadsheet on time, following provided guidelines Ideal Candidate: - Proficient in data entry with experience in handling diverse types of data - Familiarity with Excel and basic formulas - Detail-oriented and capable of consistently delivering accurate work - Able to work independently with minimal oversight If you have th...
...looking for a skilled photo editor to help me eliminate the glasses from a high-resolution photo. The main aim of this task is to enhance the overall appearance of the image. Key Requirements: - The photo is of high resolution and detail. It will require a professional with experience in handling photos of similar quality. - The primary task is the removal of the glasses, and this should be done with precision and attention to detail. - I'd also like the freelancer to provide skin retouching. This will involve making minor adjustments to smooth skin tone and remove blemishes. - Additionally, I need assistance with background editing. The background should be edited to ensure it complements the main subject, without being ove...
I am reaching out to you with an exciting project idea for a mobile app focused on cricket match scheduling. As a cricket enthusiast, I have often faced the challenge of finding available teams to play matches against on short notice. To address this issue, I envision an app that can connect teams and simplify the process of organizing cricket matches. Project Overview: The primary goal of the app is to help cricket teams find and schedule matches with each other. Teams can mark their availability for matches, view other available teams, and communicate directly to arrange matches. Core Features: User Registration and Profiles: Teams and individual players can create profiles. Profile information includes team name, location, contact det...
...thesis, I'm in need of a 3D model and rendering for a co-working space. The project focuses on the entire building comprising 5 floors, but interior designs are only required for a few views. Key Requirements: - I'm looking for a modern style for the co-working space. - I require basic level of detailing for the 3D models and renderings, with simple textures and minimal details. The main areas to focus on for the interior views are the various workspaces within the co-working space. Ideal Skills and Experience: - Proficiency in 3D modelling software, specifically for architectural projects - Prior experience in creating basic level 3D models and renderings. The project is specifically ...
As a local contractor, I'm looking for a skilled and experienced Google Ads expert to help me generate leads within our city. My target audience is homeowners, and the main focus of this campaign is to generate high-quality leads. Key Requirements: - Proven experience in running successful Google Ads campaigns - Deep understanding of lead generation techniques - Prior experience working with local businesses - A clear understanding of the homeowner market The ideal freelancer would be able to set up, monitor and optimize the campaign to ensure a steady flow of leads. A keen eye for detail and a collaborative approach to work would be highly valued.
I'm looking for a skilled professional who can meticulously guide me in video call through setting up a VPN using Google Cloud and OpenVPN. The primary aim is to ensure secure remote access to a MySQL database from my Windows laptop. Key requirements: - In-depth knowledge of Google Cloud and OpenVPN - Proven experience in configuring secure VPNs - Expertise in MySQL database security and remote access Your role will be to provide detailed, step-by-step instructions on how to properly configure the VPN to meet my security needs. Please bear in mind that I may require access to the MySQL database from multiple remote locations, but most likely will only need it running from...
My website currently has an average performance in search engine rankings and I am primarily looking to enhance this on Google. I'm in need of a SEO expert who can identify and implement both On-page and Off-page techniques to improve my site's visibility and ranking. Key Requirements: - Experience in SEO: A proven track record of increasing search rankings for clients. - Google SEO Knowledge: A comprehensive understanding of Google's algorithms and best practices. - On-page & Off-page SEO Skills: Proficiency in both these areas, including content optimization, link building, and other relevant strategies. Your work will be critical in boosting our online presence and driving more organic traffic ...
I'm in need of a structural engineer or a person with a relevant background in load-bearing support. The project involves the use of I beam sections, particularly an ISMB-300 beam acting as a column and another ISMB-300 beam acting as a beam. Specific Details: - The ISMB-300 beam will connect to the web of an ISMB-500 column. - The ISMB-300 beam will connect to the flange of the ISMB-500 column. - The connection will be executed by 3 - 20mm diameter bolts. - The I beam sections will be put to use in an industrial environment. - The load anticipated for these I beam sections is a medium load, ranging from 5 to 15 tons. Ideal candidates for this project should have a strong understanding of load-bear...
I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
I'm seeking an experienced SEO professional to help me rank 10 keywords on Google. Key Requirements: - On-page & Off-page SEO: You should be proficient in both to help my website achieve better visibility on Google. - Keyword Research: I have some specific keywords in mind, but I also need your expertise to identify other relevant keywords that can aid our goal of increasing website traffic. Additional Information: - The primary goal of this SEO campaign is to drive more visitors to my website. Therefore, the successful completion of this project should result in a noticeable increase in organic traffic. Ideal Skills: - Proficient in both on-page and off-page SEO - Experienced in keywo...
I need a script that can scrape the Google Play store specific data from list of apps in the search result url of any keyword. Need data in Excel spreadsheet. Eg : if i search cat in playstore, i need the below mentioned details of first 100 apps shown in the search result. Key Project Details: - I require the script to scrape app names, descriptions, emails, download counts, and URL of the app. - The scraped data should be compiled into an Excel spreadsheet format for my review and analysis. - deploy the script into my server The Ideal Freelancer: - Proficient in web scraping tools and techniques - Experience working with Google Play store data - Competent in automating data extraction and processing - Ability t...
...need a professional to set up an email campaign for my travel agency on Constant Contact. The primary goal of the campaign is to increase brand awareness. **Project Scope:** 1. **Welcome Email:** - **Trigger:** Sent immediately after someone subscribes to our email list. - **Content:** Welcome message introducing LabNomads LLC, highlighting our travel planning services, and thanking them for subscribing. - **Key Points:** - Warm greeting - Brief introduction to LabNomads LLC - Overview of services offered - Contact information 2. **Follow-Up Email:** - **Trigger:** Sent 3 days after the welcome email. - **Content:** Friendly message checking in to see if the subscriber has any questions or wou...
...ClickUp, Zapier, Mailchimp, and Google Sheets. This will include: - Data syncing among all four applications, set to be updated daily. - Automating my email marketing process via Mailchimp. - Automating task management via ClickUp. Specific Tasks: - Automation of task creation in ClickUp. - Automation of sending out emails based on changes in task status. Skills and Experience Required: - Proven experience in working with ClickUp, Zapier, Mailchimp, and Google Sheets - Proficient in automating processes and task management - Strong data management skills - Experience in email marketing automation is an asset This automation project will help streamline my business processes, so efficiency and attention to ...
I'm seeking experienced UML and OCL modelers to conceptualize my full system information and transcribe the model for the USE (.use) tool. Key tasks include: - Conceptualize the entire system model using UML and OCL - Transcribe the model for USE tool - Create necessary UML diagrams: Class Diagram, Use Case Diagram, Sequence Diagram Ideal skills would include expertise in UML, OCL, and system modeling. Familiarity with the USE tool is essential.
...skilled developer or development team to create a comprehensive web crawler system. This system should scrape, structure, and update information from web pages, handle large projects, and be accessible via a powerful API. The system should offer user-friendly features for both individuals and businesses and include flexible user management for both customers and employees. Project Requirements 1. Web Crawling and Data Extraction -Develop a system capable of scraping entire websites and extracting data from each page. -The system should divide the scraped information into sections to facilitate easy reading and understanding. -For e-commerce sites, the system should identify and structure the following information: --Product category (including ...
I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forw...
I'm looking for a Google Ads expert who can help me create and manage a video ad campaign with the primary objectives being to enhance brand visibility and drive more traffic to my website.
...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 least one of our apps and see the cur...
I need a Google Sheets expert to help me put together an extensive and detailed cricket schedule for the upcoming English summer season. Tasks Include: - Including International, Domestic, and Club tournaments and teams in the schedule - Organizing fixtures based on the date Additional Details: - Each fixture should have comprehensive information about the venue - Match timings should be included - Broadcast details for each match should be provided Ideal Skills: - Proficiency in Google Sheets - Knowledge of cricket and its various tournaments - Attention to detail to ensure that all necessary information is included - Time management skills to complete the project in a timely manner more details...
...can't help or if you think the budget is too little, save some time for both of us I want to have a website made by a freelancer. the website is intended to track and register passengers and drivers. the database must have the following users. -Administrator -Driver -Parents what should the driver be able to do? 1. register 2. Scan passenger in and out using a QR code 3. be able to record comments for each passenger per day if necessary 4. being able to see each passenger monthly report of where they got in/out and at what time. 5. Be able to create a QR code for every name. Drivers must be able to clock in and clock out while driving. what should parents be able to do? 1. Real t...
I'm looking for a talented freelancer to help me automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly ...
Thank you, Mr. Nicola, for considering 8veer for your project. Below is the detailed quote for creating a comprehensive project plan for the launch of your financial blog. ___________ Scope of Work: 1. Project Planning: • Develop a Detailed Project Plan: Outline the entire process from inception to completion, ensuring a structured approach to the blog launch. • Define Key Milestones: Establish critical milestones to track progress and ensure timely delivery. • Deliverables and Timelines: Clearly specify all deliverables and set realistic timelines for each phase. • Resource Allocation: Assign tasks to team members, including writers, editors, and designers, to ensure efficient use of resourc...
We are looking for developers who are proficient in WooCommerce and Google Sheet API to help with our ongoing project to improve some of it's functionalities and features. Key Responsibilities: - Assist in setting up WooCommerce functionalities on a website, including product catalog, shopping cart, and payment gateway integration. - Implement integration with Google Sheet API for specific data processing & syncing requirements. Ideal Candidate: - Proficient in WooCommerce, including setting up product catalog, shopping cart, and payment gateway integration. - Experienced in integrating external APIs, specifically Google Sheet API, App Scripts Programming. - A good understanding of data processing and ...
I am seeking a skilled professional who can help me migrate my entire website onto Neo4j as a new database and subsequently launch the website live. Key Tasks: - Full migration from the current platform to Neo4j - Ensuring the website is fully functional post-migration - Optimizing the performance of the site - Confirming all data is migrated accurately - Ensuring the website is live and accessible Ideal Skills: - Advanced Neo4j knowledge and experience - Proficiency in website migration - Strong understanding of database management - Proficient in website launching processes Overall, the project requires someone who is not only technically proficient with Neo4j, but also has experience in handling website migration and launching, ensuring a seamless ...
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invo...
I need historical stock prices and income statement data, deliver python script to collect this data for an arbitrary stock from google finance.
...Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each ins...
I'm looking for help from a talented programmer with C++ experience and low-level programming knowledge. The main purpose of this project is to develop a keyboard input emulator specifically for gaming purposes. Basic requirements: - Compatibility: The emulator must be designed to run on Windows operating systems. - Programming Language: It is important to develop the emulator using C++. - Purpose: Macro tests will be performed with the emulator in the game. Your role will be as follows: - Design and develop a reliable and efficient keyboard input emulator for gaming. System level programming is required. (It will simulate the keyboard on the hardware and perform keydown and keyup operations. I want it to press the z1 key when ...
Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules ...
