Excel automatic data entry formulaงาน

I have a project that involves organizing customer data. The raw data is currently in PDF documents, and I need it transformed into well-structured Excel spreadsheets. Ideal Skills and Experience: - Proficient in data entry and management - Experienced in working with PDF documents and Excel - Detail-oriented with a focus on accuracy - Capable of delivering organized and actionable insights from raw data

I'm experiencing issues with my Excel budget sheet. The logical and conditional formulas are returning incorrect results. I need a freelancer to troubleshoot and fix these formulas. Ideal skills and experience for the job: - Expertise in Excel, particularly with logical and conditional formulas. - Strong problem-solving skills to identify and rectify the issues. - Attention to detail to ensure all parts of the budget are accurately calculated. - Experience with troubleshooting Excel formulas.

I have a PDF showing a bank account transaction history, but I need it to be put in excel format. The data is organized into multiple tables or sections. I need all columns from the PDF to be included in the Excel file, with an additional column showing the resulting balance after every transaction. Here is a screenshot of the first of 37 pages of data. So I know you read my brief, and are not automating a bid, please write UNDERSTOOD at the top of your bid. Thanks

...user experience. Login & Registration Validation: Implement mobile login with OTP and email confirmation. Streamline the registration process for a smoother user experience. Admin Invoice Correction: Resolve gaps in invoice details. Make the delivery address mandatory during order placement. Order Fulfillment Text: Change "Order Fulfill" text to "Dispatched" in the admin panel. Order Download Excel Sheet: Add fields like SKU, product name, contact details, coupon codes, and shipping address. Display transaction ID from the payment gateway in invoices. Order History: Enable date-wise order history in both admin and user panels. Email/Text Notifications: Set up email SMTP and text notifications for order updates. Review Module: Validate reviews to be ...

I'm seeking a skilled Android developer with Kotlin and Firebase expertise to create a robust referral system for my app. Key Features: - A unique referral link for each user - Automatic ad-free rewards after 3 successful referrals (7 days per 3 referrals) - Real-time data storage in Firebase - The same user can refer to more than 3 people and he will get ad free days accordingly. - An in-app notification box displaying the number of successful referrals and the remaining ad-free period - Updating the in app notification box - Push notifications alerting users of their earned ad-free days Ideal Skills and Experience: - Proficient in Android app development - Extensive experience with Firebase services (Realtime Database, Firestore, Authentication) - Prior experience ...

I am seeking a skilled B2B cold caller, fluent in English, focused on lead generation for my solar engineering services targeting commercial businesses. Key Responsibilities: - Cold calling potential commercial clients to generate leads for solar engineering solutions. - Pitching our services in a clear, persuasive manner to secure interest. - Documenting responses and ...interest. - Documenting responses and potential leads for follow-up. Ideal Skills and Experience: - Proven experience in B2B cold calling - Exceptional English speaking and listening skills. - Strong persuasive communication skills. - Experience in lead generation. - Ability to document and track leads. Your goal is to connect our innovative solar engineering solutions with businesses, & we have a automatic ...

hola, tengo un excel con dos hojas, una para generar datos de partidos con informacion como la fecha, la categoria, equipo local y visitante, fecha, etc. Tambien tengo la lista de jugadores de ambos equipos y una seria de acciones que se realizan durante el juego. tambien tengo un campo simplificado para posicionar dichas acciones y el tiempo en que estan ocurre. Me gustaria transferir esas acciones de manera automatica a la hoja donde guardo los datos para su posterior analisis. hay que formatear para que sea claro las opciones que se eligen y transferirlas a la hoja de datos. Cada evento, como un gol, una posesion o un cambio de los jugadores que juegan debe ser transferido en lineas sucesivas en la hoja de datos con toda la informacion, para despues poder analizarla. adjunto imag...

I'm looking for an expert to help me create a small ERP system using CASPIO. The goal is to streamline our operations currently managed via Excel. Key Responsibilities: - Uploading Purchase Orders (POs) - Creating Record Sheets - Generating Job Cards - Compiling a List of Orders - Maintaining Inventory - Updating Job Statuses - Scheduling Tasks The highest priority for this ERP system is maintaining our inventory. I require this system to have a scheduling module with the following functionalities: - Automated reminders - A calendar view - Drag-and-drop scheduling capabilities Access Control: The system should have two levels of access - Admin and user roles. Ideal Skills: - Expertise in CASPIO - Experience in creating ERP systems - Proficiency in managing inventory syste...

...*This role is not open for applicants from Pakistan, Nigeria, Nepal, or Bangladesh. *Our target market includes North America, Europe, the Philippines, and the Middle East. *Proficiency in spreadsheets is essential for lead tracking and updates. *This is a full-time, long-term role (6+ months) with monthly enrollment targets. If you’re ready to make a lasting impact in the lives of learners and excel in a dynamic sales role, apply now!...

With over six years in customer support and cold calling, I have expertise across various industries. I excel in managing customer interactions through multiple channels, ensuring prompt and effective communication. My skills in resolving issues, enhancing customer satisfaction, and driving sales through cold calling and lead generation are well-honed. Whether you need a skilled virtual assistant or a lead generation specialist to achieve your sales goals, I’m here to deliver outstanding service and results. Let’s work together to elevate your customer experience and drive business growth. Core Skills: I possess a strong command of my core skills, and I am confident in my ability to deliver exceptional service in these: ● Customer Support Specialist & Service Repres...

I'm in need of an Excel expert to design an inventory management sheet tailored for tracking raw materials. Key features I require include: - Automatic stock updates: The sheet should have a system in place for real-time stock level updates. - Low stock alerts: A mechanism to notify when stock levels are running low. - Supplier information tracking: Space and functionality to keep track of supplier details for each raw material. Ideal candidates for this project should have extensive experience in Excel, particularly in creating inventory management tools. Familiarity with features such as conditional formatting for alerts, data validation for supplier information, and formulae for automatic stock updates is essential. Ultimately, I need a user-fr...

I'm seeking a proficient data analyst and dashboard developer to create a comprehensive dashboard using both Tableau and Excel. This dashboard will be integral for data visualization, data analysis, and reporting. Key Responsibilities: - Construct a dual-platform (Tableau and Excel) dashboard that allows for seamless data visualization, in-depth data analysis, and comprehensive reporting. - Ensure the dashboard is intuitive and user-friendly, catering to both technical and non-technical stakeholders. Data Sources: - The dashboard will primarily connect to a Database and various CSV files. Therefore, experience in managing and visualizing data from these sources is crucial. Ideal Skills: - Proficiency in Tableau and E...

I need a freelancer to assist with compiling a Bank Reconciliation Statement (BRS) for the past 8 months. Key Data to be Included: - Transactions history - Deposit summaries - Outstanding checks -Bank book & Cash book will be provided by me. - Freelancer has to make a Reco month-wise for all difference . Purpose of the BRS: - It will primarily be used for internal record keeping. Format: - There is no specific format or template required, so a standard Excel format will suffice. Ideal Skills and Experience: - Proficiency in Excel is a must. - Previous experience with preparing Bank Reconciliation Statements is highly preferred. - Attention to detail and accuracy is crucial.

I am seeking a skilled B2B cold caller, fluent in English, focused on lead generation for my solar engineering services targeting commercial businesses. Key Responsibilities: - Cold calling potential commercial clients to generate leads for solar engineering solutions. - Pitching our services in a clear, persuasive manner to secure interest. - Documenting responses and...interest. - Documenting responses and potential leads for follow-up. Ideal Skills and Experience: - Proven experience in B2B cold calling - Exceptional English speaking and listening skills. - Strong persuasive communication skills. - Experience in lead generation. - Ability to document and track leads. Your goal is to connect our innovative solar engineering solutions with businesses, & we have a automatic ...

I have a project that involves organizing customer data. The raw data is currently in PDF documents, and I need it transformed into well-structured Excel spreadsheets. Ideal Skills and Experience: - Proficient in data entry and management - Experienced in working with PDF documents and Excel - Detail-oriented with a focus on accuracy - Capable of delivering organized and actionable insights from raw data

I'm looking to create a PC-based, turn-based strategy game that mirrors "Rule the Waves 3", but with a focus on ground armies instead of navies. The visual style should be akin to an Excel spreadsheet, which will require a developer who's comfortable working with minimalistic, grid-based graphics. Key requirements: - Expertise in PC game development, particularly with turn-based strategy games - Strong understanding of tactical simulation mechanics - Ability to create a compelling, yet simple, Excel-like visual style - Experience with developing strategy games focused on ground armies This project is ideal for a freelancer with a passion for strategy games and a knack for innovative game design. If you have the skills and experience for this project, I&...

...an Epson TM-T82 (3-inch roll) thermal printer. This project is very simple, focusing on core billing functionalities with minimal complexity. Technology Stack Backend: .NET Framework (Windows Forms Application). Frontend: Windows Forms (UI). Database: SQL Server or SQLite (lightweight for local storage). Features Add Invoice Items: Enter MRP, discounted price, and quantity for each product. Automatic Calculations: Calculate total payable amount and savings for the customer. Optional Customer Mobile Number: Enter the mobile number only at the final stage (optional). Edit Invoice: Edit or remove items before finalizing. Finalize Invoice: Generate the final invoice with customer details. Print Invoice: Send the invoice details to an Epson TM-T82 thermal printer. Database Design Ta...

I have 121 lines of information that need to be sorted into an Excel document with 6 specific columns: name, street address, city, state, zip, and country. The data is not organized at all, so it will require thorough sorting and careful attention to detail. Key Requirements: - Proficient in Excel with experience in data management - Strong attention to detail to ensure accurate sorting - Ability to handle unorganized data effectively Special Instructions: - Incomplete or missing information should be left blank

Recreate pages 3,6,7,8,9,10,11,12,16,18,20,21,33,34,35,36 33,34,35,36 should be in excel

I'm in need of a detail-oriented freelancer to assist with a data entry project. The task involves sourcing text data from online databases and inputting it into an Excel sheet. Key Requirements: - Exceptional attention to detail to ensure accurate data entry - Proficiency in using online databases - Strong skills in Excel, including knowledge of basic functions and formulas - Ability to work independently and meet deadlines Ideal Candidates: - Previous experience in data entry is preferred - Familiarity with online databases is a plus - Excellent command over English for accurate text data interpretation

I need a proficient biostatistician to analyze my Excel spreadsheet. The results will be used for a research publication, so accuracy and clarity are paramount. You'll mainly be using descriptive statistics to interpret the data. Key Tasks: - Conduct biostatistical analysis using descriptive statistics, students T test to show significance etc - Present results in clear, organized tables Ideal Skills: - Proficiency in biostatistics - Expertise in Excel - Experience in preparing data for research publications Please note, the final output should consist of tables only. Graphs and summarized text reports are not required.

...candidate who can provide valuable insights and guidance in navigating the complex regulatory landscape associated with international business operations. The ideal candidate will play a pivotal role in helping us optimize our logistics processes, ensuring that our supply chain is efficient and cost-effective. You will be responsible for developing and implementing innovative strategies for market entry and growth, allowing us to capitalize on new opportunities in diverse regions around the world. Your expertise will not only drive our international initiatives but also enhance our overall business performance. Your insights will be crucial in enhancing our global presence and ensuring compliance with a myriad of international trade regulations and standards. A strong understan...

As per explanation in messages

I'm seeking a seasoned professional in Microsoft Access to help with the creation of data entry, search and navigation forms, as well as summary, detailed and dashboard reports. Key Responsibilities: - Design and implement user-friendly data entry, search and navigation forms. - Create comprehensive summary reports, intricate detailed reports, and interactive dashboards. Ideal Skills: - Proficiency in Microsoft Access with a focus on form and report creation. - Experience in designing user-friendly and efficient database interfaces. - Expertise in constructing intricate and insightful reports. Your work will greatly enhance the usability of our database and the clarity of our reports. Please attach samples of your previous Microsoft Access work in your...

This is a Sample Project to help you understand the concept of the work. • You are required to type the exact text from the left box to the blank box at the right. • The size of the text should be 8-10 and theme should be ‘Arial’ or ‘Times New Roman’. • The accuracy level to be maintained is >90%. Payment per page depe...be ‘Arial’ or ‘Times New Roman’. • The accuracy level to be maintained is >90%. Payment per page depends on the plan chosen. • The main project would contain further information regarding submission of assignment. number). These three fields are the only information that I need - please ignore the rest of the text other than the state name, id number, and job title. There are about 1,500 rows o...

I need a well-structured Excel spreadsheet to monitor employee details and calculate their compensation. Key Features: - Tracking Information: The spreadsheet should keep a record of each employee's name, Department, hours worked per day of the week, and their individual hourly rate. - Compensation Calculations: It should automatically compute the total compensation based on the hours worked and the hourly rate. - Bonus Calculations: The spreadsheet should also include a section to calculate bonuses for each employee. Ideal Skills: - Proficiency in Excel, including the use of complex formulas and functions. - Experience in creating employee tracking and compensation spreadsheets. - Understanding of payroll, bonuses, and general HR practices. This tool will assist m...

I'm seeking a dedicated data entry professional for my company. The job primarily involves typing and handling data entry tasks that I will provide. It's a straightforward task, and the ideal candidate will be working for 8 to 10 hours daily, with a weekly compensation of $50. Key Responsibilities: - Daily data entries based on tasks provided - Handling data from plain text files - Extracting and organizing inventory lists Requirements: - Experience with data entry - Proficient in typing and handling plain text files - Capable of extracting and organizing data efficiently I'm looking for a reliable individual who can commit to this role.

I'm looking for a professional who can create an organized and comprehensive Excel contact list for my business. Key Requirements: - Include contacts from various categories: clients, suppliers, and subcontractors. - Collect and input specific information for each contact: their names and addresses, phone numbers and emails, as well as their company details and roles. Ideal Skills and Experience: - Proficient in Excel, with experience in creating structured spreadsheets. - Excellent research skills to gather necessary information. - Previous experience in creating business contact lists is a plus.

I'm looking for an Excel expert to create a database specifically tailored for my sales reporting needs. Key Requirements: - The database should primarily serve the purpose of reporting. - It will be focused on sales data specifically. Ideal Skills: - Advanced Excel skills. - Good understanding of sales metrics. - Experience in creating databases for reporting purposes.

As discussed, ongoing shopify work to get the site up and running. Product pages created, categories being added etc.

My Python3 code for Excel on Mac is experiencing issues that need to be addressed. The main problem lies in the calculations, particularly with logical comparisons. Ideal skills and experience for the job: - Proficient in Python3, with a focus on data analysis and Excel integration - Experience troubleshooting and debugging code - Familiarity with Mac's version of Excel - Able to understand and rectify logical comparison errors - Attention to detail to ensure all equality checks function correctly

I'm in need of a proficient data entry expert to assist with handling information from Excel sheets and CSV files. The work primarily involves data entry and updating records. Ideal skills and experience for the job include: - Proficiency in Excel and familiar with CSV files - Attention to detail to ensure data is entered accurately - Experience with data entry and record updating - Ability to work independently and meet deadlines

I'm working on an economic development project and I need someone skilled in Excel and writing to assist me. The primary focus of the project is financial forecasting. Many different financial data points will need to be forecasted, including revenues, expenses, and cash flows. Your tasks will include: - Using Excel to analyze and forecast various financial data - Writing clear and concise documentation of the financial forecasts for the project - Assisting with the preparation of the documentation for the financial forecasts - Helping to prepare the final presentation of the financial forecasts for the project Skills and experience ideal for this job: - Proficiency in Excel, with experience in financial forecasting - Strong writing skills, with t...

...double-check system to confirm package assignments to trucks before loading. 4. **Software Development**: Develop a user-friendly software platform to manage, track, and analyze package data. ### Target Market - **Internal Stakeholders**: Package delivery company management and operations team. - **External Stakeholders**: Customers relying on timely and accurate package delivery. ### Solution Overview 1. **RFID Label Activation**: - Attach unique RFID labels to each package containing tracking information (e.g., destination, contents). - RFID labels will be activated at the point of package entry into the system. 2. **Transponder System**: - Install transponders on delivery bins and trucks to create a network for real-time tracking. - Each tru...

...Consultancy services based in New Zealand. The ideal candidate should possess a strong background in office management or a similar role, demonstrating proven expertise in providing administrative support, data entry, and document preparation. This position requires a high level of precision and the ability to handle confidential information with utmost discretion. Responsibilities - Keeping track of important paperwork and ensuring everything is organized and up to date. - Aiding in the drafting and writing of various proposals, letters, paperwork and other information. - Perform data entry tasks with a high level of accuracy. - Managing and prepping draft emails. - Provide other support to the team as needed. Skills Required - Proficiency with Microsoft...

I'm looking for a skilled software developer to create a desktop application for Windows that automates restaurant orders. This system should be able to take orders through WhatsApp and automatically post them to the Point of Sale (POS) system. person with creating BOT for desktop and Whatsapp Key functionalities include: - Order taking through WhatsApp - Automatic posting of orders to POS The ideal candidate for this project should have: - Proven experience in developing Windows desktop applications - Knowledge of Point of Sale (POS) systems integration - Previous work with order management systems is a plus - Excellent problem-solving skills and attention to detail

I'm looking to create a professional, clinical-style website for booking doctor appointments. Key Features: - Doctor profiles and specialties: The site should have a comprehensive list of doctors, their profiles and specialties to help patients choose the right doctor. - Patie...professional and clinical design to reflect the nature of the service. Ideal Skills: - Web development with a focus on creating professional, clinical-style websites. - Experience with implementing doctor profiles and patient review systems. - Strong understanding of user-friendly, modern web design principles. I do not need any special features for the appointment booking system, such as automatic reminders or online payment integration. The focus should be on functionality, ease of use and a pro...

I need a basic inventory manager but I need a function more. Basically I sell my items and several items from other sellers, and I need to check every day if some piece is sold. For exemple I have a supplier that has its item published on ebay, another on its own webpage, so I check every day, searching some keywords with a python script made my self, if there is something sold. On the o...copy/paste the urls of the item from one specific supplier. I need a daily check availability report to unlist items not available from our main marketplace a function to download the whoole inventory in csv would be very appreciated. last but important we need fields for searches and filters, for example seeing only the products from one specific supplier of course we will need a section for data...

I have an Excel file that requires some urgent corrections, specifically related to fixing errors in the formulas. The primary focus is on logical conditions, particularly with the Data Validation function. The ideal freelancer for this project should have: - Extensive experience with Excel and its formulae - Specific expertise in troubleshooting and rectifying issues with logical conditions - A keen eye for detail to ensure all errors are identified and corrected Please bid if you are confident in your ability to rectify these issues swiftly and accurately.

I'm seeking a data extraction expert to help me gather real estate listings from OLX for four cities in the State of Pará, Brazil. These cities are Belém, Altamira, Marabá, and Castanhal. The data should pertain to residential properties and land. Ideal Skills: - Data mining and web scraping - Proficiency in using OLX and similar platforms - Experience in collecting real estate data Data Requirements: - Residential properties - Land Delivery Format: - The data should be compiled and delivered to me in an Excel spreadsheet. Please ensure that your bid reflects your capability to fulfill these requirements. Thank you!

This is my plugin: Description: This plugin automates the creation of AI-generated German product descriptions and optionally generates English translations using WPML (WordPress Multilingual Plugin). It ensures seamless integration with WPML by initializing after WPML is fully loaded. Workflow Overview 1. Automatic Generation of German Descriptions for New Products 2. Optional Creation of English Translations 1. Automatic Generation of German Descriptions for New Products Purpose: Automatically generates and applies German translations and descriptions when a new WooCommerce product is published. Workflow Steps: 1. Monitor Status Transitions: The plugin listens for changes in the status of WooCommerce products. Specifically, it detects when a product is published ...

I'm in need of a comprehensive spreadsheet that allows me to compare the pricing of trees and shrubs for an upcoming landscape job. The prices should be sourced from both local nurseries and online stores. Key Requirements: - The spreadsheet should include specific details for each plant price entry, namely: - Plant size - Availability - Supplier information - Ideally, you should have experience with data entry and spreadsheet creation. Prior knowledge or experience in landscaping or horticulture would be a plus. - Attention to detail and ability to source information from various suppliers is crucial for this project. The goal is to have a clear and organized comparison of the plant prices to facilitate the budgeting and purchasing process for the land...

I'm in need of a reliable freelancer who can assist me with copy typing from digital text files. The tasks primarily involve routine typing tasks. Ideal Skills: - Proficient in typing - Attention to detail - Ability to meet deadlines - Experience with copy typing from digital text files Experience in data entry and a commitment to delivering accurate and timely results are essential.

...EMAToday​=​(ValueToday​∗(Smoothing/1+Days​))+EMAYesterday​∗(1−(Smoothing/1+Days​))​ - Entry/exit with a limit order at the closing price of the Heikin Ashi candle. Heikin Ashi sail construction : • haClose=(O+H+L+C)/4 • haOpen=(previous haOpen + previous  haClose ) /2 • haHigh =Max (H, haOpen, haClose ) • haLow =Min(L, haOpen, haClose ) - The Martingale method is to multiply the value of losing trades to compensate for the loss X2. First deal: $20 Second deal: $40 Third deal: $80 Fourth deal: $160 Fifth deal: $320 Sixth deal: $640 - Enter into quick boosting deals with large quantities with a limit order for the quantity, to achieve profits instead of the value of previous losing deals and exit quickly. - If the entry pr...

I'm looking for a skilled Excel Add-In developer to create a tool that automates various tasks in Excel. Key Features: - Automation of tasks such as data import/export, report generation, and data validation. Requirements: - The Add-In needs to interact with external databases. Ideal Skills: - Proficiency in Excel Add-In development - Experience with database connections - Strong understanding of task automation within Excel Experience in developing similar tools will be highly regarded. Please include examples of your previous work in your proposal.

I'm in need of a seasoned Kotlin Android developer. The goal is to construct an application that will: - Allow manual data entry from the user - Update existing rows in Google Sheets - Both add and update mixed data (text and numbers) The application should seamlessly integrate with Google Sheets and offer a smooth user experience. Ideal candidates should have: - Extensive experience in Kotlin and Android development - Previous experience with Google Sheets integration - Strong UI/UX skills for a user-friendly application

I'm looking for a professional who can help me calculate trend lines using statistics and math. The input data will be numerical, provided in an Excel spreadsheet, and I'll need a linear trend line calculated. Ideal Skills: - Proficiency in statistics and mathematics - Expertise in Excel and data analysis - Experience in calculating trend lines Please only bid if you can provide high-quality work in a timely manner.

I'm looking for an experienced developer to create a futuristic design style Android app for a Satta Matka website. The app should come equipped with: - An Automatic Add/Withdraw Facility: This feature is crucial as it allows users to seamlessly manage their transactions without any hassle. - User Authentication: A secure login system to ensure user data and transactions are kept safe. - Real-Time Notifications: Users should receive instant updates and alerts, keeping them engaged and informed. The ideal candidate for this project should have: - Proven experience developing Android applications, preferably for gaming or betting platforms. - A portfolio showcasing modern, futuristic design implementations. - Excellent understanding of integrating secure user authentic...

I will complete the redesign of your E-Book with more infographics, as well as add the BIG excel file into the e-book, making sure it looks as visually appealing as possible.

Excel Bookkeeping services for 2023&2024