How to add two columns in excel jobs

I'm seeking a payroll expert to assist with creating 74 W-2C forms for my company. We operate on a manual payroll system and I have all the necessary employee information at hand. The primary purpose of these forms is to correct wages. Ideal candidates for this project should have: - Extensive experience in payroll and tax form preparation. - Familiarity with W-2C forms and the reasons for their use. - Ability to work meticulously and maintain a high level of accuracy. - Demonstrated track record of precision and attention to detail in payroll tasks. The employee information will be provided in a digital format such as an Excel or Spreadsheet. The W-2C forms should be completed within 2 weeks. The completed W-2C forms should ...

? Job Overview: We are looking for a highly skilled Google Sheets, Data Automation, and Social Media Analytics Specialist to assist in developing spreadsheet-driven forecasting, demand planning, inventory tracking, social media performance tracking, and financial analysis tools for our e-commerce business. The ideal candidate should be proficient in Google Sheets, (formerly Integromat), API integrations, and e-commerce data analysis (Shopify, Stripe, etc.). You will work on a case-by-case basis to build tools that help us make data-driven decisions regarding inventory, financials, fulfillment, social media marketing, and customer analytics. This role will also include supporting tasks currently handled by our Virtual Assistant, ensuring seamless integrati...

...Description: I am seeking freelancers with expertise in the following areas: Content Writing: Articles, blogs, and creative story writing. Typing and Copywriting: Fast and accurate typing skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. ...

...require an Excel expert to streamline my weekly report process. This involves merging four distinct reports - Maintenance, Operations, Supply Chain Management (SCM), and Finance - into one comprehensive Excel spreadsheet. Key tasks: - Combine the four reports into one Excel sheet on a weekly basis. - Visualize the data trends over time using a bar graph. - Ensure the graph highlights the key trends across the four departments. - Automate the import of data from each of the four reports to reduce manual input. - Develop a dashboard in Excel that displays key metrics and trends in a user-friendly format. - Generate a weekly summary report that provides insights and highlights key findings. - Set up conditional formatting or alerts ...

Need to cover and update the following points 1: Prevent users from copying and pasting data to the Template file from other files 2: Link the new planning template to VLOOKUP file. Need the Dropdown data validation options on this file to match the Vlookup file that we maintain separately and use for our other templates. 3: Ensure that VLOOKUP file needs to be referenced from original location instead of creating a copy to the folder. 4: Stop workbook links message when file is opened 5: Stop VLOOKUP file closing message when file is closed

I am looking for a skilled Power BI expert to create a dashboard primarily focusing on sales analytics. Key Requirements: - The dashboard should connect to Excel/CSV files. - It should track revenue by product. Ideal Skills and Experience: - Proficiency in Power BI. - Experience in sales analytics. - Ability to work with Excel/CSV data sources.

Hello. As discussed, I’ll make the dashboard for you.

I'm seeking help with matching date ranges in my data. The data is time-sensitive and needs to be handled with precision. Ideal Skills and Experience: - Proficiency in Excel, particularly with the INDEX and MATCH functions - Strong understanding of date and time data - Experience in data analysis and sorting - Attention to detail to ensure accurate matching of date ranges

I have an Excel sheet containing sales data and I need help converting this information into a parts needed list. The parts list should be organized by dates of sales. Key requirements: - Identify individual components from sales data - Organize parts list by sales dates Ideal skills: - Proficiency in Excel - Experience with data analysis - Attention to detail

Project Overview I am looking for a full-stack developer (or a team) to build a custom fundraising webshop system where individual sellers (e.g., students, sports teams, or non-profits) get their own personalized online store to sell products and raise funds. The system consists of two main parts: A standard webshop where anyone can buy directly with a payment gateway. A reseller system where sellers get personal webshops, but orders are only recorded and later exported to a group leader—no payment processing on reseller pages. Core Requirements 1. Standard Webshop () A fully functional e-commerce store displaying all products. Standard cart & checkout process. Payment gateway integration (Stripe, PayPal, Klarna, or similar). Orders placed here are p...

I'm in need of a professional who can assist me with a data migration task. The data is currently stored in another Excel file, and I require help specifically in removing duplicates during the migration process. Ideal Skills: - Proficiency in Microsoft Excel - Experience in data migration tasks - Ability to identify and remove duplicate entries This project is straightforward but requires attention to detail and a strong understanding of Excel.

I need an Excel whizz to help me manage and analyze my inventory data. The primary focus will be on organizing data and setting up formulas to track stock levels efficiently. Key Tasks: - Organizing my inventory data - Setting up formulas for tracking stock levels - Creating visualizations like charts and graphs for easier data interpretation - Providing step-by-step instructions and useful tips I am looking for someone who can also guide me on using advanced Excel functions such as VLOOKUP, pivot tables, conditional formatting, and data validation to streamline this process. Ideally, you will provide me with templates that can save time and enhance productivity in handling large datasets. The ultimate goal is to improve accuracy and gene...

I'm in need of a standard, detailed Chart of Accounts specifically tailored for the service industry. Key Aspects: - Development of a standard Chart of Accounts - Focus on the service industry - Detailed level of account categorization Ideal Skills and Experience: - Understanding of service industry financials - Experience in creating detailed Charts of Accounts - Knowledge of standard Chart of Accounts - Strong accounting and financial planning skills. The Chart of Accounts should be delivered in Excel format. Please include specific industry examples or templates for reference.

I am a person who specializes in studying the world of diseases. There is an Excel file about the disease covid19. I want to analyze the data in the file and display it in a clear way through which I can understand the data so that I can use it in my research on covid 19 This project involves statistical analysis. Please apply descriptive statistics to the data. Please include charts to clearly visualize the data. Please include bar charts to clearly visualize the data. Please focus on knowing where the disease is spreading. Please include bar charts to clearly visualize the data. Focus on analyzing the geographical distribution of covid19 cases. The analysis should cover data from the date on which the data was ...

I'm in need of a professional who can create a comprehensive Excel sheet for billing and invoices. It should include an expense tracking component as well. Key Requirements: - Design an Excel sheet specifically for billing and invoices - Include an expense tracking component in the sheet Expense Tracking: - The sheet should allow me to categorize expenses - It should track the amount spent on each expense - The sheet should include a column for the date of each expense. - A column for a brief description of each expense should be included. - There should be an option to attach or link expense receipts. Ideal Skills and Experience: - Extensive experience with Excel - Previous work with designing billing and invoicing Excel she...

...macro for Microsoft Word and Excel that captures comments from a Word document and exports them into a structured Excel spreadsheet. Requirements - The macro should extract the following details from each comment: - Author (name and email) - Date and time of the comment - Comment resolution status - Line number associated with the highlighted main text - Main text that the comment is based on - Section header, if the main text falls within a chapter or section of the document - Page number for the highlighted main text - Subsequent comments or replies, structured in additional columns rather than additional rows Excel Output Requirements - Each comment should be recorded as a single row in the spreadsheet. - Responses to comments shoul...

Please complete the edits for the 'revamping a book'. The project is completed with the delivery of the design files (like last time). You said you worked about 3 hours. With your published rate of $20, this project budget is $60. Thank you.

I'm in need of a freelancer who can provide me with daily updates on divorce listings in the Toronto area, delivered in an Excel spreadsheet. Requirements: - The Excel spreadsheet should contain the names of the individuals involved in the divorce and their contact numbers. - The data should be organized, accurate, and up-to-date with daily listings. Ideal Skills: - Proficient in data collection and Excel. - Able to ensure data privacy and handle sensitive information with discretion. - Familiarity with sourcing public information, particularly legal databases, is a plus. Data should be sourced from public records. Please include the property addresses in the listings. Include full addresses with street, c...

I need assistance in entering text data from PDF files into an Excel spreadsheet. Ideal skills for this job: - Proficient in Excel - Excellent attention to detail - Speedy and accurate data entry - Able to follow instructions precisely - Ability to validate and verify data

I want to build a portal similar to for tyres and auto parts. The portal should have four distinct sections: 1. **Customer Login**: This section should allow customers to browse and purchase parts seamlessly. 2. **Partner Login**: This part should empower our partners with the ability to access sales reports, manage inventory, and handle customer queries. 3. **Parts Provider Login**: This section needs to be robust, allowing parts providers to upload new inventory items, track inventory levels, and generate sales reports. 4. **Courier Tracking and Login**: This segment will be dedicated to logistics, providing tracking functionality for our couriers. 6. Review System: A system for customers to leave reviews on products and s...

...designed to automatically pull data from multiple sources, including different projects, documents, cloud storage services (Dropbox, S3), URLs, and media content (YouTube videos). The agent will process, clean, and store the extracted data for further analysis, search, and retrieval. 2. Objectives Develop an AI-driven system to aggregate data from various sources. Enable automated extraction, transformation, and loading (ETL) processes. Ensure seamless integration with cloud storage, document repositories, and media platforms. Implement Natural Language Processing (NLP) for document comprehension and YouTube transcription. Provide an API interface for querying and accessing the processed data. Support integration with various Large Language Models (LLMs), allowing f...

I'm seeking an expert in mathematical modelling, particularly in supply chain contexts, to assist with an assignment. The project will involve using Excel Solver to tackle various complex problems related to inventory management and demand forecasting. Key Objectives: - Apply linear programming and integer linear programming models to optimize and simulate supply chain scenarios. - The primary goals are to minimize costs, maximize efficiency, and optimize resource allocation. Constraints: - The model must account for various budget, capacity, and time constraints. Ideal Skills: - Proficiency in Excel Solver and mathematical modelling. - Strong understanding of supply chain management, particularly in inv...

I need to create Word document forms that are linked to a MySQL database for auto-update. The forms should reflect both text and numerical data from the database. Ideal Skills: - Proficiency in Microsoft Word and MySQL - Experience in creating structured Word files - Ability to connect Word files to external data sources, specifically databases Requirements: - Create structured Word document forms - Link these forms to a MySQL database - Ensure both text and numerical data is auto-updated in the Word forms Please refer to this link for more details:

I need an Excel signing sheet created from a single PDF. The Excel sheet should include names and signatures autopopulated from another sheet, as well as the date and time. Please use standard rows and columns for formatting refer to pdf

...for a proficient Excel developer with a strong background in trading systems to build an Excel-based trading system interfacing with Upstox. Key Requirements: - The system should support Day trading and Scalping strategies. - The system must include features for Automated trading, Data analysis and visualization, as well as Trade logging and reports. - The system should fetch market data via API integration with Upstox. Ideal Skills & Experience: - Advanced proficiency in Excel, including VBA for automation. - Proven experience in developing trading systems. - Familiarity with Upstox and its API. - Strong understanding of Day trading and Scalping strategies. - Excellent data analysis and visualization skills. Please, include examp...

...someone who will do the following. You will get an excelliste There you will find entries from 21435 rows Only columns A and B are relevant for you There you have to copy out the so-called HSN and TSN of the vehicle and enter them in a portal to identify the engine code of the vehicle. The engine code must then be entered in column H or, if there is more than one engine code, in column I and so on. Most vehicles have one engine code. To find out the HSN & TSN we will provide 3x websites where this can be done. The order is made in 2000 steps in milestones A second freelancer will check the integrity of the data. It must be 100% ensured that no errors are made. We will pay in milestones everytime 2000 entrys ...

This project is ideal for someone with experience in creating budget spreadsheets, preferably for couples or families. Excel or Google Sheets expert is a must. It would be beneficial if you can incorporate features that enable easy tracking and analysis of our financial habits. Include charts to visualize the data. Include a feature to track and visualize progress towards savings goals. example:

This project is ideal for someone with experience in creating budget spreadsheets, preferably for couples or families. Excel or Google Sheets expert is a must. It would be beneficial if you can incorporate features that enable easy tracking and analysis of our financial habits. Include charts to visualize the data. Include a feature to track and visualize progress towards savings goals. example:

I need a tool that will help me create offers based on an Excel price list. The tool should allow for multiple product selection and have the ability to generate a PDF of the final offer. Key Features: - Multiple Product Selection: The tool should allow me to select multiple products from the price list when creating an offer. - PDF Generation: The final output of the offer should be a neatly formatted PDF. Skills and Experience Required: - Proficiency in Excel and PDF generation - Prior experience in creating similar tools or applications - Understanding of e-commerce product selection and offer creation process is a plus. The PDF output should have a custom layout with specific design elements. The PDF should include offer terms and condition...

Need two menus and submenus

I need a family budget spreadsheet tailored for a couple. Its primary function is to track income and expenses. The spreadsheet should be able to monitor various types of expenses including monthly bills, daily spending, and unexpected expenses. This project is ideal for someone with experience in creating budget spreadsheets, preferably for couples or families. Excel or Google Sheets expert is a must. It would be beneficial if you can incorporate features that enable easy tracking and analysis of our financial habits. Include charts to visualize the data. Include a feature to track and visualize progress towards savings goals. example:

I'm seeking a seasoned professional to help automate processes related to our 'pinkfish' website project. Key focus areas include: - Data entry: Streamlining input processes to save time and reduce errors. - Email responses: Automating customer interactions to ensure consistent and timely replies. - File management: Ensuring all files are organized and accessible, with minimal manual intervention. The ideal candidate will have experience with Excel/Google Sheets, as well as CRM systems and project management software. Skills in web development and knowledge of e-commerce platforms will be highly beneficial.

I'm looking for a freelancer who can independently manage and accurately transfer information from various sources into an Excel spreadsheet. The specific sources will include paper documents, spreadsheets, and online forms. The ideal candidate should have experience with data entry, attention to detail, and proficiency in Excel. Key Skills Required: - Data entry - Excel proficiency - Attention to detail

...respective river or canal. The resulting polygons should be provided in Well-Known Text (WKT) format. Details: • The polygons must accurately reflect the entire water surface of each river or canal. • The focus is on 25-30 rivers and canals, (global Importance). • The polygons should be manually drawn using GIS software and then exported as WKT strings. • Ensure the data is topologically correct and corresponds precisely to the actual river boundaries. • The final output should be an Excel file with two columns: • “Name”: The name of the river or canal • “WKT”: The corresponding WKT polygon Deliverables: 1. Excel file () with two columns: • Name (river/can...

...developer to help me finalize and fix various issues in my web-app. The project is a POS/Inventory system integrated with an online store. Key Fixes Required: - Language Switcher: Needs multi-language support, language auto-detection, saving user language preferences, and currency updates. - Modal Pop-Up: Should be used for user notifications. - CheckOut Mail: Fix issues related to email notifications during checkout. - B2B Options: Implement and fix features related to Business to Business options. - Ensure the web-app is fully responsive across various devices and screen sizes. - Implement a comprehensive user role and permissions management system. - Integrate third-party APIs for extended functionalities such as shipment tracking. - Impl...

I'm seeking an Excel professional who can assist with modifying a file and selecting specific data. The task involves saving images in bulk from local files and requires some specific data formatting. Key Requirements: - Data Modifications: Save images in bulk from local files. - Data Formatting: Primarily involves cell merging and alignment. Ideal Skills: - Proficiency in Excel - Experience in data cleaning and formatting - Familiarity with bulk image saving techniques - Attention to detail

I'm seeking a skilled developer with extensive experience in Laravel 11. I need modifications to my existing code to incorporate: - Private call functionality with call masking (this should involve masking both caller and receiver numbers) - SMS sending with OTP (One Time Password) - Video call capabilities The call masking feature will require third-party API integration, so familiarity with relevant APIs is a plus. The ideal freelancer for this job should have a strong background in Laravel, experience with API integrations, and knowledge of implementing call and SMS features in a web application.

I'm looking for an Excel expert who can assist with data analysis and report generation. The task involves working with large datasets, creating dynamic reports, and ensuring data accuracy. You will primarily be working with financial data. Your tasks will include: - Analyzing and cleaning up large data sets in Excel. - Developing and automating custom reports using advanced Excel functions. - Creating Pivot Tables, Charts, and Graphs to visualize data. - Developing macros for repetitive tasks and data automation. - Working with VLOOKUP, INDEX MATCH, and other advanced Excel formulas. - Ensuring the data integrity and accuracy of reports. - Providing clear and concise documentation of the work performed. The ideal freelancer should be profi...

I need a professional who can extract and compile the dimensions of all the girders from my Tekla Structures model of a Foot over Bridge. The ne...extract and compile the dimensions of all the girders from my Tekla Structures model of a Foot over Bridge. The necessary details include the length, width, and height of each girder, as well as its material type. The final output should be an Excel spreadsheet containing these details for every girder in the model. Ideal skills and experience for the job: - Proficiency in Tekla Structures - Excellent data extraction and organization abilities - Proficient in creating and managing Excel spreadsheets - Understanding of civil engineering concepts related to bridge construction - Strong knowledge of str...

I need a skilled Excel expert to help me with my formulas. I'm specifically working with mathematical and text functions. My main goal is to enhance my data analysis capabilities. Ideal Skills and Experience: - Proficient with Excel - Strong understanding of mathematical and text functions - Experience with data analysis

...EXPERT EXCEL EXPERT Please do not bid if you're not a genuine expert that can import thousands of products every week. Tasks and Responsibilities: - Be super organized. We will be sending you documents: please sort them in a way that will make it easy for you to revert to these documents whenever needed. We use Office 365 / OneDrive to organize our documents. - You will be importing using excel or CSV or, if you're a true expert: you may even use XML. You will need to maintain these files. If we find out that an attribute was not defined, we want to make sure it will be easy for you to add the attribute and reimport the products adequately. Note: in some cases, product assets/attributes are...

Need to split a line break in a column into own rows without overwriting other data. So it needs to be inserted in between current rows. It is three documents with today approximately 60 000+ rows each. Where it is inserted, the other column needs to be filled with the same value as above.

I'm looking for a skilled professional to create a Power Automate workflow for me. Key Requirements: - The workflow should run daily. - It will pull data from an Excel spreadsheet and update/add rows in another table based on a primary key column. - If a primary key from the source table does not exist in the target table, a new row should be added. If it does exist, the corresponding row should be updated. Ideal Skills and Experience: - Proficiency in Microsoft Power Automate. - Strong experience working with Excel. - Ability to work with primary key columns and understanding of their usage in data synchronization. Please bid if you're capable of delivering this project efficiently.

Project Title: Excel Macro-Based Inventory Management System for Diamond Trading Project Description: I am looking for an experienced Excel VBA (macro) developer to create a comprehensive inventory management system tailored for my diamond trading business. The system should be user-friendly, efficient, and capable of handling dynamic data with automated calculations. Key Requirements: 1. Modules: - Cash balance -Purchase and Sales records -Upcoming receivables and payables - 2. Automation Features: - Automated calculations for inventory updates based on parcel changes. - Dynamic addition and deletion of rows with real-time data updates. - Scrollable history for easy tracking of past transactions. - Backup and restore functionalities (preferab...

I need an Excel spreadsheet generated from my access machine which includes user details, sorted by department. Details to be included: - Name - Department - The ideal freelancer for this task should have: - Proficiency in Excel - Experience with data extraction from access control systems - Ability to sort and organize data effectively Please ensure the final output is user-friendly and ready for printing.

More details: What type of data do you need to extract from your private website? Text data What format do you need the extracted data to be in? Excel Do you need any specific data processing or cleaning before the data is saved? Yes, advanced data processing

Need a form where the customer can pick options to build a quote for renovating residential rental inventory

I need a minor edit on two screenshots. Both are in PNG format. The task is to simply change a '5' into a '4' in two different locations in each picture. 10$ Details: - The '5' that needs to be changed is located in two spots in the picture. - No additional changes are required. Ideal Skills and Experience: - Proficient in image editing software - Experience with PNG format - Attention to detail

I need this done right now Entered numbers not adding up My Excel file has issues where manually entered data is not updating. There are no error messages appearing, but this problem is causing significant inconvenience.

I'm looking for an Excel script that can automate the checking of my SKUs against a consolidated list that includes URLs and titles. The script will need to perform the following tasks: - Check against a consolidated list with URLs and titles - Download images - Rename files according to the SKU The SKU list is located in an Excel file and the consolidated list with URLs and titles is also provided in an Excel file. Ideal skills and experience for this job include: - Proficiency in Excel and Excel scripting - Ability to create scripts that can automate repetitive tasks