Combine two excel sheets based on common column jobs

I'm looking for an experienced Excel Power-BI professional to assist me with various tasks. Key requirements: - Proficiency in Excel Power-BI. - Demonstrated experience in data analysis, dashboard creation, and report generation. - Ability to work with minimal supervision. I will share more details in via chat box. Only interested person placed a bid Thanks

I'm seeking a Django and Python Fullstack developer who can lend their expertise to my application project. The chosen freelancer should excel in creating: - Robust user authentication and authorization systems - Seamless database integration - Responsive design that adapt to various devices I have certain design ideas but I would highly appreciate guidance to help realize these concepts. The freelancer should possess a strong grasp of user-centric design and prove instrumental in translating these concepts into a streamlined, functional, and easy-to-use interface. Ideal skills: Python, Django, Database Management, User Interface Design, User Experience Design, and Responsive Web Design. It's a bonus if the candidate has a knack for making technical functionalities sim...

I am seeking a graphic designer how can abstract a high res logo of an existent brand design. Your deliverable: - Create an original, abstract logo for ExcitaBrand - Use a color palette of yellow, white, black, and orange (as per current design) The ideal freelancer should deliver within 2 days and should be comfortable with abstract designs and skilled in color theory to effectively combine yellow, white, black, and orange to create a logo that is modern, engaging, and visually appealing.

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

...with ( cash in flow and cash out flow. . It should encompass data on sales, expenses, and profits, analyzing trends and variances, while also incorporating a break-even analysis. Key Requirements: - In-depth monthly analysis of sales, expenses, and profits. - Solid experience in applying trend analysis. - Capable of conducting variance analysis. - Skilled in implementing break-even analysis. - Previous experience in creating comprehensive business financial forecasts. The end goal of this project is to have a detailed yearly overview of my business's financial health, with a focus on identifying trends and outliers, and ensuring our financial strategy is aligned with our business goals. Ideal Skills: - Advanced Excel proficiency. - Expertise in financial...

...Integration 1. Website Development (Exclude Content) Overview: Develop a survey website that allows users to register, upload documents, make payments, and track the status of their submissions using a unique tracking number. Additionally, integrate a WhatsApp or chatbot for customer support. Frontend Development 1. User Interface Design: • Create a responsive and user-friendly design that works on all devices (desktops, tablets, mobile phones). 2. Components: • Homepage: • Engaging visuals and clear messaging to capture visitor attention. • User registration, login, and payment links. • Introduction to the service. • About Us Page: • Detailed information about the company's background, values, and team. • Products/Services Page: &bull...

I'm in need of an expert in Excel for a project centered around statistical data analysis. Key Requirements: - I require someone able to handle statistical analysis in Excel. - The data is large and will require a high level of accuracy and attention to detail. - Since the data source is not specified, you should be flexible and able to adapt to varying data types. Ideal Skills and Experience: - Proficient in Excel, especially in handling large data sets. - Experience with statistical analysis in Excel. - Previous success in providing accurate data analysis. Please note the source of the data is not explicitly mentioned, so experience with different data types is a plus.

I’m currently in search of a multitasking office boy, who aside from being handy with common office duties, is also an experienced electrician. Their responsibilities will include: - Installing and repairing electrical outlets - Troubleshooting common electrical issues Along with the electrical tasks, the hired individual would also be expected to execute: - Cleaning and organizing tasks within a large office space environment, consisting of 7+ rooms - Running necessary errands as and when necessary - Assisting with basic office administrative tasks Ideal candidates should be well organized, experienced in office administration, and have a proven track record in handling electrical tasks. Prior experience in a similar role will be highly preferred.

I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.

...custom online form on my website using WPForms. The form should save all submitted data to a database. Here are the specifics: - **Export Data:** The form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience ...

I need a data entry specialist to clean a dataset to be used for reporting and analys...the inconsistencies, errors, and duplicates in the dataset to make it suitable for reporting and analysis purposes - Ensuring the dataset is properly formatted and organized for its intended use Skills and Experience: - Proficient in data cleaning with a keen eye for detail - Experience with Excel and data entry is a huge plus - Strong understanding of data maintenance and organization - Ability to follow data cleaning guidelines and ensure data integrity The final dataset should be delivered in Excel format. The successful candidate for this job will have a deep understanding of data cleaning, excellent attention to detail, and the ability to deliver a clean dataset suitable for report...

I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure...

I'm in search of a talented individual who can create a series of GIPHY designs catering to two separate businesses. The ultimate goal is to offer a range of animated logos, product animations, and custom illustrations. Business one- body composition and metabolic testing business. showcase the brand and products etc Business 2- breathwork, mindset Key Points: - You'll be working on GIPHY designs for two distinct businesses - The designs should encompass a mix of animated logos, product animations, and custom illustrations - The animated logos should carry elements of modernity, playfulness, and professionalism Ideal Skills and Experience: - Proficiency in GIPHY design and animation - A strong portfolio showcasing a diverse range of design styles - A...

...calibration, and part replacements. Frequency of Maintenance: Specify how often each maintenance task needs to be performed. This could be based on factors like manufacturer recommendations, usage hours, or time intervals (e.g., daily, weekly, monthly). Priority and Criticality: Prioritize equipment based on its criticality to operations. This helps in ensuring that maintenance efforts are focused on the most important equipment first. Assigned Personnel: Assign responsibility for each maintenance task to specific personnel or teams. This ensures accountability and clarity on who is responsible for carrying out each task. Completion Tracking: Include a column or section to track when each maintenance task is completed. This should inc...

I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.

I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

...need a Google Sheet that will serve as a simple database for my business. Here's what I need: - Data entry and storage: This is the primary function of the sheet. My team will need to manually input data into the sheet on a regular basis. The sheet should be well-organized to easily accommodate new entries without compromising the existing data. - Access control: Only I, as the owner, should have the permission to edit the sheet. It's important that this access control is robust to maintain data integrity and security. I'm seeking a freelancer who is proficient in Google Sheets and can deliver a simple, user-friendly, and secure solution for this project. Experience in data management, user access control, and business data storage would be a plus. Your b...

I am looking for a creative and talented logo designer to help me create a logo for my youth program, "Summit Seekers Squad". The ideal candidate should be able to: - Translate the spirit of my program into a visually app...combined education, outdoors, and leadership. I have provided the font sample and logo sample along with colors and help me design a logo. I have given 2 specific S examples only use those or small variances of those logos Must have hands around it to be considered Must use tagline "seek and you shall find under or around logo Only use the two S logos for design inspiration and do not variate to far. My main goal is to combine the elements we already have to a tasteful logo Please keep these colors and elements consist...

I'm needing a skilled Wix developer to build a membership website for our association. This project encompasses numerous features: - Member Registration: Design an accessible registration process for new members. - Payment Processing: Implement a seamless and secure system for processing recurring membership subscriptions. - Member Login & Account Management: Enable members to login using their email and password in order to manage their own account details. Prior experience in executing similar projects and knowledge in payment gateways is preferred. The website should be user-friendly, guaranteeing our members a smooth and intuitive experience. Your expertise in building Wix websites will be instrumental to the successful completion of this project.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

I'm seeking a proficient freelancer to assist in a straightforward yet critical task. The project involves: - Data Entry: You will be required to input simple text or numbers into an Excel sheet. - Data Collection: Sourcing of data forms part of the project. This encompasses the need to gather the necessary information for the task. The ideal candidate for this role should have: - Strong Excel Skills: Proficiency in Excel is a must. You should be comfortable with data entry and basic functions. - Attention to Detail: Accuracy is paramount in this task. - Research Skills: The ability to efficiently source and collect the required data. Candidates with a track record of completing similar tasks efficiently and effectively will be highly regarded.

...assistant to manage my emails and handle various data-related tasks. Key Responsibilities: - Manage and respond to 10-50 emails daily in a timely manner - Efficiently handle data entry and management tasks - Create, update, and maintain spreadsheets - Conduct research and collect relevant data as required Ideal Skills and Experience: - Proficiency in using Google Suite, particularly Gmail and Google Sheets - Previous experience as a virtual assistant or in a similar role - Excellent organizational and time-management skills - Strong attention to detail and accuracy in data management - Good written communication skills for email handling - Ability to conduct research and data collection effectively The successful candidate will be proactive, self-motivated, and able to work i...

I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaningful analysis - Opportunities t...

I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so experience with this type of formatting is an...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I'm in need of an experienced PHP developer to assist in enhancing my project with specific focus on design modifications and functionality enhancements. Key Tasks: - Design Modifications: The project requires a design overhaul to improve aesthetics and user experience. This includes updating the layout, color scheme, typography, and overall visual elements. Your ability to create appealing, modern designs that align with our brand is crucial. - Functionality Enhancements: There are certain functionalities within the project that need to be revisited and improved. Your role will involve identifying areas for enhancement, suggesting necessary changes, and implementing these updates effectively. You should be well-versed in PHP development and capable of optimizing existing fea...

I'm currently in need of someone with expertise in graphic design to help reimagine the layout of my existing text-based logo. While the style should remain consistent, I want to rearrange the logo so teh writing is all on one line, retain the turbo either between the works or at the end of the words and remove the spanner. The logo is for a long banner for the front of a building. Key requirements include: - Ability to work with text-based logos - Skilled in modern, minimalistic design - Proficient in reorganizing elements for a visually striking yet organized output Aesthetics are vital in this task, yet the ability to incorporate the reorganized elements seamlessly into the existing style is equally important. Note that the style is not changing, it's...

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

I'm looking for a skilled developer to assist with my social networking platform. - I'd like to add new features to my website. These could be anything from messaging and notification systems to user profile enhanceme...could be anything from messaging and notification systems to user profile enhancements. - I also need help debugging and fixing errors. If you have a keen eye for detail and are a good problem solver, you'd be a great fit for this job. - If you have experience with optimizing and improving the performance of websites, that would also be a big plus. - While the CMS is not specified, knowledge of common CMS platforms such as WordPress, Joomla, or Drupal may also be beneficial. Your experience in web service development and social networking platfor...

I have an html form php file on my server. I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields. Can you help with this? We have an form in the laravel, these are three main tasks : 1) Secure the form with 6 code passcode. 2) Update the URL of the form. 3) Save the form data in google sheet. There are various tabs in the sheet, so we need to save the data in google sheet tabs as per the dropdown sel...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and cha...

Please Sign Up or Login to see details.

I'm looking for a Laravel expert to integrate Google Sheets into my system. Specifically, I want to connect it with a form on my site for seamless data handling. I have an html form php file on my server (built in laravel). I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields.

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

I'm looking for a skilled professional to set up a Virtual Box on my dedicated server, running Windows OS. The primary function of this setup is to have multiple virtual terminals of Windows operational. Key requirements: - Installation of Virtual Box on a dedicated server - Configuration for simultaneous operation of 5 virtual terminals of Windows Ideal skills and experience: - Proficiency in Virtual Box and working with dedicated servers - Strong knowledge and experience in setting up and configuring Windows OS - Ability to ensure smooth and efficient operation of multiple virtual terminals

business profit loss reporting excel(Jan, Feb & March)

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression an...

I need an experienced data entry person to perform research on Twitter(X) for crypto/stock twitter influencers/posters with over 1,000 followers who make predictions on crypto/stocks. @CryptoCapo_ is one example of a desired crypto influencer account. I also want you to find stock and crypto prediction Substack accounts, there is no subscriber minimum. It is your job to find other similar accounts and make a spreadsheet with two sheets, one for twitter and one for substack. the twitter sheet will include the twitter handle and the link to their profile for each account. The substack sheet will include the link to the main substack page, the number of subscribers, and whether the substack is free or paid. if the substack is paid, please have different columns ...

ATTENTION: This is not a project to create a 3D model. It's to create a sample mobile app in Flutter. I need a 3D object renderer programmed in Flutter for PLY files. The intended purpose is visualization rather than animation or virtual reality. The selected candidate should possess: - A strong knowledge ...Flutter and 3D rendering techniques. - Previous experience in creating high-quality renderers, as this project demands a high-performance level. The renderer should include the following functionalities: - The ability to rotate objects. - Zoom in and out capabilities. As an expert in this field, you're expected to provide advice on the best techniques and practices to achieve a high-quality 3D object visualization. The Flutter project need to be executable o...

...Implementing new search criteria: Specifically, I need the addition of a new category search criterion using the Smyles Plugin on the back-end. - Ensuring a smooth integration: You must make sure that all changes and additions are fully integrated with the existing system without causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for em...

Hi Laravel senior developers. I want a video explanation on already project written for explanation. should be fluent in English to explain the codes to me better.

...launch and scale of my new Info Product, a Home Services based Launch and Scale Program. The ideal candidate should be based in the US, have an excellent command of the English language, and possess a proven track record of successful high-ticket sales. Key Responsibilities: - Collaborate on the development of sales strategies for the Home Services program - Conduct sales calls and negotiations with potential clients - Close high-value deals in the Home Services industry Ideal Skills and Experience: - Proven experience as a high-ticket closer in the US market - In-depth knowledge of the Home Services industry - Excellent communication and negotiation skills - Experience in launching and scaling of info products is a plus If you are a US-based high-ticket c...

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

The WhatsApp bot contains two services: one for subscribers and one for the general public. For the general public: 1. When a sender sends any message, number, or letter, the bot greets them and requests input of a code or menu name (there are 200 codes or menu names available). 2. If the input is incorrect, the bot asks the sender to resend the correct code, send an image containing all the codes, or return to the main menu. 3. If the code is entered correctly, the bot displays general information in text form taken from a Google Sheet. Along with this information, a menu is displayed: • PDF file extracted from Google Drive or a folder • Image • Information in text form taken from a Google Sheet • Input another code • Return to the main menu For subscribers...

...for my hair salon, "CXR Hair Studio". I'm looking for a simple and sleek text-based logo. You can have the words “cxr” and “hair studios” in different fonts to spice it up. The main requirements are: - Color Scheme: The logo should have a black background with white letters. The words “CXR” and “hair studios” can be in different fonts to spice it up as well. This minimalist approach will help maintain a clean, professional look that's essential for a hair salon. - Font Style: I'm hoping to have an elegant font style for the logo. This will give it a sophisticated and stylish visual appeal. - Graphic Elements: I'm not looking for any graphic elements to be incorporated with the text. The focus should s...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.