Vba excel spreadsheet work仕事
I'm seeking a freelancer who can extract data from Yellow Pages for me. The data I need includes business names, phone numbers, and physical addresses. The extracted data should be delivered in an Excel spreadsheet. Ideal skills for the job include: - Data extraction - Proficient in using Excel - Attention to detail
I'm seeking a professional who can convert my financial statements in Excel or CSV into a proper accounting format. The data needs to be transformed for clarity, accuracy, and compliance with standard accounting practices. Ideal skills and experience for the job include: - Proficiency in Excel or CSV - Extensive knowledge of accounting principles and standards - Attention to detail for identifying and correcting discrepancies - Ability to present data in a clear and readable format
I'm Alaa, a data entry and organization specialist. I need an experienced professional to help with data conversion from PDF to Excel/Word and Word to PDF. The tasks will require maintaining the original layout during the conversion. Key Requirements: - Proficient in converting data between formats, particularly from PDF to Excel/Word and Word to PDF. - Able to maintain the original layout during conversion. - Attention to detail to ensure the layout is preserved accurately.
I'm looking to have an Excel-based system developed that is capable of: - Tracking attendance - Generating payslips - Calculating worked hours The system will be fed data from a time clock or biometric device and will need to import this data from a time tracking tool. Ideal skills for this job include advanced proficiency in Excel, experience with time tracking systems and knowledge of payroll processes. The ability to create a user-friendly interface and ensure data accuracy is crucial.
Blog Writing on Digital Marketing & Work-from-Home Opportunities We are looking for a talented and experienced blog writer to create engaging and informative content related to digital marketing and work-from-home opportunities. The goal is to educate and inform readers about the evolving landscape of online marketing and how individuals can explore remote work options in this field. Responsibilities: Write well-researched and engaging blog posts (500-1000 words each) focused on various aspects of digital marketing (SEO, social media marketing, content marketing, email marketing, etc.). Provide valuable insights on how individuals can get started in digital marketing and secure work-from-home opportunities. Offer tips on how to build a successf...
I'm looking for a skilled Excel expert with a strong background in Python web scraping. The task involves: - Auto extraction of data from the NSE/BSE website. - Creation of a daily report in Excel representing the daily position. The report should include data represented in tables and text summaries. If the initial work is completed to satisfaction, there will be opportunities for future modifications and changes. Payment will be as per industry norms.
I need help extracting mixed data from an Excel file to a CSV template. I have a car service schedule, I want to extract the details into excel to include all the service description for each car model at each service interval, what is the labour cost, what is the labour hours and what is the total cost.
...for each. Your task will be to find and provide images that meet the following requirements: ✅ Image Size: 1000px width × 452px height ✅ Inner Gap: Around 32px for consistent spacing ✅ Angle & Consistency: Must match the sample image I provide ✅ Shadow Effect: Required for a professional look ✅ Accurate Details: The make, model, and body type must exactly match the provided Excel sheet I will supply the list in an Excel file along with a sample image for reference. Your job is to ensure all images maintain the same angle and style for uniformity. Ideal candidate should have: - Experience in image sourcing and editing - Familiarity with vehicle makes and models - Proficiency in using image editing software Looking forward to working with you! Let’s creat...
...is the perfect opportunity! ??? ????????????????: ✅ Full-cycle recruitment management ✅ Payroll and performance management ✅ Employee relations and policy development ✅ Day-to-day HR operations ??? ????????????: ✅ Minimum 3 years of HR experience in the manufacturing industry ✅ Proficiency in MS Office (Excel, Word) and HR management systems ✅ Strong communication and teamwork skills ✅ Knowledge of labor laws and regulations ✅ Mandarin speaking skills are preferable. ✅ Ability to work under pressure and a strong sense of responsibility ???????? ??? ????????????s: ? Competitive salary (RM 6,000 - RM 8,500/month) ? Annual performance bonus (1-2 months' salary) ⏰ 5-day workweek (8:00 AM - 6:30 PM) ?️ Meals and accommodation provided ? EPF, SOCSO, and EIS contributi...
I need a skilled professional to recreate my Excel spreadsheet. The goal is to enhance its visual appeal and lock specific formatting elements to prevent alterations. The final product should be visually aligned with my brand's colours, which I'll provide. Key Requirements: - Recreate entire spreadsheet with an appealing design - Locking of Column/Row sizes - Implementation of provided brand colour scheme - No need for formulae, focus on aesthetics Ideal Skills: - Proficient in Excel - Strong design sense - Familiar with brand colour implementation - Attention to detail
I'm looking for someone to help me enter data from a series of screenshots into a sortable Excel spreadsheet. The data is mixed (both text and numbers) and needs to be categorized and described as per its respective column. Key Requirements: - Proficient in Excel and data entry - Able to accurately transcribe mixed data from screenshots - Familiar with categorizing and describing data Specifics: - The data will need to be sorted by state in the Excel spreadsheet. - The specific columns in the spreadsheet include 'Category' and 'Description'. - I will provide a sample layout for data. Ideal Skills: - Attention to detail - Ability to work independently - Previous experience with data entry from screenshots or imag...
Only minor thing to do, can be done in 1 hr Follow instruction, I will give content to replace one by one. NO DESIGN
...experience applying statistical concepts to a real-world scenario. Specifically, you will analyze the relationship between poverty rates and cancer-related death occurrence rates from a supplied data set of over 90% of counties in the United States. Your calculations will be executed in Microsoft Excel, and you will produce a written report that contains your analysis along with graphs, charts, and tables generated in Excel. To prepare for this assignment, you should: ● Download and review the associated Excel file ● Download and review the report template ● Watch the video guide for this project found in the Blackboard content folder. Instructions for Completing this Assignment Imagine that you have been hired as a data analyst for the health department. Wh...
I have ongoing work related to our previous project 'Direct Mail Marketing Campaign -- 2'
Tasks to complete and send back Format pivot Create pivot table by customer name, warehouse, document description showing aging balances (all aging buckets) Manually add a summary/comment column to pivot table for comments/notes to be added by warehouse AR data for testing – v-lookup From tab named consolidated – add data on columns O and P into tab named AR Data 2-15-24
I need an Excel spreadsheet expert to create a system that categorizes multiple input text values into predefined categories, producing corresponding categorical outcomes as output values. Key Requirements: - Proficient in Excel with a deep understanding of its functions and capabilities. - Experienced in handling and analyzing text data in Excel. - Ability to create multiple output values based on multiple input values. Ideal Skills: - Excel - Data Analysis - Text Processing in Excel - Creating Categorical Outcomes in Excel
I need a software that can track both food and beverage items consumed daily based on an excel sheet of our item-based sales report. Key Requirements: - The software should process an XLSX sales report, calculating the quantity of each item sold (e.g., burger buns, lettuce, sauces, etc.) based on sales of meal sets (e.g., burger meals). - The software needs to track both food and beverage items. - After processing the sales report, the software should update the stock quantity in an internal database. Ideal Skills & Experience: - Proficiency in software development with a focus on data processing and inventory management. - Experience working with Excel and internal databases. - Understanding of food and beverage item tracking would be an advantage.
I'm looking to build a targeted email marketing list of residents with homes in Cape Cod, Massachusetts. The list needs to be comprehensive, accurate, and formatted correctly, as specified below: - Format: The email list should be provided in an Excel spreadsheet. - Content: The list needs to include the full name, email address, and home address of each resident. - Email Verification: All email addresses need to be verified via a double opt-in process, ensuring the list is composed of real, engaged individuals. Ideal candidates for this project should have prior experience in data collection and email list creation, particularly focused on real estate or local demographics. Familiarity with the double opt-in verification process is crucial. Please provide a bid if you...
My Excel 365 project has radio buttons that are not displaying correctly. Unfortunately, I am unable to pinpoint when the issue first occurred or if it is linked to a specific Excel sheet or file format. I need an Excel expert who can troubleshoot this display issue. A strong understanding of Excel's functionalities, especially with radio buttons, is essential for this job. Please reach out if you have the skills to assist me in resolving this issue.
I am looking for a person familiar with Odoo and Excel to create a sales report that pulls data from Odoo into excel to generate a top level sales report by customer with filters for sales person, state etc. Sample excel sheet is attached. So you must be able to open this sheet, select the year to report and click refresh and it must pull the current up to date data directly from Odoo and present the report at any time. I think this is a fairly simple report, but the critical thing is to get it in excel and looking to Odoo data. Looking at the attachments, here is some additional info. Sheet 1 is the sales report • User inputs the Calendar year they wish to report on and clicks run or refresh and the sheet pulls data from Odoo. • Every customer for...
I need help reviewing 6-10 PDF quotes. Your task will be to extract common part numbers and descriptions, putting them into an Excel file. All relevant information is provided in the attached Excel sheets. This should take no more than an hour. Ideal Skills: - Proficient in Excel - Attention to detail - Able to work quickly and efficiently.
We are needing to take an existing excel sales activity dashboard and add functionality, an executive summary based on inputs.
- 400 + Links in a month. - Domain Authority (DA)-/ 30 + 50, 60, - Page Authority (PA) -/ 60 + / 50, 40, - Performance Tracking and Reporting - 100% Manual Work
convert 3 tax checklists from word into fillable pdf with option of check boxes for yes/no each check list is about 3-4 pages and there are some general fields like first name last name etc, as well as the options for list like do you have employment income - click the box for yes.
I've created an Excel self-assessment for a client, but the radio buttons are not appearing correctly for some users. They all use Excel 365 on Windows. I need an Excel form expert to help troubleshoot this issue. Ideal skills for the job include: - Proficient in Excel, particularly form creation - Experience with troubleshooting Excel issues - Familiarity with Excel 365 - Knowledgeable about cross-user form discrepancies
I'm in need of a skilled Excel professional to help me create a new VLOOKUP formula. The data I'm working with is mixed - including both text and numerical data. The VLOOKUP will need to pull data from different worksheets, so experience working with multi-sheet Excel files is crucial. Ideal Skills: - Proficient in Excel, specifically with VLOOKUP. - Experience handling mixed data types. - Familiarity with navigating and pulling data from different worksheets.
I'm seeking a proficient Excel expert to create a Cost of Food Tracking sheet for me. This sheet will enable me to log all my food purchases against their corresponding events or meals. Furthermore, I need to be able to input the sales dollars for these events, which will allow the sheet to automatically calculate the food costs associated with each individual event. Ideal Skills and Experience: - Proficient in Excel with excellent data handling skills - Previous experience in creating tracking or accounting sheets - Understanding of food cost calculation in catering or restaurant context would be a plus - Ability to deliver a user-friendly and efficient sheet Please note, I do not require any specific templates or layouts. You have the creative freedom to design a sh...
I'm looking for an Excel expert who can create a mail merge template for me. Here's the breakdown of what I need: - The data for the mail merge will include: company name, address, phone, people, their title, email, and phone number. - The output documents should be letters - I will be generating these letters through Gmail Ideal Skills: You should have a strong command of Excel, experience with mail merges, and familiarity with Gmail.
I'm in need of a Python script that will scrape TikTok for videos related to the "Romanian 2024 November elections and Calin Georgescu". The data should be compiled into an Excel spreadsheet and the script needs to run daily. Key Scraped Data: - Video URL - Username - Views - Likes - Comments Ideal Skills: - Proficient in Python - Basic understanding of web scraping - Familiarity with the TikTokApi of Python - Excellent communication for updates and discussions Please ensure the code is error-free and runs smoothly. Looking forward to your bids.
I'm in need of a freelancer proficient in Excel. My project involves primarily data entry and the organization of text data. The data needs to be sorted meticulously by specific categories. Ideal candidate should have: - Excellent skills in Excel, particularly in data entry and organization. - Ability to understand and sort data by various categories. - Attention to detail to ensure data is accurately entered and organized.
I have ongoing work related to our previous project 'Comprehensive Diesel Delivery Brochure Design - 22/01/2024 05:11 EST'
I'm seeking a detail-oriented freelancer to assist with manually entering information from my scanned PDF receipts into an Excel spreadsheet. Key Information to Extract: - Date - Amount - Receipt Number - Received From - Payment for - Student Name - Grade Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry - Ability to follow instructions accurately. 496 Receipts to enter - see example of Receipt and Spreadsheets in files tab/section.
I have ongoing work related to our previous project 'CAD drafter for industrial construction projects'
Un formato mucho mas optimizado de la actual plantilla (adjunta) para la confección de la estadística anual de esta unidad. Necesario hablar Español para poder entendernos.
Preciso de alguém que me ajude a desenvolver uma planilha no Excel e que me ensine um pouco também
Sincronización Bidireccional de Datos en Excel mediante Lista de SharePoint y Archivo Maestro Descripción General: Se busca desarrollar una solución que permita la sincronización bidireccional de datos entre dos o mas archivos de Excel independientes (por ejemplo, y ) y un archivo maestro consolidado, utilizando una lista de SharePoint como fuente central de datos. El objetivo es que cualquier modificación en uno de los archivos se refleje en la fuente central y, a su vez, se actualice en todos los archivos conectados, permitiendo la edición colaborativa en tiempo real o con actualizaciones muy frecuentes. Objetivos Específicos: Centralizar los Datos: Utilizar una lista de SharePoint para almacenar la informaci&oacu...
I'm seeking a comprehensive list of 10,000 leads specifically from logistics or eCommerce companies in the U.S. These companies should own property valued over $5M. The leads must include the followin...the CEO or Founder of these companies. - Region: While a specific region wasn't mentioned, the leads should be from all over the U.S. Ideal Skills & Experience: - Proficiency in data mining and lead generation. - Experience with logistics or eCommerce industries preferred. - Tools to verify the property value of the companies. - Ability to provide leads in an organized manner, ideally in a spreadsheet or database. I don’t need a data scraper or data entry person, I just want someone who already has the data and can sell it to me for cheap. Looking to spend $10...
...freelancer capable of creating a comprehensive Excel spreadsheet, alongside a detailed Word report and PowerPoint presentation for a capstone project centered on the merger of Company A and Company B. - Excel Sheet: This must encompass a complete dataset spanning five years for both companies, inclusive of historical data, future projections and all M&A related calculations. - Word Report: This should cover all relevant information pertaining to the M&A, detailing the financial status before and after the merger, the financial implications and outcomes. - PowerPoint Presentation: This must effectively summarize the key findings and insights from the Excel sheet and Word report. The ideal candidate will have strong expertise in financial analysis, ...
I'm looking for a freelancer who can convert my Excel file into a PDF. The file primarily contains text and numbers. The ideal candidate for this project should have a strong proficiency in Excel and PDF software. Attention to detail is crucial as the conversion should preserve the integrity of the data.
I am currently working on an assignment focused on the German Tax system. I need someone who has expertise in German Tax system and can help in preparing excel formulas for Steuerklasse 1 to Steuerklasse 6 in excel. Ideal freelancers for this project should have: - Expertise in tax law, specifically the German system - Experience in tax calculation methodologies. I already have an excel that has basic details but the calculation is wrong. I would be happy to share existing excel file.
I'm looking for a professional to set up my GL NET MT 3000 VPN connection, enabling seamless remote work access from outside my country. Key Requirements: - Expertise in VPN configuration - Familiarity with GL NET MT 3000 - Experience with Windows operating systems - Ability to ensure secure and reliable connection Devices: - Primarily for use with Laptops/Desktops Please note: The goal is to set up the VPN for easy and secure access as if I were working from within the country.
I need assistance in creating a series of documents in Google Docs from provided Google Templates. This includes 72 weeks of Managers' Meetings and 12 days of Governing Body Meeting Minutes. All necessary data will be provided in Excel spreadsheets, and the formatting will be supplied by me. Ideal Candidate: - Proficient with administrative tasks - Experienced in Google Docs - Able to follow specific formatting instructions This task is expected to take approximately 3-5 hours. ChatGPT can be utilized if needed.
I am seeking a professional and structured pay slip template in Excel with a modern design. The template should comprehensively cover various aspects of payroll, including: - Employee Details: Name, ID, job title, SIN - Pay Period Details: Start/End dates, pay date, YTD earnings - Work Hours: Regular, overtime, vacation, sick leave, holidays - Deductions & Taxes: Federal/Provincial tax, CPP -5.85%, EL -1.58% - Benefits: Health insurance, life insurance, RRSP - .NET Pay Calculation: Earnings minus deductions - Employer & Bank Details: Company name, payment method, direct deposit The template needs to use the 2024 tax brackets and ensure accurate calculations. The layout should be clean, professional, and well-structured, reflecting a modern style. In terms of desig...
I have an Excel database containing 814 names and addresses of clients, and I require accurate, current email addresses for this list. This project will facilitate my client communication and potentially lead to a long-term collaboration, as I have many similar tasks in the pipeline. Key Responsibilities: - Find and provide accurate email addresses for the given names and addresses. - Ensure the email addresses are current and valid. Ideal Skills and Experience: - Proficiency in data mining and research. - Experience in finding email addresses for specific individuals or businesses. - Familiarity with Excel and data processing. - Excellent communication skills, as some individuals on the list are previous clients. Your expertise and capability to deliver accurate results ...
I require assistance in automating the process of populating Excel files (.csv) with data extracted from various e-commerce sites. The ideal freelancer will be: - Proficient in creating and manipulating .csv files in Excel - Experienced in web scraping, particularly from e-commerce sites - Able to programmatically collect product details and pricing information - Skilled in identifying and capturing specific product details such as names, descriptions, specifications and images - Willing to remote connect to my PC to observe the manual data entry process and build an automation tool based on it This project aims to speed up and automate the manual process of data entry. Please ensure you have the skills and experience necessary for this task.
I'm in need of a meticulous professional to sift through certain emails and enter mixed data (text and numbers) into an Excel spreadsheet. Key Tasks: - Data extraction from specified emails based on given criteria - Entering mixed data into Excel accurately Ideal Skills and Experience: - Proficiency in Excel - Excellent attention to detail - Experience in data entry and email management - Ability to follow specific criteria Looking forward to your bids!