Excel automatic data entry formula jobs

I need a seasoned professional skilled in utilizing spreadsheets and uploading product images for Walmart's marketing platform. The primary focus will be on analyzing product performance. Key Responsibilities: - Data entry and organization - Product performance analysis Ideal Skills: - Proficiency in spreadsheets - Experience with Walmart's marketing platform - Strong data analysis skills - Ability to upload product photos

We are seeking a reliable and organized Admin Assistant to support our team with essential administrative tasks. This role offers a monthly salary of $420 USD and requires excellent organizational skills and attention to detail. Key Responsibilities: Manage and organize documents, schedules, and team communications. Assist in data entry, record-keeping, and maintaining accurate files. Coordinate with team members to ensure smooth daily operations. Handle administrative tasks such as creating reports and preparing correspondence. Support in scheduling meetings and managing calendars. Requirements: Proven experience in an administrative or assistant role. Excellent communication skills and attention to detail. Proficiency with productivity tools such as Microsoft Office or Goo...

https://www.freelancer.com/projects/excel/Excel-Tax-Rate-Reversion-Formula/proposals

As a student seeking online work, I'm looking for a freelancer proficient in data entry, particularly in managing spreadsheets. Key Responsibilities: - Oversee and manage various spreadsheets - Generate reports from the data Ideal Skills: - Strong attention to detail - Proficient in Excel and other spreadsheet software - Experience in data entry and report generation Looking forward to your proposals.

*** NOTE: It seems that all these bids are automatic and AI-powered bids. If you are a real freelancer, please modify your bid by including "NOT automated" at the beginning of your bid, otherwise, I will not consider it. Thank you. *** Development of a Configurable SaaS Boilerplate using PHP (CodeIgniter) and Bootstrap Project Overview: We are seeking an experienced PHP developer to build a configurable SaaS boilerplate using CodeIgniter (HMVC architecture) and Bootstrap. The boilerplate will serve as a foundation for multiple SaaS projects by including essential SaaS features such as user management, subscription packages, payment integrations, and administrative controls. CodeIgniter Modules and Controller Functions Auth Module (User Authentication) Controller: Auth ...

I have financial data in an Excel spreadsheet that needs to be mail merged into a Word document. This document will then be converted into a PDF following a pre-defined template. Ideal Skills and Experience: - Proficient in Microsoft Excel and Word - Experience with mail merge - Able to convert documents to PDF - Attention to detail for template adherence This is a straightforward task for the right candidate. Please do not attempt to calculate or process the data prior to merging.

...need of an Excel expert to create a dashboard that links information from 2-4 external workbooks. The external workbooks contain data related to tracking our key performance indicators (KPIs), specifically focusing on operational efficiency. Key Requirements: - Link 2-4 external workbooks to a central Excel dashboard - The external workbooks contain data on production output and employee productivity Ideal Skills: - Proficient in Excel, particularly in creating dashboards and linking workbooks - Experience with KPI tracking and understanding of operational efficiency metrics - Attention to detail to ensure accuracy in data representation and tracking This project will enable us to effectively monitor our operational efficiency, providing us w...

I am looking for a professional to assist with my bookkeeping tasks using Microsoft Excel. This will involve data entry and organization, managing accounts payable and receivable, and performing bank reconciliations. Ideal skills for this job include: - Proficiency in Microsoft Excel - Experience in bookkeeping and managing accounts - Attention to detail for data entry and bank reconciliation

I'm seeking a seasoned developer to build a modern, responsive Progressive Web App (PWA) using Next.js. The app should manage a store loyalty progra...user-friendly interfaces will be vital in ensuring that the app is both functional and enjoyable to use. Project goal: Develop a Progressive Web App for managing a store loyalty program, including features for authentication, points management, and voucher redemption. Scope of work: - Implement user authentication with secure login and 2FA using AWS Cognito. - Enable card scanning via camera or manual entry post-login. - Create user interfaces for entering transaction amounts or points that connect to an API route for point calculation. - Develop a points redemption system allowing selection and confirmation of items before act...

I'm in need of a seasoned professional who can assist me in procuring low-cost multi-layer printed circuit boards based on an existing Gerber file and an Excel file bill of materials. Phase I: - Obtain a cost estimate for the PCBs and the components based on the provided files. Phase II: - Evaluate the delivered PCBs. - Proceed with the assembly of the components. My technician will handle the testing and reviewing of the assembled boards. Ideal Skills: - PCB sourcing - Cost estimation - Assembly - Multi-layer PCB expertise - Supplier negotiation

I'm looking for an expert in Excel who can help me build a comprehensive spreadsheet to track my business expenses from multiple sources including bank accounts, credit cards, and receipts. Key Features: - Daily updates: The spreadsheet should be designed to accommodate daily expense tracking. - Duplicate charge detection: The system should help identify duplicate charges automatically. - Note-taking: I need to be able to record notes directly in the spreadsheet. - Categorization: All expenses need to be categorized so I can sort and see total costs for different categories over different time periods (time periods should be customizable). Ideal Skills: - Proficiency in Excel: You should be extremely comfortable with Excel and be able to create complex formulas...

I am in need of a dedicated full-time admin assistant with strong English skills. Key Responsibilities: - Data Entry: Inputting and managing various types of data. - General Admin: Assisting with a variety of administrative tasks and duties. The ideal candidate will be organized, detail-oriented and able to handle a range of administrative tasks. Experience in a similar role is highly desirable. Needs to have a high level of spoken, written and reading English (UK)

I'm looking for a web scraping expert who can extract wine data from Tajan. The data to be scraped includes: - Bid prices: Picture 1 - Auction dates: Picture 1 - Wine details: Picture 2 See an example as an attachment Website: Needed data: all wine events from March 2020 until the end of 2024 Auction item: Wine The scraped data should be delivered in a Spreadsheet (Excel/CSV). A snippet of the data from 2013 is attached. This is a one-time project, so I do not require ongoing data collection. Ideal skills for this project include: - Proficiency in web scraping tools - Experience with data extraction - Ability to present data in a clear, organized manner Please provide examples of similar projects you've complete...

...should be incorporated within or around the circle. Symbolism: Digital Creativity: The logo should subtly represent digital creativity and innovation, possibly through abstract shapes or lines within the circle. Excellence and Leadership: The design should convey a sense of excellence and leadership, aligning with the brand's values. About Our Company: Mission: Rexo Studio aims to lead and excel in the digital world by providing reliable, expert, and optimized digital services that elevate our clients' online presence. Services: We specialize in graphic design, web design, and social media marketing. Our team combines creativity with technical skills to deliver innovative and effective solutions. Values: Our core values include reliability, expertise, excellence, an...

I'm seeking a data mining professional to assist in organizing and extracting data from .xlsx files into a provided .xls template. Key Responsibilities: - Extract and organize customer orders and information from .xlsx files. - Input data into a specified .xls template. Ideal Skills: - Proficient in data mining and data entry. - Experience with .xlsx and .xls files. - Attention to detail to ensure data is accurately recorded. The chosen candidate will mine the archives and put them in the template as "2023" and "2024"

I'm seeking a skilled data processing programmer to help transform numerical data from CSV and Excel files. The primary focus of this task will be on data transformation. Ideal candidates should: - Have a strong proficiency in programming languages suitable for data processing such as Python or R. - Be experienced in working with CSV and Excel files. - Have a solid understanding of numerical data and data transformation techniques. Your expertise will help in converting raw data into a more useful format. Please bid if you have the necessary skills and experience.

I need a seasoned professional who can help me tweak my trading EA for better profitability while keeping risks in check. The EA uses a martingale strategy with th...risks in check. The EA uses a martingale strategy with the obvious downside that if the market stars to trend in one direction it can encounter drawdown. I would like to change the way the Martingale works in order to adapt the EA to start marking counter trades if a certain criteria is breached. Key Tasks: - Adjust the Risk Management Parameters to optimize leverage usage - Modify the Trade Entry and Exit Criteria for enhanced performance Skills and Experience Required: - Proven experience with trading EAs - Strong understanding of risk management in trading - Ability to balance between maximizing profit and minim...

Please Sign Up or Login to see details.

I'm seeking a highly skilled virtual assistant who can help me with data entry and research tasks. The primary focus will be on transcribing digital documents. Ideal Skills and Experience: - Proficient in data entry and research - Excellent transcription skills - Able to handle digital documents with precision - High attention to detail - Strong organizational and time management skills

...the marketplace: o Products related to the photovoltaic sector, such as solar panels, inverters, batteries, optimizers, mounting structures, etc. 2. Upload a database of companies: o Approximately 5,000 companies, categorized as manufacturers, distributors, or installation companies. o Each entry will include details such as company name, address, contact information, country, and category (manufacturer, distributor, or installer). This version is for internal use only, enabling me to organize data and test the platform's functionality before making it public. Quotation 2: Fully Functional Marketplace For the more advanced version, I require the following features: 1. Publishing products and services: o Manufacturers and distributors should be able to lis...

...to the marketplace: o Products related to the photovoltaic sector, such as solar panels, inverters, batteries, optimizers, mounting structures, etc. 2. Upload a database of companies: o Approximately 5,000 companies, categorized as manufacturers, distributors, or installation companies. o Each entry will include details such as company name, address, contact information, country, and category (manufacturer, distributor, or installer). This version is for internal use only, enabling me to organize data and test the platform's functionality before making it public. Quotation 2: Fully Functional Marketplace For the more advanced version, I require the following features: 1. Publishing products and services: o Manufacturers and distributors should be able to list their ...

I'm seeking a VBA expert to help me extend my current data collection project. The task involves: - Collecting soccer fixtures from Coral, including odds for home, draw, away, over/under and both teams to score markets. - Integrating this new data into my existing Excel file, which currently collects the same data from two other sports websites. The data from Coral is similar to the other sites, so no special handling is required. The ideal freelancer should have extensive experience with VBA and data collection, as well as a keen attention to detail.

...comprehensive report summarizing findings, assumptions, and recommendations. Present financial models in an easily interpretable format for stakeholders. Key Deliverables: Financial feasibility model in Excel or equivalent software. Detailed investment and cash flow projections with supporting assumptions. Sensitivity and scenario analysis results. Executive summary with key insights and actionable recommendations. Qualifications: The ideal candidate should possess: Expertise in financial modelling for real estate projects. Strong knowledge of residential real estate market dynamics. Proficiency in Excel and financial analysis tools. Demonstrated experience in conducting feasibility studies for comparable projects. Engagement Timeline: The financial feasibility mode...

I am looking for an Excel expert to assist with data analysis tasks. I already have the data for analysis and need help in identifying trends and making predictions based on the data. The desired outcome is to gain insights from the data for decision-making purposes. Ideal skills and experience for this job include: - Strong proficiency in Excel and its formulas and functions - Experience in data analysis and visualization - Knowledge of statistical analysis techniques - Ability to interpret and communicate findings effectively

I need a cloud-based access control system for vehicle entry and exit. The system should be capable of storing: - Vehicle entry and exit times - Vehicle identification details - User information linked to the vehicle This system will be standalone, not requiring integration with any existing security or database management systems. Ideal candidates for this project should have experience in developing cloud-based systems and access control mechanisms.

...application process, schedule visa appointments, and easily retrieve appointment confirmations. - It should be capable of booking appointments for VFS Lithuania, Hungary, Portugal, as well as all other countries in the VFS database. - A crucial feature of this software would be integration with the VFS Global API allowing for smooth interaction with the VFS systems. - The software should also have automatic form-filling capabilities reducing manual input from my end. - A real-time availability check and notification system needs to be built into the software, alerting me of available appointments. ### Functional Requirements: 1. **User Authentication:** - The software should support user authentication to ensure security and restrict unauthorized access. - Users should be...

...file for use by the notification system. 2. LuxAlgo Notification Integration: Integrate LuxAlgo Premium toolkit on TradingView. Configure alerts based on user-defined settings and conditions. 3. Machine Learning Pump Prediction: Implement a machine learning model to identify potential pumps of at least a 15% price increase. Ensure the model accounts for a maximum 3% retracement from the entry price. Integrate these predictions into the alert/notification system. 4. Signal & Alert System: Set up a notification system (e.g., email, SMS, or another channel) that sends signals when conditions are met. Configure alerts for multiple timeframes, from 15 minutes to 4 hours. Integrate both LuxAlgo signals and ML predictions into a cohesive alert system. 5. Testing ...

I need a project set up in Microsoft Dynamics 365 Business Central A/L, specifically within the Finance module, to track bank cheques received from customers. The project should cover three main steps, each involving a posting entry. Key Steps: 1. Receiving the cheque: Credit the customer and debit the Non-Return (NR) account. 2. Sending the cheque to the bank for collection: Credit the NR and Debit the 'Checks under Collection' account. 3. Bank collection: Debit the bank and credit the 'Checks under Collection' account. There are additional scenarios to consider: 4. Bank rejection: If the bank rejects the cheque, it should return to the customer's balance by debiting the customer and crediting the 'Checks under Collection' account. 5. Transactio...

Read current economic data and forecasts from and transfer them to an Excel table. See appendix for a list of indicators. Countries: USA, Europe, UK, Australia, New Zealand, Switzerland, Canada and Japan. Only the first page of the Excel sheet will be important to me. I would like to see the indicator(s) from the selected countries superimposed in a diagram using a checkbox. updating the data from the website should be possible at "the push of a button"

I'm in need of a seasoned Magento 2 Developer who can expertly implement an API Stock synchronization from a 3rd party source. The system must automatically update stock in real-time, reflecting changes across both our inventory management system and product listings on the website. Key Requirements: - Implement automatic stock updates via API - Ensure real-time updates across both inventory and product listings - Expertise in Magento 2 - Prior experience with API Stock synchronization - Ability to deliver a robust and efficient system

...to payment with workflow system for casual employees Key Features of the Onboarding System: - User Registration: This should be simple and user-friendly via websites or apps. - Document Uploading: Employees should be able to upload necessary documents securely via websites or apps. - Manager/ HR to the be able to approve the data and timesheet submitted by the employee - HR to be able to use the data to process the payroll. (with setting to setup the payment formula.) - Payment: The system should be able to handle initial payment setup. Ideal Skills and Experience: - Proficiency in full-stack development (Website, apps) . - Experience with creating HR or payroll systems will be highly advantageous. - Strong UI/UX design skills to ensure the system is user...

I need someone to manually enter project data from PDF or DOC files into an online website, the website is built in the Umbraco CMS, and we are required to enter projects on it. Key Requirements: - Proficient in data entry with high attention to detail. - Able to follow instructions carefully to ensure data is entered accurately. - Familiar with PDF and DOC file formats. - Upload images for each related project. - Urgent and Speed, require approx 75 projects to be uploaded asap. The ideal freelancer for this project will have previous experience with manual data entry, preferably in Umbraco. Speed and accuracy are paramount for this project.

I'm in need of a skilled Data Entry Operator. The job involves working with text data from digital files, specifically Excel spreadsheets. You will be responsible for entering data into various computer databases and maintaining effective record keeping. Ideal Skills: - Proficient in Excel - Excellent attention to detail - Strong organizational skills - Experience with data entry no

I'm looking to design a gate that opens via facial recognition to allow only subscribers to enter. You can use Raspberry Pi, ESP32, or any other reliable method. The main aim is to ensure an efficient facial recognition system that can securely manage entry. Key Requirements: - Use of any reliable method for the facial recognition system. - No specific facial recognition software in mind, but familiarity with options like OpenCV or FaceNet may be beneficial. - Potential to incorporate additional features like logging entry times, remote access control, and alerts for unauthorized attempts. Ideal Skills and Experience: - Proficiency in hardware programming with Raspberry Pi, ESP32 or similar. - Experience with facial recognition systems. - Knowledge of relevant software...

I'm seeking an data entry professional to assist me with this project Key Details: - You will need to possess a keen eye for detail to ensure all data is captured accurately and comprehensively. Ideal Skills: - Proficiency in data entry. - Strong attention to detail. Please submit a bid if you are skilled in these areas and can assist with this are most the information needed will be given.

I'm looking for a seasoned developer to create an automated NBA betting system for me. The system should integrate with DraftKings and FanDuel and have the following functionalities: - Placing automatic bets based on sophisticated algorithms - Providing timely betting alerts and notifications -Use certain aspects of stats to come up with certain lines The ideal candidate for this project should have a deep understanding of NBA betting and experience in developing similar automated systems. If you have the required skills and experience, please get in touch.

I need an expert in Excel to apply Color Scales conditional formatting on an Excel sheet containing number ranges. The color scale should span from Green to Red. Ideal Skills: - Proficiency in Microsoft Excel - Expertise in Conditional Formatting - Ability to work with number ranges Please ensure that you are able to deliver a well-formatted Excel sheet with the required conditional formatting.

I need an expert in Excel VBA to create a tool for me. Requirements: - Import specific row fields from a CSV file. I need to import Names and Addresses, Product IDs and Descriptions, Dates and Amounts, and other general things. - The import should be triggered by a menu option in the Excel toolbar. - There should be a print button to print the new sheet with the imported contents. Ideal Skills: - Proficiency in Excel VBA. - Experience with CSV file manipulation in Excel. - Ability to create custom toolbar options in Excel.

...the salesperson clicks multiple times, the system makes a transaction numerous times. Which is wrong. (Same bill multiple times transactions) 2. Please remove the Print pop-up from the POS page. The system should print directly to the printer after completing the transaction. 3. POS sales time if sales salesperson does not enter any customer name or number, the system creates blank customer data, which affects the customer table. 4. We can't reprint the individual refund receipt (http://localhost:3005/pos/refunds) 5. Refund bill amount is deducted from the same bill number which was created before. This amount should be deducted from his account, which is creating the refund bill. 6. We can't reprint the individual refund receipt (http://localhost:3005/pos/refunds) ...

I'm seeking a tech writer with expertise in web app development to create a comprehensive technical document for a custom web app. This web app is primarily a data entry platform with user login capabilities, and it will also handle attachments. Key Components of the Document: - An in-depth description of the app's purpose and functionalities - Detailed specifications for user account management features: user registration and login, password recovery, and user profile management. - A technical outline for the data entry components and attachment handling features. Ideal Skills: - Proficient understanding of web app development terminology - Experience in technical writing specifically for web applications - Ability to translate complex technical inf...

I need assistance with manual data entry. The data has to be extracted from video and organized into Excel spreadsheets. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with manual data entry - Ability to accurately extract data from PDF files

Business Requirements Core Modules: Dashboard: *Overview of Key Metrics: Provides a consolidated view of attendance, events, and exam schedules. *Role-Specific Dashboards: Custom dashboards for admins, teachers, parents, and students. *Customizable Widgets: Personalize the display for quick access to essential data. Message: *Real-Time Communication: Secure messaging between teachers, parents, and students. *Broadcast Announcements: Send updates or notices to groups or the entire school. *Message Archives: Store and retrieve older communications for reference. Calendar - *Event Scheduling: Display and manage school events, holidays, and meetings. *Automated Reminders: Notify stakeholders about upcoming deadlines or events. *Parent-Teacher Meeting Planner: Simplify scheduling for i...

Build a excel spreadsheet identical to the photo listed Must have the formulas to make the boxes work correctly I need to have these in there Daily sales Cost of goods Total cars Job averages Sales projection Monthly targets Daily targets cost of goods will be total cost minus daily sales total Total cars will need to be calculated off of total sales and divided which will bring the job averages Monthly target will make a daily target depending on days in the month and Daily sales will affect sales projection

I'm seeking an expert to track and compile a list of properties from for properties all around London only with date it was uploaded to Rightmove. The list needs to be in Excel format and should include the address of each property & identification when a property updates to sold or under offer. I have included a screenshot from Rightmove and arrows showing the data that needs to be captured. Ideal Skills and Experience: - Proficient in data collection and analysis - Familiarity with Excel - Knowledge of real estate data tracking Key Requirements: - Regularly updated list of properties with the date it was uploaded/reduced around London on Rightmove - Regularly updated list of properties that has changed its status to Sold or Under Review - Pi...

Lead Generator for Instagram Influencers Are you skilled in finding Instagram influencers? Join us on a simple but rewarding project! Role: We need a Lead Generator to hunt do...Role: We need a Lead Generator to hunt down qualified Instagram influencers within a specific target market (we’ll provide details). Responsibilities: Find influencers based on our target market. Provide qualified leads in a Google spreadsheet. Compensation: $1 for every 10 leads. The first milestone is 100 leads. Plenty of similar projects are available for long-term collaboration if you excel at this task! What We’re Looking For: Someone efficient and detail-oriented. A good understanding of Instagram influencer niches. If this sounds like a good fit, let’s work together! Rea...

I'm seeking an Excel expert to create a comprehensive budgeting and forecasting tool. The tool will need to accommodate: - Expense & Revenue tracking - Expense & Revenue forecasting using drivers The data will be manually entered, so the interface needs to be user-friendly, with clear instructions for inputting data. The ideal candidate will have: - Extensive experience with Excel, particularly with creating complex spreadsheets for budgeting and forecasting - A strong understanding of budgeting and planning - Proficiency in creating and implementing Excel macros The end goal is a robust, easy-to-use Excel file that will help me keep track of my finances and forecast future expenses and revenues.

I need assistance with my Microsoft Excel spreadsheets to delete duplicate rows without moving any data. The duplicates are identical rows. Ideal skills for this job include: - Proficiency in Microsoft Excel - Experience with data cleaning and management - Attention to detail to ensure all duplicates are removed accurately and efficiently.

I'm looking for a freelancer who can assist with data entry from handwritten notes and online content. - Text Data: The primary task involves entering text data from handwritten notes. - Online Content: You will also be required to transcribe information from web pages. Ideal candidates for this project should have: - Excellent typing skills with high accuracy - Ability to decipher handwritten notes - Familiarity and comfort with working on web pages - Prior experience in data entry Please provide examples of similar work you've done in the past. Thank you.

I'm in need of a diligent virtual assistant. Your first task will involve sorting through job candidate applications and compiling relevant information...Education background - Work experience - Projects Done - CGPA - Availability (Start date and end date) - Educational Institution - Course The information should be organized alphabetically by candidate name. Ideal Skills: - Proficient in Google Sheets - Excellent attention to detail - Good organizational skills - Ability to maintain confidentiality - Previous experience as a virtual assistant or data entry professional preferred. There are about 230 candidates . Information for all these candidates need to be organised. If this task is done well, I plan to use the same person for any other administrative tasks on a ...

...in need of an Excel expert to transform a spreadsheet into a comprehensive inventory system. The system should be capable of receiving and logging orders, generating invoices, and providing a form for data entry. Additionally, there should be a way to attach drawings to the relevant items. Key Requirements: - Order tracking and logging - job scheduling - Invoice generation - Form for entering details - Capability to attach files as objects in Excel The system needs to accommodate more than 200 different types of inventory items. Ideal Skills: - Advanced Excel proficiency - Experience with inventory management systems - Familiarity with invoice generation in Excel - Ability to create user-friendly data entry forms Please bid o...