Excel project data cleaningKazi
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 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 ...
...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 experience with mac...
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 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 deliver clear and comprehensible data reports.
...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 rep...
...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 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 cleaning it up.
...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.
Job Description: We are seeking a skilled freelancer to enhance and optimize our current spreadsheet system for tracking class data. Our goal is to make the system more insightful, visually engaging, and actionable for our business planning. Current Setup: We use spreadsheets to track class data, including the category of the class, the instructor, and the location. Each year has its own dedicated sheet. A summary sheet aggregates data from the yearly sheets, providing total counts for the year. Scope of Work: We’d like to expand the capabilities of this system by introducing new graphs, charts, and insights, including: Graphs and Charts: A graph showing the number of classes taught at each location, broken down by year and month. A chart summarizing how many c...
Company Name: HelperCode Field of Activity: Cleaning, Nanny, and Housekeeping Services Goal: Create a minimalistic text-based logo that is modern, stylish, and easily recognizable. Requirements: 1. Style: The logo should be text-focused, with an emphasis on unique typography. Subtle visual hints or accents reflecting the connection between “helper” and “code” can be integrated into the text. 2. Font: Use a modern, clean, and highly legible font with custom elements to ensure originality. 3. Colors: Opt for a professional and trustworthy color palette, such as soft blues, greens, or neutral tones. 4. Versatility: The logo should be adaptable for use across digital platforms, print materials, clothing, and vehicle branding. 5. Memorability: The design sh...
I need an Electrical Contractor or equivalent experienced in 3 phase, commericial electrical work as well as 24v occupancy sensor work and in-conduit wiring to generate an extremely detailed electrical take-off from blueprints which I will provide in PDF format. I need the result to be an excel spreadsheet with columns for "Item" "Quantity" "Description" "Location" etc. It needs to include the lengths of conduit by type/size as well as wire as well every box, conduit elbo, panel, service entrance item, light, switch, etc. The take-off needs to formatted as such that I can send it to various electrical supply houses for material pricing. Take-off is ONLY needed for electrical sheets, E001, E101, E211, E212, E221, E222, E231, E511, E601 ...
I'm in need of a skilled photo editor to restore and enhance an old Civil War photograph. The project involves both cleaning up the photo and making some alterations. Key Tasks: - Add missing facial features to the subjects in the photo. - Repair and enhance the clothing or uniforms of the individuals in the photo. - Maintain a realistic style throughout the restoration. The ideal candidate for this project should have a strong background in photo editing and restoration, with specific experience in historical photo enhancement. Attention to detail is critical to ensure the final product is a faithful, yet improved, representation of the original image.
I'm seeking to create a comprehensive database of US companies in the medical device cleaning and medical facilities cleaning industries. The database should include email contact for the CEO and number of employees of the company. I will buy lists of 1000 contacts each time I may buy lists from more than one bidder, and may buy more than one list per bidder to the extent the lists provided have the right level of quality. You should quote the price for each list of 1000 contacts. Ideal Skills: - Data mining - Database creation - Market research - Lead generation Experience: - Prior experience in compiling corporate databases - Familiarity with the medical device or cleaning industry is a plus.
I'm in need of an Excel list containing at least 5,000 UK-based healthcare and wellness companies, specifically hospitals and clinics, fitness centers and gyms, as well as wellness spas and retreats. Key Requirements: - The list should include the business name and address for each company - The data should be delivered in .xlsx format Ideal Skills and Experience: - Proficient in data mining and Excel - Previous experience in compiling business lists - Understanding of the healthcare and wellness sector is a plus.
...my sales leads. Key Responsibilities: - Gather and compile all provided Excel files containing sales leads into a single, comprehensive Excel sheet. - Organize the leads in alphabetical order from A-Z. - Identify duplicate entries and highlight them in yellow for easy identification. Duplicates can be same address, or company name, or phone number etc. - Ensure that the final document is clean, organized, and easy to read. Ideal Skills: - Proficient in Microsoft Excel or similar spreadsheet software. - Detail-oriented to ensure duplicates are marked accurately and the final document is neat. - Good organizational skills to compile and sort the leads effectively. Please note, the ability to handle large data sets and maintain confidentiality is cruci...
I'm looking for a professional to clean my email list of 30,000 contacts, remove duplicates, and segment the list based on purchase history. The cleaned list should ideally have an open rate of about 20% on Mailchimp. Key Requirements: - Remove both identical email addresses and same contact information with different emails. - Segment the list based on purchase history. Your expertise should improve my deliverability and ultimately increase my open rates. Experience with Mailchimp is essential.
...Desktop App. The script needs to capture specific data when I draw a vertical line on the chart to identify a particular price bar. When I place a vertical line on the chart, I want the script to extract the following information and send it to an Excel sheet: 1. The date of the price bar 2. The time of the price bar 3. The price (it should consider the high price of the bar if I use a green vertical line, or the low price of the bar if I use a red vertical line) The exact specifications of the project, including the precise format for the data, can be found in the attached document. Key requirements: - Expertise in TradingView and its scripting language - Proficiency in Excel and data formatting - Attention to detail Placing a bid on this...
I'm looking for a skilled data manager to assist in consolidating financial data. Key Responsibilities: - Extract financial data from multiple Excel financial statements - Compile the data into a single Excel sheet Ideal Candidate: - Proficient in Excel - Experience with financial data - Detail-oriented and able to ensure data accuracy
Seeking a full-time member to join our team. We're a real estate photography agency based in New York. The job will start with a 3-week trial period at 48 hrs/week. If we find during that period that you ar...Available Mon - Sat, 9am - 7pm NYC time -- Great visual eye -- Attention to detail -- Fluent in English -- Great communication (verbal and written) -- Patience -- Experience with Google Docs, Google Calendar, & Microsoft Excel preferred -- Content writing experience is a plus. -- Newsletter management is a plus. Roles & Responsibilities -- Quality check photos and provide feedback to photo editor. -- Schedule photography appointments with clients and photographers. -- Respond to customer inquiries via email promptly. -- Send lead generation messages. -- Online r...
I'm in need of an Excel spreadsheet designed to meticulously track my sales team's performance, both weekly and monthly, as well as year-to-date (YTD). The primary focus will be on sales performance metrics. Key Requirements: - The spreadsheet needs to be capable of tracking various sales performance metrics - It should be able to capture data on a weekly, monthly, and year-to-date basis - It should be user-friendly and easy to update Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in designing sales tracking spreadsheets - Understanding of sales performance metrics - Ability to create user-friendly and easy-to-navigate spreadsheets I appreciate your bids and look forward to working with a professional who can help me with this ...
I'm seeking a Scala Spark developer who can come to my home and assist with various data processing tasks. Key Responsibilities: - Data Cleaning: Ensuring that the data is accurate and ready for analysis. - Data Transformation: Modifying data into a suitable format for processing. - Real-Time Data Streaming: Handling and processing data as it comes in. Data Type: The developer will primarily be working with structured data. Ideal Skills and Experience: - Proficient in Scala and Spark - Extensive experience with data processing - Comfortable working in a home setting - Capable of handling structured data I'm looking for someone who is not just technically proficient but can also collaborate wel...
I'm looking for a financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts...financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts in both Argentina and the USA into a single Excel sheet or similar. Key Requirements: - Automatic linkage of all my checking, credit card and savings accounts. - Consolidation of expenses into a clear, comprehensible format. - Support for specific banks from Argentina and the USA. Ideal Skills and Experience: - Proficient in financial software and Excel. - Experience with linking bank accounts and credit cards for expense tracking. - Knowledge of specific Argentine and USA banks. - Ability to present data...
I'm looking for a professional Excel expert who can help me format a spreadsheet containing contact details into a user-friendly, easily sorted and searchable data reference guide. This is a single spreadsheet with 15 columns within 11 headings and about 13 rows of data entry. Specific formatting and ease of search and sort are key. Ideal Skills and Experience: - Proficient in Excel with advanced formatting skills - Experience in creating searchable databases - Strong attention to detail - Ability to understand and implement a specific project vision
...experience in healthcare quality systems. The project involves building sheets, reports and dashboards that track operational metrics within a cloud-based quality management platform. Key Requirements: - Proficient in Smart Sheets - Experience with healthcare quality management systems - Ability to create comprehensive, easy-to-understand dashboards and reports - Strong understanding of operational metrics in healthcare The ideal candidate should have a keen eye for detail and a strong background in data analysis, as well as the ability to present complex data in a clear and concise manner. I am looking for someone who can deliver high-quality work on time and can communicate effectively throughout the project. We need to date a mesh inputs from Excel...
I need a comprehensive Smartsheet dashboard for monitoring daily hospital operations. This dashbo...including Emergency, Surgery, and Outpatient. The ideal candidate will have experience with Smartsheet and data visualization tools like Tableau. Key requirements include: - Integrating various data sources: Excel/CSV files, Online Smartsheet forms, and a Database - Creating dynamic views for different operations teams - Designing the dashboard for ease of use and comprehension Skills and experience needed: - expert Proficiency in Smartsheet - Experience with data manipulation and visualization - Ability to design user-friendly dashboards - Understanding of hospital operations would be a plus I want the dashboad in smartsheet to be similar to to the dashboard ...
I need an Excel expert to elevate my sales data spreadsheet into a high-end, professional looking document, perfect for data presentation. Key Requirements: - Extensive experience with Excel and data visualization. - Ability to incorporate company branding seamlessly into the spreadsheet. - Understanding of the principles of professional, high-quality design. Important Elements: - Integrate company logo and color scheme. - Create a visually appealing layout that enhances data presentation. Ideal Skills: - Excel - Data Visualization - Graphic Design in Excel - Branding Please note, this project is not about altering the underlying data, but about making the spreadsheet visually impressive and suitable for prof...
...create a comprehensive Excel spreadsheet template with macros, active control options, and bar charts for my company, Measurement Solutions, Inc., an industrial distributor specializing in measurement equipment. This template will be used for quoting custom gages. The project will involve: - Creating macros to automate calculations, generate custom quotes, and handle data validation and cleanup. - Designing the template to input various types of data including customer information, product specifications, pricing details, and delivery information. - Incorporating bar charts for price/time comparisons. Ideal skills for this job include: - Advanced Excel expertise, particularly in creating and implementing macros. - Experience with data validati...
