Data cleaning excel macro jobs
Hello, we work in telecommunications and trading "capacity" such as submarine cables, satellites, fiber, etc. is very complex as every hour we get a lot of requests and offers - tracking these in an excel takes a lot of time and we lose opportunities. I need an AI based tool that : 1 - structure on an excel file or Sql database ALL the capacities that we have and that keep coming every hour. I will provide the structure and the route 2 - a tool that reads in my emails and whatsapp conversation and can extract and fill the database. For example "hello Tony, how are you - I have an urgent need of 100MB of Internet in New York, my target price is 10K USD" -- this would have to be properly read, extracted and summarized for my approval before being inserted....
Here's what I need: - Conversion of my PDF file to Excel. Each page of the current PDF must be transferred onto a separate sheet within Excel. - Absolute precision is critical in the conversion, it needs to be 100% accurate. Double-checking of the converted data against the original PDF is expected to confirm accuracy. - The PDF holds only text data, there's no requirement for converting any figures or tables into Excel. Ideal candidates should have: - Proficiency in data entry - Attention to detail to ensure error-free data conversion - Experience in converting PDF files to Excel - Ability to proofread and find any errors in the converted data.
...professional to work with numeric data and perform some basic mathematical operations on it. The final output should be in the form of excel sheets. Key tasks would include: - Data operation: Efficiently manage large amounts of numeric data - Calculation: Perform basic mathematical operations on the data - Data formatting: The final output should be well-organized excel sheets An ideal candidate for this project will have proven experience in data management and Excel spreadsheet functions. Attention to detail and accuracy in conducting calculations is crucial. Familiarity with basic mathematical operations is a must. A background in data analysis or related field would be a plus. This project requires technica...
I'm in search of a seasoned freelancer with proficient skills in Excel data entry. Tasks will primarily involve the input of a mix of numerical and textual data into spreadsheets. Desired Skills: - Moderate expertise in Excel for creating and applying straightforward formulas. - Experienced in data entry from various sources. - Attention to detail with the ability to accurately compile and enter mixed data. The ideation candidate should have a proven track record of handling similar data entry tasks. Your role will be integral to the organization and interpretation of vital information, hence, precision and consistency are paramount.
I'm in need of a meticulous researcher with strong data mining skills to uncover detailed contact information related to specific mobile phone numbers. I have First nameLinkedIn, email, last name and I need a complete direct phone number and mobile number Primary Task: - Retrieve contact details, specifically direct phone number, mobile phone numbers. Required Sources of Information: - Search through public directories. - Utilize social media platform insights. - Access telecom databases. Ideal candidate should have a demonstrated history of effective and compliant data mining. They should excel at search strategies and have familiarity with browsing multiple types of databases for information retrieval. A background in telecom, information technology, or a re...
I'm in need of a seasoned professional to create a dynamic, easily fillable form in either Word or Excel. This form needs to be highly versatile, accommodating various input types and behaviors. Key features desired include: - Conditional color changes based on text inputs, selections from dropdowns, and checkbox checks. - Seamless conversion to PDF once filled out by our team. Expertise in creating dynamic, interactive forms and firm understanding of input condition coding are essential in order to be successful in this project. I need this project completed as soon as possible, so proficiency under tight deadlines is another critical skill. Attached is the template form for your reference. The template I attached was designed by one of our employees, looks very basic desi...
I need a freelancer adept at Excel and Visual Basic for Applications (VBA) to assist with a project that necessitates basic data manipulations and formulas. The application is primarily dealing with both numerical and textual data. The ideal candidate should possess: - Proficiency in Excel functionalities and VBA scripting. - Experience with handling diverse data types like texts and numbers in Excel. - Ability to quickly comprehend and effectively manipulate data structures using VBA. Kindly submit your bids if you meet these requirements and can efficiently solve complex data problems.
I'm in need of a dedicated data entry specialist, who is adept with invoice processing in various formats; PNG, JPEG, and PDF. Key Responsibilities Include: * Accurately entering invoice data into Microsoft Excel spreadsheets. * Ensuring adherence to specific formatting requirements, details of which will be provided upon project commencement. A deep understanding of Microsoft Excel and precision in data entry is crucial for this role. Experience with processing invoices is highly desirable. Attention to detail and maintaining the integrity of confidential information are also essential for this project. Project Description: We have a pressing requirement for a meticulous and detail-oriented freelancer to assist us with data entry tasks....
Mandator Skills-The person should be able to coordinate with SAP Basis, DC Windows, Other vendors, Plant folks and get the work done. Track in Excel. This all, apart from his core SAP PP/WM ( Warehouse management ). SAP PP/WM Expertise: In depth understanding of SAP PP/WM modules including configuration, customization, and integration with other SAP modules. (Min 2 e2e implementations) Strong understanding of SAP Printing functionality and setup Ability to troubleshoot SAP Printer issues in PP/WM disciplines Proficiency in SAP PP functionalities such as MRP (Material Requirements Planning), production orders, capacity planning, etc. Excellent written and communication skills to interact with stakeholders, team members, and vendors. Individual contribut...
More details: How do you envision the Monte Carlo Optimization Simulation Equation improving roadway work zone safety? Identifying high risk areas, Optimizing safety measures, Reduci...the Monte Carlo Optimization Simulation Equation improving roadway work zone safety? Identifying high risk areas, Optimizing safety measures, Reducing accidents and fatalities Are there any specific safety measures or strategies in place currently at your roadway work zones? Traffic control devices, Speed reduction zones, Warning signs What data or inputs will be used to perform the Monte Carlo Optimization Simulation? Traffic flow data, Accident history data, Work zone layout, Work zone speed limit, Work Zone Length, Work Zone Time Duration, Time of the day work is performed, Presence ...
I am seeking a diligent and accurate freelancer who can perform a data entry task for my project. - This requires transcribing text data from a range of PDF documents accurately into an Excel spreadsheet. - You should have strong attention to detail to ensure all data is transferred correctly and exactly. - Ideal candidates will have a proven track record working with PDF documents and Excel. - You should be competent with data entry tasks and efficiently working within an Excel format. This task may require you to decipher complex information from the PDFs, so excellent comprehension skills are also necessary. An understanding of keeping data organized and accessible within Excel is a must.
...Meters. User Verification and allow Manual Edit. * Geo Location of Each Meter Reading In-depth understanding of secure platforms, strong database management skills are required for the web portal component of this project. Web Portal Key Features: 1. User Logins with Rights for each user type (Admin | All Rights | Supervisor | Field Meter Reader | Billing Review | Approve Billing | Export Billing Data ..... Integrate reCAPTCHA Image for logins Ability to schedule site reading allocation to user by manager and reading progress report for site and user. 2. Property Management for Meter Usage and Service Fee Charges: Property Profile Admin, ( Name, Address, No of Meters, Site Status, Water Billing Cycle (Monthly/Quarterly), Service Charge Billing Cycle, Water Usage/ Service Fe...
check reference image, excel insert row & copy the value from above row
I need a proficient Excel handler to quickly make significant updates to my current costing worksheet. Your task will involve: - Formatting Changes: While I don't have any specified changes in mind, I trust you as an expert to make the worksheet visually appealing and easy-to-read. - Formula Updates: You'll revamp the formulas on the worksheet for enhanced efficiency and effectiveness. Your instantaneous service delivery is highly desired given this project's urgency. Thus, Excel expertise with stellar efficiency and speed is critical.
we have pdf document created in adobe acrobat that need a bit of cleaning up to get them functional for digital signing. content is created already. We imply need fields for signing, client info, etc to be made functional. Pages total 31 for 3 documents.
We need you to find commercial cleaning companies, Indian food catering companies and security companies in Perth. If you can start on this task urgently please bid.
I'm looking for a solution that can effectively scan barcoded items and automatically update an Excel database. This needs to include: - Instantaneous data input into Excel after each scan, eliminating the need for manual updates or end-of-session entries. - Accurate inventory count post each scan, providing an easy record of stock numbers. Ideal freelancers will have robust experience in barcode reading technology and automatic data updates. Familiarity with inventory management technology is a plus. This project requires a high level of accuracy and efficiency in data entry.
In this project, I require assistance in extracting numerical data from an existing excel sheet and placing it into a table. The extracted information should maintain the current format present in the excel sheet, without any additional emphasis on alphabetical or ascending numerical order. The ultimate aim is to create a table where the extracted data will be allocated to both rows and columns. - Ideal Skills: Proficiency in Excel and data visualization, keen attention to detail, good understanding of data organization and manipulation. - Experience: Previous work involving data extraction or conversion from excel to other formats is bit of a necessity here.
More details: What specific data do you need to fill in the Excel sheet? search for startups in 2023 you will see relevant info to fill in. What type of information are you looking to fill in for each startup? will need to create a free crunch base account and fill details in excel What specific details do you need to fill in for each startup on the Crunchbase account? Company description, Founder names, Funding details, etc. I will provide sample sheet for 2023.
I'm looking for an expert in Excel to design and develop a sophisticated program dedicated to data analysis, financial calculations, and data organization. Key Requirements: - The program needs to be condensed into a single sheet or tab. - It will be standalone with no necessity for integration with external software or apps. - Should be flexible and user-friendly to allow modifications if needed. Ideal Candidate: - Proficiency in the use of Excel is paramount. - Experience in creating similar complex spreadsheets. - A keen eye for detail and a strong understanding of financial calculations and data structuring.
I require a data expert to migrate a medium sized dataset (100MB-1GB) from MS Excel to a MySQL database. Additionally, the database requires optimization to improve query performance and enhance data retrieval speed, improving overall efficiency and usability. Upon completion of the migration and optimization, the development of a desktop application is also required. This application is to assist with data browsing, editing, and filtering in a user-friendly manner. Ideal candidates should have: - Proven experience in migrating data between different platforms - Extensive knowledge of MySQL optimization techniques - Proficient in developing desktop applications with data browsing, editing, and filtering functionalities - Good understanding of ...
Join our dynamic team at Zyre Virtual Solutions! We're seeking motivated individuals for a commissioned-based sales position with endless growth opportunities. Role Overview: Compensation: 10% of total sales plus performance-based bonuses. Ideal candidate: Experienced in both marketing and sales, with a drive to excel and lead a team of interning students. This cannidate will also have experience in affiliate marketing to build out funnels and email marketing campaigns as needed. Responsibilities include: Organic marketing, cold calling, lead generation optimization, social networking, and account demos Immediate start: few days qualification training required Language proficiency: Good to great English skills essential. Communication: Ability to connect with US clients v...
I am in need of an experienced data professional with stellar expertise in data mining, data cleansing, and data validation. Your role will primarily involve: - Extracting requisite information from chosen sources (Data Mining). - Correcting errors and inconsistencies in the data (Data Cleansing). - Making sure that the data is accurate and valuable for my business (Data Validation). All of the data to be handled will be in the format of an Excel spreadsheet. However, as a requirement, you should be proficient with Google Sheets, since this is the tool we'll be using for this project. Please note that attention to detail, efficiency and accuracy are paramount for this role. Experience in similar previous ...
I require a freelancer who has expertise in working with Excel data and automated emailing. This is what I need: - Extract specific columns only from an existing Excel file. - Create multiple new Excel files from this data. - These files must be organized according to a format I will provide in a template. - Attach these newly created Excel files to an Outlook email. - Draft the email with text I will provide. - Automate the sending of this email. The freelancer should ideally have advanced Excel skills, including familiarity with data extraction and manipulation. Experience with email automation, preferably in Outlook, is also required. A high level of attention to detail will be crucial to structure the data according to...
I'm in need of a skilled graphic designer to create and redesign striking, versatile icons for the services provided on my website. These will represent various services we offer: removals, furniture assembly, deliveries, cleaning, mobile barbers, mobile hairdressers, Man and Van, Shop and Deliver, car transport and mobile nail technician. The icons can be flat, 3D, or line styled icons. The choice is yours but they should be consistent in style and easily identifiable most importantly in line with the colour scheme on the logo. Outstanding consideration will be given to candidates with proficiency in Icon design, Photoshop, and Adobe Illustrator. Using our company's brand colors, your task is to ensure every icon carries the heart of our brand while clearly differentia...
I am seeking a detail-oriented freelancer experienced in data entry, specifically from websites into Excel sheets. The task involves manual entering of text data found on several websites into an organized Excel document. Ideal Skills: - Proficiency in English language - Fast and accurate typing skills - Experience with Excel - Previous data entry experience - Strong attention to detail No specific software is required, however, access to websites and Excel is a must. Having an eye for detail and a systematic approach would be advantageous. Familiarity with basic Excel functions is preferred to maintain structured spreadsheets. The project completion deadline is two weeks from the date of contract initiation.
I am seeking a detail-oriented freelancer experienced in data entry, specifically from websites into Excel sheets. The task involves manual entering of text data found on several websites into an organized Excel document. Ideal Skills: - Proficiency in English language - Fast and accurate typing skills - Experience with Excel - Previous data entry experience - Strong attention to detail No specific software is required, however, access to websites and Excel is a must. Having an eye for detail and a systematic approach would be advantageous. Familiarity with basic Excel functions is preferred to maintain structured spreadsheets. The project completion deadline is two weeks from the date of contract initiation.
...session/scenarios. B) Propose an alternative for each. PART 2 – Five mixdowns + videos – A) Four stereo mixes (WAV) - 2 different mixes of each two recording sessions chosen. B) One Immersive headphone mix (WAV) - from any of the sessions (and can be different from the session used for your regular stereo mixes). C) Five walkthrough videos. One for each mix submitted. PART 3 - Kit proposal (EXCEL or EXCEL exported to PDF)...
I need a custom Windows executable program built that converts .pdf files into Excel (.xlsx) files. The program should take files from a pre-defined folder and leave the converted Excel files in the same location. Key requirements include: - The program should have no external inputs or outputs - Each PDF page should be converted to a separate Excel sheet - The program needs to only process files in the specified folder, with no need to process sub-folders Ideal candidates for this project would have a strong background in software development, specifically with expertise in Windows applications and file conversion programming. Experience with PDF layouts and Excel file structure will also be greatly beneficial. Experience with Python may be useful.
I'm seeking an experienced individual who can assist in formatting my Excel spreadsheets and creating informative charts/graphs. Specific tasks include: - Organizing existing data into cohesive tables - Crafting graphs to illustrate data points in an easily digestible format The data specifics were not provided but given its complexity, your experience in organizing diverse data types would be beneficial. Proficiency in Excel with a strong understanding of data analysis is expected. Your ability to present data in clear, comprehensive ways will be extremely valuable in this project.
I am attaching a file that includes the current output with notes. You can see yellow highlights as to what needs to be corrected in the existing code. Then I need a second macro to output data into the DoD_merge template. I added notes to that docunment.
We are looking for an experience IT Recruiter to help IDENTIFY potential candidates to some of our roles in the Mexico Market. Principal profiles: -Software Developers (Java, Python, .Net, JS,) -Mobile developers (android, iOS) -Architects -QA (Automation tester, Manual tester) -Cloud ...-Cloud Engineers What you will be doing: -Linkedin Searches -Identify potential candidates -YOU DON'T NEED TO CONTACT OR SCREEN THE CANDIDATE -Work 10 vacancies per day -Present at least 10 candidates per job, per day (around 100 profiles per day) You won't be calling or screening or interviewing the candidates, just present the profile and we will do the rest. Your deliverables will be: -Word, Excel, PDF or text file, listing all the potential URL Linkedin profiles to each vacancy (...
Objective: Upgrade an existing ETL process to enhance data validation, error handling, and user feedback for structured Excel files uploaded to SharePoint 2019, for subsequent transfer to a database. The solution could be also implemented via Azure Functions and Sharepoint online if deemed possible. Existing Setup: A basic ETL process developed with the Luigi library, lacking advanced validation and user feedback mechanisms. Solution uses parsing code (Pandas) for Excel files data parsing that can be utilized for the upgrade also. There are 4 different excel files, so 4 different parsers will be provided. The system should manage four unique Excel file types, each in its own SharePoint folder, requiring separate parsers for their distinct stru...
We are currently working on an oil and gas projet. We already prepared the loads on excel, prepared the 3D models, and the load combinations. We need an experienced engineer to add the loads, and the design of the structure.
As an online business owner, I'm seeking a web designer with vast experience in user experience (UX) to perform various improvements on my existing website. Specifically, I require: - Navigation: The current layout needs a complete overhaul to make it more user-friendly and intuitive. - Page Loading Speed: My we...Page Loading Speed: My website needs to be optimized to ensure faster loading times for a better user experience. - Responsiveness: I need my website to be fully functional and responsive across different devices, from desktops to mobile phones. Although I don’t have specific examples of websites to emulate, I trust in your expertise and creativity to take my website to the next level. If you excel in creating fluid, intuitive, and fast-loading websites, this ...
I need a thorough scraping of seven websites, extracting both the text content, images, and links. Not a single element should be left...paragraphs, lists, everything. I'm not particularly choosy about the tech you use to get the job done, but it will need to be delivered in an Excel format. Ideal Skills: - Experienced in web scraping across various websites - Proficiency in using scraping tech and tools - Familiarity with Excel or similar data processing platforms - Strong attention to detail to ensure completeness of data extraction - Previous experience with large-scale data collection projects would be a bonus. Major kudos for managing data extraction projects involving multiple sites. Remember, the key here is thoroughness - I need ...
As an online business owner, I'm seeking a web designer with vast experience in user experience (UX) to perform various improvements on my existing website. Specifically, I require: - Navigation: The current layout needs a complete overhaul to make it more user-friendly and intuitive. - Page Loading Speed: My we...Page Loading Speed: My website needs to be optimized to ensure faster loading times for a better user experience. - Responsiveness: I need my website to be fully functional and responsive across different devices, from desktops to mobile phones. Although I don’t have specific examples of websites to emulate, I trust in your expertise and creativity to take my website to the next level. If you excel in creating fluid, intuitive, and fast-loading websites, this ...
I am in need of a freelancer with excellent attention to detail to enter both text and numerical data from PDF files into an Excel sheet. The work involves: - Typing data from PDF files into Excel. - The Excel sheet has between 50 and 100 columns and rows. The perfect candidate will have: - Experience in data entry - Accurate typing skills - An excellent understanding of Excel - Previous experience with PDF to Excel data transfer. All information required for this project is contained in the PDF files. Accuracy and adherence to the format and structure are vital. This is a straightforward task, yet attention to detail is crucial.
I am currently experiencing some issues with my Linux server. I discovered it has been infected with malware, consequently raising serious security concerns. I'm seeking an experienced Linux server admin to conduct a thorough check. Key tasks will include: - Detecting malware on the server - Cleaning up any identified malware - Strengthening server security to prevent future malware infections The ideal candidate should have: - Proficient knowledge on Linux Server administration - Extensive experience in diagnosing and resolving malware issues - Strong understanding of server security measures Your expertise will be crucial for enhancing the security measures on my server and ensuring it's safe from future infections.
I'm in need of a capable developer who can convert our Excel books into a MySQL-driven application. The software should include the following: - Search Functionality: The ability to quickly retrieve specific data from the database. - Data Import/Export: The capacity to smoothly import data from our current books to the application and export it when necessary. - User Access Levels: The system should differentiate user roles and permit each level to only access designated areas. In terms of security: - Basic authentication: A simple username/password login system. - Two-factor authentication: Additional security measure to verify users. - Role-based access control: Enhanced security to designate access based on role. A successful freelancer for this job...
I'm seeking an Excel expert who can proficiently extract and clean data from Microsoft SQL Server databases. Your skill set should ideally encompass: - Proficient knowledge of database extraction processes particularly from Microsoft SQL Server - Advanced Excel capabilities, particularly in data cleaning - Familiarity with data structures within databases You will be expected to apply your Excel knowledge to clean up the extracted database data and make it ready for further analysis. Previous experience with similar projects is preferred. This project will require excellent attention to detail, precision, and consistency. Familiarity with database manipulation and data extraction tools, in addition to Excel, is a ...
I'm seeking a senior level associate/assistant auditor for financial and compliance auditing tasks. The ideal candidate should demonstrate: - Proficiency with Excel for auditing tasks - Ample experience in financial and compliance auditing - Strong analytical, and communication skills - Familiarity with local audit regulations and standards - Experience performing audits in the country (Zimbabwe) Possession of relevant qualifications and previous experience in a similar role is essential.
I am in need of a capable individual who can juggle a few tasks, namely copywriting, data entry, and account management. This position is open for only US. • Copywriting: The ideal candidate should be able to effectively write content for our website, product descriptions, and marketing material. Good command over the English language is crucial. • Data Entry: Accurate and efficient data input skills are required. Experience with Excel and other data entry platforms will be useful. • Account Management: The ability to efficiently manage and maintain client accounts is essential. Experience at an entry to intermediate level (0-5 years) in these tasks is required. Overall, I'm seeking a reliable, multi-tasker with a knack for writing...
We are seeking a highly skilled and experienced Linkbuilder and Outreach Specialist to join our dynamic team. Qualifications: - At least 1 year of experience as a link builder. - English language proficiency of at least Intermediate (B1) level. - Ability to conduct business correspondence in English. - High productivity and responsibility. - Proficient in Google Spreadsheets and MS Excel at an advanced level (knowledge and ability to use formulas, filters, formatting). - Ability to quickly find required information independently. - Excellent knowledge of Ahrefs, SEMRush, and/or other web tools for backlink analysis (competitor analysis). - Ability to create specifications for content, as well as to check content for compliance with the specifications. Responsibilities: - Analysi...
I'm seeking a seasoned Social Media Marketer with prior experience in the cleaning shops industry in USA. Your main focus will be the Facebook and Instagram platforms, therefore deep knowledge and understanding of these two are highly essential. Key campaign goals include: - Increasing brand awareness - Driving website traffic - Generating leads Your proposal should demonstrate your understanding of the cleaning industry in the USA and illustrate how you would use social media to tap into the specified audience demographic. Skills & Experience: - Proven track record in similar roles - In-depth knowledge of Facebook and Instagram algorithms - Solid understanding and experience in the cleaning shops industry in USA - Demonstrable experience in audienc...
...need a skilled Email Marketing Manager for an outreach campaign targeting venues, event managers, and entertainment agencies in the Netherlands, Belgium, Germany, and France. Your main task will be to build relationships with industry professionals so that they will invite us to perform. The person must possess: - A solid background in Lead Generation - Proficiency in managing and sorting data in Excel - Email Marketing Expertise - Exceptional English communication skills In your role, you will be: - Managing and measuring campaign effectiveness - Performing lead generation and following up Showcase your ability to extend a band’s reach and deepen industry connections by applying for this role. We need a dedicated professional who knows how to strike a chord wit...
...with strong competency in Power BI, Excel, and Power Automate, knowledgeable in data analysis from GA4. The main task would involve accurately pulling data from GA4, migrating it on to Power BI for a comprehensive analysis, and subsequently exporting it to Excel using Power Automate. Key Responsibilities: - Extract relevant metrics from GA4 to Power BI. - Focus on the analysis of the conversion rate data. - Proper utilization of Power Automate to export the final data to Excel. Ideal skills and experience: - Proficiency in Power BI and Power Automate - Comfortable with Google Analytics 4 (GA4) - Experience with conversion rate analysis and reporting - Proficient in Excel The ultimate goal of this project is to streamline the a...
Our company is in the commercial cleaning business, needing a lead generation consultant that covers an extensive range of businesses. We are explicitly targeting: - Retail stores - Office buildings - Restaurants And many more Our primary goal - sales increase. To execute this, we require a campaign centred on promotional offers to entice our target audience as our research shows this is what they respond best to. Ideal skills and experience for this project: - Proven experience in lead generation campaigns - Knowledge of the UK commercial sector - Exceptional abilities in creating compelling promotional offers - Understanding of optimal customer engagement strategies - A track record of increasing sales through effective lead generation.
