Macro excel cellsJobs

...in data entry • Research abilities • Proficient in email management Though the specific tasks were skipped during the question phase, I expect your application to include details about your past work experiences where you carried out similar tasks. A comprehensive project proposal will also be beneficial. SOFTWARE PROFICIENCY It would be a plus if you have proficiency in tools like Microsoft Excel, Google Sheets, or any CRM systems. While these tools were skipped during the initial question and answer phase, they still play a valuable part in performing your duty effectively. Kindly ensure your bid reflects your skillset and experience within these domains....

...freelancer to help extract textual data from tables in a website file and compile it into an Excel file. The website won't let you copy from it so its going to be a manual process. I found a way to somewhat get it exported to excel but not all the email addresses a complete and are cut off. I need someone to open the webpage and the excel file and compare the email address and enter any missing characters. There is 2,252 rows to go through! Requirements: - Proven experience with data extraction - Proficiency in the use of Excel - Ability to interpret data in table format in a PDF - Highly accurate and detail-oriented The webpage file contains table data which you will need to take and organize in an Excel file - in the exact same order it app...

Tengk que cargar entre 15.000 y 20.000 varisntes de codigo de barras en un excel, provenientes desde varios excel de proveedores

I own a business and I'm in need of an accountant to create multiple Excel templates that mirror the amendments needed to an original Corporation Tax (CT600) return when applying Research & Development (R&D) relief. The templates must cover all possible aspects with help text. Here's what I need: - A template for when the company is making a profit - Another template for when the company is making a loss - May need multiple templates for a loss making company to cover carrying losses forward, carrying losses back, group relief and immediate cash rebate at 14.5%. - There will also need to be a loss making variation determinable template which will tell me which loss making template to use or which combination to use to receive the maximum benefit. It is crucial...

Create a website for stem cells. Pages: Home, Services, Contact Sections: Service, FAQ, and Videos

I need an expert who can create an Excel system that can help me improve the efficiency of my manufacturing business. My primary focus is on automating our inventory management. As of now, we are tracking things manually, using pen and paper. This old-school method is tedious and prone to errors. I believe that by automating this, we can significantly reduce the time spent and improve accuracy. Your role will be to create a sophisticated Excel spreadsheet that allows: - Automatic calculation of inventory turnover to understand how efficiently we're moving stock. - Alerts for when the stock falls below a certain level to prevent running out of stock. - Data analysis on the highest selling products to better understand what's driving our business. Ideally, you will...

I'm in need of assistance updating Excel spreadsheets for a Small Business Administration loan. The work involves a moderate level of financial data calculations. Since I skipped this last question, I'm giving the freelancer the freedom to employ their knowledge of financial formulas. The ideal candidate for this job will have: - Strong Excel skills - Practical experience in financial data management - Knowledge in small business loan requirements - Expertise in financial formulas adjusting to SBA standards - A keen eye for detail to ensure accuracy in updates. Your role is critical to the successful acquisition of this loan, hence precision is key.

As an e-commerce store owner operating on Shopify, I am seeking a capable professional with experience and skill in product listing to manage the numerous products I intend to have on my store, as their number exceeds 100. To excel in this project, you'd need to demonstrate a track record of successful Shopify management with an emphasis on: - Expertise in handling high volume product listing (above 100 items) - Excellent attention to detail for product descriptions, images, pricing, etc. - Efficient time management skills - Familiarity with SEO principles and application in product listings to drive visibility in organic searches - Knowledge of Shopify's back-end to ensure seamless experience for shoppers Your role will not only contribute to the establishment and ope...

My budget are $10-15. Pls quote someone can work on this budget. I'm looking for an expert in PHP, specifically skilled in developing web applications. # Project Documentation: Lead Management System ## Frontend...the lead. #### Send New Quote - Input: - System capacity - Quote amount - BOS cost - I&C cost - Net metering cost - Liaisoning cost - Dealer margin #### Call Later - Schedule a call with date and set a reminder. ### Submission - After inputting data, submit the details. ## Backend ### User Management - Create and manage user accounts. ### Lead Management - Upload leads from Excel (fields: customer name, address, city, phone). - Download user input data. ### Assignment and Email - Assign leads to users. - Users receive email notifications ...

I am in need of an Excel expert who can assist me with analyzing and reporting a Warranty cost management. Tasks would predominantly include: - Conducting thorough Warranty Coasting analysis on provided data - Developing comprehensive reports on findings - Applying any additional information to point out where the cost were higher. The ideal candidate will: - Have extensive experience with Excel, particularly in data analysis and reporting - Have the ability to use Excel to conduct performance analysis This role does not require VBA macro knowledge but it would be advantageous. Proficiency in data management, manipulation, and interpretation is essential. Along with a knack for turning raw data into comprehensive and meaningful reports.

...specific text details, consisting of Titles and 20 different fields of text or numeric data from individual pages and compile them into a single spreadsheet. This task requires attention to detail as the fields are consistent across all pages, hence it is imperative they are accurately represented in the spreadsheet. Ideal Skills: - Data extraction expertise - Attention to detail - Proficiency in Excel - Web scraping abilities - Understanding of titles, text or numeric data fields extraction I want a sheet with data on the 600 schools associated with the U.S. Interscholastic Sailing Association and its seven districts listed on this page: Each school has data on the team listed on its own page, we need this data, as shown here:

I am seeking a professional with expertise in accounting for a part-time position. The engagement will require them to work twice a month. Their main responsibilities will be: - Financial statement preparation - Bookkeeping - Payroll The ideal individual should have extensive experience managing these tasks. Proficiency in the use of Excel spreadsheets as an accounting tool is a must. As this is part of the software I currently utilize, I would greatly appreciate candidates who can effortlessly navigate this tool in fulfilling their duties. In-depth understanding of tax laws and regulations will be considered an added advantage.

I need an expert freelancer who would help with extracting data related to contact information for all businesses in our region. The project involves web scraping and data mining to extract the required information. Required Data in Excel: - Business name - Business address - Business City/town/village - Business Products or Services - Website - Business contact name - Phone number - E-mail address By the end of this project, I am expecting to have a comprehensive list of relevant businesses including their locations, the products or services they offer and their respective contact info. Your work will play a crucial role in helping me connect with potential business leads in this industry. Ideal skills and experience for the job: - 2+ years of experience in data mining - Past ...

I'm in need of a professional who can set up an automatic data entry system for my Excel sheets. My goal is to improve efficiency and accuracy in my tasks. Key Responsibilities: - Automating the entry of mixed data types (texts and numbers) in Excel - Sourcing these data from an online database Ideal Skills and Experience: - Expert knowledge in Excel and automation processes - Proven experience in dealing with complex data and online databases - Ability to ensure that data is captured accurately and efficiently. Ultimately, I need someone who can implement this automation seamlessly with accurate results. Your contributions will significantly improve my data management processes.

As a client, I'm seeking a skilled developer to design a reporting tool. Key Requirements: - Proficiency in Java, Python, and C++. The chosen developer must have extensive experience developing with these languages as the reporting tool will need to be compatible with all. - The reporting tool needs to have specific features including data visualization and the ability to export data to PDF/Excel. - The tool must be designed to connect to a database for importing data. Ideal Skills and Experience: Experience in developing reporting tools, expertise in data visualization, database connectivity, and data exporting. Familiarity with Java, Python, and C++ is mandatory. Experience in handling data in various formats and creating customizable dashboards is a plus.

My goal is to clean text data in my Excel worksheet. The main agenda of doing so is to facilitate descriptive statistical analysis. Therefore, I need a service provider who: - Has a broad understanding and hands-on experience in data cleaning, especially text data. - Is proficient in Excel and detailed-oriented to avoid manipulation errors. - Possesses skills in statistical analysis, specifically descriptive statistics. Your responsibility will not only include cleaning the text data but also preparing it for subsequent tasks of statistical examination.

I need a freelancer skilled in data visualization and Excel to convert an Excel file into a pivot chart showing the top 10 diseases. The chart should focus on disease prevalence, using the disease data provided in the file. Essential skills and experience: - Excellent knowledge of Excel and data visualization - Ability to accurately portray data - Strong attention to detail - Proven track record creating visuals from raw data Tasks include: - Analyzing the provided Excel file to understand the data - Creating a bar chart that highlights the top 10 diseases - Ensuring the chart is accurate and easy to understand Looking forward to receiving proposals from freelancers who understand the significance of accuracy in data presentation.

I'm looking for an adept Excel user to correct the data display problem in my existing small spreadsheet. Here's what I need help with: - The data in the spreadsheet isn't displaying properly. I need someone who can troubleshoot and correct the problem. - I would like to have color-coded cell conditions implemented to represent the presence of specific text. This means that cells containing certain text strings should display in different colors. This would provide a clear and colorful representation of text conditions throughout my document. Proficiency in Excel, particularly in handling display issues and cell formatting, is critical for this project. You'll need an understanding of how to apply color conditions based on text presence in Exc...

I require a quick and accurate data entry specialist to input numerical and textual data, sourced from an online database, into my system. With an estimated total of 100 to 1000 entries, the ideal candidate should be proficient in data mining and Excel. The high degree of precision needed mandates thorough experience with similar projects.

Buongiorno, ho un elenco excel di circa 1930 aziende (righe) con indicazione del nome, città e link al rispettivo sito web. Per ognuna di queste bisogna aprire il sito web, verificare che il sito abbia la possibilità di acquistare online (presenza ecommerce, o solita iconcina del carrello) e inserire sull'excel un'altra informazione veloce reperibile sempre dai siti delle rispettive aziende. Per ogni inserimento di fatto ci vuole massimo 1 minuto ad azienda o poco più. Per completare il file quindi ci vogliono circa 32-40 ore. Solo italiani o chi parla italiano fluente per favore e no offerte fuori budget, grazie

Búsqueda/Recopilación de Datos: Búsqueda de Correos Electrónicos para Empresas Tecnológicas - Estoy buscando un freelancer que pueda ayudarme a recopilar direcciones de correo electrónico de una lista de empresas. - El propósito de este proyecto es recolectar datos para fines de investigación. - El freelancer ideal debería tener experiencia en recopilación de datos y ser competente a la hora de realizar investigaciones en línea. - El proyecto requiere recopilar un número sustancial de direcciones de correo electrónico de una muestra de aproximadamente 7000 empresas. - La atención al detalle y la precisión son cruciales en este proyecto para garantizar la validez de las direcciones de co...

Infographic designer that can design a chart that shows the information in the excel chart. The excel chart has 52 accounting applications with a logo of each and characteristics and features. The chart need to be printed in different sizes a2,a3, a0 and one large chart one meter by three meters. A logo for the chart is required title (Accounting digital innovation lab ADIL). The chart can be as a circle with the 52 logos and the title at the middle or a creative graph of amazing shape.

am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books ). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise, meticulous, incredibly organized, and possess th...

I need assistance with creating spreadsheets for managing sales records in Microsoft Excel. This project's specific responsibilities would primarily include: - Developing precise and effective spreadsheets to capture all relevant sales data. Considering the nature of this project, it would be ideal if you have: - Extensive experience in Microsoft Excel, specifically in constructing spreadsheets. - Proficiency in managing and organizing sales records. - An understanding of best practices when it comes to data management in Excel. Please note, no project management fields need to be included in the spreadsheets. Your key objective will be to create spreadsheets that simplify the data entry process and effectively organise sales records.

I am in need of expert help in organizing less than 1000 entries of customer data on a spreadsheet. The data includes various customer details that currently lack structure, making it challenging to retrieve specific information. Ideal Skills and Experience: - Expert knowledge in using spreadsheet tools such as Excel or Google Sheets - Strong experience in data organization on spreadsheets, specifically customer data - Attention to detail is vital as the data should be organized in a manner that enables easy location of specific entries - Understanding of customer data privacy requirements necessary

I am in need of a financial consultant with specific skills in Excel to help me enter financial statements data correctly and promptly. Requirements for this project include: - In-depth knowledge in financial consultancy - Proficiency and experience in Microsoft Excel - Ability to manage and organize financial statements efficiently - Attention to detail and high level of accuracy Please bid with confidence if you meet these requirements and are capable of delivering high-quality results in a timely manner.

I am in need of a professional proficient in Excel VBA coding. The right person for this job should have: - Extensive Excel VBA experience - A strong record of creating effective data analysis tools - Proficiency in automating repetitive tasks to enhance productivity. The project will involve: - Developing custom VBA code to streamline data analysis processes - Crafting automation tools for repetitive tasks to increase efficiency Candidates should have demonstrable experience with similar projects, showcasing their ability to take in requirements and effectively translate them into actionable, efficient solutions. Skilled in time management and a keen eye for detail will make you a standout candidate. Your main goal will be to tailor an existing system to better match ...

Entry of 150 invoice to Excel sheet

I'm in need of an efficient individual to assist with typing data from JPEG invoice images into an Excel spreadsheet. KEY JOB DETAILS: - Your tasks will involve transferring grand total amount data from approximately 120-150 invoices. - The specific data required from each invoice include: Invoice File Name and the GRAND TOTAL amount. SKILLS AND EXPERIENCE: - Strong attention to detail - Proficiency with Microsoft Excel Keep in mind, the project will only be deemed complete once all data has been entered accurately. Speed and precision are a must for this job.

I'm currently seeking a proficient freelancer for a data entry project. The task will involve sourcing numeric data from online resources, and accurately inputting them into a Microsoft Excel file. Key requirements include: - Excellent attention to detail to minimize errors in data entry - Proficiency with using Microsoft Excel and online research tools - Previous experience performing similar data entry jobs successfully Your responsibilities will include sourcing the data and ensuring it is correctly and accurately entered into the Excel file. The final Excel file must be formatted correctly to enable easy use and manipulation of the data. If you possess these skills and experiences, please feel free to place your bid.

I'm in need of a detail-oriented professional to provide administrative support, specifically focused on processing business trip receipts / record into provided excel template Your responsibilities include: - Use Excel. - Organised - NOT part of agency / provider service

I am seeking a freelancer with strong data entry skills to transpose numerical data from PDF files into an Excel spreadsheet. Key Requirements: - Accuracy in typing numbers and data extraction from PDF files - Proficient in Microsoft Excel for data planning and management - Able to perform a simple copy-and-paste activity without error Preference will be given to applicants who have prior experience in numeric data entry and PDF data extraction. The ability to diligently check work for any errors is critical to the role.

I'm looking for a consultant guru to share a robust post-merger integration plan in excel for me. Various workstreams including Finance, Commercial, HR, IT, etc should be structured into separate sheets within the file. Key features should include: - Workstream Organization: Every workstream will have its dedicated sheet. - Finance Tracking: The finance sheet should be capable of recording and tracking all related data. - Commercial Analysis: A sheet to monitor commercial aspects following the merger. - HR Management: A comprehensive sheet to manage all HR related tasks post-merger. - IT Integration: A sheet to plan and track IT integration process. Ideally, I would like someone with experience in mergers & acquisitions, process inprovement and change management to take...

I'm looking for a detail-oriented data entry specialist to help me extract financial data, particularly remuneration details, from approximately 50 annual reports. I need these details entered accurately into an Excel table I can later analyse. Tasks: - Extraction of financial data from annual reports - Focusing on remuneration information: salary information and sitting/attendance fees - Accurate data entry into Excel Ideally, you have prior experience with financial statements and can pay strong attention to detail. Familiarity with Excel and financial data entry is a must! Accuracy and efficiency are paramount in this job. Here are some links where the annual reports (Year end 2023 or 2022 if 2023 is not available) would sit:

I am looking for an advance Excel expert who can do data analysis of manpower position in an organisation. Sample work is attached in Excel data will he a bit complex.

I'm in need of a creative person with a vision for a 3D rendering of a Mediterranean style house facade. Leveraging your expertise and creativity, I would like you to introduce these elements: • Lush landscaping • Decorative arches and columns • Rounded walls Depict...experience should include, but not be limited to; • 3D rendering • Architectural design • A keen eye for landscaping design I am set on the floor layout. Happy to make some minor changes to suit the facade loking at introducing some drapped plants from the balcony and open to roof or flat roof option. I am looking at a modernised version of Mediterranean to better blend with the area. If you excel at providing creative perspectives, this is the opportunity for you. Let's b...

I need a data analyst to thoroughly assess my sales data. The information is stored in Excel and needs to be analyzed urgently to determine key metrics that will enable me to make informed decisions with regards to our vending machines. The most critical details to extract include: - Product sales: Identifying which items sell more than others - Most popular products: Discovering the specific products customers prefer - Sales volume: Understanding our overall sales output The ideal freelancer should be proficient in Excel and data analysis. Previous experience working with sales data would also be advantageous. Time is of essence for this project and would require immediate prioritization.

...e-commerce platforms. The task involves: - Using Python to scrape a sample size of 2000 product details specific to the "Health and Beauty" category in Vietnam marketplace - Gathering specific details from each product including price, number of purchases, customer reviews, title, description, specifications, rating, category/sub-category, seller, and user comments. - Exporting the data into excel sheets as in attachments - Provide documentation detailing the scraping process and data format. - Provide code that is modular, well-documented, and easy to maintain. Ideal skills and Experience: - Proficiency in Web Scraping - Knowledge of E-commerce platforms, Shopee in particular - Familiarity with the "Health and Beauty" category on e-commerce platforms - Inf...

I need assistance correcting an Excel column calculation. An error labeled "#SPILL!" pops up whenever the calculation is attempted. I require someone who can fix it quickly.

...require my direct attention. - Client Relationship Management: Maintaining a professional relationship with our clients. Helping to build and maintain strong, long-lasting relationships. Schedule meetings, send reminders, and follow up with clients to ensure their satisfaction and keep them engaged with our services. - Data Entry: Accurately entering and updating pertinent data. Familiarity with Excel or similar software will be beneficial. - Bidding Task: Take charge of identifying and bidding on relevant projects across multiple platforms. This involves creating compelling proposals that highlight our strengths and match the client's requirements. Requirements: Proven experience as a Virtual Assistant, particularly in inbox management, client relationship, and bidding ta...

I'm in need of a talented photographer to capture high-quality images of my gemstones for online sales. - Skills & Experience: - Professional product photography - Experience with jewelry or similar items - Skills in photo editing - Macro photography Equipment because the stones are very small. - Prior experience in e-commerce product photography would be a plus - Project Details: - The primary task is to photograph gemstones effectively, highlighting their natural beauty and details. - These images will be primarily used to facilitate online sales, so an eye for creating enticing product photos is needed. I would like to show the stone on a white background. I look forward to working with individuals who are passionate about their craft and come wit...

I am in need of an Excel expert who can assist me with analyzing and reporting a Warranty cost management. Tasks would predominantly include: - Conducting thorough Warranty Coasting analysis on provided data - Developing comprehensive reports on findings - Applying any additional information to point out where the cost were higher. The ideal candidate will: - Have extensive experience with Excel, particularly in data analysis and reporting - Have the ability to use Excel to conduct performance analysis This role does not require VBA macro knowledge but it would be advantageous. Proficiency in data management, manipulation, and interpretation is essential. Along with a knack for turning raw data into comprehensive and meaningful reports.

Precisamos de um script ou programa para geração de arquivos CNAB de pagamentos para o banco Inter. O programa deve ler/importar os dados dos pagamentos de um arquivo XLS (Dados favorecido, banco, agencia, conta, nome, cpf, valor), separar os pagamentos por banco e gerar um arquivo CNAB par...para Bradesco, BB, Caixa e Santander etc. O arquivo sera enviado ao banco de forma manual pelo Internet banking. Temos preferência por alguém que já tenha trabalhado com arquivos CNAB ou serviços financeiros/TI bancário, tendo em vista a complexidade e nível de detalhes exigidos pelo banco. Se você tiver uma ideia ou sugestão para melhorar este processo, fique a vontade para sugerir. Exemplo de excel com a lista de pagamentos...

I'm seeking an expert in financial forecasting to help construct a comprehensive model for a multi-vendor eCommerce marketplace. This platform wil...5-year forecast period The perfect candidate will understand the nuances of an eCommerce business and be able to leverage that understanding to present an accurate and comprehensive financial model. Experience in forecasting for global markets is a plus. Accurate data will be the heart of this model and the forecast should encompass all necessary elements to ensure its precision. I have one excel based financial forecast made by a firm for a while ago with a set budget. And i want to change the budget to a higher one. Plus this budget are only based on the indian market and not broader to include China, EU for vendors and global...

We are seeking a skilled Electrical Engineer with expertise in PCB design using Altium Designer to execute the panelization of 7 distinct PCB designs. The successful candidate will be r...designs. The successful candidate will be responsible for preparing and optimizing each design for manufacturing (DFM) and ensuring efficient utilization of PCB space during panelization to minimize costs and enhance production efficiency. Deliverables: -Panelized PCB design in Altium Designer format (.PcbDoc). -Gerber files for the panelized design. -Bill of Materials (BOM) for the design in Excel or CSV format. -Pick and place files (.CSV) for automated assembly. Requirements: -Proficiency in Altium Designer for PCB layout and panelization. -Experience with DFM principles and PCB manufacturing ...

Type the Text from the images to Excel as per the sample provided.

...Python or Access macro to create a solution for processing data from a .csv file and exporting the results to multiple .csv files. Export to a new .csv file every time the data in the first column changes. See attached power point for details. It will be employed on a Windows operating system - no specific Python version was mentioned, so either current stable releases of Python 2 or 3 should work. The responsibilities and requirements are detailed as follows: - Data aggregation: Your solution should be capable of aggregating the data where necessary. - Category-wise CSV Export: Export the resulting data into .csv files, with one file per category of data. The ideal freelancer for this project should have the following skills: - An excellent understanding of Python or ...

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

I'm looking for a resourceful freelancer who has proficiency in Microsoft Excel. The task at hand is to develop a method that can effectively compare two Excel files. The detailed requirements are as follows: - You need to focus primarily on the 'Cell Values' while comparing. Other aspects such as cell formatting or column structure are not part of the scope. - If differences are found during the comparison, they need to be highlighted. - As for the highlighting, all differences should be marked in one uniform color. This comparison should be accurate and easy to comprehend. It's an ideal opportunity for someone with a good eye for detail and strong Excel skills. Previous experience in similar tasks would definitely add value.