Excel automatic data entry formulaJobs
I need assistance updating my Excel spreadsheet, primarily focused on creating new mathematical formulas. Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in creating complex mathematical formulas - Good understanding of data analysis techniques Please note that the specific mathematical functions can vary based on the data, so flexibility and adaptability are key. A keen eye for detail and strong problem-solving skills would also be beneficial.
Bonjour Sur la base du relevé des compte, je souhaite éditer un fichier Excel qui met en exergue la tva collectée ainsi que la tva déductible et la différence
...area of my screen and export those numbers to an Excel sheet or a custom interface that conducts basic arithmetic calculations. Key Features: - Mouse Drag-and-Select: The program should allow me to select the screen area from which characters are extracted using a simple drag-and-select method with the mouse. - Dual Export: It must export the extracted symbols automatically to Excel or the custom interface every 2 seconds, as well as on demand via a hotkey. - Basic Math: The custom interface should be able to carry out basic arithmetic operations (addition and subtraction) on the extracted data. Ideal Skills and Experience: - Proficient in Windows application development - Experience with screen capturing software - Familiarity with Excel automation - Unde...
I'm in need of a detail-oriented Data Entry Clerk to assist with the transcription of data from digital documents from Excel. Key Responsibilities: - Accurately inputting both text and numeric data from digital documents from Excel into our platform. - Ensuring data is correctly transcribed and free from errors. Ideal Skills: - Proficient in Excel, with a strong understanding of its functions and features. - Excellent attention to detail, with a high level of accuracy in data entry. - Able to work independently and manage time effectively to meet deadlines. You will need to sign a GDPR document in order to maintain confidentiality.
...website will be multi-lingual i.e 2 languages (you can use the Yii2 module for it) Website requirement/ functionality : 1. Develop an admin panel (for design ,any premade template can be used) for some data entry like : a) Create / Edit / Update (CRUD) operation for website users b) Adding some data against each user eg investment amount, return amount. Sample data set will be provided. c) Contact us page queries data display. 2. Frontend : Design will be provided to you. a) Login / Pass reset / Forgot pass module. b) Contact us page c) Dashboard showing the user data including graph and few filters The website design will be shared in advance for better clarity of project. The website will be responsive as it has to be c...
I have a set of document templates in Word and Excel that need to be updated to align with our new branding. These templates include Data Sheets, Excel proformas, and Business Presentations. Key Requirements: - Expert application of our new brand elements (logo and color scheme, typography and imagery) across all templates. - Strong design skills to enhance the visual appeal while maintaining brand consistency. - Ability to ensure consistency in layout across all templates. Ideal Skills and Experience: - Proficiency in Microsoft Word and Excel. - Advanced design skills with experience in template design. - Strong understanding and application of brand consistency. - Proficiency in design and also Powerpoint
I'm seeking a freelancer for manual data entry from image receipts for my Accounting. Ideal Skills: - Proficiency in data entry - Attention to detail - Familiarity with data is a plus - Ability to work with image formats - Strong organizational skills
...involves analyzing data, structuring information, and creating a visually appealing and easy-to-understand presentation. Responsibilities: 1. Collect and organize testing reports from 5-6 testers. 2. Analyze the results to identify key trends, issues, and insights. 3. Consolidate the findings into a clear and structured final report (PDF format). 4. Create a client-friendly presentation using PowerPoint, Google Slides, Canva or similar tools. 5. Ensure that all critical details are included, and the data is visually appealing and accessible to the client. Requirements: ● Proven experience in report writing and data analysis. ● Strong skills in PowerPoint, Google Slides, Canva or similar presentation tools. ● Attention to detail and ability to work with structured an...
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
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
...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...
