Excel data cleaningprojekty
...currently using Excel for creating my retail quotation templates. I am looking for a professional who is adept at: 1. Custom Field Incorporation: Please be able to add or remove fields within my current retail quotation template to customize it according to my business needs. 2. Design and Layout Alteration: I want to improve the design and layout of my retail quotation templates. I estimate this to be a significant portion of the project. A strong sense of aesthetics and understanding of UI/UX principles will be beneficial. 3. Branding and Color Scheme Consistency: Please ensure our company's existing color scheme and branding are incorporated seamlessly into the redesigned template. Strong attention to detail will be highly appreciated. Proven experience with...
Hi, we have an large Excel file with all of our customers contact details. We group them with tags in several different types - like pharmacy client, personal friends, partners and such kind things. I already wrote an py script wich processes this main excel file and splits the persons in their several categories each one with an own excel file. What i want now is that when someone from our company is writing to an defined mail account wich is an gmail account an message like. Hey Bot, give me please the excel list with friends, the py script should catch the keywords friends and should send the sender back an mail with the excel file wich contains just the friends back to him. last year i already wrote similar thing for an different purpose, this can be...
...implement a simple, easy-to-use portal on my website for sales data upload. This portal should accept XLSX files and validate them against having correct column headings in A, B and C. Key Features: - File Upload: The portal should be able to handle XLSX files for data upload. - Validation: The portal should check if the uploaded file has the correct column headers in A, B and C. If the spreadsheet fails this validation, it should provide an error message with guidance on how to correct the issue. - Accessibility: The portal should be accessible to anyone, without the need for user accounts. Ideal Skills: - Proficiency in web development with experience in building portals and handling file uploads. - Strong understanding of Excel file structures and the ...
I'm in need of an experienced data analyst or data scientist to clean and refine my text data. Though I haven't outlined specific tasks, the freelancer should be knowledgeable in tasks such as removing special characters, eliminating stop words, and correcting spelling errors. Ideal candidate should be proficient in: - Data cleaning techniques - Text analytics - Proficiency in programming languages often used in data science such as Python or R The requirement is not urgent. I'm expecting to have the final output within a month. Please place your bid based on this timeline.
لدي نادي متخصص في لعبة الإسكواش وأحتاج عمل قالب اكسل لحساب مدد بدايات ونهاية الاشتراكات وعدد ساعات التدريب
Project Description: We are looking for an experienced Wordpress developer to create a high-quality course details page for our Excel Mastery course at Metaverse Learn. The course details page should be designed to match the example provided here: Here is our current course details page : Requirements: - The course details page should be visually appealing, user-friendly, and mobile-responsive. - It should include all necessary elements such as course overview, curriculum, instructor details, testimonials, FAQs, and enrollment options etc. Basically all the elements on our existing course details page. - The page layout should be customizable and designed as a template so that it can be replicated
Metaverse Learn is seeking an experienced and creative designer to craft a high-quality, trendy image ad for our Excel Mastery course. This ad will be posted on Instagram, Facebook, and LinkedIn to attract aspiring Excel wizards! Project Details: - Design an eye-catching image ad for our Excel Mastery course. - Must be suitable for Instagram, Facebook, and LinkedIn platforms. - Incorporate the Metaverse Learn logo and course details. - Ensure the ad reflects the professionalism and quality of our brand. - Trendy and modern design style preferred. - Final open file/project files (Photoshop file) must be provided upon completion. Requirements: - Experience in designing social media ads, preferably for educational or online courses. - Proficiency in graphic design too...
I'm looking for an SEO expert to fully optimize my home cleaning website. As of now, it is not ranking yet and I need it to be visible on major search engines. Key responsibilities: - Incorporate effective SEO strategies - Improve the Meta tags and Header tags - Achieve a better URL structure Ideal skills and experience: - Proven record in SEO and ranking improvement - Knowledge of meta tags, header tags, and URL structure integration - Experience working with home cleaning or similar websites - Creative in creating SEO strategies Please note that no specific keywords have been planned to rank for as of now, any suggestions would be welcomed. Applicants who can provide a brief strategy plan in their proposal would be preferred.
I need a reliable system that automates a process, doing a couple of specific tasks: 1. Reading specific data captured in Excel files. 2. Automatically sending texts via SMS when there's a data match in a particular column of the Excel file. This task will require programming skills, particularly with Excel and automation tools API. Experience with SMS gateway integration is a huge plus. You will be required to advise on appropriate SMS gateways if you have prior experience. The matching data column in the Excel file should be the trigger initiating the text sending automation. The target of this automation is to streamline and expedite our communication process, reducing manual effort involved in sending periodic SMS updates. If ...
I need a proficient Excel specialist to provide immediate support with data analysis, automation, and formula creation. Your expertise is essential in transforming a specific data format from '111111111111' to '' in Excel. I just need for someone to show me how to do it so I can replace it in my Excel database
WHAT’S NEEDED: Uccello Designs is looking for a freelancer to input data from the provided PDF’s into the provided Microsoft Excel sheet. WHAT’S PROVIDED: We have designed the sheet to include all relevant headings that are important to the data entry project. Within each PDF are multiple files that need extracted and added to the sheet. ABOUT THE PROJECT: These documents cover our customers registering the products they have purchased. The 3 products are the Uccello Kettle, Muggi and Uccello Grip Mat. With the excel doc there are 2 tabs, one is solely for the Uccello Kettle and the second is called the accessory registration tab where we ask that you include the Muggi and Grip Mat. NON-DISCLOSURE AGREEMENT: The information that you are bein...
Crear un documento excel para el seguimiento de visitas de comerciales. Creando una ficha de cliente muy básica (nombre, localidad, pers de contacto, telf contacto, mail de contacto y tipo de comercio) Con fechas de visita, resultado de la visita, próxima acción, ¿es cliente S/N?, tipo de visita (presencial o telefónica), observaciones Y con ello poder hacer un seguimiento de las visitas: nº visitas diarias, cuantas visitas por comercio cuantas visitas son presenciales y telefónicas.
Unire colonne di testo su file excel, inserire scontistiche, immagini e altro producendo un nuovo file. Lavoro continuativo.
I'm looking for a freelancer with a strong comprehension of formal, strict language and knowledge in copyright law. The project's objective is to draft compelling copyright notices explicitly for m...draft compelling copyright notices explicitly for my business partners. The ideal candidate should possess: - Exceptional writing abilities - Familiarity with copyright laws and documentation - Experience in developing policies or legal documents with a formal and strict tone - Proficiency in Excel for organization and template creation Your tasks include: - Understanding my business and its partners - Writing strict and formal copyright notices - Organizing these notices in a user-friendly Excel format Quality, accuracy, and adherence to the formal tone are key...
I have text data stored in a MySQL database that needs to be cleaned and formatted in Excel. Key Tasks: - Identify and correct errors in the data - Eliminate irrelevant information - Standardize data for consistency - Ensure data integrity and quality Key Skills: - Proficiency in MySQL database management - Strong experience in data cleaning and manipulation - Expertise in Excel for data formatting - Attention to detail for identifying anomalies and inconsistencies - Ability to ensure data quality and integrity We need a freelancer with a keen eye for detail and strong data management skills to take on this task. A background in data science or analysis would be highly beneficial. Please include example...
...automated Excel Workbook specialized in the area of cost reporting. Key components I need are: - Calculation Formulas: Enable the workbook to calculate various financial metrics automatically. Should include revenue, expenses, and profit calculations. - Analytical Charts: The workbook should be able to visually represent the data and calculations such as revenue, expense, and profit trend lines. - Advanced Analysis: In addition to basic calculation formulas, the workbook should be able to analyze profit margins and handle cost variance analysis. It should have the functionality to run scenario analysis based on different inputs. Ideal candidates should have strong skills and experience in advanced Excel, particularly in creating automated workbooks, delivery of ...
...Description: We are looking for a talented and experienced freelancer to build a platform similar to and Our goal is to create a marketplace that connects customers with skilled professionals for various services, such as home maintenance, repairs, renovations, cleaning, and more. Key Responsibilities: Develop a user-friendly portal with features for job posting, bidding, messaging, payments, reviews, and profiles. Implement secure payment gateways and data encryption to protect user information and transactions. Design algorithms or systems for matching job requests with suitable professionals based on skills, location, availability, and ratings. Ensure mobile responsiveness, search engine optimization (SEO), and scalability of the platform. Integrate
As a healthcare company, we are in need of a financially savvy individual for financial forecasting, budgeting and planning tasks. Your ...comprehensive financial model that compares leasing and selling machines Identify key variables and assumptions for the model, such as machine costs, consumable prices, and operating expenses Determine the potential profit margins for both leasing and selling scenarios Provide recommendations based on the financial analysis findings Project Scope The project will include the following activities: Data gathering and analysis of machine costs, consumable prices, and operating expenses Development of a financial model using Microsoft Exce Testing and validation of the model to ensure accuracy Creation of a report summarizing the findings and recom...
I am in need of an expert researcher to build an email l...and Tax and Audit Firms operating within Germany. The primary purpose of this email list is for implementing a marketing campaign centred around our SEO service offerings. Ideal Skills: - Proficient in online research - Proven experience in data collection and management - Background in marketing or business development preferable - Excellent proficiency in English and some understanding of German language would be beneficial. Outcome: - An accurate email list with verifiable contacts - Must be formatted in a clear, organized manner (Excel CSV preferred) This is a venture that requires a good understanding of the targeted industry. With your expertise, we hope to successfully reach out to our prospective cl...
Job Title: Sales Outreacher Company: KT Studio About Us: KT Studio specializes in growing personal brands and businesses, focusing on YouTubers and influencers aiming to enhance their growth and efficiency. Role: Sales Outreacher...outliers) Experience: 1 month to 2 years (training provided for beginners) Application Process: If you are driven by success and ready to seize this exciting opportunity, send a DM with the word "outreacher" along with your cover letter and resume showcasing your sales experience and why you are the perfect fit for this role. Highlight any achievements or skills that demonstrate your ability to excel in sales and client relations. We are seeking a standout candidate to join our elite team, and exceptional performers will enjoy a rewarding career...
I am seeking an Excel expert capable of calculating First in First out (FIFO) for tech stocks that I own. Your responsibilities will include: - Taking provided data including purchase date, purchase price, stock ticker symbol, stock splits, the number of shares purchased, the number of shares sold and the respective dates - Arranging and analyzing these data accurately in an Excel document utilizing the FIFO methodology - Assessing if the stock sale is subject to tax due to the tax exemption for holding the stock for longer than 3 years The ideal freelancer would have: - Extensive experience with Excel - Familiarity with the FIFO method - Strong understanding of tech stocks This job will require attention to detail and precision. It's crucial t...
I'm in need of a skilled copy typer to assist me with converting a variety of documents into a digital format. The documents I need typed are a mixture of printed and scanned materials. Key Requirements: - Copy typing experience, particularly with printed and scanned documents - Accurate replication of the original content - Ability to match formatting to the original document Copy required in excel
I'm urgently in need of a proficient freelancer who can help with a crucial data entry task. Unfortunately, I skipped some questions, so I'll provide more context. The task is a one-time project, but the data type to be entered is not fixed yet, it could be either numerical data, textual data or a mix of both. Ideal Skills Needed: - Efficient in Excel Data Entry - Experience with Online Form Filling - Proficient in Copy-Pasting Data This project requires some urgency so a quick turn around will be highly appreciated.
I'm in immediate need of a professional who specializes in Japanese accounting to rectify numerous issues with my accounts. The primary challenges include: - Correcting incorrect entries. - Locating a...accounting discrepancies and should have excellent attention to detail. Knowledge of Japanese accounting is a must. Furthermore, I need your help in separating my business and personal transactions. Reconciliation will also be required between the two. Given both these contexts, I'm open to starting afresh with a new accounting system if deemed suitable. This project will entail cleaning up 3 years worth of data, hence a good measure of commitment and availability will be appreciated. I look forward to working with a competent freelancer who can meticulously u...
I'm in need of an expert in data entry, particularly in Microsoft Excel. The task revolves around basic data entry, which includes names, email addresses, and other related simple information. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Previous experience in basic data entry - Strong attention to detail - Ability to handle repetitive tasks accurately and efficiently Your primary responsibility will be to accurately transcribe and input the data provided into the Excel spreadsheet. Your attention to detail will be crucial, as even small errors could have significant repercussions. Please make sure you are comfortable with the given task before placing a bid.
I'm looking for an experienced Excel expert to assist with my data analysis and formula creation tasks. - Data Analysis: I need you to help me with both statistical and financial analysis. It's essential that you are comfortable and proficient with these kinds of data analysis within Excel. - Formula Creation: You'll also be responsible for creating various formulas, particularly related to budgeting and financial forecasting. Experience in working with such data to build accurate and efficient formulas is a must. I'm looking for someone who can quickly understand the data, provide insightful analysis, and create the necessary formulas for financial tasks.
I'm seeking a dedicated person who knows data engineering and data analysis with special expertise in AWS services. Your primary responsibilities will include: - Data cleaning and preprocessing: Handling a variety of data structures, from unstructured to semi-structured and structured - Data modeling and warehousing: Proficiency in using AWS S3, Athena, Glue, and other analytical services - Data analysis and visualization: Delivering insights through efficient data analysis and visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work wi...
I am looking for an expert data entry freelancer who can efficiently and accurately transfer text data into a Microsoft Excel format. - The final delivery should be in a Microsoft Excel file format. - The preferred data structure in the Excel file should be row-wise. - Excellent attention to detail and proficiency in Excel is a must for this job to ensure data is entered correctly. I look forward to working with someone who respects deadlines, has a solid understanding of data entry requirements, and values quality service. This project could lead to long term engagement if successfully completed.
I need an expert in Excel macros to develop a tool for me that would allow me to automate some specific tasks as I work in Excel. Key Specifications: - The tool needs to be able to automatically format cell values. I will provide the existing format and the new format that I want. - It should be able to add text boxes to specific cells in the Excel file. The content of the text boxes will vary depending on the content of the respective cells. - The tool should allow me to delete specific columns based on the value in a particular cell. Ideal Skills: - Proficiency in Excel macros/VBA - Prior experience in customizing Excel files - Good communication to understand my needs and implement them accurately I have an excel sheet with production dat...
I'm in need of a system that can transform my existing PDF into word file. - The first needs to be a Word document, containing a...Word document, containing a fillable form. This form should encompass text fields, check boxes and date fields, mirroring those found in the original PDF. - The second is an Excel spreadsheet, which is to be linked directly to the Word form. This link should enable automated data transfer between the two, minimising the need for manual data input processes. Proficiency in Word, Excel, PDF conversions and data automation would be ideal for this project. Understanding of complex form creation and Excel-to-Word data linking is also crucial. This endeavour requires precision and a strong attention to detai...
I have 73 PDFs that I need to be converted into separate Excel sheets. The Excel sheets need to follow a specific format, which is in table form with specific columns. Key Requirements: - Convert 73 PDFs into rows of an Excel sheet - The Excel needs to follow a pre-defined format, which I will provide. - The pre-defined format is in the form of tables with specific columns The Excel sheets should contain all the data as shown in the template with a separate summary tab with the following: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation Hours - Average and standard ...
...help me convert a bulk of my purchase invoices from PDF format to Excel. - The PDF invoices are all Text-based and thus, the conversion can be automated. - The original scanned PDF will also be provided if needed. - The Excel sheet should have the following fields: - Vendor information, Invoice number, Invoice date, Purchase details (Product Name, Uom, Qty, Rate, VAT, Total) - I prefer all the invoices to be organized in a single sheet in the Excel file. Ideal skills for this job include proficiency in data extraction, PDF to Excel automation, and a keen eye for detail when it comes to organizing data. A background in finance or accounting would be a plus, as it will help in ensuring the accuracy of the extracted data. Automate /...
I'm searching for a highly skilled Web3 designer to build and launch a Web3 website. This individual should excel in user interface design, creating visually pleasing and intuitive designs for a seamless user experience. Key responsibilities will include: - Developing a user-friendly Web3 website design - Incorporating decentralized identity feature in the website Expertise and Skills required: - Proficiency in Web3 designing - Previous experience with decentralized identity - Solid understanding of Blockchain - Proficiency in user interface design Ideally, you should have an impressive portfolio of previous Web3 design work. Looking forward to a designer who can deliver a high-quality user interface and contribute innovative ideas for site features.
I'm looking for a playful and creative logo for my cleaning business. The logo should reflect a silhouette of a person in full motion of walking, with one foot placed on the shape of Africa and the other on New Zealand. Instead of a bindle, the person should have a mop over their shoulder and a bucket in hand. My company name is Mufambu Key Requirements: - Silhouette of a person with a mop and bucket - One foot on Africa and one on New Zealand - Playful and creative style Color Preferences: - Blue and Green as primary colors - One version in color and one in plain black Usage: - The logo will be primarily used for print on business cards and flyers, as well as on merchandise like t-shirts and hats. Ideal Skills for this project: - Graphic Design - Logo Design - Creativity...
Grâce a l'ocr et AI je veut créer une plateforme en ligne pour récupérer les factures scannées ou photographier ou les bon et pourvoir lire tout les informations de la facture grâce a l'ocr et reconnaître les différentes type de factures grace au machine learning et a la fin récupérer les données dans un fichier excel ou csv ou dans une base de données grâce a la configuration de chaque rebrique et colonne.
As a company, we're currently in need of a seasoned Power BI expert, well-versed in creating engaging dashboards and detailed reports....engaging dashboards and detailed reports. Key Responsibilities: - Develop and design interactive dashboards and reports - Generate in-depth, data-driven reports - Provide data analysis and insights Key Requirements: - Proficiency in Power BI - Strong experience in creating interactive dashboards and detailed reports - Skilled in data analysis and providing insights The project will involve connecting to data sources primarily from Excel spreadsheets. The main audience for the dashboards and reports will be our data analysts. To ensure that you're the right fit for this project, please provide exampl...
Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.
...expertise in data handling specifically relating to Excel spreadsheets. The ideal candidate will be responsible for: - Sorting the data to make it more organized and user-friendly. - Cleaning the data. This may entail tasks such as detecting and correcting errors, and potentially removing any duplicates (however, a clear plan on handling this aspect will be shared later in the project, since the specific data cleaning operations were not predefined). - Separating the data as requested. This is a time-sensitive project requiring completion as soon as possible. Therefore, the individual needs to be adept at working under pressure and towards tight deadlines. The perfect fit would be someone with a proven track record handling simil...
I will do enlisted task. Renovation Brands needs an analytical assistant to support our FP&A department in a variety of tasks. The ideal candidate will have experience with Excel and running/modifying SQL (no need to have experience writing it). Tasks will include things such as downloading data from ERP or SQL, Refreshing files and validating refresh worked, troubleshooting errors in execution, etc.
I'm looking for someone with a solid understanding of the market and strong research skills to help identify multi-brand women's clothing retailers in the UK and USA. The project involves finding both online and physical retailers that also have an online presence. Th...presence. The ideal candidate will have experience in market research, preferably within the fashion or clothing industry, and possess excellent analytical skills. Knowledge of the retail sector is crucial, and having access to premium market research tools would be a plus. Please include details of your experience and your research approach in your proposal. Note that we will provide an Excel sheet for the data, and we are offering $50 for every 1000 records. Please apply only if the budget is ac...
I need a talented statistician to help determine if there is an association between gender and different types of admission sources from the Emergency Department (ED). The analysis will not be limited to a particular admission source. The data for the project will be supplied in an Excel file format. Freelancers are required to have proficiency in Excel and a deep understanding of statistical tests, particularly Chi-Squared tests. In your application, please include: - Your past work relating to statistical analysis - How you plan to execute this project utilizing the Chi-Squared Test - An estimated timeline for completion I look forward to working with you on this exciting project!
I've compiled an Arabic-Chinese dictionary in an Excel file and I'm seeking a skilled developer to convert this into a user-friendly software. This software will be exclusively for laptop or computer use, and should operate offline. Key requirements: - Experience with software development for Windows and Mac operating systems - Proficient in programming languages suitable for offline software - Ability to create a user-friendly interface The ideal freelancer will have experience in developing functional and user-friendly software. I would like this project completed within a month, so I'm looking for someone who can work efficiently, while also maintaining high-quality standards.
We are seeking a highly organized and proactive Web Assistan...stakeholders to discuss updates and resolve issues. Utilize Microsoft Office tools to create and manage content, reports, and presentations. Coordinate with team members to ensure smooth execution of web projects. Manage email correspondence and ensure timely and effective communication. Qualifications: Excellent command of English, both written and verbal. Proficiency in Microsoft Office (Word, Excel, PowerPoint, Outlook). Strong interpersonal skills and the ability to communicate effectively with various stakeholders. Previous managerial experience is highly desirable. Ability to work independently and in a team-oriented environment. Must be organized, attentive to detail, and capable of handling multiple tasks simul...
I'm in need of a proficient data analyst to handle two main tasks on my project: data cleaning and data visualization. Your primary skills and experience should include: - Mastery in Python and Tableau for a smooth workflow - Solid background in health care data processing The dataset in need of your expert touch is small, less than 1GB. I expect clean and organized data after preprocessing, followed by clear and precise visualization of the cleaned data. Visualization should be easy to comprehend and able to unravel crucial insights from the healthcare dataset. Your work will be instrumental in further guiding my next steps in the project. Looking forward to your bid.
I'm in need of a freelancer with an eye for detail and proficiency in Excel for a data sorting project. The task involves the following: - Sorting of a large Excel dataset - Understanding of sorting methods with Excel is crucial - Experience in data management would be a big advantage Completion of the project within the next three days is essential. The efficient and quick turnaround is a prime requirement. Let's discuss if you thrive in fast-paced environments.
I need a professional to create a dual-platform dashboard in both MS Excel and Power BI. The primary objective of these dashboards is to monitor the status of multiple projects. Key responsibilities include: - Setup and design of interactive dashboards that display project status in a user-friendly manner. - In MS Excel, the dashboard should efficiently track and report project status. - For Power BI, the focus will be on analyzing project status. Ideal freelancer will have: - Proficiency in MS Excel and Power BI. - Proven experience in creating versatile dashboards. - Strong understanding of project management principles. - Knowledge of data analysis and reporting.
I need an Excel spreadsheet created to store and display information for 200 products. The project involves: - Entering product name, product description, and price for each item - Embedding images for each product in the spreadsheet - Receiving product information and images in a text document Ideal skills for this project: - Proficiency in Microsoft Excel - Attention to detail - Ability to work with and embed images in Excel - Familiarity with data entry and handling product information Looking forward to working with a skilled freelancer on this task.
I'm seeking a knowledgeable individual who can teach beginner-level tutorials focusing on GPT-4 training and the implementation of AI techniques. Since I did not specify any programming languages o...proficient in teaching complex concepts in an easy-to-understand manner. We are looking create a knowledge base within our business that will help us embrace AI moving forwards and enable us to create GPT’s, mainly to extrapolate / merge / compare / reformat data from excel files. We would like to train 3 staff members with the knowledge of how to ultimately create GPT’s to take multiple workbooks of data, extract the relevant information, using GPT to identify and present the specific required information, then maybe reworking that data into a ...
