Excel macro find data jobs
I'm looking for a skilled SEO professional to execute a strategic, monthly SEO plan for my website ( ) aimed at enhancing search engine rankings, increasing web traffic, and accele...Keyword/phrase optimization - On-page SEO tactics - High-quality backlink generation - Site performance improvement - Google analytics - MOZ and DA Rank Improvement Ideally, the right candidate will have prior business-oriented SEO experience, with an in-depth understanding of our target demographic's search behavior. They should also be highly analytic with a proven track record. An innovative approach to find and exploit new SEO opportunities will be commended. Over time, this strategy should lead to a sustained increase in organic traffic, improved search visibility, and boosted sales.
I am looking for a skilled Shopify developer to help me build up my jewelry website. The ideal candidate will be comfortable with Shopify's Liquid and API requests, and able to implement the following features: - Product filtering: I want to make it easy for my customers to find the product they are looking for. - Shopping cart: Ensuring the checkout process is smooth and user-friendly is crucial to me. - Chat functionality: I want to have chat functionality for customer support and engagement. - Automated product catalogue updating: I want a system that will automatically update the online catalogue with new products and changes. - Social media integration: It's important to me that my website is easily shareable and that my customers can connect with us on various socia...
I'm looking for a skilled Excel expert to automate the formatting of a spreadsheet from a Quickbooks export. Key Requirements: - I primarily need the freelancer to set up and automate formatting in my Quickbooks Excel spreadsheets. - The final formatting should be both visually appealing and easy to read for the end user, we will provide guidance on what the end result should look similar to. Ideal Skills and Experience: - Strong proficiency in Excel, especially with automating processes and conditional formatting. - Previous experience working on projects involving data visualization and presentation. - A good eye for design to ensure the data is clearly differentiated and visually engaging.
I have a project that involves data entry from an Excel file. The data needs cleaning and formatting before entry, and the end goal is data analysis. I am looking for a freelancer who can help me with the following: - Excel Data Entry: Transfer data from an Excel file into a designated system. - Data Cleaning & Formatting: Ensure the data is cleaned and formatted correctly before entry. - Data Analysis: Help in structuring the information in a way that facilitates analysis. Ideal skills for this project include experience in data entry, Excel, and data analysis. Looking for a reliable and detail-oriented freelancer to complete this task efficiently.
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 rec...
NO AUTO GENERATED APPLICATIONS. THEY WILL BE DELETED. NOTE: I'M PAYING $2 PER HOUR FOR THIS JOB. DO NOT APPLY IF YOU ARE NOT OKAY WITH THAT RATE I want you to look at this personal portfolio site. Your job will be to evaluate the entire site and tell me any design issues, bug issues, UI or Flow problems, that need to be fixed. If you are a WordPress-Elementor developer, I can hire you to do the fixes as well. I'm looking for someone that can work immediately. REQUIRED: In your application tell me: 1. What computer & mobile devices do you own? Tell me the versions of the devices 2. What is the hourly rate I'm paying for this job? Are you okay with it? 2. Look at the site Tell me 2 problems you notice with the site, 3. Are you a wordpress-elementor developer? ...
I am looking for an experienced individual to help me create an interactive web platform that will serve as a guide to various types of machine learning algorithms. The purpose of this guide is to cater to beginners and intermediate lev...Learning Algorithms# -Supervised Learning -Unsupervised Learning -Semi-supervised Learning -Reinforcement Learning I need totally 14 article. Each article must consist of 1500 words. Python should be preferred as the programming language. A minimum of two-three images should be used to support each article. Also each article should be a guide for people new to Machine Learning. You can find the datasets to be used for these articles from the link below:
We have three separate infographics that we need created. Day to Day Operations, Day to Day Operations with a TPA, and Contracting Enrollment. You will find each of these charts in the files. Ware looking to improve this very simple, infographic. Attached is also the logo we have as well as some inspiration for color/font/etc. We want the infographic to have great color, and flow, using real word images/stock photos or cleverly related icons for each step. We want this to wow our potential customers. Note, the bubbles contain a lot of text. If it makes sense to use single words then a feature list below each bubble we are fine with that (see example). Please see project files and ask any clarifying questions. Thank you
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 Thi...
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...
... The app will offer services like location tracking and generating lists of nearby services. Key Functionalities: - For the location tracking feature, I will need: - Real-time tracking: This will be a core feature of the app - API: Reading from API - Listing nearby services based on some KPI - For the nearby places search feature, I will need: - Filter by category: To enable users to find relevant places - Sort based on property: This will enhance user search experience Ideal Skills: - Proficient in React Native framework - Experience with mapping services - Strong understanding of real-time tracking - Previous work on location-based service apps - Familiarity with custom marker implementation - Ability to create a user-friendly and robust UI I am open to suggesti...
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 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've done ...
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 ...
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!
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.
I am hoping to find an expert to create a versatile chat bot for my operation. The bot will be integrated with an AliExpress API and tasked with handling customer inquiries in multiple languages. Key Features: * Answer customer questions: The chat bot must be designed to manage and respond to various customer inquiries. Not only should it offer general support, it must provide specific responses related to product offerings being sold on aliexpress * The chat bot should be able to respond with relevant products according to the inquiry that will be offered to the client via affiliate links * Multilingual Support: The bot should have the capability to handle inquiries in various languages. This feature is vital as we cater to a diverse, international market. * Interaction Styl...
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...
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 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 ...
I’m seeking a data expert to scrape a specific database and transfer all available 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...
...end goal is to utilize these 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. ...
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
...the backend functionality, Firebase rules, state management, and data handling aspects quickly. I will need 20 hours of training (5x4h or 10x2h sessions) Key areas I would like to focus on: - Implementing backend functionality: Advanced backend functionality is my primary learning goal. I need to be able to understand and implement complex backend features in my apps. - Firebase rules: A good understanding of how to set secure and efficient rules in Firebase is essential. - State management: I need to understand advanced state management techniques in FlutterFlow. - Data handling: I need to learn how to efficiently handle data within my applications and understand the best practices. I am a veteran PHP SQL developer and I find it difficult to wrap my mind...
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.
...diligent professional to handle the daily update of our inventory data. The primary purpose of this task will be to generate purchase orders based on the stock levels at any given time. The data for this update will be sourced from various channels, which include supplier invoices, our 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 - Atte...
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 - St...
I am looking to find a skilled designer to create an authentic and appealing logo for a Marketing Agency located in Saudi Arabia "Media Dar" Which means "House of Media" and its written in Arabic "ميديا دار". I don't have a particular color scheme in mind, so I'm opening up the canvas to your creativity, be it warm, cool, or neutral colors. Key Requirements: - Unique, creative design - Must be specifically for a Media/Marketing services. When applying, kindly ensure to include your past work, and experience. While I don't necessarily have a fixed idea for my logo, I would love to see your original ideas based on the marketing agency name and concept. If you have a detailed project proposal you would like to present, that will be highly...
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 bonu...
I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more
I am in need of a skilled Figma designer who can create a visually stunning and user-friendly hotel website for me. The main goal of this website is to make it easy for visitors to book rooms. Key Deliverables: - Homepage that is visually appealing and functional - Room details page that is easy to navigate and showcases the accommodation beautifully - Contact us page that is easy to find and navigate Requirements: - Proven experience in Figma or other design software - Experience in designing elegant and luxurious websites - Understanding of user experience in e-commerce websites, specifically for booking processes - Ability to work with minimal supervision and deliver high-quality work within set deadlines If you are confident you can create a modern, elegant and luxurious hot...
I am seeking a professional website designer who can make an intuitive and engaging digital library for sustainable development goals (SDGs). This platform is intended to serve both students and the general public. The website functionality should include: - A powerful search function that makes it easy for users to find specific information. - An extensive collection of online reading materials related to each SDG. - Interactive quizzes to test user knowledge and engagement. - A curated drop-down list of book recommendations for each SDG. - A dedicated section for book reviews to create a community feedback loop and promote engagement with the content. - An "About Us" section highlighting the program, founders, and further relevant information. -We are also lookin...
Logo Refresh - looking for someone to help update the current logo for my business. I love it but I find that it is too dark, bold and intense. Would love to see how we could soften it to make it more friendly and appealing to all types of customers. Also, open to the idea of just cleaning up the logo to make it look elegant. There are 2 types of logos attached 1 - Main Logo 2 - Simplified Logo WWP I am still happy to keep the same colour but also open to similar colours if you have any other suggestions Font files are also uploaded
The instrument for which we want to find a great name shall be used by doctors, nurses and lab technicians in many countries. The measurement technique used is called "multiple electrode aggregometry", or "impedance aggregometry" or "whole blood aggregometry" and a similar system on the market is the Multiplate analyzer. Other a bit less similar devices are the PFA-200 and the Verifynow system. Background: Blood platelets are tiny cell fragments, which contribute to the blood coagulation system. When there is a bleeding, blood platelets stick together and create a aggregate that helps stopping the bleeding. You can find information on blood platelets here: • You can find fimilar existing instruments below:
...on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain data accu...
I am seeking an expert in Shopify product sourcing, editing, and listing to help me build a comprehensive online store that offers a variety of items in categories such as Fashion accessories, Electronics, Camping, Sport and Leisure, Clothing, Tiles and flooring. The ideal candidate should have expertise in the following areas: - Product Sourcing: My top priority is to find unique and high-quality products in the aforementioned categories. As such, I need someone who can efficiently research and source products from reliable and affordable suppliers. - SEO Content Creation: To ensure that the products are effectively marketed and attract the right audience, I need an individual who can create compelling SEO content for the product listings. Proficiency in keyword research and SEO ...
Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would gre...
...the option to click on “Reject request” (with a short explanation) or on “Send offer”. - With “Send offer” a price must be entered, some checkboxes and a text field) - The request is then moved to the “Processed requests” tab - Tab “Processed requests” - Here you have the option to click on “Receive order”. The request is then moved to the “Orders” tab - Orders” tab -Here you will find orders that have been won “Admin area” - All requests can be viewed here - The requests are distributed to various partner workshops. - We can see if a lead has been marked as “Order received” or “Order placed” by the workshop or the customer (table wit...
I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.
I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.
I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete thes...
...insights, ensuring optimal performance and ROI. I excel in staying abreast of emerging trends and algorithm updates, enabling me to adapt strategies swiftly and capitalize on growth opportunities. Moreover, my strong communication skills and a keen eye for detail empower me to maintain brand consistency and uphold the highest standards of quality in all content produced. I am particularly drawn to this role because of [specific reason, e.g., your company's innovative approach or commitment to community engagement]. I am eager to bring my expertise to your team and contribute to achieving your social media objectives. Thank you for considering my application. I am eager to discuss how my skills and experiences align with your needs further. Please find my resume att...
I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.
...agriculture broad acre farmers. The site should serve as a detailed resource, highlighting key aspects of our work and organization. Key Features: -A professional look and feel `-Wordpress based - A comprehensive "About Us" page to outline our mission, goals, and team. - A clear display of our contact information on every page. - Easliy updated by ourselves with graphics based on data collected and stored in MS Excel -Potential for client login The perfect candidate for this job would be an individual with a keen eye for modern web design, experience building informational websites, and ideally some knowledge in Australian agriculture. Good communication skills are necessary, as you'll be expected to collaborate with our team closely. A successful end r...
I'm looking for an Excel expert to help me clean up a dataset. I have a large dataset that contains both text and numeric data that needs to be cleaned up. The specific issues I'm facing are: - Text Data: There's a need to find and remove any duplicated values, missing values, and correct any formatting issues. - Numeric Data: The numeric data in the dataset has inconsistent decimal places and a few outliers that need to be identified and adjusted. Ideal skills for this project include: - Proficiency in Excel, particularly in data cleaning and data analysis. - Experience in handling both text and numeric data. - Strong attention to detail to identify and rectify issues within the dataset. Please, onl...
