Systemdatadataset excelemplois

I have multiple Excel files that require thorough cleaning. The data inconsistencies that I need addressed include duplicates, formatting errors, and incorrect entries. There's also a need for merging, splitting, and conditional formatting. Ideal candidates for this project should be proficient with Excel and have experience in data cleaning. They should also be adept at identifying and solving data-related issues. Ultimately, I need all duplicate entries to be removed from these files. • SKILLS REQUIRED: - Proficiency in Excel - Experience in data cleaning - Ability to merge and split data - Familiarity with conditional formatting

Project Description: We are seeking a talented graphic designer to create a captivating social media flyer for our online course. The course targets individuals aged 15-25 and course name is Data analysis with MS Excel Requirements: 1. Design must be visually appealing, professional, and in line with our brand identity. 2. The post should include engaging visuals and concise, compelling copy to capture the audience's attention. 3. Dimensions: WhatsApp status, WhatsApp post, Instagram 4. Incorporate relevant course details such as course name, key benefits, and a call-to-action (e.g., "Enroll Now"). 5. Use our brand color pallette 6. Provide the design in a high-resolution format suitable for social media posting. Deliverables: - One social media post design in the...

I require a comprehensive spreadsheet created that compares four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the follo...four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the following aspects: - Fees - Number of transactions closed - Average price point - Stock options - Agent attraction For the 'number of transactions closed', I wish to use a preset value for each brokerage. Moreover, I want the 'fees' data structure to be tiered. Candidates with excellent Excel skills are preferred. It's also beneficial if you have a good understanding of real estate brokerage fees and structures. Attention to detail is essential as the spreadsheet needs to allo...

I require expertise in extracting purchase details from text-based PDF attachments in my Outlook emails and compiling this data in an excel sheet. Key tasks: - Set up a platform that automatically imports data from new email attachments - Extract purchase details from these attachments - Place this data into an Excel sheet accurately. Skills and Experience: - Proficient in Microsoft Outlook and Excel. - Knowledge of data extraction from text-based PDFs. - Automation experience, ability to set up a system that triggers upon receipt of a new email. - High attention to detail required. - Previous work in data extraction or related fields is a plus.

I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub

Tengo el inventario de la tienda ya escrito, pero nescesito tenerlo en un excel para que sea mas dinamico y facil de usar.

I need a meticulous person with a keen eye for detail to hunt down and manually input contact details from an event's website into an Excel file. Key Responsibilities: - Collect the data fields: Name, Email, Phone Number, Company and Sector from the website. - Store data in an organized manner in a .xls Excel file. Ideal Candidate: - Someone with experience in manual data entry - Attention to detail, as accuracy is of utmost importance - Please provide examples of past work demonstrating your data entry skills I look forward to seeing your applications and choosing the best fit for this job. Remember, past experience counts!

Hi, I need to extract data and images from product pages into an Excel file. Here is an example link - Video showing it - ATTACHED FILE is the format it needs to go into so I can import it into WooCommerce Product name All images Price About this product Details Variations: color, size, etc

...a meticulous and detail-oriented freelancer to concentrate specifically on the following for an unspecified number of Excel files and bank statements: - Date Formats: Ensure all dates are consistent - Transaction Types: Verification and correction of all transaction types - Narrative Consistency: Ascertain uniformity in transaction narratives Ideal skills for the job would include extensive proofreading experience and in-depth knowledge of Excel data and bank statements. Any examples of past work or detailed project proposals you could include in your application would be beneficial. Please be prepared to dive into a project of an undefined size, as the number of Excel files and bank statements has not been specified. With your assistance, I'm confident we ...

...skilled graphic designer who can develop a series of medium-sized, flat design styled icons for our digital courses. These courses encompass topics including Excel, PowerPoint, MS Project, and Power BI. The icons should follow the style of the ones we already have for our HSE (Health, Safety, and Environment) courses, maintaining consistency across our course offerings. Ideal Skills and Experience: - Proven experience in designing intuitive and visually appealing icons - Proficient in Adobe Illustrator - Strong understanding of flat design principles - Prior work on digital content or courseware would be a bonus - Familiarity with Excel, PowerPoint, MS Project, and Power BI for context-oriented design. Requirements: - Maintain consistency with the style of icons used fo...

Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but 3 results is seemed, adding more columns at the final table (see atta...

I'm seeking a freelancer proficient at data entry for impending tasks. The job involves entering both numerical and textual data. Details: - You will need to enter a mixture of numeric and textual data. - Accuracy is crucial to ensure the quality of data entry. - The finalized data should be provided in an Excel spreadsheet. Skills and Experience: - Proficient in data entry. - Strong attention to detail. - Experience using and formatting Excel spreadsheets.

I have two excel files. In the file, I want you to color code cells from B2:E2 to the end of the columns with text as either green, yellow, orange, red for how closely the text in one cell matches in another. Green - perfect or near perfect match Yellow - most of it is good Orange - less than 70% match Red - poor match or no match I roughly counted there are about 2000 cells.

I'm looking to hire someone proficient with Excel to reconstruct a spreadsheet using a template that I will provide. The new version should replicate the original as closely as possible, without any added functionalities. Key requirements: - The spreadsheet should have exactly the same type of data as the original one. - You will not need to incorporate functionalities such as formulas, calculations, data validation or conditional formatting as they were skipped in the requirements. I want to ensure that my project is in good hands, therefore, your experience is crucial to me. During your application, kindly detail relevant experiences you've had recreating or working with spreadsheet templates. Looking forward to finding a trustworthy and knowledgeable professional w...

I am seeking an Excel expert who can provide in-person training on ‘Budgeting and profit and loss projections’ for one person. I already has an intermediate understanding of Excel and we need further training on: - Basic Excel Functions: The trainer would be expected to reiterate on the basic functions to ensure a strong foundation for the subsequent practical sessions. - Creating Formulas: The ability to create and manage formulas is the next skill we wish to hone. This includes all the necessary functions to perform complex calculations for our projects. The spreadsheet has already been created, it needs to be corrected a little but can be explained further in the training session. This training should be tailored to suit individuals with intermediate ...

I urgently require a meticulous and professional proofreader, well-versed in Japanese, to refine four not-safe-for-work (NSFW) lan...not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Japanese. You will be provided 6 landing pages that you will need to open with a browser language set to Japanese. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is highly val...

Hi there! I'm Sourabh Dhos a detail-oriented individual with a knack for data entry. I thrive in fast-paced environments where accuracy is key. Proficient in ( Excel,ms word,I ensure data integrity while meeting deadlines.

Looking for an individual to accurately transfer numerical information and tables from PDF to Excel. Previous experience in data entry will be advantageous. Ideal skills and qualifications: - Beginner level experience in data entry or similar roles - Proficient in Microsoft Excel - Excellent attention to detail - Ability to interpret and analyze data Example attached.

The aim is to build a comprehensive business plan for my IT Service, consulting tech...attract investment. To this end, I need a professional who can effectively portray my business and future prospects through this plan. Key Requirements: - Incorporation of financial projections for more than 5 years into an Excel sheet. - Strong understanding of the technology service industry. - Experience in developing business plans specifically for investment purposes. Skills and Experience: - Excellent financial modeling skills. - Profound knowledge of the technology industry. - Experience in preparing business plans for fundraising purposes. - Proficiency in Excel. By effectively portraying my business strategy and financial future, you'd provide the key tool I need to secu...

I am seeking a skilled R programmer to develop code to create interaction matrices. The code will need to read in data from 80+ Excel sheets, create interaction matrices, and link in ID numbers from a separate document. Ideal Skills: - Mastery of R programming - Experience with scientific research data - Strong skills in data analysis

I'm searching for an individual specialized in data mining and web scraping who can help me extract specific product information from an e-commerce website. Key Responsibilitie...in data mining and web scraping who can help me extract specific product information from an e-commerce website. Key Responsibilities: - Locate and extract specified data from the selected e-commerce site - Ensure collected data is reliable and structured properly Ideal Candidate: - Has in-depth knowledge in Web Scraping and Data Mining - Is familiar and proficient with Excel as the required output format is an Excel file This project aims to support a larger market research initiative, thus accuracy and attention to detail is critical. Only professionals with proven experience in simila...

I'm experiencing an ...pbix file. Despite the fact that my data is neatly structured on a single worksheet with multiple tables in Excel, it is not refreshing in the pbix file when expected. Given the nature of this problem, it's clear that an expertise in data management with Excel and Power BI is necessary for this project. Proficiency in troubleshooting Power BI related issues is also a must. The primary tasks will include: - Analyzing the pbix file and the associated Excel worksheet - Pinpointing the cause behind the failure to refresh data - Implementing a fix to ensure smooth data refresh in the future The preferred freelancer should be experienced with: - Power BI (especially .pbix files) - Excel data management and organization - Problem-so...

I have a specific goal for this project, which involves web scraping and organizing data into a comprehensive Excel spreadsheet database of UK care homes. The work scope includes: - Extracting contact details (both phone numbers and emails) of each care home - Categorizing the extracted data based on care home location The ideal freelancer for this job should hold the following skills and experience: - Proficient in web scraping - Knowledge of categorizing or sorting data - Excel spreadsheet expertise Accuracy and attention to detail is crucial in this task. This project is suitable for individuals who have previously demonstrated efficiency and success in similar roles. Resource could be

...operations. Primarily, I need a skilled Python developer to integrate the Angel Smart API with Microsoft Excel. Areas of concern include: - Developing data retrieval and analysis functionality: This involves retrieving and analyzing stock prices. - Option chain data management: I am specifically looking for functionalities like real-time option chain data retrieval, historical option chain data retrieval, and sophisticated analysis and visualization of the gathered data. - Creating an automated reporting system: In order to keep track of market conditions, an automated system for generating reports is essential. The ideal candidate should be expert in Python, comfortable with Excel, and have experience working with Angel Smart API. A strong background in financial mar...

...document attached for full scope of contest. I require a skilled professional in Excel to develop an automated dashboard for my business. The system will need to manage data entry, data analysis, and reporting - all automated. Key tasks will include: - Setting up a dashboard connected to Excel files with automation functionality. - Automating cleaning up and processing of data for analysis. - Developing reports with automatic generation feature. Regarding data visualization, the dashboard should be capable of generating pie charts, line graphs, and bar graphs as per the data analyzed. You should be proficient in Excel and familiar with data visualization techniques. Experience in automation and connecting Excel with other data sources will also be an adva...

I'm seeking a proficient data specialist who can successfully convert a CSV file into an XLSX Excel format. This conversion needs to be done meticulously to ensure optimal usability for sharing data with others. Key responsibilities will include: - Converting a CSV file into an XLSX format - Checking data integrity post-conversion - Ensuring the final layout is easy to understand and use for sharing with others The ideal freelancer for this job has extensive experience with Microsoft Excel and, more specifically, with CSV to Excel conversions. This is a one-off project, but I'm interested in a flawless output. Accuracy and meticulous attention to detail are critical for this task.

I urgently require a meticulous and professional proofreader, well-versed in Italian, to refine four not-safe-for-work (NSFW) landin...but not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Dutch. You will be provided 6 landing pages that you will need to open with a browser language set to Dutch. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is highly val...

I have a requirement for an advanced Excel specialist to develop a structured Gantt chart. More details will be provided to shortlisted candidates.

Veuillez vous inscrire ou vous connecter pour voir les détails.

I am in need of an Excel operator to assist with data entry tasks. Ideal candidates would have extensive experience in Excel and be confident in their data entry abilities. Skills and Requirements: - Proficient in Excel data entry - Attention to detail - Experience with Excel formulas is a plus Application Details: Applicants should include their Excel experience details in their application. Please provide information about past related work, specifically focusing on data entry tasks in Excel. Tasks to be Performed: - Input various data points into Excel spreadsheet accurately - Handle high volumes of data entry - Maintain the integrity and accuracy of the data If this sounds like something you can handle, apply now and let's work...

...developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and handling large...

...developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and handling large...

I need a proficient translator for a document that's less than 1000 words from Spanish and French into English. Furthermore, the translation will need to be inputted into Microsoft Excel. Key responsibilities: - Translate document from Spanish and French to English - Data entry into Microsoft Excel Ideal Skills and Experience: - Fluent in English, Spanish and French - Previous translation experience - Proficiency in Microsoft Excel - Strong attention to detail - Ability to maintain confidentiality I am looking for a translator that can deliver accurate, high-quality translation and data entry with a sharp eye for detail. Please submit your bids with past related works and expected delivery timeline.

I'm...aiming for a modern aesthetic and it's crucial that you're capable of creating designs in this style. - Translating Concepts into Design: These designed shirts will be part of my marketing effort. I want to convey specific themes and messages, so you have to be adept in incorporating concepts into design. - Delivering Print-Ready Files: Ultimately, I require these designs to be print-ready. To excel in this job, you need: - Proven experience in graphic design, especially in modern styles. - An impressive portfolio showcasing your talent. - Strong understanding of how to design for print. - The ability to work collaboratively, take direction, and incorporate feedback. - Great communication and time management skills. I can't wait to see your portfolios ...

I require a skilled data entry specialist to handle an Excel sheet that involves the aid of typing in a combination of different data forms: Numbers, Text, and Dates. - The sheet you'll be working with houses 10 - 50 columns and rows, so attention to detail is paramount. Ideal skills include: - Excellent knowledge and experience in Excel - Ability to accurately and swiftly handle data entry - Proficiency in handling multiple data types This project focuses strictly on data entry alone and does not require any data analysis skills.

I am seeking a highly experienced .NET 8 trainer with advanced level expertise, capable of providing live online training. I was a full stack .Net...coding for 6-7 yrs. I am aware of the basic concepts but rusty at the moment so need to brush up the concepts. So, the training needs to be ground up. Ideal Skills and Experience: - Profound knowledge in C# programming language - Experience with .Net Core - In-depth understanding of APIs and Microservices - IIS hosting - CD via Team City and Octopus This is a fantastic opportunity for those who excel in making complex information easy to understand and engaging. If you are up for the task, connect with me and let's take this further. Please include references of your previous trainings as they will be considered during the sel...

...planning schedules, reduce wastage, and increase productivity. - Purchase Order Management: The platform needs a feature that simplifies purchase order creation and management. User Scale: - The MRP system will be used by less than ten users. Consequently, it needs to be user-friendly and intuitive, requiring minimal technical knowledge for daily operations. Optional: - We are currently using Excel to do Materials Requirement Planning, so a similar operation logic would be good. Your background should ideally include significant exposure to MRP system development, cloud-based platforms creation, and a keen understanding of inventory management, production planning, and purchase order management. Strict adherence to best practices in software development, a high degree of relia...

As an organisation, we're currently utilizing Excel 365 and have compiled sales figures by product that we'd like to further analyse. We're in need of an expert in Power BI who can help us convert our Excel data into meaningful Power BI visualizations. In essence, our main objective is to analyze our sales data comprehensively. Key Tasks: - Convert our Excel 365 sales data into Power BI - Design intuitive and interactive dashboards - Provide insights based on the data analysis Successful candidates should have: - Proven experience with Power BI and Excel 365 - An ability to create interactive visualizations - Strong analytical skills, particularly in sales data analysis

I'm looking for a proficient Excel expert with a strong background in production planning and forecasting. The task at hand involves revising and enhancing an existing production schedule, enabling it to track more complex parameters and deliver insightful reports. In particular, the freelancer will need to: - Incorporate production milestones into the schedule, with these milestones determined by both booked work values and forecasted values. - Integrate a system for tracking production based on specific booked work values, as well as forecasted values. - Use parameters such as Steel in Tons and kg, and Pipe fabrication in Diameter inch for forecasting production. The ideal candidate will have: - Profound knowledge and experience in Excel and its more advanced featur...

I'm in need of skilled developers to create a web and mobile application for my log sheet management system. The applications need to cater to data entry, approval, storage, and controlled access to records. Records should be accessible in PDF files, Excel, and Word formats, in a particular layout that I'll provide. Files and data to be stored in our own server which can be accessed via internet. Sample file format attached Key Features: * Compatibility: The mobile application must be compatible with Android devices. * User Roles: The application will host three user types - Data Entry Operator, Record Manager, and System Administrator. Each role has distinct responsibilities and access within the application that I’ll explain further down the line. * Design: The de...

Hi, I am a backend developer experienced in data extraction, web scraping, and automation. I guarantee: - Quality and Quantity - Fast delivery For more details, don't hesitate to get in touch with me. Thanks for your time. Cheers, Amr E.

I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...

I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...

...an experienced industrial engineer proficient in Excel to develop the capacity requirement component for a Manufacturing Resource Planning (MRP) system. The project involves integrating the capacity requirement section with the existing material requirements planning (MRP) part, creating a cohesive manufacturing resource planing MRPII system in Excel. Key Requirements: 1. Develop the capacity requirement component in Excel. 2. Integrate it seamlessly with the existing material requirements planning part. 3. Create a user-friendly interface for easy navigation. 4. Implement backstage functionality to simplify user interaction. Project Timeline: Completion within two days. Budget: Maximum budget is $100. If you are confident in your Excel skills and can ...

I require an Excel expert with in-depth knowledge in VBA for developing a comprehensive invoicing system. I have my qr scanner when I scan product it's shows products details automatically. I attached 5 list of products. Your Task: * Create VBA macros to automate system functionalities * Design invoice templates that encapsulate professionalism * Implement automation for data entry tasks Purpose: The overarching purpose of the invoicing system is to streamline the tracking of sales and payments, automatically calculate finance-related aspects, and generate professional invoices that accurately represent our company. Required Features: * Ability to generate insightful reports on business financial trends * Functionality to send automated reminders for payments * Integration ...

I require an experienced data entry specialist to convert a substantial volume of physical documents into an organized format in Excel. The job is significant, involving more than 1000 entries. This task necessitates the following: - Proficiency in Excel and its various functions - Experience with high-volume data entry projects - Excellent attention to detail - Ability to convert physical documents into digital data accurately Additionally, a strong understanding of maintaining data privacy and confidentiality would be advantageous.

I will provide the freelancer with a formatted template in Excel. I will also provide the freelancer with 5-7 different excel documents that are micro reports. The freelancer will pull the data/information from the 5-7 different excel documents and format them inside of the template, keeping the same colors and conditions. The template includes a pivot table. The freelancer will need to replace the information on the pivot table with the new data from the 5-7 different Excel documents.

I want someone to copy almost 100 accounting equation answers. It's written in PDF form and I want it in Excel. Pages full of words like the first 6 pages are not required. You can leave some equations with long answers, but don't leave a lot.

Hello ! I need a real expert on Excel / Google sheet. I am using both for projects, and I need someone who can : Using Vlookup , and all specific formulas that can help build up and create spreadsheet. I have a lot of datas to clean and make automatic fill up . So I need someone who can help organize my spreadsheets and fill up a lot of datas . It start with small project to try and then it's gonna be a monthly project

I need an Excel expert to review, verify, and potentially improve the advanced functions (e.g., ARRAYFORMULA, QUERY) in 2 to 5 of my existing spreadsheets. Your job includes: - Inspecting and analyzing the existing functions for accuracy and efficiency - Proposing or implementing necessary adjustments to optimize functionality - Once changes are made, providing a clear explanation—either in writing or video format—on the changes applied and any suggestions to maintain or further improve the spreadsheet's performance You should have a strong knack for identifying errors, inconsistencies, and opportunities for improvements in complex Excel spreadsheets. An excellent command of advanced Excel formulas is essential. Ability to clearly communicate changes...