Excel automatic data entry formula Jobs
El proyecto "Servicios Personalizados en Excel" consiste en ofrecer trabajos a medida en Microsoft Excel, donde el cliente especifica sus requerimientos y yo me encargo de realizar el trabajo correspondiente. Este enfoque garantiza que cada proyecto se adapte a las necesidades unicas de cada cliente, asegurando satisfacion y resultados optimos. Objetivos del Proyecto: 1. Atención Personalizada: Escuchar y comprender las necesidades del cliente para diseñar soluciones efectivas. 2. Ejecución Rápida y Eficiente: Realizar los trabajos solicitados en un tiempo razonable, manteniendo altos estándares de calidad. 3. Diversidad de Servicios: Ofrecer una variedad de servicios que incluyen automatización de procesos, análisis...
I'm in need of a comprehensive spreadsheet to track various employee absences. The types of absences I want to monitor include sick leave, call-o...spreadsheet should capture the date and time, the reason for the absence, whether the employee gave late notice or not, and the number of "attendance points". - Identification: Employees should be identifiable by their full name. Here are some links to tutorial for similar trackers: Ideal Skills: - Proficiency in Excel or Google Sheets. - Experience in creating tracking spreadsheets. - Understanding of HR metrics would be a plus. Please ensure that the spreadsheet is user-friendly and can be easily updated on a regular basis. Looking forward to your bids.
I have two Excel files detailing my wine collection - one is from 2023 and the other is an update. I'm looking for someone to identify the differences between the two files. Specifically, I need to see: - Changes in item quantities - Any addition or deletion of items After the comparison, I would like the results to be compiled into a summary report. Additionally, if possible, a visual chart illustrating the differences would be appreciated. Ideal candidates should have extensive experience with Excel and data analysis. Familiarity with inventory management and wine collections would be a plus.
...for a skilled Django Python developer to integrate the WhatsApp API into a customer support system. This system will manage customer queries with preset responses based on the type of user inquiries. Key Features: - Handle diverse queries: The system should be capable of addressing services inquiries, technical support questions, and general information requests pertaining to the service - Automatic Query Categorization: I require the system to automatically categorize incoming queries for efficient response managemen and generate relevant response. - Multi-Platform Synchronization: Besides WhatsApp, the system responses should be synchronized with Email, SMS, and Web chat. Ideal Skills: - Proficiency in Django and Python - Experience with WhatsApp API integration - Knowledge ...
I'm seeking an virtual assistant from the United States or Canada. It will generate a great revenue over time for long term period.
I require an excel sheet that tracks and analyzes the changes in open interest data of the NIFTY index. This sheet should be able to provide insights into market sentiment based on this data. Key Requirements: - The excel sheet should continuously update the data every minute. - The sheet should be able to provide a text summary of inferences about market sentiment from the open interest data. Ideal Skills: - Proficiency in Excel with experience in financial data analysis. - Understanding of open interest and its implications on market sentiment. - Ability to create an automated Excel sheet that updates data every minute. Please note that I'm looking for a freelancer who can deliver a high-quality, reliable tool...
I'm seeking a professional and formal branding package for my independent training company, Rethink Abuse, which focuses on domestic abuse and stalking training, consultancy and support service. I’m happy to just receive a logo for competition entry, but I would need the winner, to complete the package with the logo on the items listed below please. The branding will include: - A logo that incorporates the company name, a symbol or icon, and our tagline which is Training, Consultancy & Support - A banner - Business card - Headed paper - Certificate designs - Instagram highlights Ideal candidates will have experience in branding design. An understanding of creating professional, high end and formal aesthetics would be great. The logo also needs to be warm, welcomin...
I need a excel sheet (some columns protected), as soon as date are entered in Sheet 1 on a specific column the entire row needs to more to tab2, same at tab 2 as soon as date entered the row needs to move automatically to tab 3, same to tab 4, 5, 6. (All the rows are protected, can not be deleted, they will only move between tabs as the project runs) - Production Job Tracking report I would like to do the project together with the freelancer on teams (within the next hour is possible) I assume the project will take maximum an hour
I'm looking for an Excel developer to create an inventory management system. While specifics on the functions of the system haven't been detailed yet, the system will need to track stock levels and generate reports. As such, the ideal freelancer for this project should have prior experience in developing similar systems on Excel. Skills and experience required: - Advanced knowledge of Excel - Prior experience in developing inventory management systems - Ability to generate and interpret detailed reports - Excellent understanding of tracking stock levels
New freelancers at low budget. I'm looking for female marketers, writers, and data entry operators from Malaysia and Singapore. Ideal Skills: - Marketing: Ability to strategize and implement effective marketing campaigns - Writing: Excellent command over English with creative writing abilities - Data Entry: Proficient in handling data with attention to detail We need New Freealncers at low budget
...part numbers and costs from a supplier's website into an Excel spreadsheet. This spreadsheet contains makes and models for every vehicle listed in the UK. Key Responsibilities: - Accurately input part numbers and costs from a supplier's website into designated columns of an Excel spreadsheet. - Follow specific formatting and column header requirements as detailed below. Specific Columns and Formatting: - The data needs to be entered under specific column headers in a predefined order: makes, models, costs, part numbers. - Conditional formatting or color-coding will need to be applied at times according to supplied guidelines. Ideal Skills: - Familiarity with Excel and its data entry requirements. - Attention to detail to ensure all ...
I need a comprehensive dataset prepared for Tableau that encompasses a variety of data types including sales, customer, and financial information. The data is currently in Excel/CSV format. Key Requirements: - Transform and clean various data types (sales, customer, financial) from Excel/CSV for Tableau - Prepare the dataset to allow for a variety of analyses and insights, including but not limited to sales trends over time, customer demographics, and expense versus revenue tracking. Ideal Skills: - Proficiency in Excel/CSV data handling - Expertise in data preparation for Tableau - Strong analytical skills to understand and anticipate necessary data transformations for desired insights Please note that the final dataset sho...
I'm looking for an Excel expert to design a template for tracking my total monthly/yearly sales. This template should also allow for comparison over time. Key Features: - Total sales tracking - Comprehensive data visualization features: Bar charts, Pie charts, Line graphs - User-friendly manual data input Ideal Skills: - Advanced Excel skills - Experience in data visualization - Knowledge in sales data tracking
‼ READ BEFORE BIDDING ‼ We are looking for a professional video editor for a long-term cooperation to create different videos for our clients. The videos will be used for project descriptions, ads and other purposes. You must possess: • INITIATIVE! Our cooperation needs to be almost automatic – we send you the folder with images, raw videos and the text file and you need to do magic combining everything into a perfect clip. • COMMON SENSE AND LOGIC! You need to understand our customers’ businesses, and the scenario texts well. • TOOLS! AI narrator software like to generate text to audio, mainly Norwegian language. • CREATIVITY! After you assess the files and scenario, you need to PERFECTLY arrange image and video files according to the audio. Wha...
I'm looking for a skilled Android developer to create a call history application in Java. This app should closely resemble the default Android call history interface. Key Features: - A search function to easily find specific calls - Call statistics to provide insight into calling habits - An icon for each call that represents the first letter of the contact's name -Upon clicking one entry, the entry should expand and show more options like add contact, sms, etc as seen with default android call history app project needs to be done in android studio using Java, using latest versions of the tools. need to handover the entire codebase from android studio. The ideal candidate will have: - Extensive experience in Android app development - A strong understanding of An...
I'm seeking an expert to assess our current email-based communications platform and enhance our practices. The main focus will be on improving our email organization and management. Ideal Skills: - Assessment of current structure -Communicating with team to achieve desired goals - Expertise in email systems - Strong organizational ...platform and enhance our practices. The main focus will be on improving our email organization and management. Ideal Skills: - Assessment of current structure -Communicating with team to achieve desired goals - Expertise in email systems - Strong organizational skills - Experience in workplace communications improvement -Integrating multiple data platforms - merging planning center and ClearStream into Squarespace -Designing newsletters/...
...installation and configuration of PostgreSQL on two new servers. The goal is to establish a replication setup where one server acts as the primary (master) and the other as a replica (slave), ensuring automatic synchronization and real-time backup of the primary server’s data. The setup should also allow secure connections to the PostgreSQL database from a third server, which will be used for accessing the database remotely. Key Requirements: PostgreSQL Installation: - Install the latest stable version of PostgreSQL on both servers. - Configure PostgreSQL to run as a service on both servers, ensuring automatic startup on reboot. Master-Replica Configuration: - Set up one server as the primary (master) and the other as the replica (slave). - Configure strea...
...be built on GoHighLevel to leverage its CRM integration, automation tools, and marketing features. Project Scope and Requirements: 1. Lead Forms • Purpose: Capture visitor information and inquiries effectively. • Features: • Embedded lead forms on multiple pages. • Customizable fields (e.g., name, email, phone number, and additional questions). • Integration with GoHighLevel CRM for automatic data collection and follow-ups. • Include a thank-you page or confirmation message after form submission. 2. Calculator • Purpose: Provide users with an interactive tool to calculate [specific use case, e.g., cost estimates, savings, ROI]. • Features: • A responsive, easy-to-use calculator embedded into a dedicated page. •...
I'm seeking a skilled data entry freelancer, specifically for spreadsheet tasks. Your role will involve: - Manipulating and inputting data into spreadsheets. - Ensuring data accuracy and integrity. - Meeting project deadlines. Ideal candidates will have a keen attention to detail, excellent organizational skills, proficiency in spreadsheet software, and a strong commitment to delivering high-quality work.
I'm in need of a reliable freelancer skilled in Excel and SQL database management. Key Responsibilities: - Regular data entry and updating in Excel. - Managing and maintaining a SQL database. Ideal Skills: - Proficiency in Excel for data entry and updating. - Experience with SQL database management. - Attention to detail for accurate data handling.
...for employees and their dependents. The app will have two user roles: employees and employers. Key Features: Employee Login: Enter Employee ID to access the app. Display Details: Show the employee's name and their dependents. Admission Form: Select the person to admit (employee or dependent). Input fields for hospital name and admission date. Submit Button: Sends the data to a backend. Employer Dashboard: Generate an Excel sheet with all admission records....
I'm looking to create a website mimicking certain investment platforms. Key features include: - Investment and Referral: Users can invest money and invite others to earn commissions, level-ups, etc. - Automatic Returns: Funds should automatically accrue interest daily and be added to the user's wallet. - Comprehensive User Dashboard: An advanced dashboard providing detailed analytics on their investments and referrals. Ideal candidates should have prior experience in developing similar platforms and understanding of financial software. Expertise in creating user-friendly, yet sophisticated dashboards is crucial. Please note, this project is seeking to create a legitimate investment platform, not a scam.
...to manually input messages through data entry fields, as well as support uploading PDF files for messages, with automatic organization into local folders. The focus is on ease of use, security, and flexibility in managing data and files. Core Requirements: 1. User Interface: - A simple and user-friendly design utilizing tabs, where each tab represents a specific type of message with dedicated input fields and tables. - Support for searching messages based on entered data (e.g., sender's name, job title, message date, etc.) for easy browsing. - Two separate drag-and-drop windows for adding PDF files ("Incoming" and "Outgoing"), with automatic saving of files to a local folder. 2. Core Features: - Manual message record...
...results through data-driven strategies. Key Responsibilities: • Set up and manage Facebook Ad campaigns, including campaign groups, ad sets, and individual ads. • Collaborate on Google Ads campaigns, refining bidding strategies and audience targeting through regular Zoom sessions. • Optimize ad campaigns to ensure maximum ROI, including A/B testing and data analysis. • Work with contact lists from tools like Seamless to upload Excel files containing 1,000-2,000 targeted contacts into the backend of Facebook Ads Manager and Google Ads for custom audience creation. • Create and manage remarketing campaigns using these custom audiences to deliver video ads tailored specifically to this list. • Provide regular performance analyses an...
I need assistance entering images into a PDF file. The images are digital photos that will require some basic editing (cropping and resizing) before being inserted into the PDF. Ideal freelancer for this project should have: - Experience with PDF software - Proficient in basic image editing - Attention to detail for accurate image placement and editing
Transform Excel Sheet Data to Charts and Stats using Power BI, we need interpretation for each chart.
Hi, as discussed in the chat to follow through the following: - Create a template for daily new fault reporting - Automatic population of the faults upon downloading of new faults and filter only necessary contents (component failure, similar fault trends) - Fault trend analysis through charts/power BI on the most reliable train and high fault component.
I am seeking a highly experienced circuit design engineer with expertise in digital and analog electronics, proficient in using Eagle for PCB design. The ideal candidate will have a strong background in signal conditioning, low-noise circuit design, and power management for compact, low-po...power management for compact, low-power applications. Familiarity with integrating multiple sensors, including PPG, glucose, HRV, and electrolytes, into electronic systems is a significant advantage. The role requires exceptional problem-solving skills, attention to detail, and the ability to deliver efficient, production-ready designs, including schematics, PCB layouts, and prototypes. If you excel in creating innovative circuit solutions and thrive in challenging projects, I would love to hear...
I'm looking for a data management specialist to assist with handling multimedia files, specifically images and videos. The tasks will include: - Data entry and validation: Ensuring the data is accurately inputted and checked for consistency. - Data analysis and reporting: Interpreting the data and creating comprehensive reports. - Database management: Organizing and maintaining the data in a user-friendly manner. The data is currently stored in standard formats: JPEG/PNG for images and MP4 for videos. Prior experience working with multimedia data is a plus. Please include relevant experience in your proposal.
I have a straightforward data entry task for you. The job involves inserting hyperlinks into 13-14 Google Docs pages. I'll provide the links and a tutorial on how to complete the task. Ideal Skills and Experience: - Proficient in Google Docs - Energetic and willing to work on similar small tasks in the long term - Attention to detail - Quick learner Tutorial -
Hi, Statistics is my favorite subject and will be glad to help. I have skills in Data Processing, Statistics, R Programming Language, SPSS, Tableau and Excel. Hire me for your methodology and data analysis chapters for your dissertation.
I need a business card design, the design can be the same or similar but we will need three different files with different names and contact information: *IF YOU DONT INCLUDE OUR LOGO YOUR ENTRY WILL BE REJECTED* Please include our CHAOS logo (attached to brief) Please make color scheme: Red/Silver or Red/Black Slogan: We Cause CHAOS (you can use the logo in place of the text "CHAOS" Please keep the theme Soccer related please add our website: Kyle Lesperance Director of Coaching GISACoachingDirector @ 734 626 0862 Ashlee Lesperance Director of Operations ChaosPDA @ gmail . com 734 301 1721 Ronald Hutchinson Head Coach RHutchinson36 @ 313 574 1321
I'm in need of a freelancer who can assist with bulk PDF data entry. The data could come from any source, including scanned documents, digital text files, or handwritten notes. The PDFs could contain any combination of text, images, tables, and charts. Ideal skills and experience for the job: - Proficiency in Adobe Acrobat - Excellent attention to detail - Ability to work with diverse types of data - Experience with data entry from various sources
I'm a beginner C programmer with a strong interest in system programming. Key Skills: - C programming - Basic understanding of system programming Looking for: - An entry-level developer position that can provide me with the necessary experience to grow and improve my skills.
I'm seeking a proficient Excel Solver expert to help me analyze my inventory data. The tasks involve moving averages, Mean Absolute Deviation (MAD) calculations, and time series forecasting. Key Tasks: - Help with moving average calculations - Calculate MAD - Apply time series analysis for forecasting Ideal skills for this project include: - Advanced Excel skills, especially with Solver - Strong understanding of inventory data analysis - Proficiency in time series forecasting methods
I'm establishing a bookkeeping business specializing in NDI...bookkeeping business specializing in NDIS plans and Aged Care home care packages. I'm seeking a part-time employee, approximately 25 hours weekly. The candidate will be responsible for setting up client accounts in Xero, performing data entry, and preparing monthly and quarterly reports. Key Responsibilities: - Setting up client accounts in Xero - Data entry - Preparing monthly and quarterly reports Reports to be prepared: - Financial statements - Expense summaries Ideal Candidate: - Intermediate-level experience with Xero - Attention to detail for data entry - Ability to prepare comprehensive reports - Understanding of financial statements and expense summaries - Previous e...
...currently using an Excel template to visually represent all our projects in a Gantt chart. I need an expert to enhance this template for me by adding a sales target function. This function should calculate and sum up the revenue for each job based on the percentage of the job completed in each month. - Example: For a $100k job with 75% of the work days in January and 25% in February, the system should automatically allocate $75k to January and $25k to February, and sum up all the jobs for each month. The work days are automatically calculated by the existing template. The only adjustment needed is the division of revenue by month and the presentation of this in total. I have an example of the desired output, just built manually. Ideal skills and experience: - Proficiency in ...
I'm seeking an experienced Android developer to create a native app utilizing the TelephonyManager. This app should be able to show an overlay when an outgoing call is made from the dialer, and subsequently close the overlay when the call is answered on the other end. Key Requirements: - The overlay should auto-play a video when an outgoing call is made. - Th...is answered. - The video should be played without any user interaction. Ideal Skills: - Proficient in Android app development. - Familiar with TelephonyManager and overlay creation. - Experience with video playback within an app. Please note, this project does not require any video calling features or user interaction with the video. The focus is on seamless integration with the dialer and automatic video playback d...
I'm looking for someone who can help me find the email addresses, telephone numbers, and website URLs of 501 businesses based on their name and address. - The final deliverable should be fields completed in Google Sheets. - The accuracy of the data doesn't need to be perfect, but it should be mostly accurate. Ideal skills and experience for the job include: - Proficient in using Google for research - Experienced in data entry - Able to deliver within a set deadline
Project Description: We are seeking a skilled and experienced data analyst to help us process, analyze, and visualize our business data to derive actionable insights. The project involves moderate-level complexity, requiring expertise in data manipulation, statistical analysis, and visualization tools. Key Deliverables: 1. Data Cleaning and Preparation: - Handle missing values, outliers, and inconsistencies in the dataset. - Ensure data integrity and prepare a clean dataset for analysis. 2. Data Analysis: - Perform descriptive and inferential statistical analysis. - Identify trends, patterns, and correlations in the data. - Generate summary reports highlighting key findings. 3. Visualization and Reporting: ...
...requirements: Automatic Price Tracking: The script must save the price history of each product in a database (e.g., Wix Data). Displaying the Lowest Price: If a product is discounted, the lowest price from the last 30 days should appear below the current price. Flexibility: The functionality must work for all products in the store and be easy for the administrator to manage (e.g., no need to manually add code to each product). Compliance with Regulations: It must adhere to the EU Omnibus Directive, including clear messaging for users, such as "Lowest price in the last 30 days: [amount]". Technical Requirements: Proficiency with the Wix Studio platform and Wix Velo (or willingness to quickly familiarize yourself with the documentation). Ability to work with Wix ...
...les entreprises de la catégorie 3 - Fournir les informations suivantes pour le bénéficiaire majoritaire : - Nom complet - Genre - Adresse postale Rédiger : - 3 bullet points personnalisés sur le bénéficiaire majoritaire ou l’entreprise. - 2 paragraphes personnalisés (3 lignes maximum chacun) sur l’entreprise. Une structure de texte sera fournie pour guider la rédaction. Livrables attendus - Un excel complet classant chaque entreprise dans l’une des trois catégories, avec les informations spécifiques pour les entreprises de la catégorie 3. Les textes rédigés devront être en français et respecter le format demandé. Profil recherché : Comp...
I need a data entry specialist who can extract text data from PDF documents for me. The type of data will mainly consist of paragraphs and sentences. Skills and experience ideal for this job: - Proficiency in data entry - Excellent attention to detail - Experience in handling and processing PDF documents - Ability to accurately extract and transcribe text
I need a skilled RPA developer to create a library for a CRM system. This library should automate data entry and updates, specifically handling customer details. Ideal Skills and Experience: - Proficiency in RPA tools - Experience with CRM systems - Data handling skills - Automation expertise
I'm seeking a developer to enhance my Home...reservation in the calendar, I need that in ttlock a new passcode is created using ttlock.create_passcode call. I attached screenshots below of an calendar entry created by rental-control. The slot code from the calendar should be the passcode in the ttlock.create_passcode call, the start_time in the ttlock.create_passcode should be the start from the calendar entry, the end_time in the ttlock.create_passcode should be the end from the calendar entry, the passcode_name in the ttlock.create_passcode should be the summary from the calendar entry if it has relevant data or just the start and end of the calendar entry. If there are changes in the calendar entry ( edit, add, delete ) I would expe...
...for an expert in Excel and astrology software integration. The primary task involves data import/export between the two platforms (excel and software). Please note, the data to be transferred/extracted encompasses specific fields from the astrolog software. Ideal Skills: - Proficiency in Excel and creating macros - Experience with software or with any astrology software that uses swiss ephemeris - Data management skills - programming skills to pull out data from () - be able to connect data from excel and the astrology software I will be placing dates and times into excel, and then I want to click a button and extract out info from software and paste it into the excel worksheet. The data I want to...
...an experience developper who can improve an existing page that shows a table layout with currently 8 columns and at the left hand side several filter options (form with submit button and dropdownlists and typeahead datalists). The goal is to significantly improve usability by having the filter options at the head of the columns and alllow the user to select/input data in the filters and have the software automatically filter the data (using javascript and fetch, but other suggestions are welcome). Some of the logic behind the filtering also needs to be changed, for example users can filter on one lastname using a typeahead freelist/datalist, but this filter should be modified to return all records found having this lastname (or having a lastname starting with the letters ...
