Excel automatic data entry formula jobs

I need a diligent data entry expert to transfer information from supplier portfolios into an Excel spreadsheet. This data will be ready for export into other programmes. Key Responsibilities: - Extracting product details and pricing information from supplier portfolios. - Utilizing a supplied template to organize data in the Excel spreadsheet. Ideal Skills and Experience: - Proficiency in Excel and data entry. - Attention to detail for manual review quality checks. English as a first language is preferred for effective communication.

I am looking for a freelancer to provide non-voice BPO services for my project. Specifically, I require data entry support. Skills and Experience: - Proficient in data entry tasks and accuracy in inputting information - Familiarity with various software platforms for data entry (no specific platform required) - Ability to meet deadlines and work efficiently Task Details: - The task involves entering data into a software platform (platform can be determined by the freelancer) - The desired turnaround time for the task is flexible and can be discussed further If you have experience in data entry and are comfortable working with different software platforms, please submit your proposal. Thank you.

...compatibility and smooth integration with Google Sheets. Package and publish the add-on on Google Workspace Marketplace. here's my apps script demo on attach file 2. Create UI in Sidebar Design a clean and user-friendly sidebar UI based on my mockup: View Mockup Here Sidebar Features: Input Field: Field for entering prompts. Dropdown Menu: "Generated Formula": Allows users to generate formulas via prompts. "Request Change": Option to request changes to generated code or formulas. Error Handling: If the code generated via "Request Change" produces an error, display an error message in the UI. Executions resulting in errors will NOT be counted as successful. ...

I run a webshop from various brand and I need a data specialist who can process and optimize all my product data in Excel. The task involves converting and structuring my current data into a format suitable for use in my webshop. I primarily need assistance with: - Optimizing product descriptions, product categories, and SKU management - Converting and structuring my current product data Experience with product data, categories, and webshop requirements is a plus. Please share your experience and approach.

I am looking to compile publicly available information on 1,035 UK IFAs (i.e. financial advisory firms) mainly from FCA register and Companies House. Most of the information can be downloaded in an automated way with some simple website parsing code, but some manual cross-checking might be required as well. I need to fill in the tab “Database (Firms)” in the attached Excel file called “2024.12.16 - List of IFAs_v02”. Here are the fields that I need to fill in: - “CH number”: Companies House reference number. I intend to fill in most of these myself, but for the ones that are missing, I will ask to help me find those reference numbers - “Year Established”: On Companies House, in the "Overview" section, you can find an ite...

...session. Multi-User Interface with Customized Access Rights: Adapt the interface for different types of users (administrators, trainers, students, consultants) with distinct access rights and privileges for efficient management. Payment and Automatic Billing: Automate the generation of invoices linked to each training or consulting service, integrating payment tracking and follow-up on receivables. Data Security and Backup: Ensure data security for sensitive student and trainer information, with regular backup protocols and recovery options to prevent data loss. Bug Resolution and Ongoing Support: Provide ongoing support for bug fixes and system troubleshooting to ensure smooth operation, including regular updates and error tracking. Special Offer and Bo...

...to assist with text creation. Daily Targets: Successfully post a minimum of 160 links across the internet each day. Important: Only links that remain live and online will count toward your daily target. Links that are removed, deleted, or flagged will not be considered. Tracking and Reporting: Maintain a well-organized record of all links posted. Submit proof of work at the end of each day in Excel format, listing all successfully posted links. Work Schedule: Days: Monday to Friday Hours: 8 hours per day Skills & Requirements: Attention to Detail: Accurately track posted links and ensure they stay live. Efficiency: Achieve the daily target of 160 live links consistently. Online Familiarity: Ability to navigate various websites, forums, directories, and communities. Writin...

Overview - We need to have Polybags branded with our brand Digifon and ICON is the most prominent image we want to illustrate, our competitor bags attached, ITEL Mass market cheap brand, Oraimo Now positioned as Highend brand , we are Premium but affordable and this product category is to mass market our entry level series we called in Mate Series as we have powerbank named Mate Series and we will like the colors to be the same as this is for mass market exposure , very cheap price point , our brand identity is more cool lifestyle Urban , young generation and will not like to look like ITEL , you will see Oraimo put a popular brand ambassador Image on the back , so our wish is to use our Cobalt blue color + Red , Cobalt being the dominant color .

...11+) might be needed. For the moment, we will only need it for Android. Audio Processing: Use Google Transcribe as an auxiliary layer for initial audio processing. Enhance audio quality before sending it to the API, using noise reduction techniques or filters. Using Google Speech-to-Text: Integrate the API to convert audio to text in real time. Adjust parameters like sample rate, language, automatic punctuation, and handling of specific terms. 3. Complementary Features Manual Editing: Allow users to correct transcriptions for greater accuracy. Notifications: Alert users when a transcription is complete or if the connection is lost. Service Integration: Enable synchronization with Google Drive or other platforms to save or share transcriptions. User-Friendly Interface: Design...

I need an Excel expert to analyze and visualize my sales data. Key Tasks: - Compare sales and orders using a pie chart. Sales and orders should be differentiated by different colors. - Identify the month with the highest sales and orders. - Analyze gender-based purchasing trends in 2022. - Provide insights on different order statuses in 2022. - List the top 10 states contributing to sales. - Explore the relationship between age and gender based on the number of orders. - Determine which channel contributes the most to sales. - Identify the highest selling category. Ideal Candidate: - Proficient in Excel with strong analytical skills. - Experience in data visualization. - Ability to provide meaningful insights based on data analysis.

1. Project Overview The goal is to create a modern, responsive, and user-friendly WordPress website to replace an existing PHP 4 data-driven website with 1000+ documents. The new system will include a custom WordPress theme, a custom plugin for document management, and an admin panel tailored for a non-technical senior author to manage documents. Additionally, the project includes ongoing technical support for 2-3 years. 2. Objectives  Design a modern, fully responsive website layout.  Develop a custom WordPress theme.  Create a custom plugin to manage document upload, update, and deletion.  Implement infinite scroll functionality for document lists on the front end.  Provide a user-friendly admin interface for a non-technical author.  Ensure system security, scala...

I need a Python developer who can write a script to extract data from text-based PDF files and convert it into an Excel file. The data that needs to be extracted is from the first column of the PDF, with the corresponding data pulled next to it. The ideal candidate for this project should have: - Proficiency in Python - Experience with data extraction and manipulation - Familiarity with handling PDF files and converting data to Excel The extracted data should be organized into multiple sheets in the Excel file, with each sheet representing a different category. This project requires attention to detail and the ability to handle data efficiently.

More details: What primary function should the platform serve? Paid tournament How should users be able to pay for tournament entry? Digital wallets, Google pay, Phonepay, Fampay Which user roles should the platform support? Players

Merge excel spreadsheet for the 3rd project

I'm seeking an experienced Virtual Assistant to generate high-quality tutoring leads for AstraX Education, primarily targeting high school students in need of Math and Science tutoring. Responsibilities: - Proactively search Facebook groups, Reddit, Gumtree, and other re...- Provide daily or weekly reports on progress and lead quality. Requirements: - Proficient understanding of social media platforms, particularly Facebook Groups, Reddit, and Gumtree. - Fluent in English with strong communication skills. - Basic to intermediate knowledge of Google Sheets or Excel. - Prior experience in lead generation or virtual assistance is preferred. This role is crucial for our growth at AstraX Education. Your skills and experience will directly contribute to helping students excel...

As a hiring manager, I need a diligent and efficient assistant to help with reviewing job applications, entering candidate data into our company system, and managing data processing. This role can be part-time or full-time, with a competitive salary. Ideal Candidate Skills: - Strong data entry skills - Proficient in Excel and Word - Experience with data processing Key Responsibilities: - Reviewing and approving job applications - Entering candidate information into the company system - Data processing Proficiency in Excel and Word is a must. Experience with HR software and previous hiring manager experience are not required but will be an advantage.

I have a number of PDF files that require manual data entry into an Excel spreadsheet. Attention to detail and accuracy is paramount for this task. Ideal Skills and Experience: - Proficient in manual data entry - Experienced with handling PDF files - Highly skilled in Microsoft Excel - Detail-oriented and accurate

...WebSocket connection to receive real-time OHLC (Open, High, Low, Close) data for multiple stock symbols at 5-minute intervals. Responsibilities: Establish a WebSocket connection to receive OHLC data for specified stock symbols. Collect and process OHLC data at 5-minute intervals. Save the latest OHLC data into a new CSV file every 5 minutes, including the timestamp, open, high, low, and close prices. Handle automatic reconnections if the WebSocket connection is lost or closed. Ensure that the CSV file is named with a timestamp based on when the file is created. Skills Required: Experience with WebSocket API integration. Proficiency in Python (or another relevant language for WebSocket and file handling). Experience with real-time data collectio...

As an accountant, I work a lot with Excel. I am looking for a freelancer with strong Excel and automation skills to help me streamline certain tasks. Key tasks include: - Automate data analysis and reporting processes - Identify specific quantities in my data sets The main focus will be to automate the analysis of trends with a specific emphasis on my spending amounts. The ideal skills for this job include: - Competence in Excel, particularly in the use of advanced features and functions either formulas, macros etc. (preferably macros) - Experience with task automation in Excel - Strong data analysis skills - Understanding of accounting principles and terminology

I need you to fill in a spreadsheet with data. The data written on paper I need it to be in excel

I need to set up a connection between QuickBooks Online and Microsoft Excel using cdata. The purpose of this connection is to transfer financial reports from QuickBooks to Excel on a daily basis. The level of detail in the reports needs to be customizable. Ideal skills for this job include: - Experience with cdata and its applications - Proficiency in Microsoft Excel - Familiarity with QuickBooks Online - Data analysis and report generation expertise - Ability to set up automated processes for daily updates. The successful freelancer will help me create a seamless connection between the two platforms, allowing for efficient and effective financial report tracking and analysis.

I'm seeking a diligent Team of Classified Traffic Count Enumerator to analyze vehicle traffic from video footage. Responsibilities: - Count various vehicle types every 15 minutes. - Accurately log data into a specified Excel format. Vehicle Types to be Classified: - Cars, Trucks, Motorcycles - Auto Rickshaws, Cycle Rickshaws, Bicycles - LCVs under 4 Tons, 4-6 Tons, and 6 Tons - Tractors with and without Trailers - Construction Equipment Vehicle Types to be Counted: - All of the above vehicles Ideal Candidates: - Experience in data entry and traffic analysis preferred. - Proficiency in Excel essential. - Attention to detail and ability to work meticulously under time constraints. Prior to awarding the job, you will be given 15 minute video to co...

...you are responsible for supporting the Logistics and Operations department. This includes but is not limited to, being responsible for all daily operations in the warehouse including all inventory handling, stock allocation support, warehouse organization, managing and handling shipping, loading and unloading of products and picking and packing. You will be required to handle phone inquiries, data entry and reporting transactions while ensuring that records are maintained and inventories up to date. You will ensure you are familiar in operating the necessary tools in maintaining and managing a warehouse. Your responsibilities will also include special projects as assigned. Strong attention to detail and the ability to work in a fast-paced environment are essential. If y...

I'm seeking a detail-oriented individual for a copy-paste data entry task. Your primary responsibility will be copying data from my emails into online forms. Ideal Skills: - Exceptional attention to detail - Quick typing skills - Experience with data entry - Proficient in handling online forms - Excellent understanding of following instructions accurately Your role will be key to ensuring my data is organized and submitted correctly. I am looking for someone who can deliver quality work consistently, without errors, and meet deadlines. Your ability to manage this task efficiently will make you a reliable asset for this project.

I'm in need of a technical expert who can help me set up and configure a system to automatically send all my limit order signals from TradingView to Tradovate via webhooks. This project includes: - Setting up the technical configuration needed for this system - Ensuring all limit order signals are sent smoothly and automatically The ideal freelancer for this project should have: - Extensive experience with TradingView and Tradovate - Proficiency in technical setup and configuration - Understanding of webhooks and their integration

I need assistance in extracting a dataset from a scanned PDF document and formatting it into a CSV file. The last 24 pages of the document...formatting it into a CSV file. The last 24 pages of the document () contain the dataset that needs to be copied. This can be done by hand, by OCR, or by a mix. Key requirements include: - Cleaning and formatting the data as seen in the PDF - Leaving incomplete or missing data points blank - Using the column names given in the PDF for the CSV file Ideal skills for this project: - Proficiency in OCR or hand data entry. - Every person and program makes mistakes, so you need to understand what data values make sense, and have a system for catching, verifying, and correcting outliers, anomalies, and errors.

I'm working on a homework assignment involving 4 problems that need to be solved using Excel Solver and regression analysis. All solutions must be shown in an Excel file, complete with the solver box in its entirety. The data sets I'll be working with pertain to sales. The primary goal of the assignment is to utilize Excel Solver to maximize profit. Ideal Skills: - Proficient in Excel, specifically with Excel Solver and regression analysis. - Strong understanding of sales data. - Capable of creating comprehensive Excel files. Experience: - Prior experience with similar assignments or projects preferred.

...month-end and year-end closing processes. Assist in budgeting, forecasting, and other financial tasks as required. Qualifications: Proven experience as a Bookkeeper in the US or working with US-based businesses. Strong understanding of US GAAP (Generally Accepted Accounting Principles) and tax laws. Proficiency in QuickBooks Online, Xero, or similar accounting software. Excellent skills in Microsoft Excel/Google Sheets and other productivity tools. Knowledge of payroll systems and processes. Requirements: Degree in Accounting, Finance, or related field (preferred but not required). Minimum of 2-3 years of bookkeeping experience in a similar role. Ability to work independently, prioritize tasks, and meet deadlines. Strong analytical and problem-solving skills. Excellent verbal a...

I need a skilled Python programmer to help me automate the order placement on Interactive Brokers. Ke...platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give Budget:1050 if you can provide result with my budget, Not your Expectation, I will give good review, if you complete my budget, Dont expect more money If you have experiece in trade a...

...a variety of administrative tasks across both my business and personal activities. This is a long term, ongoing role for the right candidate, so I'm looking for someone who is not only skilled but also adaptable. Key Responsibilities: - Manage my calendar -Work on projects with me - Book travel -Gather information - Utilize G Suite and MS Office for various tasks including document creation, data entry, and email management. - Collaborate with my team using Trello and other collaborative tools. - Communicate effectively in written English for correspondence and updates. -Work with the marketing team and in the backend of our various software used for marketing and training Ideal Skills and Experience: - Proven experience as a Virtual PA or in a similar administrativ...

Please check the attached file, 'STAFF TRAINING LIST'. Input the date and course completed into the Excel file. Also, please list in a Word file which staff members have not completed specific training. I can pay 10 CAD, and I need it done within 1 day

Looking for Arduino FastLed library expert to complete board code for 120 Leds stripe (ws2812B) clock Board is NodeMCU ESP8266 , getting ntp local time. Mandatory : smooth led transitions (fading chase sequantial for seconds) Hour shift between minutes aurora / breathing effects on 12 and 24 clock time Day/night automatic (based on hour time) brighness dimmer level any other improvment will be evaluate.

I need an Excel macro expert who can help automate the report generation process in Excel.

I need an Excel macro expert who can help automate the report generation process in Excel.

...experience with Zapier integrations - Proficiency in working with fuel management systems - Strong analytical skills for interpreting fuel purchase data - Familiarity with CRM software, Email marketing tools and E-commerce platforms will be an advantage. Project Outline We utilise a Fluid Management System form a company call FMT, there is an existing API and documentation available and we have used this API with a previous system, but there is no existing integration in Zapier currently. Probably need to use webhooks etc. We need to: 1] Updated from a MS excel CSV file Vehicle data using the API 2] Updated from a MS excel CSV file Plant data using the API These files will be generated by an internal system and loaded to a specific location either on...

...create a complex Excel formula for me. I currently have a formula that takes several variables to calculate rates and taxes from a net value to derive a gross value. What I need now is a reverse formula that will take a gross value and return to net value using the same rates and taxes. Key Requirements: - The formula must be able to handle multiple tax rates and deductions, as I have several different rates and deductions to factor in. - The types of taxes and rates that will be part of the formula are mainly Brazilian taxes, so familiarity with these rates would be an advantage. Ideal Skills: - Advanced Excel skills, with experience in creating complex formulas. - Understanding of various tax rates and deductions, particularly Brazil...

I'm seeking a skilled developer capable of creating a unique Fibonacci TradingView indicator tailored for cryptocurrencies. Key Features: - Automatic Fibonacci retracement and extension levels: The tool should automatically identify and display these critical levels, saving me time and enhancing my trading accuracy. - Customizable Fibonacci levels: It should allow me to modify the Fibonacci levels according to my personal trading strategy. - Visualization: The Fibonacci levels must be represented as colored regions/ lines on the chart. This project should be well-versed in TradingView's Pine Script language and have a deep understanding of Fibonacci levels and their application in cryptocurrency trading. Experience with developing TradingView indicators is a significan...

...as the founder. About You I’m not looking for beginners, mid-level engineers, or agencies. I need an experienced solo developer who can confidently manage a fast-growing and technically complex platform without external support. If you don’t meet the qualifications listed below, please don’t apply, as I will only be considering candidates with the required expertise. What You’ll Work With To excel in this role, you need strong experience with the following technologies: Flutter Node.js/Express Azure (App Service, CDN, Front Door) Firebase Backblaze MongoDB Postman Nodemailer Handlebars Resend Intercom Slack Non-Negotiables To succeed in this role, you must meet the following criteria: Availability: Be online and available from 1:00 PM Australian East...

Employee Uniform Ordering System Objective: Create a system for employees to order uniforms and an admin dashboard for managing orders. Deliverables: 1. Order Form (Google Forms/Excel) with dropdowns for uniforms and sizes. 2. Admin Dashboard (Google Sheets/Excel) with order summaries and charts. 3. Aushang Design with QR code Skills Required: • Google Forms/Sheets or Excel with VBA • Data Visualization • UI/UX Design • Graphic Design

... Currently, we're using Google Sheets and Excel for our daily ledger, credit-debit journal, and voucher entries, but it's not meeting our needs. Key Requirements: - User Interface: The interface should be customizable with themes. It should allow us to switch between different looks and feels based on our preference or requirement. - User Authentication: The system should support a simple username and password authentication. - Features: The platform should have the following features: - Automated Reports: The system should be capable of generating reports automatically based on the data inputted. - Multi-User Access: It should allow several users to access and input data concurrently. - Data Export Options: We should be able to export dat...

...accounts for seamless access. 2. Payment Integration: Automatic Deposit: Crypto (USDT) Manual Withdrawal: A manual withdrawal option. 3. Referral program. 4. Investment Feature: - Users can invest in an offer that lasts for 24 hours. - After the 24-hour period, users will receive their invested amount back with a profit. 5. Game: - Connect the Casino table game, so that users can play the game using their main balance on this platform. Admin Dashboard: - A simple admin dashboard with options to manage users, monitor transactions, handle withdrawals, and few others. Requirements: - Experience in Casino game development. - Proven experience in web development with payment integration. - Familiarity with security protocols to handle user data and financial transactions. -...

I need an MS Office expert who can help me craft a detailed research report. The report will be prepared using Microsoft Word, Excel, and PowerPoint. Key Responsibilities: - Collect and organize information I provide. - Gather and analyse additional relevant data. - Create a comprehensive research report. - Design and incorporate engaging PowerPoint slides. - Generate and include relevant charts (Bar, Pie, Line) in Excel. Ideal Skills: - Proficiency in Microsoft Word, Excel, PowerPoint. - Strong analytical skills to gather and interpret data. - Excellent report writing skills. - Ability to create visually appealing presentations. - Experience in creating research reports. Please provide samples of previous reports you have created, preferably research ...

...Power BI engineer to create interactive and insightful data visualizations and dashboards. Key Requirements: - Experience with Power BI - Proficiency in data visualization - Ability to create user-friendly dashboards Data Sources: - The data will primarily come from Excel files, Jira, and Salesforce, along with some miscellaneous sources. Therefore, experience integrating these data sources with Power BI would be beneficial. Data Updates: - The dashboards will need to reflect daily updates. Previous experience handling regular data refreshes in Power BI is preferred. Skills & Experience: - Expertise in Power BI is essential, with a strong focus on creating data visualizations and dashboards. - Prior experience in...

The project involves generating power plant which includes 8, 5kV generators, 5kV switchgear, step-up and step down transformers 2.5MVA, 4.16/25kV and transmission lines. The project also involves another distribution substation and distribution transformers and switchgear in addition to automatic voltage regulators. I'm looking for someone to provide an estimation for the above work including labor and materials. The project will be in the Canadian Northern Territories. Therefore, Canadian experience will be required. The estimates must comply with CSA and IEEE standards. Ideal candidates should have extensive experience in cost estimation for medium voltage substations and a deep understanding of these standards. Please provide examples of previous similar projects you...

I'm looking for a professional...Areas of Focus: - Enhance loading speed - Optimize database queries - Improve user interface responsiveness - Create a new, modern dashboard - Implement multilingual support based on the client's country IP - Redesign the automatic email sending system Ideal Skills: - Extensive experience with React.js, Node.js, and MongoDB - Previous work on site migration from PHP and Laravel - Strong understanding of performance improvement techniques - Skills in creating modern, user-friendly dashboards - Experience with implementing multilingual support - Proficiency in designing automatic email systems Your expertise in these areas will greatly help in revamping existing features, updating crucial functionalities, and ensuring a smooth transi...

We are looking for a dedicated freelancer to help us expand our sales on Etsy in international markets, including Italy, Germany, the UK, and Canada. This is a revenue-sharing opportunity where you can earn 30% commission per sale, with an average payout of $50 or more per sale. What We Offer: No investment required – We cover all expenses, including inventory, IP setup, and listing costs. Earn a consistent commission – You’ll earn 30% of the revenue from every sale. Work with a team experienced in selling digital software and physical products in global markets. What You’ll Do: Collaborate with us to list and manage products on Etsy. Help target specific international audiences (training will be provided if needed). Ensure the growth of sales through basic marke...

I'm in need of an office support staff member to help with both administrative tasks and customer service. Administrative duties include: - Data entry - Sending faxes - Uploading received faxes - Sending invoices - Managing insurance claims Customer service tasks primarily involve: - Answering phone calls - Notifying customers about outstanding invoices -Helping new patients schedule a consultation Ideal candidates should have strong data entry skills, experience in handling customer service, and be able to manage administrative tasks efficiently. Good communication skills and a customer-oriented mindset are essential.

...interactive shopping cart. Offer personalized recommendations based on user and environmental conditions. Support multiple payment methods for completing purchases. 1.2 System Objectives Deliver a fast, personalized, and innovative shopping experience with seamless voice or manual interaction. Reduce operational costs and maximize efficiency in small spaces. Ensure continuous offline operation with automatic synchronization when online. 1.3 Special Features Outdoor Operation: Built for external environments, resistant to external noise, weather, and vandalism. Hybrid Interaction: Switch between voice and touch interaction. Voice-Controlled Shopping Cart: Customers can manage their cart (add, remove, or check products) using voice commands. 2. Hardware Requirements Main Unit: Proc...

...my small engineering firm. The tasks will include: - Scheduling and Calendar Management: You will be responsible for managing my calendar, scheduling meetings and coordinating with relevant stakeholders. - Email Management and Correspondence: You will handle my inbox, filtering emails, responding to common queries and drafting correspondence. - Data Entry and Document Preparation: You will assist with the preparation of documents and data entry tasks. - Client Follow-Up: You will be responsible for following up with clients about project updates and feedback. - Meeting Minutes: You will take detailed notes during meetings and distribute the minutes to all relevant parties. - File Management: You will organize and manage digital and physical files, ensuring...

...timelines. Add KPI tracking with dashboards, target-setting, and visual progress monitoring. Create custom reporting templates with data visualization tools (e.g., charts, trends). Enable task and milestone tracking with automated notifications for deadlines and status updates. Role-based user access for admins, researchers, M&E, and project management staff with multi-level permissions. 2. System Integration: Configure bulk data imports (Excel/CSV). Set up APIs or connectors for integration with tools like KoboToolbox or Google Sheets. 3. Data Quality Checks: Automate validation rules to ensure data consistency and accuracy. Add audit trails for tracking data changes. 4. UI Enhancements: Simplify the interface for non-tech...