Excel project data cleaning jobs

...to develop a comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of complex...

I'm in need of a skilled branding professional who can c...can be used. - Typography Guidelines: Detailed information about the fonts and typography style that should be used in all our communications. - Merch Guides: Design suggestions and guidelines for any promotional or merchandise items that we may produce. - Store Design: Guidance on the color scheme, logo placement, and overall aesthetic that should be maintained in our physical store. To excel in this project, you should have a proven track record of creating brand guidelines. Proficiency in graphic design, branding, and an understanding of the pet grooming industry would be advantageous. Your work should be detailed, professional, and easy to understand. A great attention to detail and a strong sense of creativ...

...skilled professional who can set up an Azure data storage account to store Excel data, particularly with the following key features in mind: - **Data Type and Source**: The data I'm working with is primarily Excel based, so having experience with managing structured data storage in Azure is a must. - **Frequency of Updates**: The data will be updated on a weekly basis, so the storage solution needs to seamlessly accommodate this. - **Purpose of Storage**: The primary purpose of storing this data in Azure is for data analysis. While not the only use, ensuring that the storage solution allows for easy and efficient data analysis is crucial. The ideal candidate should have prior experience with Azure ...

...information into an Excel sheet. There would be a subsequent function for field extraction to compile a final report. - Desired Skills and Experience: • Proficiency in OCR technology for handwriting detection • Experience in custom software development • Excel programming expertise for auto-consolidation of data • Knowledge of report generation mechanisms within software Successful execution of this task would drastically streamline data processing in my start-up. To increase accuracy, the OCR program needs to be trainable, in order to recognize unique handwriting styles of different individuals. To provide you a sense of the variety, samples of these handwriting styles will be made available. I am seeking a freelancer who understan...

I have a simple flowchart in Excel that I need converted to DrawIO format. The purpose of this flowchart is for internal ISO 9001 documentation , so it needs to be clear, easy to understand, and look somewhat formal, so Font style and Color scheme should be appropriately chosen. I'm looking for a freelancer with experience in graphic design, particularly flowchart creation and DrawIO, who can give this flowchart a clean, professional look. The excell file will be provided to you, so you can copy/paste the text. I do not expect you to change the content. There might be additional flowcharts in the future, so potentially repeat business. When bidding, let me know whether or not you have experience with ISO documentation drafting, which might be a plus.

I'm requiring assistance with a meticulous task of transferring text data from a website. The data on the site is neatly arrayed in table format, and I need someone to manually sift through and copy the specific fields of 'Name', 'Date', and 'Description' into an Excel file. Ideal candidate would have: - Excellent attention to detail - Proven experience with manual data entry - Proficient in Excel - Understanding of structured web content This task requires patience, a keen eye for detail, and expertise in transforming web data into organized Excel entries. Interested freelancers need to commit to high levels of accuracy to ensure all data transferred is error-free.

I am looking for Excel experts who can assist me with creating formulas and functions within a week. I have wholesale mobile shop. I want excel works for example desboard in one sheets and custumer sheets which contain debit credit ,describtion and total amount one more important all costumer name on desboard and if debit or credit amount also show on desboard please also look for attect excel file

I'm looking for a versatile data scientist to undertake a data science project. Details about the specific tasks, data set, and project purpose will be provided later, but it's best if you can perform data cleaning, data analysis, and predictive modeling. Ideal skills and experiences: - Proficiency in data cleaning and data analysis - Strong background in predictive modeling - Experience in handling diverse data sets Please make a bid if you feel comfortable working with ambiguous guidelines and can adapt quickly as the project's requirements take shape.

I require an expert in Excel financial calculations to design a spreadsheet to calculate commission on sales. The main purpose is to drive commission payments based on a tiered structure. It will be used to manage commission payments linked to sales figures above a specified target. Ideal Skills: - Extensive experience in Excel spreadsheet design, particularly with financial calculations - Experience in tiered commission structure calculations - Strong understanding of financial data management. Responsibilities: - Design and implement Excel spreadsheet for commission calculations - Ensure accuracy of calculations based on the tiered commission structure.

Hi Ishaq. Can you have a look at this app for us. We want to convert it from a commend line batch file to a GUI app in Python. We had one of our team build the app in C# a few years ago, but he has left and we have the source code. The app will extract an image from an excel spread sheet based on the column ref and put the image into a nominated directory with the imaged named as per another column in the source excel spreadsheet. I can send yu a full demo of the app. regards Rob

...with solid experience and in-depth knowledge about real estate excel modelling. I need an Australian-based freelancer who has real estate experience. We have existing excel models that with the recent departure of our CFO, need someone to drive them while we find a replacement. The inputs will be provided by the project team and a hand over with the person who built the model is also possible if needed. Whats required is someone to ensure the models are used correctly. There is both a project specific model used for analysing whether a particular feasibility meets our hurdle rates along with a fund model that rolls multiple projects together along the operation of the manager. We primarily need the freelancer to input the data and generate report...

...primary criterion, and collating the data of various companies into the excel spreadsheet I will provide. Key Tasks: - Browse the provided website and search explicitly based on geolocation. - The geolocations of interest are predetermined and are stated within my excel sheet. Data Collection: - Oddly, I do not require some common fields like company name, address, or phone number. - Ensure accuracy and completeness of data collated into the excel spreadsheet. Ideal Skills and Experience: - Proficiency in advanced web research and data entry. - Working knowledge of geolocation-based search - Attention to detail and a keen eye for accuracy Applications: - Please include details of your past work experience. Showcasing relevant proje...

I'm in need of a skilled data entry specialist, specifically someone with experience in Excel and online data entry. Key Project Details: - The task at hand is small and involves less than 100 records, so the workload is manageable. - Primarily, I'm looking for someone who can analyze the data rather than just inputting it. Ideal Skills: - Proficiency in Excel and online data entry tools. - Strong analytical capabilities. - Previous experience with similar, small-scale data entry projects would be an advantage. I'm eager to work with a diligent, detail-oriented freelancer who can ensure that the data is accurately inputted and analyzed.

I'm in need of an Excel expert to meticulously update the product descriptions and prices in my catalog. The requirements include: - Updating: You'll be tasked with updating the product descriptions with new information and ensuring all the prices are current. - Catalog Size: The catalog comprises over 500 products, so attention to detail and ability to handle large volumes of data is crucial. - Formatting: Special formatting is not required, the new product descriptions and prices need to be consistent with the existing entries. Ideal Skills & Experience: - Proficiency in Excel: Successful candidates should have a high level of understanding and experience with Excel, particularly handling large datasets and using formulas. - Attention to Detail...

...experienced MS Excel programmer to enhance and automate an existing Excel spreadsheet. The primary goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you have completed. I am ...

...to develop a comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of complex...

I need a modern A2 size poster that reflects my cleaning company's brand and values. The poster should be: - Modern in style - Reflect our company's minimalist ethos - Use colors in the orangish spectrum, although a balance with neutral tones is essential Ideal Skills: Graphic Design, Poster Design, Branding, Color Theory

I'm in need of a data processing expert who can assist me in developing an architecture to analyze knowledge graphs using ETL and machine learning. Key Tasks: - Leveraging Data Processing Expertise: I need someone with a strong background in data processing, particularly in relation to graph technologies. Your role will be to harness this knowledge to create an efficient and effective architecture for analyzing knowledge graphs. Ideal Skills and Experience: - Strong Data Processing Background: A deep understanding of data processing is crucial for this project, particularly in the context of graph technologies. Experience in working with large datasets and complex data structures is highly desirable. - Familiarity with Graph Technolog...

I'm in need of a data processing expert who can assist me in developing an architecture to analyze knowledge graphs using ETL and machine learning. Key Tasks: - Leveraging Data Processing Expertise: I need someone with a strong background in data processing, particularly in relation to graph technologies. Your role will be to harness this knowledge to create an efficient and effective architecture for analyzing knowledge graphs. Ideal Skills and Experience: - Strong Data Processing Background: A deep understanding of data processing is crucial for this project, particularly in the context of graph technologies. Experience in working with large datasets and complex data structures is highly desirable. - Familiarity with Graph Technolog...

data entry (copy EAN code, SKU, and size) from label /image 2.300 label /image to Excel spreadsheet / google sheet file.

VBA EXCEL Bulk SMS Template

I need a detailed Microsoft Excel spreadsheet that tracks expenses related to Hurricane Ian and deducts them from my current house appraisal. Key aspects of the project: - **Expense Tracking**: The spreadsheet should offer a detailed list of expenses. These should be categorized (e.g. repairs, replacements, labor). - **Formula Integration**: It should also include formulas that automatically calculate the sum of these expenses. Ideal Candidate: - Proficient in Microsoft Excel - Experience creating detailed expense tracking sheets - Familiarity with property appraisal processes and calculations Please submit examples of similar spreadsheets you've created in the past.

I am seeking a skilled part-time accountant to assist with bookkeeping and tax preparation tasks. Key Responsibilities: - Handling Bookkeeping: Your primary responsibility will be to maintain accurate financial records using Excel spreadsheets and Tally ERP 9. - Tax Preparation: You will also be responsible for preparing our taxes, particularly VAT. Ideal Candidate: - Proficient with Excel spreadsheets and Tally ERP 9 for maintaining financial records - Experience in tax preparation, particularly VAT - Knowledge of accounting principles and practices - Excellent organizational and time-management skills - Ability to work remotely and meet deadlines Please note that familiarity with Saudi VAT regulations is crucial for this position.

I'm in need of an experienced and reliable financial professional to handle our bookkeeping tasks. Key responsibilities will include: - Regular, ongoing bookkeeping using popular software like QuickBooks or Excel. Ideal candidates should: - Have a strong background in bookkeeping and finance. - Be proficient in using bookkeeping software (e.g., QuickBooks or Excel). - Have a track record of delivering accurate and timely financial services. This project is about maintaining our financial records with precision and efficiency. It's crucial that the freelancer is able to commit to regular, ongoing bookkeeping tasks.

I discovered the power of Google Doc in recognizing manually written data. I have typed tables with handwritten data. The problem is that when I import my data into Google Doc the formatting is not respected. I have to add that these tables I want to transfer them to excel I would like to make it an automatic process take a pciture then convert the picture to excel

...latest trends in commercial design, particularly in healthcare. Location Information: - The project is planned in Saudi Arabia. - The project spans over an area of 546 squared meters on two floors. The project will involve: - Creating a modern design concept for the clinic that aligns with the corporate logo. - Providing detailed floor plans (dwg and pdf formats), 3D renders, and material suggestions (excel format for each floor/room). - Ensuring the design supports a professional and welcoming atmosphere for both staff and patients. Timeline: - Project shall be handed over 30 calendar days after the Kickoff meeting date. - Project date inclusive of two review sessions. Upon award of the project, the successful bidder will be handed...

My project involves collecting all of my medical records from a variety of locations and consolidating them into a master excel spreadsheet. In summary, the records include patient histories, immunization records, various diagnostic results, lab results, radiological imaging, surgical history, vision and hearing tests, and dental records. Given the sensitive nature of this data, I would ideally seek out a professional with experience in medical data collection and health-related projects with experience accessing patient data from various portals. Tasks include: - Gathering required records - Converting these records into an Excel format - Utilizing a specific organization system for collation, based on my Excel template (attached) Inter...

Hi, I have an excel file that contains 190 rows and 6 columns. I need someone to sort the data for me in a text file based on a specific required. Needs to be done now, in a short time frame. Type EXCEL at the beginning of your proposal if you understand the above. Proposals without it will be ignored.

...currently in need of a skilled professional who is adept with Microsoft Excel to assist me in a task that involves highlighting multiple cells within a spreadsheet swiftly. The key details of this task are as follows: - The data within the cells that require highlighting are textual in nature. We're looking to apply emphasis on particular pieces of text within the document. - The focal point of the highlighting is based on specific conditions. In this case, the cells should be highlighted based on containing certain text. Skills and experience required: - Proficiency in Microsoft Excel is essential. - Familiarity with conditional formatting in Excel to highlight cells. - Experience working with text-based data in Excel. - Attention to det...

I'm in need of a virtual assistant to support me with a variety of tasks including online search, maintaining data in an xl file, and making cold calls to potential customers. Key Responsibilities: - Conduct online research as needed - Maintain data in an excel file - Make cold calls to prospective clients The ideal candidate should be proficient in: - Online research - Data entry using excel - Cold calling I will require daily updates or reports on the tasks completed.

I need a skilled data entry specialist to help me transfer data from printed documents into an Excel spreadsheet. The data requires careful attention as it must be accurately and consistently entered. Ideal Skills and Experience: - Proficient in data entry - Attention to detail - Ability to consistently maintain data quality - Previous experience in similar tasks would be beneficial.

I'm in need ...physical products to my Woocommerce store. The selected candidate will need to: - Handle a range of physical products: My products come in a variety of sizes and colors, so experience with variable products in Woocommerce is a must. - Manage product information carefully: As I have a significant number of products, I will be providing the product information in an Excel/CSV format. The freelancer will need to ensure that this data is accurately transferred into the Woocommerce platform, including details on variations. Some products have 10 variables some products have 5, It's between 2-15 variables no more no less, If you understand all the above please type the price per product at the beginning of the proposal with the word RED. Proposals with...

I'm in need of a proficient developer with experience in both Excel VBA and Selenium to create a template that enables automated sending of bulk WhatsApp messages. The core functionality I'm seeking includes: - Automated WhatsApp messaging directly from Excel - Bulk messaging support: The capability to send out multiple messages at a time. The messaging content that will be automated is primarily related to the Products and Services information. The ideal candidate for this project should have a demonstrated history of working with Excel, VBA, and Selenium. Experience with similar projects relating to WhatsApp and bulk messaging automation would definitely be a plus. This will be a unique project with potential for ongoing work and tweaks d...

I'm interested in having an Excel template developed which uses VBA to automate the sending of bulk SMS. Major points of focus in this project are: -- Compatibility: The template should be compatible with Excel 2010, 2013, and 2016. -- Phone Numbers Input: I'd like to manually enter phone numbers from which the SMS will be sent. -- Message Customization: Depending on the requirement, both the same message may need to be sent to all recipients and different messages to each recipient. The ideal freelancer for this task should be proficient in Excel, VBA, and have experience in automation. Strong communication skills would be appreciated to better understand and implement the specifics of message customization.

I'm seeking a skilled mobile application developer to help me transform an existing Excel file into a functioning Android app. The primary purpose of this app is to perform calculations using the data inputted by users. This project requires the developer to have a strong knowledge of: - Android app development - Data handling in mobile applications - Implementing calculations It would also be beneficial for the prospective freelancer to possess prior experience in transitioning from Excel to a mobile application, ensuring the seamless implementation of these functionalities.

...capacity to collect and arrange data quickly are requirements for the perfect applicant. The main responsibility of this position is to assemble lists of possible partners, clients, or prospects according to predetermined standards. 1. Perform internet research to find prospective partners, clients, or leads. 2. Gather information and arrange it into structured lists based on predetermined standards. 3. Check the integrity of the data and confirm the veracity of the information acquired. Use a variety of platforms and tools to efficiently gather and handle lists. 5. Help maintain and update listings that are already in place as needed. 6. Keep in constant contact with the group to share developments and address any obstacles. One must be experience in ● Excellent data...

...you: Position Title: Excel Specialist About Us: We are seeking an Excel Specialist to join our team. Our organization values efficiency, accuracy, and excellence in all our projects. As an Excel Specialist, you will play a crucial role in handling various tasks that require advanced knowledge and proficiency in Microsoft Excel. Job Description: Utilize Microsoft Excel to complete a variety of tasks and assignments. Manipulate data, perform calculations, and generate reports using advanced Excel functions. Analyze and interpret complex data sets to provide valuable insights. Develop and maintain Excel templates and spreadsheets for organizational use. Collaborate with team members to ensure timely completion of projects. ...

I'm looking for help with competitor price comparisons for my online products. The data should contain the competitor name and their price - also any notes including discount codes which could affect this price in the checkout. I can provide up to 6 known competitor website URL's but would also require any other sellers names and prices adding to the data. Competitors can be found by Product Name. I'd like a final excel document with my price alongside my competitors prices for each of my products. If you need more information let me know. I have ~1,000 products to compare

I'm in need of a virtual assistant to create accounts and verify them. IMPORTANT INFO: You will get paid per verified profile You must have flexible time You will need a laptop You must have knowledge how to use TeamViewer (to control my laptop from yours) You must have knowledge of how excel work to write information Previous experience as a virtual assistant or in social media management is a plus.

Hi Sandeep C. JI MY NAME IS ANAND I AM NEW HER I KNOW EXCEL PLEASE SUPPORT ME ,AND HELP ME IN GETTING MY FIRST PROJECT ,THANK YOU SIR

I'm in need of a creative professional to craft compel...professional to craft compelling slogans for my website. The aim is to create a formal tone that will grab attention, promoting our brand, and helping increase conversions. The document attached features examples of what may be used, however I didn't find any of them appealing. I run a car detailing business and the themes of this business are cleaning vehicles, waxing cars, detailing interiors and providing services that are based around cleaning vehicles. I want the slogan to have a professional tone as it will be used on my website. Some of the key words are automotive, detailing, polish, vehicle, treatment etc. Ideally, I would like the slogan to be 3 key lines eg Detailing on demand Detailing at y...

I need an expert in Excel to conduct a statistical data analysis. The outcome should be presented in an excel spreadsheet. Key Requirements: - Proficient in Excel with deep knowledge of formulas and functions - Experience in conducting statistical data analysis - Able to deliver a comprehensive analysis within the given time frame Additional Skills: - Strong analytical skills - Ability to interpret and present data effectively - Attention to detail Please, apply if you have the necessary expertise.

I need a skilled data entry specialist to help me transfer data from printed documents into an Excel spreadsheet. The data requires careful attention as it must be accurately and consistently entered. Ideal Skills and Experience: - Proficient in data entry - Attention to detail - Ability to consistently maintain data quality - Previous experience in similar tasks would be beneficial.

As a frequent user of Microsoft Excel, I'm looking for a skilled professional to design and implement a powerful goal seek macro for my spreadsheet. Here are the details: - **Scope:** The macro's primary purpose is to automate complex calculations, which would otherwise be time-consuming and prone to errors if done manually. - **Functionality:** The macro should be capable of performing multiple cell goal seek operations. This means it should be able to iterate through several scenarios until a set of conditions are met. - **User Interface:** I prefer to trigger this macro through a button click within the spreadsheet. **Ideal Freelancer:** To successfully complete this project, you should have: - Proficiency in Microsoft Excel, including advanced knowle...

...number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will b...

I'm seeking a skilled Data Analyst who specializes in Power BI to handle a range of tasks, including data visualization, data modeling and analytics. Key tasks: - Create compelling visualizations to represent data trends effectively. - Develop robust data models that align with my business requirements. - Conduct in-depth data analytics to glean valuable insights. My data sources are primarily Excel spreadsheets and SQL databases. Therefore, expertise with these platforms is vital. Additionally, the candidate must be comfortable working with large datasets, as the project involves more than 10GB of data. Skills and Experience: - Mastery of Power BI for data visualization - Strong background in data...

I need a talented data analyst to analyze survey results. - Significant experience with Excel - A history of data analysis, particularly within social media - Experience turning raw data into bar charts, line graphs, and pie charts - Knowledge on Feedback interpretation Key Responsibilities: - Analyze the data and create charts/graphs in Excel - A bar chart, line graph, and pie chart are required as a minimum - Deliver clear, concise insights from the data analysis Let's connect if you're ready to turn complex data into insightful, simple visuals.

I'm looking for a skilled document writer with a diverse range of experience. The ideal candidate will be ...diverse range of experience. The ideal candidate will be able to tackle legal documents, business documents, academic documents, college projects, and research reports. Key Requirements: - Proficiency in crafting and formatting documents in both Word and PDF formats. - Ability to conduct thorough research using both primary and secondary sources. - should able to make Powerpoint presentation & Excel sheet. The ideal freelancer should have: - Strong background in legal writing and understanding of business protocols. - Prior experience in academic writing and report creation. - A keen eye for detail and an ability to deliver high-quality, well-researched documents ...

I'm seeking a candidate experienced in financial analysis capable of dissecting budget forecasts. Specific tasks involve primarily budget modeling built from the forecasts provided. To accomplish this, you should be; - Detail-oriented with strong excel proficiency - Have expertise in budget analysis and modeling - Be familiar with various financial analysis tools Previous experience in similar projects is a must. We're keen on accuracy, effectiveness, and promptness. Sharp analytical skills, in advance, would be highly valued.

I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data needs to get into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. I'm seeking a freelancer with experience in the Amazon Seller API to pull back data and metrics - all columns of data related to Sales, Orders, Products, Customers...