Excel macros google sheet jobs

I'm looking for a Google Sheets expert to help with the following tasks: - Implementing formulas for summing and averaging data - Applying conditional logic for data analysis - Setting up conditional formatting for better data visualization - Creating data validation rules for accurate data input - Designing custom charts and graphs for enhanced data representation. The ideal candidate for this project should have a strong background in Google Sheets and data analytics. Experience with complex formula implementation and data visualization is a plus. Being detail-oriented is crucial, as accurate data handling is a key aspect of this project.

Configuring Google and Facebook logins is essential for enhancing user convenience and security on your platform. By integrating these social login options, users can effortlessly access your platform using their existing Google or Facebook credentials, eliminating the need to create a new account. To configure Google login, you'll need to create a project in the Google Developers Console, obtain OAuth 2.0 credentials, and configure your platform's authentication settings accordingly. Similarly, for Facebook login, you'll need to create a Facebook app, configure the app settings, and obtain the necessary credentials. Once you have obtained the required credentials from both Google and Facebook, you can integrate their respective SDKs into y...

...collaboratively with our web developers to set up eCommerce measurement in our Google Analytics (G4) account. Our system is a proprietary coded registration platform, built using PHP. Please note that the web developers have already attempted to set this up using the set up instructions provided by Google, so advanced knowledge is required. Key Requirements: - Adapt the eCommerce measurement setup for our unique, PHP-based system - Capture registration data in analytics including dynamic products and revenue details - Ensure the correct tracking of user behavior on product pages - Implement tracking to understand traffic sources and their impact on sales Ideal candidate: - Proficiency in eCommerce measurement and Google Analytics, especially G4 - Experience with P...

I require an experienced data cleaning specialist who can proficiently handle Excel spreadsheets. My project involves tidying up datasets related to customer, product, and financial data, though different types of data might need to be scrubbed too. This data cleansing task involves a lower volume dataset of less than 1,000 records. Key tasks include: - Identifying and correcting any inaccuracies. - Identifying and handling missing data. - Assuring the consistency of datasets. The ideal freelancer should have strong skills in spreadsheet management, a keen attention to detail, exceptional data analysis abilities, and a solid understanding of customer, product, and financial data. Experience in Excel and a proven track record in data cleansing are a must.

I am looking for a detail-oriented professional to assist me with basic data entry tasks in Excel. The primary responsibility will be to input data such as names and addresses into an Excel spreadsheet. Key Responsibilities: - Inputting basic data into Excel spreadsheet Furthermore, the project requires data verification. This means ensuring that the data has been accurately entered. You will be required to cross-reference the inputted data against the source material to detect any discrepancies or errors. Ideal Skills & Experience: - Proficient in Excel - Attention to detail - Strong data entry skills - Familiar with data verification processes - Previous experience in basic data entry This project is quite straightforward, but precision and accuracy ...

I'm looking for a skilled professional to assist me with various customer support, operation, and mana...manage customer inquiries through phone calls, email, and live chat. - Managing Customer Databases: This project requires proficiency in maintaining databases across various platforms including CRM systems, Excel spreadsheets, and online database platforms. - Analyzing Customer Feedback: An ideal candidate will have experience in analyzing customer feedback to help our services grow. The ideal freelancer for this project should possess: - Proven experience in customer support and management - Excellent communication and interpersonal skills - Proficiency in using various CRM systems, Excel, and online database platforms - Familiarity with analyzing customer feedbac...

I am seeking a professional to efficiently set up Google Analytics for my website's Product pages. Despite the scope of my project is not vast, it does need a precise and careful setup. Key requirements: - The ability to grasp the specifics of the Product pages on my website and implement fully-functioning Google Analytics tracking. - Encounter with analytical tools and specifically Google Analytics. Ideal skills: - Experience in Google Analytics setup. - Keen attention to detail. - Solid understanding of web metrics. - Strong problem-solving skills. Since I hadn't clarified the kind of data to be tracked, I am eager for your professional insight on the most significant metrics to track on Product pages. The goal is to better understand user behavi...

...needs to: 1. Emphasize on * Standard Business Model: Clearly articulate the traditional and consistent business operations that my RCM enterprise adopts. 2. Include Key Components * Income Statement: A detailed income statement highlighting the revenue and expenses over a specific period. * Cash Flow: A cash flow statement displaying how changes in balance sheet accounts and income affect cash. * Balance Sheet: A report that summarizes my firm's financial standing in terms of assets, liabilities, and shareholders' equity. * Revenue Breakdown: Thorough analysis of different streams from where the business is generating its revenue. * Cost Breakdowns: An explanation of how much the firm is spending on its employees among other operation...

Configure Google analytics events and goals to track the following: - Contact form submission (3 forms on site) - Video Play (Hosted on Vimeo, embedded in site) - Events for key page views, tab clicks, % of scroll -Create a report to determine the goals by UTM parameters and sources -Review any questions we may have on the implementation Website is Wordpress based, forms are made with the WP Bakery form builder. Start your bid with your favorite fruit to confirm you've read the details of this short project.

I'm seeking a google sheets expert to design and set up a customized sales and expense tracking system for my start-up smoothie/juice outlet. - The system will primarily track weekly sales - The expense tracking should be moderately detailed, breaking down expenses into categories such as ingredients and utilities. - The ideal sheet will include forecasting models, particularly incorporating seasonal adjustments and growth rate calculations for sales. The freelancer should have: - Proficiency in Google Sheets, particularly in setting up automated calculations and formatting for ease of use and understanding. - Experience in financial modeling and projection, with specific experience in the food/beverage sector being a plus. I'm looking for a system th...

I'm looking for a freelancer who can help me set up a VPN server on Google Cloud using Linux as the operating system and OpenVPN as the VPN protocol. We need an IPSec-ready end device on our side (or hosted somewhere), where the data traffic should terminate. The service will route all the data traffic through the tunnel. Need to have an US based breakout then. So, when we are receiving the traffic on one central address, and there we can do the breakout and the NATing into the world wide web on our side.

I'm looking for a Google Ad's specialist to assist in a lead generation campaign targeted at small business owners who are seeking financial solutions. The campaign will be built around generating high-quality, relevant leads that fit our target demographic and will likely require the following: - A solid understanding of Google ad targeting, particularly with regard to the financial services sector. - Proven track record of generating leads through Google Ads. - Familiarization with financial jargon and understanding of small business needs. Your role will entail: - Creating compelling ad content that attracts our target audience - Implementing strategic bidding and keyword selection - Monitoring and adjusting campaigns for maximum success Ideal consu...

In my r...and would like those eliminated as well. This is where you come in. Main Responsibilities: - Conduct comprehensive Google citation cleanup - Correct any incorrect information found - Detect and remove duplicate listings on Google - Identify and eliminate any black hat practices Ideal Skills and Experiences: - Proven experience in performing citation cleanup on Google - Familiarity with the retail industry is a must - Knowledge and understanding of black hat techniques - Attention to detail to ensure all incorrect info and duplicates are properly addressed and cleaned - Excellent communication skills to provide progress and reports effectively Let's clean up our Google presence and make sure our retail business shines in the online world. ...

I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account ...

I'm in need of a reliable virtual assistant, competent specifically in managing and scheduling appointments on Google Calendar. Key Responsibilities: - Arrange my weekly meetings and appointments through Google Calendar - Be timely and up-to-date with all appointments Skills and Experiences: - Proficient in Google Calendar - Exceptional organizational skills - Experience in a similar role, particularly with appointment scheduling, is a plus. Your role would be crucial in ensuring that my weekly calendar is organized and accurate.

I need emails from these companies of CEO ot anyone else working in financials, sales, or partnerships. Data scraping from rocketreach of the emails of the people that you can find with relevance from these companies in the image. Excel sheet with company name in the rows and in the 3 columns full name, email and position in the company

Data entry operator and my work very clear

I'm looking for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. Please include samples of similar work you'v...

I am seeking an experienced professional to integrate Directions, Geolocation, and Custom markers into a Google Maps project for my locksmith business. The ultimate aim is marketing-focused to drive more traffic to our website and enhance our visibility in local search results. Key Aspects for the project include: - Knowledge of Google Maps API functionalities especially pertaining to Directions, Geolocation, and Custom markers. - Proven experience in Search Engine Optimization (SEO) and Local Directory Listings. - Proven track record of improving website traffic and boosting local visibility through effective marketing strategies. - Understanding of the locksmith industry and the unique needs of a local service-based business will be an added advantage. Please bid if yo...

Looking for a skilled Google Ads specialist with excellent graphic design abilities to create effective campaigns, with the goals to notably increase website traffic and generate high-quality leads. Ideally, the successful candidate should have a proven track record in executing high-budget ad campaigns effectively, with appreciable results. Key responsibilities: - Identifying target audience and devising digital campaigns that engage, inform and motivate - Designing and creating highly engaging visual ad content - Regularly monitor and optimize the campaigns for maximum performance Requirements: - Solid knowledge of website analytics tools (e.g., Google Analytics) - Experience in setting up and optimizing Google Adwords campaigns - Strong analytical skills and data...

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-friendly or ...

I'm seeking a skilled marketing professional to help me create and manage a targeted Google Ads campaign that will significantly boost sales for my business. Key Requirements: - Expertise in Google Ads: Proven experience with creating and managing successful Google Ads campaigns is a must. - Sales-Oriented Strategy: I'm looking for someone who can design the campaign with a clear focus on driving sales, not just traffic. - Display Ad Experience: I prefer using display ads in the campaign as they appear on relevant websites. Experience in this type of ad creation is highly desired. Your responsibilities will include: - Creating a strategy to enhance sales through our Google Ads campaign. - Designing and setting up the campaign, including the usage of...

Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!

I'm looking for a skilled professional to help me create a Google Ad campaign. The main purpose of this campaign is to increase website traffic. The ad will be targeted at the general public in a specific local area or city. Key Requirements: - Experience in creating successful Google Ad campaigns - Capable of targeting campaigns to specific locations - Understanding of digital marketing and strategies to increase website traffic I'm looking for someone who can help me achieve noticeable results in terms of increased website visits. The right candidate will have a firm grasp on how to tailor ads towards a local audience and drive traffic to my website. Previous examples of successful Google Ad campaigns and expertise in ad targeting are a plus.

Website on Wordpress License key generator with DB API for Excel Template connecting to DB for license key validation. Dashboard for administrator enter buyer/customer account credetials. The administrator must be able to enable and disablle accounts. Update Excel Template LicenseValidation code for connectiing to API/DB. I will privide this Excel Template code file.

...item availability. 4. Delivery Tracking - Allowing customers to check their food order status. 5. Nutrition Coaching Reservation - Capability for customers to reserve sessions with a dietitian. 6. Customized Ordering - Feature that facilitates personalized orders based on customer needs of calories and macronutrients (the system will customize the meals according to user inputs of calories and macros). 7. Blog Integration - To serve engaging, relevant, and up-to-date content to our users. 8. Calculators for calories and macronutrients. 9. using geolocation to locate the customer's location. 10. multilanguage (arabic, english, kurdish) 11. PWA app of the website. 12. User Authentication: A secure logging system for users. 13. Payment Integration: A stable and secure mechanism...

We are actively searching for a skilled and detail-oriented Google Ads Specialist to join our team as a key contributor to our digital marketing efforts. In this role, you will play a crucial part in optimizing our online presence through effective search engine optimization strategies and managing Google Ads campaigns for maximum visibility and performance. Responsibilities: - Developing and managing AdWords campaigns effectively and efficiently within predetermined budgets - Optimize ad copy, bidding strategies, and targeting to maximize ROI. - Regularly monitor and adjust advertising campaigns based on performance metrics. - Analyze campaign performance, track key metrics, and provide actionable insights to enhance campaign effectiveness and achieve business objectives. ...

Hi! I am seeking an expert in Google Cloud's Pub/Sub service. My Python application needs to publish and subscribe to text data messages. Knowledge in message encoding and decoding, as well as Pub/Sub client libraries, is crucial. Therefore, a strong background in Python and Google Cloud Platform is required. Take a look a example image attached. Key responsibilities include: - Assisting with publishing text data messages - Helping with subscribing to these messages Please have proven experience in Google Cloud's Pub/Sub and Python programming for processing text data.

I need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project is changing the color of cel...

Required Google ad expert to setup google ads on behalf of me

I'm looking for an experienced Excel and PineScript expert to create custom Excel formulas replicating my developed PineScript indicator. The indicator performs functions for Bollingerbands and Keltner Channels. The task will be to incorporate Open, High, Low, Close prices into the Excel formulas. Please note, data collection or data visualization is not required for this project. To give your best, you should possess an advanced understanding in: - PineScript - Creating complex Excel formulas Looking forward to your informed bid.

I'm in need of a Google Review Management specialist with a proven track record. This project involves managing my Google reviews on Google My Business. Key Responsibilities: - Improve our online reputation by increasing positive reviews - Monitor and respond to customer feedback in a timely manner Your role would also include: - Providing specific strategies to encourage more positive review - Utilizing social media to interact with customers and build a positive online presence Skills and Experience: - Demonstrable experience in Google Review Management and Google My Business - Proficient in social media customer interactions - Strong communication skills, particularly in dealing with customer feedback - Proven track record in increasing positi...

I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer information and product inventory m...

...fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all accessible information per entry is needed. Your expertise in internet research, data mining, and...

I am seeking a t...numbers for promoting my business. Key Features: - Bulk Phone Number Verification: The tool should be able to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number verification tools will be a plus. Please provide examples of similar projects you have worked on previously. Looking forward to y...

I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.

I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided

I need an experienced Google Ads specialist to optimize and manage the Google Ads for my agency clients. Key requirements: - The primary goal of the campaign is to increase sales. You should have a proven track record of achieving this objective through Google Ads. - The target audience for the campaign is national customers. It's crucial that you have experience in targeting and converting national audiences. - The industries my agency clients belong to vary, so a versatile background in Google Ads across different sectors would be highly beneficial. - You'll be responsible for the end-to-end management of these campaigns including setting up, monitoring, and optimizing. Ideal Skills & Experience: - Proven experience in Google Ads managem...

I'm seeking a proficient Google Ads expert specializing in text ad campaigns aimed at young adults. The goal of this project is to significantly increase bookings for our escape rooms. The perfect candidate should demonstrate: - Extensive experience with Google Text Ads - Success in driving bookings through ad campaigns - Excellent understanding of marketing. Your job will be: - To create engaging text ads - Analyze and optimize for best performance - Target ads at people 20-40 yo. Ensure your proposal includes: - Your previous success stories related to this task - Your strategy for increasing bookings. We're looking forward to finding the right expert to grow with us.

Work on SDTMs, ADaMs and TLF for various projects. To be able to work on standard macros. STDMs and ADaMs specs writing

For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.

...Point of Sale (POS) system, and warehouse stock counts. Key responsibilities: - Regularly updating our inventory data with utmost accuracy - Ensuring all channels of data (supplier invoices, POS system, stock counts) are accurately reflected in our inventory records - Generating purchase orders based on the updated stock levels Your skills and experience should include: - Proficiency in Excel/ Google Sheets - Experience in inventory management/data entry - Attention to detail and accuracy - Ability to work independently and meet daily deadlines - Familiarity with purchase order generation is a plus. A successful candidate will not only update the inventory data accurately and promptly but will also be able to adapt to any changes in stock levels in real-time, ensuring...

I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security...

I'm in need of a fitness expert who can develop a comprehensive personal training program sheet for my clients. The ideal candidate would have a strong understanding of exercise physiology and program design, as well as extensive experience in personal training. The program should cater for three main fitness goals: - Weight loss - Muscle building - Endurance training It should also cater to two levels of fitness experience: - Beginners - Intermediate The training frequency may vary, though it typically falls between 3-5 days a week. I need the program to be versatile and adjustable according to the individual's schedule. Include - Nutrition - Graph for progress (weight, fat percentage, habit tracking, calories/steps calculator) whether fitness watch can be attached...

...receptionist (if they are busy, we will assist you right away). Panel: Receptionist sees that there is a call listening to the purchase announcement, or if she has a balance she sees that there is a call coming in. She also sees call/s queued to be received on hold if there are any. - Logged in receptionist answers the call on your landline. Panel: The receptionist sees the client's information sheet, name, phone number, comments, purchase history, balance, etc., modifiable. The purchase option also appears in case the customer wishes to purchase more balance. Here the receptionist sees the list of busy and free agents, and selects a free agent to transfer the call she is answering. - Receptionist has already transferred the call. Panel: the receptionist can see in real time...

I am seeking an expert in Google Cloud's Pub/Sub service. My Python application needs to publish and subscribe to text data messages. Knowledge in message encoding and decoding, as well as Pub/Sub client libraries, is crucial. Therefore, a strong background in Python and Google Cloud Platform is required. Take a look a example image attached. Key responsibilities include: - Assisting with publishing text data messages - Helping with subscribing to these messages Please have proven experience in Google Cloud's Pub/Sub and Python programming for processing text data.

My Portfolio website is not displaying Google AdSense ads, despite having added the code. I don't have any ad blockers enabled in my browser. I need a skilled professional to troubleshoot and resolve this issue as soon as possible. The ideal candidate should have: - Expertise in website monetization and Google AdSense implementation - Experience with Portfolio websites - Strong debugging and problem-solving skills - Ability to communicate clearly and provide updates on progress

Need person who make my website adsense friendly and get adsense approval paymant after work

I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.