Excel merge data sets işler
I'm on the hunt for a skillful coder proficient in web scraping, specifically for Website A. The goal of this project is for obtaining valuable and significant data for analysis, competitive intelligence, and price comparison. While there's no explicit mention of the type of data to be scraped, I anticipate that a capable offering will cater to a variety of needs such as: - Text content - Image content - Metadata Ideal Experience and Skills: - Proven experience with web scraping - High proficiency in handling large data sets - Comfort in navigating Website A - Ability to collect comprehensive data categories Looking forward to a potential collaboration to achieve this goal!
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is detail-oriented, skill...
...sophisticated and luxurious that reflects the high-end nature of our products • The catalog's focus is to generate sales leads, so the design must be enticing to potential customers While previous experience with luxury product catalogs will be a strong advantage, it's the ability to understand and design according to project's purpose that truly matters. The selected designer should be able to merge several individual booklets in a comprehensive and attractive manner. Impress me with your previous works and innovative approach to this project....
As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.
...to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on gene...
...elegant typography. Bilingual: The logo must seamlessly integrate both French and English brand names. Versatility: The design should translate well onto cake boxes, packaging, and other branding materials. Color Expertise: Ability to suggest a refined color palette that complements the brand's style. This job is best suited to a versatile designer with a creative eye. You need to be able to merge a modern, minimalist design aesthetic with an element of cake-themed whimsy. Proficiency in French (or strong experience with bilingual design projects) would be ideal. Desired Skills: Proven experience in minimalist logo design. Strong typographic skills. Excellent understanding of branding principles. Experience designing for food/beverage or luxury-oriented businesses is...
I'm looking for a professional who can ...from a website that I will share with you. This data should be filtered according to specific product details. Key Requirements: - Retrieving product information including SKU, Category, Sub-Category, Color, Gender, Age, Material, Sleeve Length - Implementing a filtering mechanism to sort and organize the scraped data - Attention to details for accurate data scraping The ideal freelancer for this job should have: - Experience in web scraping and data mining - Strong understanding of data sorting and filtering - Proficiency in managing and storing large sets of data - Excellent communication skills to understand and address any queries regarding the project Looking forward to working together ...
I am looking for an expert to guide me through my upcoming SHL Numerical Reasoning Assessment. The current level of my understanding falls under the 'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experie...'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experience for this task would be: - Strong knowledge and experience in SHL assessments, especially Numerical Reasoning - Excellent in teaching Problem Solving strategies - Proven track record of coaching intermediate level candidates Your guiding hand will help me excel in this assessment. Please submit your bid if these requir...
I'm searching for an experienced programmer who is well versed in both MS Access and Visual Basic. Your Responsibilities: • Assist with MS Access / Visual Basic programming and tutoring sessions • Work without a pressing deadline, a...steady progress. If you're an expert in these areas, I'd love to learn from you. You should solve individual tasks alone, but also with me online using TeamViewer. Please understand item, warehouse, inventory management and so on... The €10 offered is only formal. We will agree on milestones or billing by the hour. 1. MS Access / Visual Basic programming and tutoring - Normalization of tables - Merge/separate tables - Field conversion - Label design - Etc... 2. Optimal: Reading “Datanorm” into Access 3. Opt...
...proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and c...
...Creation: I need a sales funnel that converts effectively. Your previous experience in creating and implementing high-performing funnels is highly desirable. specifically: 1. WEBSITE HAS BEEN LAID OUT, NEED TO FINISH IT 2. SET UP REGISTRATION QUESTIONS AND PAYMENTS (WOULD LIKE TO OFFER ACH PMT OPTION ALSO) 3. FUNNEL REGISTRATION QUESTIONS TO AN EXCEL REPORT TO USE FOR MAIL MERGE DOCS TO PRINT CUSTOMIZED ITEMS (***FIRST CHOICE IS THAT THE MAIL MERGE BE AUTOMATED ALSO!!!***) 4. AFTER ATTENDEE REGISTERS: a. POP UP ASKING TO COMPLETE PRE-RETREAT SURVEY b. WELCOME EMAIL WITH DETAILS IS SENT c. CALENDAR INVITE IS SENT (IF LIVE DEI) have welcome video attached d. NOTIFICATION IS SENT TO ME, MY ASSISTANT, AND POSSIBLY VENDORS (INITIATING SHIPMENT OF PRODUCTS TO ATTENDEE) ...
I need assistance with formatting an MS Word document that has been converted from PDF. The document contains some unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames...unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames from the document - Amend specific sections of the main body text - Optionally, transfer the figures in the document into Excel Ideal skills for this project include: - Proficiency in MS Word and Excel - Experience in document formatting and editing - Attention to detail for accurate text amendments - Optional: Experienc...
...to work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination a...
Project Deliverables: 1. Complete research paper manuscript in accordance with JAN guidelines. 2. Data sheet such as MS Excel or SPSS etc. Payment schedule: Complete payment transfer after the manuscript is received and checked by the client. P.S. The revisions proposed by JAN will be incorporated even after the payment release or project completion.
I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time rep...
I'm looking for a skilled freelancer who can work with Esri to automate the generation of medical expenditure reports and produce printable PDF heat maps. Ideal Skills & Experience: - Proficiency with Esri's software and tools, particularly in generating automated reports and heat maps - Strong understanding of data visualization and the ability to create insights from complex data sets - Experience in the health or medical industry is a plus, as an understanding of medical data will be beneficial Key Requirements: - Automation of medical expenditure reports using Esri - Creation of printable PDF heat maps highlighting areas with high medical expenditure Please let me know about your relevant experience and how you plan to approach this project.
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
As the project owner, I am looking for a talented individual who can handle two crucial tasks in Excel: 1. Adding advanced functionality with IF, VLOOKUP, and INDEX MATCH formulas. 2. Implementing conditional formatting. To be successful in this project, you should have: • Proficiency in Excel's advanced functions and calculations • Experience with customizing Excel using conditional formatting • Attention to detail and the ability to execute tasks accurately. Your primary task will be to help me improve Excel's current functionality by implementing the advanced functions mentioned and customizing my Excel using conditional formatting. Your deep understanding of Excel will be crucial to successfully carrying out these tasks...
I require sophisticated analysis conducted on two data sets, aimed at identifying patterns and generating valuable insights. The focus of this analysis should be a comprehensive examination of various chemical elements. Here's what I'm looking for: - Uncover patterns: Use statistics to identify any evident or subtle patterns in our dataset. I'd be particularly interested in seeing how these patterns may highlight similarities or differences between the two data sets. - Generate insights: Beyond just identifying patterns, I'd like to understand what these patterns mean - their impact, their implications, and how we can use them to our advantage. - Element-focused: The data sets contain a variety of elements which should be the f...
I am in urgent need of skilled developers to create a web-based CRM system. The details of the industry this CRM will serve will be shared in further discussions. Ideal Skills and Experience: • Proven CRM development experience • Good command of web-based applications • Ability to deliver in a short timeline Timelines: Immediate start with a goal for as quick a completion as possible.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly i...
Looking for a savvy surveyor who can get to the crux of the ready mix concrete market in Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requireme...Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requirements include: - Compile a detailed report, covering your analysis & proposing actionable strategies. - Provide raw data in Excel or CSV format in addition to the report. Prior experience in market surveying and a knowledge of the construction industry are big pluses. Your ability to work fast while maintaining accuracy is paramount. Let's revolutionize the Varanasi ...
I need help with simple copying and pasting tasks from online directories. The data needs to be organized by category. The primary task includes: - Copying data from various online directories - Pasting the data into an Excel/CSV file - Organizing the data by categories Ideal skills: - Excellent attention to detail - Proficiency in data entry and Excel/CSV - Understanding of data categorization The task is straightforward and doesn't require any complex skills. I am looking for someone who can deliver accurate results in a timely fashion.
Preciso transportar dados de uma pesquisa do google formulário para gráficos gerados em Excel, para serem adicionados em trabalho acadêmico.
I have excel table with project tasks by dates start and end and duration. I want to change it to project table. Preferred microsoft format.
I urgently need a professional who can input textual data onto an Excel sheet in a visually appealing and easy-to-understand way. Key Responsibilities: - Representing textual data in a clean and organized manner within an Excel sheet. Ideal Candidates Should Have: - Proficiency in Excel, particularly in handling and presenting textual data. - Strong attention to detail, ensuring that all data is correctly input. - Ability to work quickly and efficiently, as the project has a tight deadline. If you have experience with data representation and can work fast, please apply.
I'm seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization us...
I require the expertise of a skilled data scraper who can quickly retrieve text data from a specified website. The site in question is I need the following specific information delivered in Microsoft Excel Format: - Country Name - Grand Lodge Name - Website address - Email address - Phone - Address - Grand Master name (if available) The ideal freelancer for this project would have significant experience in data scraping, particularly text data, and an understanding of the website's structure to retrieve the desired information effectively. Speed and efficiency are of the essence. Your ability to deliver this project promptly without compromising accuracy will win you this bid.
To give you a brief idea the data you are dealing with is for recipe ingredients and I need nutrition info for all those ingredients from USDA. I'm seeking a Python expert who can give me 100% accurate "mapped" data without duplicates or missing information. YOU WILL BE REQUIRED TO WRITE/SEARCH NEW script to modify my data in Excel sheets - I have 3 Excel files having a total of 50000 rows, These are ingredients from recipes, I need you to do the following tasks - (A) - Assign a new ingredient ID number to all non-duplicate Ingredients. (B) - Replace "Name of ingredients" with the newly assigned number in the whole file (C) - For all ingredients - search, get the FDC ID from USDA Food Central and save this info in a separate fi...
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this tas...
...application that can handle various data-related tasks, from generating PDFs to processing scannable sheets, creating data visualizations, and interactive reports. The ideal candidate for this job should have experience with PHP, MYSQL/MariaDB, and an understanding of data processing and visualization. Key features and requirements: - PDF Generation: The application should be able to take XLSX files, and based on the uploaded data, generate PDFs. - Scannable Sheets: The system must be able to process bulk uploads of scannable sheets, interpret the data (including pencil bubbles), and translate it into tables. - Error Reporting: I need the system to either prompt users to fix any errors or flag errors for later attention, ensuring data integrity...
I'm in need of a creative marketing professional to propose unique and memorable names for our real estate projects in Saudi Arabia. Here's what I am looking for: - Four distinctive project names that blend Arabian heritage, modern luxury, and sustainable living concepts, and to ...memorable names for our real estate projects in Saudi Arabia. Here's what I am looking for: - Four distinctive project names that blend Arabian heritage, modern luxury, and sustainable living concepts, and to be trendy. Ideal skills and experience: - Proven track record in creative marketing with real estate projects. - Deep understanding of the Saudi Arabian market and heritage. - Ability to merge modern luxury and sustainable themes into the naming process. - Excellent written and ver...
In search of an experienced recruiter with keen insights into the Pakistani IT market. The ideal candidate must have a proven record in hiring senior-level IT professionals. Special emphasis is on the skill sets of: - Web Development - UX/UI Design - DevOps - QA testers Knowledge of the local IT culture and trends will be a major advantage. Looking forward to connecting with a diligent professional to fill these roles as efficiently and effectively as possible. This is an expansive role that requires a wide network and innovative recruiting strategies.
I'm in need of an experienced freelancer who can effectively perform data entry tasks involving financial data. While the specific type of data has not been specified -- it could range from invoices and expense reports to bank statements -- the chosen professional should exhibit versatility and aptitude in working with various forms of financial data. Key Requirements: - Proficiency in Excel: You'll need to be well-versed in using Excel for data entry tasks. - Background in Finance Data Entry: Experience or relevant knowledge in finance data entry is crucial. This ensures you can deliver accurate results. To apply, offer a detailed approach on how you would tackle this project. Also, provide evidence of your past wo...
...highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the requi...
Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab
I intend to streamline the process of document submission and verification in relation to EDPMS entry and BRC, with a focus on customs or trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validati...trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validation purpose. Key Responsibilities: - Submission and verification of customs or trade-related documents - Verification and correction of any errors found in the documents Experience & Skills: - Experience in the customs or trade sector is essential - Proficient in Excel/CSV - Strong attention to detail and high accuracy in document handling - Previous exposure to EDPMS and BRC is...
I've already done most ...the key piece of work. - Comprehensive Review: It's important that you review my analysis comprehensively and suggest corrections or improvements where necessary. - Final Financial Year Analysis: The analysis should cover multiple financial years, ensuring a comprehensive assessment of my trading performance. Ideal Skills and Experience: - Proficiency in Excel: The data prepared to do is in an Excel spreadsheet format, so advanced Excel skills are essential. However I also have a full list of my trades that is only in pdf. - Financial Analysis: A solid background in financial analysis and portfolio management is necessary for this project. The ideal candidate will have a keen eye for detail and the ability to provide reliab...
As your assistant for this project, my job will be to type data into an Excel spreadsheet. However, I currently don't have specific information on what type of data (text, numbers, dates) you require. Additionally, I need clarification on whether you have any specific formatting needs for the data and if any calculations or formulas will need to be applied. Ideal Skills: - Proficient in Microsoft Excel - Precise and quick typing ability - Understanding of Excel formulas (just in case) Your prompt response to these questions will help ensure successful completion of your project. Looking forward to working with you!
...be used for introducing our company and its capabilities to potential clients and partners, with a particular emphasis on attracting interest from government agencies and private companies. Key Components: - Company Background and History: An engaging section that reflects the origin, values, and growth of the company. - Core Competencies and Specialties: A clear and concise presentation of what sets our company apart in terms of skills and expertise. Ideal Candidate: - Proficient in graphic design and content creation. - Demonstrated experience in crafting capability statements. - Clear understanding of marketing and communication principles. - Familiarity with creating detailed documents for the construction and services industry. - An understanding of the expectations and pr...
...architectural drawings in an impressive and articulate format. So, if you've got strong knowledge of residential architecture and experience with these software tools, you could be the perfect fit for this project. Your expertise is paramount for the success of my architectural drafts and interior designs. Individuals with a detailed-oriented mindset and the ability to think outside the box will excel in this project....
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this tas...
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the porta...
For my expanding fashion business, I'm on the hunt for inspired and skilled fashion designers -- those who excel in creating both underwear, swimwear, and sleepwear for Womens. But, the real cherry on top would be a knack for lingrie designs. Key Requirements: - Ability to create unique, innovative designs that target different audiences - Proficiency in both trendy and classic styles. We value versatility! - Expertise in working within a monochrome and neutral color scheme Desired Skills: - Expert knowledge of fashion trends in underwear, swimwear and sleepwear - Exceptional creativity and innovation - Strong sketching skills with attention to detail With your help, we can revolutionize the market by producing designs that encapsulate both the traditional classics and...
I'm seeking a meticulous data entry operator capable of transferring data from digital documents to an Excel sheet. This task involves: - Taking solely textual data from digital documents. - Conducting minor internet research and using ChatGPT when necessary to fully understand the instructions. - Accurately entering the required information on the provided Excel sheet. The ideal candidate for this job is one who is proficient in the use of Excel spreadsheets and has excellent attention to detail. Previous work experience in a similar data entry role is advantageous. This work is specifically in the context of creating content for product listings in e-commerce sites. So if you have specific experience in this area, that would be an ...
Hi, I need to link various data between sections in my current Perfex CRM installation. I'll provide you a staging version of the CRM where you can try the customization and then replicate it into the main version. I've attached an explanatory excel where you can see what data is to be shown in other sections of the CRM. (CRM ) Below you can see what data need to be sync in the Perfex CRM. 1. When creating a Lead-related Task, copy the data [Address] [City] [Description] 2. When creating a Proposal related to the Lead, copy the data [Network] In CRM I created a custom Network field (multiselect) for Leads and Customers and the same field within Proposals as well. When creating a proposal associated with a lead or customer the Networ...
I require a freelancer proficient in excel to assist with data cleaning and sorting tasks for a range of diverse digital files. Your expertise in managing and optimising Excel spreadsheets will be invaluable and greatly appreciated. Key tasks will include: - Using Excel functions to clean datasets, removing discrepancies and inaccuracies - Sorting data into relevant fields and categories for easier access and analysis The optimal freelancer will have: - A meticulous eye for detail to ensure data accuracy - An understanding of Excel formulae and functions - Proven data cleaning and sorting experience - The ability to meet tight deadlines without compromising quality. Your primary role will be to untangle and streamline my Exce...
