Excel macro automate data entry jobs

I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valu...

I'm seeking a professional who can help me leverage Azure OCR Document Intelligence in order to automate the data entry process for a set of invoices. Requirements: - Utilize Azure OCR for extracting text from invoices - Implement an automated system for data entry based on the extracted text Integration: - I require the system to be integrated with my accounting software. Ideal Skills: - Proficiency in working with Azure OCR Document Intelligence - Strong experience in automating data entry processes - Prior work in accounting software integration is a plus

I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!

I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO

I need an expert in data capturing to mine specific information from websites and organize it efficiently into spreadsheets. The ideal candidate should be meticulous and comfortable with the following: - Data Capturing: The primary task involves extracting and compiling data from various websites. - Web Research: Ability to navigate and find required data efficiently. - Spreadsheet Proficiency: Experience with spreadsheets and data organization. Please bid if you have a strong eye for detail and a proven track record in data entry and web research.

I'm in need of a competent Website Assistant to join our growing team and handle the daily maintenance of my Shopify website. Your key tasks will be data entry and image uploading. You may also be required to crop and change resolution of images as required. Key Skills: 1) Easy to contact - available Monday - Friday 2) Willing to work more than 10 hours a week 3) Can work with an hourly contract 4) Able to learn instructions and work within a team I'm looking for a dedicated and reliable individual who can ensure that my website is always running smoothly. If you fit the bill, I'd love to hear from you.

I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I'm looking for a skilled DevOps Engineer who has extensive experience with AWS, particularly EC2 instances, S3 storage, RDS ...enhancements and further integration of the other AWS services. Key requirements and responsibilities include: - Proficiency in AWS services, with a focus on EC2, S3, RDS, and Elasticache - Experience in configuring and managing infrastructure with Terraform - Ability to enhance and integrate an existing EKS template - Implementing Infrastructure-as-code best practices - Working to streamline and automate infrastructure management - Prior experience with DevOps practices and tools Ideal candidates for this project should have a proven track record in AWS infrastructure management and Terraform. A strong understanding of DevOps principles and practice...

...Sounding Names: We kindly request all participants to register using American sounding names to maintain the authenticity of the event. Engage in the Webinar: Join the webinar and actively participate in the discussion. At the end of the session, you'll have the opportunity to ask questions related to the commercial real estate market. Take a screenshot of your question and upload to the contest entry so that we can pay you Reward Scheme: First Place: The person who asks the most interesting question will receive a reward of $100. Second Place: The second-best question will earn a reward of $50. Third Place: A reward of $25 will be given to the third-place question. We value your engagement and look forward to your insightful questions during the webinar! Registration L...

office templates, excel, word, power point

I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - I need you to know more about KDP marketing than I do. I only know the basics. I need an advanced skilled...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...

We need someone reliable and trustworthy to help us store and ship our clothes. As our Clothing Storage and Shipping Assistant, your main job will be to store 19 sets of nightwear ((consisting of a top + shorts) at your location and send them to the buyer as needed. You will receive already packaged production, and your main task will be to send it to buyer (living near a postal servi...with extra space who is willing to provide storage and shipping service. Please note, that storage and shipping service would be required until all 19 sets would be shipped. Location: Vancouver or around Vancouver only Skills needed: - Must be reliable and trustworthy - Good at organizing - Pay attention to details - Excellent communication skills Size: Small Duration: Up to 4 months Expertise: Entry...

...should be in Excel (.xlsx) and easily editable. - **Data Required**: The spreadsheet should include Business Name, Address, Phone Number, Email (if available), and any other relevant contact details. - **Usage**: I'll be using this directory for sales lead generation, so it's crucial that all the information is up-to-date and well-organized. - **Categorization**: The businesses should be categorized by specific industry (e.g., Hospitality, Retail) to help with targeted marketing efforts. I would like this done for the retail/hospitality e.g. butchers, newsagents, cafes, and convenience stores. We are not targeting large chains or franchisees. **Ideal Freelancer**: - **Excel Expert**: Proficiency in Excel is a must for this project. - **Data...

Seeking a skilled professional who can help finish up the set-up of Zoho CRM for my organization. We are using Zoho CRM to manage the patients who want to seek second medical opinion from expert doctors in India . This is the ideal workflow that we want to implement 1. Patient submits basic information like name, email, and location via Zoho Forms 2. The information is saved to Zoho CRM 3. The Patient is sent an invite to the portal 4. The patient sets up their account. The patient can view their treatment progress and edit their details. For the treatment progress, it needs to look like a timeline or steps that display this user journey. Something like this: 5. The patient is given an option to book a call. They must submit their medical records and a brief description of their illness. ...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completio...

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modellin...

I require assistance to set up a cronjob using Django cron-tab for my professional project. The main purpose is to automate tasks, specifically to - Send scheduled, automated reminder notifications to our clients. Ideal Skills and Experience: - Expertise in Django and cron-tab - Experience in setting up automated scheduled notifications - Knowledge on programming for customer interaction. Need simply a person to help me with enabling already set-up cronjob in my Django project(professional work).

...support, among others, member registration, subscription tracking, member services management, and trade references. The system should facilitate data import from Excel and accommodate online and offline accessibility based on the user’s capacity to meet online hosting costs. Member Registration: Develop a module for member registration capturing key details such as Name, address, and any other contact information. Village, group, area, district, province, sub-group affiliation (e.g., Study circle, VSLA, commodity association etc.) Demographic information (age, gender, household size, etc.) Implement functionality to adapt and import member data from Excel sheets. Enable different access levels (Project team, Donors and trading partners) for viewing,...

I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based researc...

...project which includes a simulation, data analytics charts, and text. I need all of these to be redone and improved. Here's what I'm looking for: - Refinement of the Simulation: The objective of the original simulation was to analyze a system. I need this part to be refined and improved upon. - Improvement of Data Analytics Charts: The original data analytics charts were created using Microsoft Excel. These need to be redone with more finesse and potentially using more advanced tools and techniques. - Text Revision: The text accompanying the project needs to be revised. This includes ensuring that the text is clear, concise, and well-structured. Ideal Skills and Experience: - Proficiency in simulation design and refinement - Strong background in ...

I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.

I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.

I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as ...

I am seeking a skilled freelancer to administer product uploads on my Spanish online clothing store, , which is set up on the Wix platform. Your task will primarily involve the accurate and efficient upload of approximatel...Experience with the Wix platform. - Attention to detail in product specifications. Your responsibilities will include, but not be limited to: - Uploading product details, specifically including size and material. - Attaching corresponding images for each product as per requirement. Please make sure all information is accurate before publication to avoid misunderstandings. Previous experience in data entry, especially related to clothing, is preferred. Your ability to ensure the successful execution of product uploads to my online store will be a great...

I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample

I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a good fit for this role.

...profile, e.g. with photo, location, nickname. Registration via email + password must be confirmed via double opt-in. The app should be able to access the device's contact lists. Now the user can create a new thread. In this he enters the following information: - Message part 1 (public) - Message part 2 (not public) - Recipient - Date The recipient (from the existing contacts, or an individual entry, e.g. telephone number or email) then receives a message via internal private messaging (if the recipient is also logged in to the app), SMS or, if known, via email. If the notification is sent via email, it will be as follows: --- START OF THE MAIL --- You have received a new message from XY, you cannot open the second part of the message until {date}. {personal message p...

In this project, I'm needing assistance to extract text data from printed documents and entering it into Google Sheets. This task involves meticulous attention to detail to ensure the accuracy of the data entered. The project requires a freelancer with strong data entry skills and the following qualifications: - Proficient in Google Sheets and Microsoft Excel - Excellent typing speed - Previous experience with data extraction - Ability to work with printed documents - Good at data categorization and organization - Proven track record of accuracy - Strong attention to detail If you have these skills, please bid for this project. Thanks in advance for your time and effort.

As a business owner with a Shopify store, I require an experienced professional to help me with product listing. ...business owner with a Shopify store, I require an experienced professional to help me with product listing. I have 5000 physical products that I need to be added to my store. Key Responsibilities: - Inputting product details such as title, price, and description - Uploading high-quality images for each product - Ensuring that all data is accurate and consistent Ideal Skills and Experience: - Prior experience with Shopify product listings - Familiarity with product data entry - Attention to detail to ensure accuracy - Ability to work with a large volume of products Please let me know your experience with similar projects and how you plan to manage the ...

I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula

The primary goal of this project is to create an Android Application that effectively manages student attendance. This software should offer functionalities such as: 1. **Manual Entry:** The app should allow teachers to manually enter attendance data for the students. This means user-friendly interface is key. 2. **Automatic Notifications:** The system should have the capability to automatically send notifications to absent students. The notifications should be programmed in such a way that as soon as a student is marked absent, an automatic notification message will be triggered to the student. 3. **Attendance Reports:** The app should generate comprehensive attendance reports, providing insight into the students' attendance habits. These reports should be easily ac...

One excel file with macro as per the customer requirement

I'm looking for a HubSpot expert to assist me with automating lead generation and email marketing tasks for my project. - Automate Lead Generation: The focus of this project is to automate various lead generation tasks using HubSpot. This would involve setting up workflows, lead scoring, and implementing strategies to increase lead generation. - Email Marketing Automation: Additionally, I'll need help with automating email marketing campaigns. The goal is to generate more leads and improve lead nurturing through a mix of promotional emails and educational content. The ideal freelancer for this job should have: - Proven experience with HubSpot automation - A strong background in lead generation and email marketing - Creative skills for crafting engaging and eff...

I'm seeking a tester to evaluate our PHP ...and assessing the website's strengths and weaknesses. Automated Testing: - Browser Compatibility: I need the website to be compatible with three major browsers (Chrome, Firefox, Safari) and require you to automate this testing. Ideal Candidate: - Proficient in PHP and Laravel: You should be well-versed with these technologies to understand the intricacies of the website. - Skilled in Manual Testing: Your experience in manually testing websites, particularly in evaluating Functionality, Usability and Compatibility, is crucial. - Automation Testing Knowledge: Your ability to automate testing, especially in terms of browser compatibility, is pivotal for this project. Please share your relevant experience and how you pl...

I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forwar...

As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!

I need to automate the process of notifying us in advance when our applications have expiring SSO certificates. - I'd like the system to monitor the certificates for me, sparing me the manual effort. - The system should send an email notification specifically detailing the certificate's name and expiration date, ideally 30 days in advance of the expiration. This way, I can ensure that we handle the renewal process in a timely and organized way. Ideal Skills: - POwerShell - Proficiency in Email Automation - Experience in Certificate Management Systems

I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interpersonal Skills: Ability to communicate effectively with team members, stakeholders, and clients.

I am seeking an experienced SharePoint developer to create a new SharePoint site and list for my team. This list should e...maximum efficiency. The significant aspect of this project is not only creating the SharePoint list, but also implementing Power Automate flow for seamless operation. Key Responsibilities: 1. Creation of a new SharePoint site and list 2. Inclusion of team member contact information and task assignments in the SharePoint list 3. Organizing the list by task category and project phase 4. Configuring Power Automate flow for the list Ideal freelancers should demonstrate: * Proficiency in SharePoint and SharePoint Online * Previous experience with Power Automate * Strong understanding of list organization and prioritization * Attention to detail and...

I need a proficient Excel expert to adapt my advanced financial models to reflect our current business strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financia...

I need a real estate development pro forma converted from a PDF to a functional excel file. One document is 18 pages and the other is 17 pages.

i want 3-5 minutes (both timeframe) candle data into excel sheet. data like date, time, open, high, close, volume of each candle. (check image for refrence) data should be updating in realtime, no delay, next candle data in new row. add instruction, so that i can edit code my self and chsnge stock symbol to get data for desired stock. easy to use and record all day data, even if i open excel at the day end or reopen thw whole day data should be recorded.

This is a very basic 3 or 4 page WordPress website. Skills needed: MySQL / AJAX / fetch / Axios / PHP / JavaScript / JSON / jQuery I'm seeking an AJAX solution for live data retrieval. Features/Pages - Registration & Profile Management page - User Data Entry Form with Data Entry History page - User Data search field page Site will need to integrate into a page builder (Oxygen) Please read the attached PDF and let me know if you can achieve the goal. Thank you for your consideration.

Looking for some simple finance-based calculations on a car-budget, some simple ratios and charts, by using MS-Excel. Also need a 650-words write up in 2 to 3 days

...comprehensive wedding website and app that will serve as a one-stop solution for all my wedding-related needs. Key Features: - RSVP Management: The app should be able to track and manage RSVPs from all invitees. - Wedding Countdown: A countdown feature to the wedding date. - Photo Gallery: A place to store and showcase the couple's photos and memories. - Guest Management: The app should have two excel sheets, one for the bride's guests and one for the groom's guests. - Dietary Preferences: A feature to collect and manage dietary preferences of guests. - Seating Charts: Ability to create and manage seating arrangements. - Communication: Integration with WhatsApp to create a community for confirmed guests. - Create an app for it so can log in via website or app. I...