Data cleaning excel macroKazi
Neme Deepak kumar s/o bhagwan das vill saraiya bhood post araul kanpur nagar
i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry i want data entry ...
hi hi hi hi hi hi h h h h h h h h h h h h h h h h h h h h h a sakjsa ;ls dsaj slk s sdskssd sj skskl
I need a professional photographer to capture my jewelry pieces for an e-commerce website. The photographs should be close-up/macro shots, showcasing the intricate details of the pieces. Additionally, I need overall views of the jewelry from different angles, including the front, side, and top. Ideal skills and experience for the job include: - Professional photography experience, particularly with jewelry - Expertise in close-up/macro photography - Ability to capture the overall view of an item from multiple angles - Previous experience of e-commerce product photography - Good understanding of the technical requirements for e-commerce photography Please provide a portfolio of your previous jewelry photography work for consideration.
G.O.A.T. – The Greatest of All Time in Football Boot Cleaning Solutions! From Mud to Match-Ready!
I'm seeking a freelancer for manual data entry from online sources. While specific data types haven't been determined, a flexible, detail-oriented individual will excel in this role. Experience with data entry is essential, and familiarity with online research will be a plus. Ideal Skills: - Manual data entry - Online research - Attention to detail - Time management - Proficiency in English
I have a picture of an Excel template that I need replicated. The template primarily consists of tables and is primarily text-based. I also need specific text formatting including bold and italics, as well as colored text. Ideal skills for this project: - Proficiency in Microsoft Excel - Attention to detail for accurate replication - Ability to format text according to specifications
I need a Power Apps application designed as a task tracker for managing hotel rooms. It ...manage rooms status as below: 1) allow me to key in the rooms for defect inspection after check out 2) if there are no defect, shift the room to cleaning 3) to view cleaning status “ not started” “ in progress” and “clean” 4) prompt the inspector that rooms are cleaned and to inspect for cleanliness. 5) if there are defect, shift it to defect room with the defect description and option to attach a photo. Ideal skills and experience: - Proficient in Power Apps development - Previous experience designing applications for the hospitality industry will be an advantage - Excellent understanding of task tracking systems - Capable of integrating data...
I have 3 Excel sheets that I need merged together. The master sheet is a list of products, while I have a separate category sheet and a separate SKU sheet. I need data from the category and SKU sheets to be merged into the master sheet by looking up the SKU and grabbing the relevant data. Ideal skills and experience for this job include: - Proficiency in Excel, particularly with data merging and lookup functions. - Experience with inventory or product data management. - Attention to detail to ensure data accuracy. Currently all files are in Google Sheets, so ideally it needs to be done within sheets or at least supplied so that it can work in google sheets I will provide a guid video on exactly how I want the data merged
I am creating a marketplace where lawyers can sell digital legal documents (e.g., .docx, .pdf, .excel) and are seeking a skilled Shopify designer and developer to design and build the platform. The platform should support multiple vendors, each with a dashboard to manage products, sales, and payments. It must be secure, mobile-responsive. Key Features: Vendor Registration: Lawyers must verify their credentials (e.g., Bar Association). Product Upload: Vendors can upload documents, add descriptions, and specify preview options. Payment Management: Integrate PayPal and credit card payments on Shopify. Single-use Downloads: Documents should be available for download only once after purchase. Preview: Buyers can preview document content before purchasing. Multivendor Dashboard: Vendors...
I need an expert data scrapper who can extract data from Google Maps, Canada. I will provide the keywords and the aim is to get 10,000 results, specifically targeting professional services. This data will be used for business outreach, so it is crucial to receive accurate and comprehensive information. Requirements: - Extract data fields including: - Email addresses - Structure the data in a specific way: - Place all email addresses in a designated column - Organize the data in separate sheets for each keyword - Deliver the final product in an Excel sheet Ideal Skills and Experience: - Extensive experience in web scraping, particularly from Google Maps - Proficient in using Excel and organizing data - Attention ...
...a master Excel spreadsheet designed and populated with data from financial documents I will provide. This will include a master page produced from all the data on the separate tabs. - Data Types: The project primarily involves working with financial data, specifically tracking revenue and expenses. - Update Frequency: The data will need to be updated monthly. Ideal skills for this job include advanced Excel proficiency, experience with financial data, and the ability to create clear and comprehensive master spreadsheets. Please provide examples of similar projects you've completed in the past. Each sheet will total and feed into the master page. I would like reports ideally that can be run on total expenses or revenue in ...
...this data is being tracked in Excel, and I'm looking for a more efficient and organized way to handle this. Key Features: - The database should capture essential data fields for each transaction. These fields include: - Account number - Amount - Date - description - some sums formulas The ideal freelancer for this project should have extensive experience with MS Access, and a proven track record of creating databases for financial transactions. They should also have excellent skills in data organization and management. Importing Data: - Currently, I am entering the data from Excel into the database manually and copy paste from bank website. The freelancer should be able to provide guidance on how to streamline this proce...
Project Overview We want to create a complete mechanical design for a mini tractor utilizing a 7 HP diesel engine. The project deliverables will include conceptual sketches, 3D CAD models, engineering drawings, bill of materials (BOM), and detailed instructions for fabrication....consolidated list of materials, standard parts, fasteners, bearings, etc. Provide potential vendor/supplier references (if known). Assembly Instructions Outline step-by-step assembly instructions (text + diagrams/screenshots). Include notes on safety, best practices, and recommended tools. Deliverables (Milestone 4) Detailed 2D Fabrication Drawings (PDF + native CAD format). Complete BOM (Excel or CSV) with part numbers, material specs, approximate costs. Assembly & Fabrication Guide (PDF/Word)...
...numerical data from tables in .pdf files, and subsequently importing these data points into an Excel sheet. The Excel sheet will also require some statistical calculations. Given the nature of this task, the ideal freelancer should possess: - Proficiency in Python and GenAI techniques, particularly for data extraction and manipulation - Strong statistical analysis skills with experience in Excel - Ability to work with diverse and inconsistent data formats The PDF files vary in structure, hence the freelancer must be adaptable and capable of handling a mix of varying formats. Please note that the focus is solely on numerical data extraction. Please see attached a few examples of what needs to be extracted from the .pdf files (in...
...effecting breathing issues, respiratory problems and associated psychological imbalances. Time of the completion of these short forms would be 10 to 20 minutes each. In the future, advanced versions of both the long and the short forms could include associtaed music, chants, sounds, medicinal foods/nutritional programs, systemic classical and modern herbology and targeted DNA and Element based macro/micronutrients for specific healing benefits. Other positive Life Style practices could be included as well as modern and ancient longevity practices. All recommendations can individually based upon the assessment and association of the identified weak or imbalanced Element and organ systems within the individual. This is a revolutionary drug free approach to health care and wellnes...
I'm seeking a professional Excel expert to create a tailored budget template for our corporate needs. The template will primarily be used for generating quotes. Key Requirements: - Incorporation of our company logo and branding into the template - Use of our specific color scheme throughout the template Ideal Skills: - Advanced Excel proficiency - Experience in corporate finance and budgeting - Strong understanding of corporate branding and design This project requires a keen attention to detail, both in terms of financial accuracy and visual presentation. Please include examples of similar projects you've completed in your bid.
I need an Excel expert to refine my database tracking patient referrals to a hospital. The database includes tracking patient specialties, procedures, price (income), and referral sources. Key Tasks Include: - Helping with Excel formulas - Organizing the data for clarity and efficiency - Linking the data appropriately The project will culminate in creating a dashboard with visual charts and graphs. The ideal freelancer should have a strong background in data analysis and visualization, and be proficient in Excel. Experience with creating dashboards in Excel is a plus.
I'm seeking a creative logo for my carpet cleaning business, Mr Bubbles Carpet Cleaning. The logo should embody a fun and playful style, in line with the brand's persona. Key elements to incorporate: - A 'bubble man' character, perhaps holding his thumb up in a gesture of approval - A wet vacuum, as this is the tool I use to clean carpets, mattresses and couches - Bubbles, as a nod to the brand name (this element is not neccesary) Color scheme: The logo should be in a blue and white palette. Ideal skills for the job would include graphic design, particularly logo design, and an ability to create playful and engaging visuals. Experience with creating brand-identifiable logos would be a plus. NO AI GENERATED SUBMISSIONS
I need a talented individual to create a system for my Excel workbook that intelligently transfers mixed data (text and numbers) from one sheet to another. The data transfer should occur daily, triggered by updates to the data. Key Requirements: - Proficient in Excel with extensive experience in creating complex formulas and logic. - Familiarity with VBA or similar programming languages for automating tasks in Excel. - Ability to understand and manipulate mixed data types. - Experience with setting up systems for daily data tracking and transfer. Ideal skills include attention to detail, problem-solving abilities, and a strong understanding of data management. Please apply if you can help me streamline my data managem...
I need assistance with my Excel Master Workbook. The project involves transferring generic data from the Master sheet into specific tables in another sheet within the same workbook. Details: - The data is dynamic and will change daily based on updates in the main sheet. - The method for matching the data to the specific tables in the other sheet varies. Ideal Skills: - Proficiency in Excel - Experience with data manipulation and transfer - Ability to work with dynamic data - Attention to detail
i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.
I need assistance in fixing and enhancing my Excel reports that are generated daily, weekly, monthly, and yearly. 1. Please fix the Stock Performance tab with Top 20 & Bottom 20. Its never worked when 2 or more companies have the same % gain/loss. 2. Commodities & Chart_All_Commodities, I changed the commodity on a few of them including Antimony, Germanium, Gallium, Platinum & Niobium. This seems to work on the Commodities tab, but I have to manually update the Chart_All_Commodites Tab, please fix this. 3. Please add 5 new Blank Commodities & Project Location Areas so it allows me to add specific ones in that field and it automically updates to the Chart_All_Commodities & Chart_All_Project Location Area too 4. Can you add a filter by Market Cap for the who...
...format, that require document processing. I need a python script that can sift through these documents to extract allergens and nutrition information, and then compile this data into separate CSV files. Key Requirements: - The documents include not just standard PDFs, but also Excel and Word files. Some of these are scanned PDFs that contain both images and text. - The script needs to be able to interpret and extract relevant information from all of these formats. - The analysis needs to be performed on documents written in English. Ideal Skills: - Proficiency in scripting languages such as Python. - Experience with data extraction and analysis from various document formats. - Familiarity with handling and interpreting scanned documents. Please bid if you can cre...
I'm looking for an Excel expert to create a comprehensive Mess Management Excel sheet. Requirements: - Tracking of student Mess fees - Fee calculation and tracking functionalities Ideal Skills and Experience: - Proficiency in Excel - Experience in creating expense tracking systems - Ability to incorporate complex fee calculations Please include examples of similar projects you've completed in your bid.
...for a proficient Excel expert with strong macro programming skills to create a comprehensive Excel sheet for processing data from my securities trading reports and FX market data. This is for the purpose of tax filing. I just update the FX page and the trade data and it produces the pnl sheet for me. I’ve attached the sheet with the required output. I need a macro to automate this sheet for me. Key Requirements: - The Excel sheet must be able to process various elements from my trading reports, including trade dates and times, transaction amounts, and securities identification. - The sheet will also need to incorporate data from FX market feeds. Ideal Skills: - Advanced Excel skills - Strong exper...
I'm seeking an experienced Excel specialist to create a software-based Gantt chart for me. This chart should incorporate task dependencies, progress tracking, and resource allocation capabilities. Key Requirements: - Proficiency in Excel with a strong understanding of its advanced features. - Experience in creating interactive, software-based Gantt charts within Excel. - Ability to incorporate task dependencies, progress tracking, and resource allocation into the Gantt chart. Ideal Skills: - Advanced Excel skills - Project management software experience - Strong attention to detail - Excellent communication skills
I am in need of a skilled Excel professional who can perform comprehensive financial analysis on my personal finance data. Key Responsibilities: - Analyze my personal finance data using Excel - Provide insights on key financial metrics - Build template for tracking personal finance Ideal Skills: - Proficient in Excel with a strong understanding of data analysis techniques - Experience with Finance formula like : Present Value, Future value, formats - Able to present complex data in a clear and concise manner
I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!
I need help with creating a detailed report from my Excel file. The report should be structured with sections and include pie charts. Additionally, it should contain a comparative analysis. Ideal Skills and Experience: - Proficiency in Excel - Data Analysis - Report Writing - Chart Creation
I currently have a project that requires the use of SPSS Statistics. I am looking for a professional who can help me with this project. Key Skills: - Proficient in using SPSS - Strong understanding of statistical an...currently have a project that requires the use of SPSS Statistics. I am looking for a professional who can help me with this project. Key Skills: - Proficient in using SPSS - Strong understanding of statistical analysis - Experienced in data visualization and hypothesis testing - Expertise in data cleaning and preparation - Able to work with survey data, experimental data, and existing datasets Experience: - Previous projects involving SPSS and statistical analysis - Proven track record in data-driven decision making - Ability to d...
...Hullbot's service team in Seattle, WA. This role involves operating underwater robotic systems for boat hull cleaning in Seattle Harbour. We are seeking a freelancer to provide robotic hull cleaning services at Seattle Harbour. At the moment, the service takes place every two weeks on a Thursday night, starting around 6pm and lasting 6-8 hours. Currently, we have one customer to service, with expectations for growth in the coming months. The freelancer must be available onsite during these service windows and for the full duration of the service delivery, including additional time for preparation ahead of the service delivery, and additional time afterwards for packing up, cleaning, and generating a service report. In-person training will be provided initiall...
Assistance with WordPress site. This project involves content updates, specifically editing existing content and removing outdated material. The main tasks include: - Deleting an embed YouTube video from the site. - Converting the WordPress page into HTML using an already installed plugin on WordPress. - Guidance on cleaning up the old WordPress page on my host. - Guidance on uploading the HTML file to my host. Skills Required: WordPress management HTML conversion Basic web hosting and file management Familiarity with WordPress plugins Experience with similar projects will be highly regarded Budget: $10-$15 USD no more.
I'm in need of a vibrant and playful logo for my women's underwear cleaner business. The logo should be modern, yet it should have a fun and light-hearted appeal. Key Requirements: - A bright and bold color scheme that stands out - Incorporation of cleaning-related icons into the design Ideal Skills: - Graphic Design - Logo Design - Understanding of playful, modern aesthetics
I need an experienced freelancer who can convert my .xlsx Excel sheet into Avery format address labels. Ideal Skills: - Proficient in Microsoft Excel - Familiar with Avery label layout templates - Attention to detail for accuracy
...internet connectivity and support a cloud architecture for at least 1000 concurrent users. The architecture must address Big Data's Velocity, Volume, Value, Variety, and Veracity while ensuring security compliance. (a) Model will be trained on large amount of variety of data such as documents, handwritten text, excel sheets, power point PPTs, word documents, BRs, equipment manuals, IR images, reports, letters, faxes, flow diagrams, charts, block diagrams, videos, training books, medical reports (all variants of medical reports, data and scanned copies). (b) The format of documents, manuals, reports, letters, faxes will not be restricted to readable PDF format and the solution should cater for all possible formats. Accordingly, solution provider should integ...
I'm launching a pool maintenance and cleaning startup and need a comprehensive market research survey. Objectives: - Understand the needs of residential pool owners - Gather insights into service preferences, price sensitivity, and satisfaction with current providers Ideal Skills: - Market research expertise - Survey design and implementation - Data analysis and interpretation - Understanding of the pool service industry
I need help with capturing data from a website. The data is displayed in a table format below a chart for a particular facility. I want to capture monthly data for all time periods for all facilities on the website. Key Details: - The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of use. Ideal skills for this project include: - Proficiency in Excel, particularly with creating and using macros. - Experience with data extraction from websites. - Attention to detail to ensure all data is accurately captured. Budget is $50
...applied dynamically. Text: “Certified for B Corp and Fair Trade.” Scene 4: Ocean Cleanup Initiative Background: An ocean scene with a mix of clean and polluted areas. Action: Show nets collecting plastic waste from the ocean. Use a counter graphic that increments to show "100 plastic bags cleaned" per order. Highlight marine life like fish and turtles thriving as the ocean gets cleaner. Text: “Cleaning 100 plastic bags from the ocean for every bag you buy.” Scene 5: Saving the Planet Background: A vibrant Earth animation with growing greenery, trees, and clear skies. Action: The Earth rotates, transitioning into a thriving, sustainable planet. Add dynamic animations of trees growing and wildlife flourishing. Show the Healuis logo appearing at t...
I'm looking to scrape 10000 restaurant websites in Australia to analyze their payment gateways. The primary purpose of this task is to ...this task is to conduct competitor analysis. I also need to gather the contact information from these sites. The ideal freelancer for this task should be skilled in web scraping, data analysis, and have a keen eye for detail. Requirements: - Extensive experience in web scraping - Proven track record in data analysis - Ability to gather and organize contact information - Skills in competitor analysis - Attention to detail The scraped data should be provided in Excel format. Please ensure that the payment gateway details are included as part of the contact information. Please organize the scraped data in an Exc...
I'm...seeking a freelancer to design an Excel reporting template to track our membership enrollments. The template will primarily handle registration data, specifically focusing on membership sign-ups. Key Features: - Automated Calculations: The template should perform relevant computations automatically. - Visual Charts and Graphs: The template must convert data into easy-to-understand visual representations. - Data Filtering and Sorting: The template needs to facilitate easy sorting and filtering of data. Ideal Skills: - Proficiency in Excel, particularly in creating complex templates. - Experience with data visualization - Strong understanding of membership enrollment processes. With this project, I hope to simplify our reporting ...
...and company communications. Skills and Qualifications * Good communication and writing skills, with the ability to convey information clearly and concisely. * Proven experience in mortgage advising, banking, or a related sales /operations environment. * Strong organizational skills with meticulous attention to detail. * Proficiency in using CRM software and office applications (e.g., MS Office, Excel). * Bachelor’s degree in Finance, Business Administration, or a related field. * Strong networking and relationship-building skills...
Dashboard Creation We are seeking a highly skilled and experienced Excel Expert to create professional and visually appealing KPI Dashboards in Excel. The ideal candidate should have extensive knowledge of advanced Excel functionalities and a strong ability to translate data into actionable insights. Proficiency in Google Sheets is a plus. Key Responsibilities: Design and develop customized KPI Dashboards in Microsoft Excel based on business requirements. Collaborate with stakeholders to identify key performance indicators and define dashboard objectives. Use advanced Excel formulas, functions, and tools (e.g., VLOOKUP, INDEX-MATCH, SUMIFS, Pivot Tables, etc.) to process, analyze, and visualize data effectively. Create dynamic and interacti...
I need a professional brand video that communicates our company's story to potential clients. The video should be crafted in a polished, professional manner, embodying the tone and style that we wish to project to our audience. Key Requirements: - Video production and editing - Storyboarding and scriptwriting - Ability to convey a professional tone Ideal skills for this project inclu...we wish to project to our audience. Key Requirements: - Video production and editing - Storyboarding and scriptwriting - Ability to convey a professional tone Ideal skills for this project include experience in corporate video production, a knack for storytelling, and a keen understanding of brand communication. I have a timeline in DaVinci Resolve I need help pulling it all together and clea...
...5. I have my own provided excel sheet, items in my leads and customers. 6. I have built a form for new leads. I need it to import all new leads I enter with phone form. 7. I need for all new customers to be added to customers not leads from website. 8. I need a to setup tabs, to send commands to your system. Like grade of each lead or send emails. Or other commands. 9. Need to setup templets for emails for the type I send like bulk. Depending on the grade . 10. I need for bulk email that can auto send depending on the TAB section. 11. Need to make sure that if I am editing a lead or customer info that notes are make separately with date and updates or call backs and meetings. 12. When a person who received an email from me do I get all of the data about c...
I have an MP3 file of my audiobook created with Audacity that needs some professional touch-ups before I can upload it to Amazon. Specific Requirements: - Comprehensive noise reduction and cleaning for the entire audiobook - Removal of unwanted background noise, primarily breath sounds Ideal Skills: - Experience with audio editing software (Audacity, Pro Tools, etc.) - Expertise in audiobook production and enhancement - Ability to deliver a clean, professional-quality MP3 Please only bid if you can ensure a pristine audio file ready for Amazon.
I'm looking for a professional who can design a template for certificates for business communications. The ideal candidate should have expertise in Microsoft Word and Excel, particularly in mail merge functions. Key Requirements: - Design a professional certificate template with space for date and signature. - Assistance with mail merge from Excel to Word. - Ensure dates are formatted correctly into UK format. I have some knowledge on how to do this but I'm currently having difficulty getting the dates into the correct format. Your expertise and assistance would be greatly appreciated.
