How to compare two excel sheets for duplicates jobs
I'm looking for an expert in AWS and data processing to create an automated system for generating and sending extensive Excel reports based on credit card transactions data stored in an S3 datalake. Key Requirements: - Extract and process data using AWS Lambda - Generate 40 comprehensive reports on a weekly basis - Implement extensive data transformations and aggregations into the reports Ideal Skills: - Proficiency in AWS, particularly S3 and Lambda - Strong experience in data processing and transformation - Excellent skills in Excel - Prior experience in generating automated reports
...designer to take our existing pricing sheet mock-up and turn it into a polished, professional, and visually engaging PDF. This document will be a key piece for customer communication and will also be used by our sales team. The ideal design should clearly present our pricing information while aligning with our brand identity. Scope of Work: Design Enhancement: Use the provided mock-up as a foundation to create a refined, professional design that is both attractive and easy to understand. Brand Alignment: Incorporate our brand colors, typography, and design elements to ensure consistency with our overall brand identity. Layout & Visual Appeal: Improve the layout and organization of information so that it’s intuitive and engaging. Add graph...
I'm looking for a skilled VBA expert to assist with Excel automation. Key Responsibilities: - Automate data entry processes - Implement custom data validation rules Ideal Candidate: - Proficient in Excel and VBA - Experienced with creating and implementing custom validation rules - Able to deliver efficient, streamlined automation solutions
I'm looking for a Google Sheets specialist who can assist me with creating simple mathematical formulas. The tasks will primarily involve: - Using random letters, - Counting option and similar Ideal candidates should: - Have extensive experience in Google Sheets. - Possess strong skills in formula creation, particularly for mathematical calculations. - Be able to provide efficient and effective solutions to my needs. Please let me know if you can help. Thank you. The task is simple. The budget is 30 USD
Doing a database search for the selected databases and sending an excel sheet containing the search results
Generate excel with all courses quiz name and count of students who appeared for it
I'm looking for a freelancer who can analyze and format my sales data into a clear, tabular Excel report. Key Requirements: - Experience with Excel is a must, especially with data formatting. - Familiarity with sales metrics and how to present them in an informative manner. - Ability to meet deadlines and provide a high-quality, easy-to-understand report. The report will primarily focus on total sales, sales by product category, and sales by region.
I'm looking for a dedicated software solution for my personal cloud storage and data management needs. The software should be compatible with both Android and Windows, and the primary purpose of this service is for backup and restoration of my files. Key Requirements: - Cloud Storage: The main function of the software will be to backup and restore my files securely. - Automatic Backups: The software should come with a feature that allows for automatic backups at set intervals. - Data Management: I have an Excel sheet filled with data that I want to manage through this app or software. The data should be converted and organized into a database that I can easily navigate and manipulate. Ideal Skills and Experience: - Proficiency in sof...
I'm seeking a skilled app developer to create a comprehensive app for my mutual fund distribution business. Key Features: - Client Account Creation and KYC: The app should allow for seamless creation of client accounts and processing of KYC. - Investment Reports and P&L: Clients should be able to view their investment reports and P&L. - Auto File Upload: The app must support automatic file uploads. This includes NFOs or investments in new or existing portfolios. - Dual Role Functionality: The app should cater to both clients and admins, with appropriate permissions for each. - Push Notifications: Notify clients about account updates, investment opportunities, and important announcements. - Analytics Dashboard: Provide clients with a ...
### **Internship Role Descriptions for Whiz Tech (Unpaid Internships)** --- ### **1️⃣ AI Research Assistant (Unpaid Internship)** **Duration:** 3-6 months **Location:** Remote (Web-Based Operations) **Reporting to:** AI Development Team **Responsibilities:** - Assist in developing AI algorithms for physiotherapy applications. - Conduct research on machine learning models, motion tracking, and posture correction techniques. - Analyze patient data to improve AI-driven recommendations (with data privacy compliance). - Collaborate with developers to test AI models and suggest improvements. **Requirements:** - Pursuing/completed Bachelor’s in Computer Science, Data Science, or related fields. - Basic knowledge of Python, AI/ML...
...Arranging parties etc. I would like to start with Tracking nutrition. In this task, Myself and Wife will share audio notes of the food we took , screenshot of exercise app , etc and this needs to be tracked on an excel sheet ( along with calorie input etc) on a daily basis. We can keep sharing this on a whatsapp group and at the end of a day (or every 2-3 days) the excel sheet needs to be updated. I will share a sample excel sheet we use for calorie tracking , calorie value will be there for the usual foods we take in that sheet. For new ones you need to use websites like nutritionix or apps like healthifyme to get the information. For Body weight tracking - We will share photos of the weighing scale ...
We need an excel fully automated document for the insurance industry that can carry out the following system functions: 1) Excel to receive a word presentation from admin staff for 1 products called Rural Combined which will will contain a lot of data e.g. policyholder details, risk information e.g. names, dates of birth, property information, (risk addresses, sums insured), claims. 2) the risk information is extrapolated from the word (presumably into a CSV file and automatically driven into an excel rating calculator where it will undergo a number of functions to calculate a premium based on a set underwriting criteria where there will be rates built into the system The document will then produce a premium. 3) The information can then...
...experienced web developer to create a user-friendly website for banking product affiliate. The site should allow visitors to compare products, read user reviews and ratings, and manage affiliate links. Key Features: - Product comparison: The website should allow users to compare various banking products. - Affiliate links management: The website needs to efficiently manage affiliate links. - Credit rating links for customers: There should be links available for customers to check their credit ratings. - Customer Data Storage: The ability to store customer information is crucial. - Product Classification: The website should categorize different banking products. Essential Features: - Product Comparison: This i...
...assistant/accountant for my engineering company. This role involves a blend of administrative and financial responsibilities. Key Responsibilities: - Managing schedules and appointments - Handling financial records and bookkeeping - Processing invoices and payments - Preparing and submitting expense reports Essential Skills: - Proficiency in accounting software, particularly QuickBooks and Excel - Excellent organizational skills - Strong communication abilities -Familiar with google drive/sheets/earth Experience in the engineering sector would be a plus, but not necessary. What is crucial is your ability to handle the finances of a growing company with precision and professionalism. Role is for one big data entry project to start along with ...
I'm in need of a data entry expert who can assist me in compiling and entering mixed data sourced from online databases into a database. Ideal Skills and Experience: - Profic...with a focus on mixed data (both numeric and textual) - Experience working with online databases - Familiarity with database software and tools - Detail-oriented with a strong focus on accuracy - Able to manage time effectively to meet deadlines - Experience in querying databases using SQL or other querying languages - Strong skills in data cleaning and preparation - Expert proficiency in Microsoft Excel or Google Sheets for data manipulation Your role will involve: - Sourcing mixed data from various online databases - Accurately entering this data into a database The expec...
I'm seeking an Excel expert who can help me create a spreadsheet for analyzing viewing and analysing our machine assets and what stage of 'hire' they are on. Should have the ab ability to pick an asset and see the next 6-12 months, or pick a month, set of month, have one view of all assets etc Key Tasks: - Design a user-friendly Excel spreadsheet tailored for viewing and analyzing - Focus on tracking the 'Asset Hire Status'. The ideal freelancer should have: - Extensive experience with Excel, particularly in designing spreadsheets for data analysis. - Strong understanding of operational metrics. - Ability to create a spreadsheet that can track specific metrics effectively.
...reliability in your datasets. 2. Excel Proficiency - Advanced Excel Skills: I possess extensive knowledge of Microsoft Excel, including advanced functions, pivot tables, and data visualization techniques. This allows me to not only input data but also analyze and present it effectively. - Macros and Automation: I can streamline data processes through automated solutions using Excel macros, saving you time and reducing manual errors. 3. Attention to Detail - Thorough Review Process: I am meticulous in my work and perform multiple checks to ensure completeness and accuracy. My commitment to detail means that errors are minimized, and the integrity of your data is preserved. - Customized Solutions: I understand that every project h...
I'm in need of a professional who can assist me in collecting customer information. The data collection will be primarily through online forms, and the collected data should be organized in an Excel spreadsheet. Ideal Skills and Experience: - Proficient in data collection and management - Experienced in using online forms for data collection - Skilled in organizing data in Excel - Attention to detail to ensure data accuracy
Project Title: Looking for Skilled Content Writers, Typists, Translators, and Data Entry Experts 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. Requirem...
I'm seeking a ski...mobile app developer to create an iOS application to manage my loan business. The app should handle various loan parameters and client data, and automate calculations and notifications. Key Features: - Client data management - Loan amount tracking - Interest calculation - Timeframe for repayments - Notification system for due payments - Investor tracking for each loan - Capital totals for investors - Monthly interest calculations for each investor - Active/settled loan status toggle - Automatic Excel database updates Ideal Skills: - iOS App development - Database management - Excel integration - Notification system implementation - Financial software development experience The app should support m...
I'm in need of a Google Sheets Expert to create a user-friendly Employee Attendance Tracker for me. This system will track punch-in/punch-out times for a small team of 1-10 employees. Key Features: - A Google Sheet where employees can log their daily work hours. - Automatic calculations of total hours worked per day. - A summary section that updates daily to track monthly totals for each employee. - User-friendly design to facilitate ease of use. - Protection mechanisms to prevent accidental changes. - Basic error checks to prevent incorrect data entry (e.g., preventing a punch-out before a punch-in). Deliverables: - A fully functional Google Sheet template. - Clear, written instructions on how to use the s...
...an Excel spreadsheet format. Key Components of the Project: - Inventory Report: This should detail our current stock levels, any shortages or surpluses, and projected needs based on current production rates. - Production Metrics: The report should include total units produced, production efficiency, and downtime causes. This will help us pinpoint areas for improvement and better understand our overall productivity. - Provide batch tracking information to trace inventory items through their production stages. - Include inventory turnover rate to assess how effectively inventory is being managed over time. - Include cost analysis regarding holding and ordering inventory to optimize financial efficiency. Ideal skills for this project incl...
I need an Excel data dump sheet designed to mimic the look and feel of my personal expense dashboard. This includes using the same colors as the dashboard. It should be tailored to incorporate specific safety categories, with the data arranged to display correctly on the graph. The ideal freelancer for this project should have - Extensive experience working with Microsoft Excel - Strong design skills to match the dashboard aesthetics - Understanding of safety data categories - Proficiency in creating Pivot Tables
I have an existing school schedule in Excel that I need to be reformatted to match a specific design/template I will provide. The ideal freelancer for this project should be proficient in Excel and have a keen eye for detail to ensure the new schedule looks exactly the same as the template. Please note that I have a file ready to upload which contains the specific design/template. Your task will be to replicate the original schedule into this new format. So I need it to add the speech class that I have on the printed paper that I’m holding , but I need it to be like the photo with the yellow highlights and everything
... Eligibility & Compliance Risk – Errors in applicant eligibility determination, failure to meet federal/state guidelines. Operational Risk – Staffing shortages, inadequate training, or system failures. Fraud & Abuse Risk – Applicants or vendors misrepresenting information. External Risks – Economic downturns, policy changes, or utility rate fluctuations. Step 2: Assign Weights to Each Risk Factor Not all risks are equal. Assign a weight (%) to reflect their relative importance. Example: Risk Factor Weight (%) Financial Risk 30% Eligibility & Compliance 25% Operational Risk 20% Fraud & Risk 15% External Risks 10% Total 100% Step 3: Score Each Risk Factor Use a scale (e.g., 1-5 or 1-10) to assess risk seve...
i run a small campground… about 80customers. I have created an account includes all services selected by the customer (at the top). The bottom portion is a running account of costs incurred over the season. I share links to each worksheet to the respective customer. Would like to find an easy and quick way to merge this with a database of all customers info so that the top selections of the account sheet can get pre-filled. And sheets created for each customer.
...We seek an experienced web developer to create an interactive, user-friendly Newcomer Credit Finder tool. This digital resource will empower newcomers to Canada, including permanent residents, refugees, and international students, by simplifying access to tailored credit products such as credit cards, loans, and mortgages, fostering financial stability and independence. The tool will integrate seamlessly with our existing Squarespace website and prioritize ease of use, accessibility, and responsiveness. The goal is to create an informational directory where users can search and filter through credit products offered by banks, credit unions, and others, accessing detailed product information. Product detail pages will open in new tabs, allowing users to...
I'm seeking urgent help with two practice exercises relating to effective RSI calculations for steel stud walls and thermal gradient & dewpoint plotting. - Areas of Focus: The project specifically involves both effective RSI calculations for steel stud walls and thermal gradient & dewpoint plotting. - Data: I have some initial data and calculations prepared, but it's only partial. - Explanation: I require both steps and final results to be explained to me. Ideal Skills and Experience: - Proficient in Excel and familiar with 2023 National Building Code, Alberta Canada Edition. - Experience in dealing with thermal and structural calculations. - Ability to explain complex concepts in a simple, understandable way. -...
I'm looking for a comprehensive spreadsheet that will help me manage a speaker management system for an event series. Excel Specification: Speaker Management System Workbook Structure Sheet 1: Dashboard Quick overview of upcoming events Key metrics (number of confirmed speakers, pending approvals, etc.) Deadlines tracker Budget utilisation summary Monthly Event Sheets (Jan-Dec) Each month that has events will have its own sheet containing: Section 1: Event Details (Frozen Top Section) Event Title Date Range (usually 1-4 days for each event but 2 speaker days) Venue Location Target Audience Total Budget Budget Remaining (formula-calculated) Event Website URL Section 2: Speaker Management Grid Columns: Speaker Name Ju...
I have a portrait photo with uneven lighting that needs to be corrected. The areas that need the most attention are behind the hair and around the head. I would like the lighting to be adjusted in a way that enhances the natural look of the photo, rather than creating dramatic effects. Ideal skills for this project include: - Proficiency in photo editing software like Adobe Photoshop or Lightroom - Experience in portrait photo editing - Ability to enhance natural lighting Freelancers with a keen eye for detail and a knack for subtle adjustments will excel in this project. Please provide samples of previous photo editing work, particularly portrait photos, in your bid. The final edited photo should be provided in JPEG format. The original...
...after. I will be reporting all "false bids" to Freelancer. This file will remain IN WORD. An excel file can be used to attain external data such as addresses and contact information. Payment will be made on COMPLETE project with no partial payments. Our quotations are made from a MS Word document. I am looking for someone to modify this quotation document with the following information. Please indicate if these requests are feasible without any 3rd party software and preferably form only 1 outside excel file for data. We will create an Excel “Contacts” document that will contain all our customer information. This data should be able to be pulled into our quotation. Company Name, address, contact name, ...
More details: What format would you prefer for the email addresses? Excel spreadsheet How many local authorities are you targeting? More than 50 What specific information do you need besides email addresses? Contact names, Phone numbers, Email addresses The project needs to be completed within 1 week. Please verify all email addresses to ensure accuracy. These email addresses will be used for outreach campaigns targeting local authorities. Please include the contact departments associated with each email address. Please categorize the email addresses by region. Please conduct manual verification to ensure the accuracy of the email addresses. Please treat all regions with equal priority. The primary purpose of this outreach campaign is ...
I'm looking for an Excel expert who can create a Google Sheet for tracking my cryptocurrency portfolio. The sheet should monitor Bitcoin (BTC) and Solana in real-time, displaying market prices, portfolio movements, and gain/loss metrics. It should also feature Line charts, Bar charts, and Pie charts to visualize the data. Key Requirements: - Proficiency in Excel and Google Sheets - Experience in creating real-time data tracking tools - Ability to create and integrate various types of charts Ideal Skills: - Strong understanding of cryptocurrency and market tracking - Excellent data visualization skills - Attention to detail to ensure accurate tracking of gains and losses
I'm in need of a professional who can develop a method to link multiple Word documents with various Excel files. The goal is to create a comprehensive mapping matrix to facilitate process automation. Key Requirements: - Mapping of diverse data types: This includes text, numbers, formulas, assessment questions and workbook content from the Word documents to the Excel files. - Establishing a Many-to-Many relationship: The project involves linking multiple Word docs to multiple Excel files, ensuring a well-structured and efficient mapping system. Ideal Skills: - Proficiency in Microsoft Word and Excel - Expertise in creating mapping matrices - Experience in process automation Your bid should reflect your ability ...
RFP for Order Management Web Application - Initial Phase 1. Introduction We are seeking proposals from qualified vendors to develop an order management web application. The initial phase of this project will focus on core functionalities like order creation and invoicing, with a simplified user role system (admin and non-admin) and no external integrations. 2. Project Scope 2. Implement a search function to quickly locate orders using various filters such as customer name, order ID, or date range. 3. Allow exporting orders and invoicing data in various formats like CSV, PDF, and Excel for external reporting or bookkeeping needs. 4. Set up email or SMS notifications for important events like order creation, completion, and shipping updates. 5. M...
I need an Excel spreadsheet template for a quality control inspection report tailored for a machine shop. Key Requirements: - The template should include an inspection checklist - There should be a section for Pass/Fail criteria - The template should be user-friendly and easy to navigate - The design should be professional and suitable for a machine shop context Ideal Skills and Experience: - Proficiency in Excel - Experience with quality control processes in machine shops - Ability to create clear, concise, and professional templates
I'm in urgent need of an Excel macros specialist who can help with data analysis and reporting on financial data. Key Requirements: - Expertise in Excel macros, specifically for data analysis and reporting. - Proficiency in handling and interpreting financial data. - Ability to create summary reports from complex datasets. Ideal candidates will have a strong background in finance and data analysis, with a track record of creating effective Excel macros. Please be prepared to showcase examples of your previous work in this area.
Vision To develop a B2B SaaS platform enabling businesses to capture, analyze, and report climate data (Scope 1, 2, and 3 emissions). The platform will offer robust reporting capabilities (BRSR, GRI), sector-wise peer benchmarking, and customizable dashboards to empower organizations in achieving their sustainability goals. 2. Target Audience Primary Users: Sustainability teams, ESG analysts, and compliance officers in medium to large enterprises. Secondary Users: C-suite executives, auditors, and regulatory bodies. 3. Features and Scope A. Login Page Requirements: Email/password-based login with "Forgot Password" functionality. Company logo display. Option for Single Sign-On (SSO) for enterprise users. B. Home Tab (Landing Page) Conten...
...information or duplicates from the PDF, please add them to the spreadsheet at the bottom, leaving a few spaces from the other data currently on the sheet. The Excel spreadsheet contains the homeowners' information, so if you find any missing homeowners or street addresses, search for the information in the homeowner Excel spreadsheet. Any duplicates should also be indicated at the bottom of the provided Excel spreadsheet. (Copy and paste) Note: In the Excel spreadsheet, highlights indicate duplicate homeowners, such as husband and wife. The second document is a PDF is the information we have in the system. First, verify each homeowner on the map to ensure they are inputted in our system (PDF Second Attachment). If you...
Description: We are looking for an experienced freelancer or team to extract data from a large volume of PDF files. Due to the scale of this task, we prefer candidates who can develop automated scripts for efficient data extraction or those with a team capable of handling bulk processing. Requirements: • Expertise in Python or other relevant programming languages for PDF parsing • Experience with libraries such as PyPDF2, PDFMiner, or similar tools • Ability to extract structured data accurately (tables, text, etc.) • Handling of different PDF formats and layouts • Data output must be in Excel (.xlsx) format per template provided. Preferred Qualifications: • Prior experience with large-scale data extraction &b...
...percentage. Working and goals of this website is to provide a platform to visitors to contribute to n number of surveys we conduct. The survey will focus on understanding the community stats of today to predict future goals and challenges. is a "Non-profit Analytica Organisation" this is how I like to describe. How we choose a survey to publish, we have a dedicated team working on current affairs and study the changing surroundings and post making our intrest we dive into creating a deep looped questionnaire related to the topic. The questionnaire with set parameters need to be uploaded on the site for the visitors to take the survey with a description of the survey and its importanc...
I'm looking for a professional to help me fill out an Excel sheet for a financial model. The sheet will involve data from the Income Statement, Balance Sheet, Cash Flow, Operating Working Capital, debt, depreciation, amortization, equity, shares, and various financial ratios. The annual report is available for reference. Skills and experience required: - Extensive knowledge of financial modeling - Proficiency in Excel - Ability to interpret and analyze financial statements - Experience working with financial ratios - Attention to detail.
I'm looking for a professional to review my medical bills, specifically hospital bills and prescription costs, and compare them to my insurance coverage. I have some insurance documents, but not all, so assistance in obtaining the necessary documents will be needed. Key tasks: - Review of hospital bills and prescription costs - Comparison of these costs with insurance coverage - Help in obtaining necessary insurance policy documents Deliverables: A detailed report of discrepancies and analysis. Ideal skills for this job include: - Knowledge of medical billing and insurance - Strong analytical skills - Excellent report writing skills Experience with medical bill auditing or insurance claim analysis would be a significant advantage.
I'm looking for a freelancer who can build a comprehensive dashboard in Excel for tracking employee performance data. Key Requirements: - The dashboard should track 16 key performance indicators (KPIs) related to equipment conditions. - Visual elements should include charts, graphs, gauges, and meters. I already make it but need to enhance and also to add more slides. Ideal Skills: - Proficient in Excel with experience in building dashboards. - Understanding of employee performance and equipment condition metrics. - Capable of creating user-friendly, visually appealing dashboards.
I'm in need of a reliable and efficient professional to assist with various administrative tasks. The job mainly involves data entry, email handling, and scheduling appointments. Your main responsibilities will include: - Data Entry: Accurately inputting information into Microsoft Excel/Word. - Email Handling: Managing my inbox, sorting emails, and responding to necessary correspondence. - Scheduling Appointments: Coordinating my calendar and setting up meetings. - Travel Arrangements: Booking flights, hotels, and transportation for business trips. - File Management: Organizing and maintaining digital and physical files. - Document Preparation: Creating and editing reports, presentations, and other documents as needed. - Meeting Minutes: Taking detailed n...
I'm looking for a freelancer who can analyze and format my sales data into a clear, tabular Excel report. Key Requirements: - Experience with Excel is a must, especially with data formatting. - Familiarity with sales metrics and how to present them in an informative manner. - Ability to meet deadlines and provide a high-quality, easy-to-understand report. The report will primarily focus on total sales, sales by product category, and sales by region.
I'm looking for an experienced Excel professional to compile a calendar for 2025 and 2026. This will include marking work tasks and deadlines, 2nd & 4th Saturdays, Sundays and all Hindu holidays. Key Requirements: - Organize data week-wise in an Excel sheet - Distinctly mark 2nd & 4th Saturdays and all Sundays - Highlight all Hindu holidays and list them in a separate column - Use Conditional Formatting and Pivot Tables to ensure easy readability and proper formatting Ideal Skills: - Proficiency in Microsoft Excel (Formulas, Conditional Formatting, Pivot Tables, etc.) - Data Entry & Processing - Attention to detail - Experience handling large datasets Deliverables: - Well-structured Excel sheet - Clearly ma...
I'm seeking a meticulous Data Entry Operator to assist with inputting and structuring data into Microsoft Excel. The job will entail: - Transcribing data from a variety of sources including scanned documents, PDFs, and handwritten notes into an Excel spreadsheet. - Ensuring the accuracy of the data and catching any potential errors. - Structuring the data chronologically for easy access and retrieval. - Upholding confidentiality when dealing with sensitive information. Ideal candidates should have: - A good typing speed and a high degree of accuracy. - Proven experience with Microsoft Excel or other data entry software. - An exceptional attention to detail. - The ability to meet deadlines consistently. Project Duration: 1-2 weeks (p...
...an individual or team to compile a detailed list of various businesses in Las Vegas. The types of businesses I'm interested in include med spas, nail salons, hair salons, dermatologists, laser hair removal centers, cosmetic and plastic surgeons, permanent makeup and microblading salons, Hormone Replacement Clinics, IV therapy clinics, chiropractors, gyms, yoga and pilates studios, dentists, weight loss clinics, red light therapy centers, day spas, anti-aging clinics, cryotherapy centers, alternative medicine centers, aesthetic clinics, tanning salons, Korean beauty clinics, eyebrow studios, lash studios, hair restoration clinics, scalp micropigmentation centers, tattoo shops, regenerative medicine facilities The information I require for ...
