Excel automatic data entry formulaроботи

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

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

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

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

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

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

Busco un profesional con experiencia en VBA para Excel que pueda desarrollar un macro que procese múltiples archivos XML de comprobantes electrónicos de Ecuador (facturas, retenciones, notas de débito y crédito), genere reportes en Excel y convierta los XML a archivos PDF con formato legible. Requerimientos: Soporte para múltiples tipos de comprobantes electrónicos: Facturas. Retenciones. Notas de débito. Notas de crédito. Reportes a generar: Reporte General: Totales y subtotales de cada tipo de comprobante. Reporte Detallado: Listado detallado de los ítems comprados o servicios adquiridos. Conversión a PDF: Convertir los comprobantes electrónicos (XML) a archivos PDF con formato legible. Person...

Segretaria da remoto con le seguenti caratteristiche: - 3 ore al giorno - spirito di gruppo - buona conoscenza di programmi di fatturazione (business in cloud) - solare ed empatica - dinamica e disinvolta - italiana di madrelingua italiana - conoscenze di tabelle excel

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

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

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

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

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

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

Sou dentista e preciso de uma tabela que será apresentada com orçamento para pacientes. Com intuito de padronizar a nomenclatura e agilizar o processo, preciso que o valor apareça de forma automática ao preencher o procedimento. Essa tabela precisa ter um bom design e possuir um tamanho imprimível. Podendo ser usada o moledo abaixo

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I need a skilled Python programmer to help me automate the order placement on Interactive Brokers. Key Re...- 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 if you can provide result with my budget, Not your Expectation Budget:Rs 1050 I will give good review, if you complete my budget, Dont expect more money If you have experiece in trade a...

Attached file that need updating, this sheet will be used on a monthly basis to value works completed and invoiced, the user is not very good with spreadsheets and is unable to track changes etc. What I am looking for is an easy way in which each time they open the sheet they can simply enter the percent complete in column D and columns E,F and G are updated accordingly. Need some wise logic to track rolling-over of valuations with the additions of newer percentages. Also need a provision to save the file as PDF.

i am having an excel script which is used to send whatsapp messages , some bug is there through which its not letting through properly , full message is not going NEED AN EXPERT ONLY , lets not waste anyone's time please ***urgent Language : VISUAL BASIC in EXCEL

I'm seeking a skilled data analyst who can help with comparing Excel sheets, data cleansing, and performing descriptive statistical analysis on the data. Key tasks: - Identify differences between multiple Excel sheets - Cleanse and standardize data - this includes removing duplicates, handling missing values, and standardizing formats - Conduct descriptive statistics to provide insights from the data Ideal skills and experience: - Proficient in Excel with strong attention to detail - Experienced in data cleansing and comparison - Skilled in performing and interpreting descriptive statistics - Able to deliver clear and concise reports of findings

I'm seeking a detail-oriented and efficient freelancer to assist with data entry from my expense receipts. The task primarily involves transcribing summary totals from printed receipts into a spreadsheet. Ideal skills for this job include: - Attention to detail - Proficiency in spreadsheet software - Experience in data entry tasks - Ability to transcribe printed text accurately

...Assistant to primarily manage Administrative Tasks, with a focus on email handling and account creation. This long-term project offers room for advancement. Key Responsibilities: - Account Management: Create, update, and maintain various accounts. - Customer Support: Handle email inquiries professionally and promptly. - Administrative Tasks: Organize emails, schedule appointments, and perform data entry efficiently. - Team Collaboration: Work alongside our team to ensure seamless operations. Ideal Skills and Experience: - Previous experience as a Virtual Assistant or in a similar role is essential. - Exceptional English communication skills, both written and verbal. - Strong organizational skills with the ability to multitask effectively. - Proficiency in Gmail and Outlo...

I'm looking for a skilled developer who can implement an automatic bidding feature for the Carrots marketplace app. Key Features: - Bid Increment Management: The system should intelligently handle bid increments based on the auction's current state, ensuring competitive yet cost-effective bidding. - Bid Time Scheduling: The feature should allow bids to be placed at predetermined times during the auction. Trigger Mechanism: - Time-based Trigger: The automatic bids should be initiated based on specific time intervals rather than being tied to price points or manual input. - Automatic bidding is placed when there is new bid according to their keyword searches Ideal Skills: - Proficiency

Work to be done: entry level Content creation on a vendor and product level. 1) 18 vendors (unique email) across 5 provinces (to be given) 2) 20 product listing per vendors (title, short description, pricing, 2 images per listing) Then feedback on the vendor registration and product loading process.