How to extract data from different sheets in excel jobs

To help streamline operations in our manufacturing firm, I'm seeking a professional with deep expertise in Excel, as well as a strong foundation in data security. As a result of this project, we need a highly functional, secure Excel template that meets the following requirements: - Advanced Excel Features: The template should involve data entry forms, complex calculations and formulas, and strict data validation rules. It should also facilitate costing, inventory management, attendance tracking, salary calculation, profit/loss calculations, and accounting. An integrated dashboard and graphical representation of data is also needed. - Security: Due to the sensitive nature of the information to...

I am looking for a specialist to create a system within Google Suite that focuses on time off and schedule change requests. The main purpose of this system would be to automate the process of scheduling approved requests into Google Calendar from information submitted via Google Forms and collected in Google Sheets. Key aspects of the system include: - Time off/schedule change requests are submitted via Google Forms - These requests are gathered in Google Sheets. - Upon approvals within Google Sheets, these requests should then be automatically scheduled into Google Calendar. The desired level of automation, for now, is partial. I do expect some amount of manual intervention, specifically - the approval of time-off reques...

...seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to...

I am seeking someone to retrieve specific contact details for a Chinese company located in Tibet. Key Deliverables: - Company Name - Contact Person - Address - Email - Phone Number - WhatsApp Number Preferred Format: The final deliverable should be in Excel or CSV format. Experience Required: - Proficiency in Chinese language and familiarity with Chinese business conventions. - Previous experience in retrieving contact information. - Attention to detail and accuracy in data collection. Please reach out if you believe you have the necessary skills and experience for this task.

Development of a website, with the Wordpress CMS from a figma model.

...through Friday via different tasks we will send you. Job half hybrid in our NYC office/half remote. (no cold calling) Job includes: -Scheduling clients with company for installs via phone calls -Keeping track of installs and inventory -Updating information for bookkeeping -Simple accounting and invoicing -Appointing clients to their appropriate sales rep -Social media management -Answering calls and relaying messages Must: -Speak English -Live in NYC -Have knowledge about common use of simple apps like excel, google drive, word, Gmail, WhatsApp -Organized Preferred: -Spanish / Chinese / Russian speaking -Website building, data security, tech -Photoshop -Living in Brooklyn or Queens Type : NYC only to show not a bot Please inclu...

I am in need of an expert Excel VBA programmer who can enhance my existing proposal workbook. The primary focus of this project is to integrate xlookup functionality and to enable the workbook to generate additional rows and tabs that pull data from various sources. Key Tasks: - Implementing xlookup function: The freelancer is expected to introduce this specific function into the workbook, allowing for efficient data retrieval. - Generating additional rows: The workbook should seamlessly add rows as needed, ensuring comprehensive data management. - Pulling data from tabs: The expert should enable data extraction from various tabs within the workbook, ensuring a streamlined process. - Generat...

I require an Excel expert to assist with a complex data analysis. The dataset is quite large (more than 1000 rows) and involves matching combinations. Key Requirements: - Data Analysis: The main purpose of your task is to help me analyze the data available. This will involve identifying patterns and matching combinations. - Excel Skills: You are expected to have advanced Excel skills to handle this large dataset effectively. - Combination Matching: The combinations you will be working with are complex, and may require manipulation of the data. I'm looking for someone with extensive experience in Excel, particularly in data analysis and matching complex combinations. Your ability ...

Creating a site with Wordpress from a Figma model.

...an expert programmer to build a web scrapping tool that can effectively scrape specific data across 1000's of web pages. The specific websites for this web scrapping operation will be college and university athletic pages. Therefore, among the required skills is the versatility to adapt to different websites' structures and frameworks. In terms of data structure, the scraped data should be organized and stored in a Google Sheets according to categories. This approach allows for a more coherent and systematic pattern for data analysis and representation. The ideal professional for this task should possess: - Proficiency in web scrapping - Expertise in Python or other relevant p...

I need a freelancer to gather contact info for 42 recruitment companies based in UAE. This information will be used for job seeking purposes. Key Requirement: You will need to find the contact name and email (and any additional possible info) for each and every recruitment/HR/Headhunting person within each company. This could be anywhere between 10 to 30 people per company. Total number of contacts would be between 350 and 700. Hays - Robert Half - Michael Page - Charterhouse - BAC Middle East - Adecco Middle East - SOS Recruitment Consultants - GulfTalent - Manpower Middle East - https://lnkd

As a client, I'm looking for a skilled data scraping professional who can create a script or tool that would automate the process of extracting data from both Google Maps and Pappers The main goal would to : Extract companies based on filters on the pappers website. The issue is pappers do not give informations like website or phone number/email. So the goal would be to add more informations to the pappers scrapping with google maps. The issue here is it would take a lot of time to type the companies names found with pappers inside google to get the additonnal information. So there is, maybe, a way to "sychronize" the export (scrapping) of the two plateform and merge them into one excel table,...

i will create 1 power power point and 1 excel sheet adding the equations

i will make excel and power point files

I need to extract data from multiple Excel files and visualize them in a separate sheet using line charts. This project involves: - Creating a separate sheet in Excel to display the data from several Excel files - Implementing a system to automatically update the data - Generating line charts based on the data Ideal skills and experiences for this project include: - Proficiency with Excel, including data handling and visualization - Experience with data extraction and integration - Expertise in creating and customizing line charts The project requires high attention to detail and the ability to work methodically with large datasets.

As someone looking to hire a talented content writer, I have a variety of assignments that'll involve writing content within a word limit of 500-1000 words. I didn't specify the exact type of content since the tasks may vary. However, a strong command of English and the ability to write engaging, quality content are essential. Ideal Skills and Experience: - Excellent writing skills - Versatility in content writing - Ability to generate creative ideas - Experience in varying styles and formats of writing - Understanding of SEO is beneficial, but not required If you believe you would excel at this, I encourage you to submit a bid.

I'd like to request a quote for "xl heet and powerpoint".

I'm looking for a skilled data scraper who can extract specific information from Hungerstation mobile app and compile it into a spreadsheet. Key Requirements: - The data I'm interested in are the menus and prices of the restaurants listed on the app. Deliverables: - The final output should be a well-structured, easy to navigate spreadsheet containing all the menus and prices from the app. Ideal Skills: - Experience in data scraping and extraction - Knowledge of extracting data from mobile apps - Proficient in compiling data into spreadsheets Please apply if you have the skills and experience required for this task. Feel free to ask any questions for clarifications before you b...

...requiring a data scrapping software quickly to extract text content from both websites and PDF documents. It's crucial that the scraped data is directed into Excel or Google Sheets format for my immediate use. Ideal skills for this job would be: - Proficiency in programming languages like Python that are often used for data scrapping. - Familiarity with web scraping libraries or frameworks, e.g., Beautiful Soup or Scrapy. - Experience using APIs to scrape data if necessary. - Previous work in pulling data from PDFs into readable formats in Excel or Google Sheet. - Ability to deliver the project ASAP. Your attention to these requirements will be much appre...

scraping 2750 records from gold-coast-tweed-heads-nsw

We're looking for a web developer to refine an existing HTML page! You'll take a previously converted Excel sheet (.html) and enhance its visual appeal. This involves adding CSS styling to improve the layout, formatting, and overall aesthetics of the page. Experience with HTML and CSS is a must, and an eye for clean and user-friendly design is a plus!

I'm in need of a tech-savvy programmer to build a comprehensive project management software using Trello/ Clickup/ along with Zapier mainly. Some additional software will be google sheets, Jibble.io. This platform should enhance task management, encourage team collaboration, and streamline our time tracking efforts. The key functions of this software should include: - Task Management: The ability to create, assign, and track tasks is essential. The software should allow for task categorization, deadline setting, and progress tracking. - Team Collaboration: The software should facilitate superior communication and collaboration. Features might include chat functions, file sharing capabilities, and project timeline views. - Time Tracking: To enabl...

I have an Android application that I'd like to enhance with a review feature. - The reviews should be submitted on a third-party platform linked from the app. - Ideally, I'd like to incorporate some form of user authentication before reviews are accepted. I'm open to suggestions on how to best handle the authentication process. The overall goal is to encourage genuine and constructive feedback while preventing spam or irrelevant reviews. I'm looking for a developer with experience in Android app development and implementing user engagement features. It's important that the final solution is user-friendly, secure, and seamlessly integrated with the existing app. Your ability to propose and impleme...

I'm seeking a skilled developer to create a website where users can generate customized Excel tables. Below are the key project requirements: Key Functions: - The website should allow users to generate customized Excel tables based on specified criteria such as user input, date range, and data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering:...

I'm seeking a professional freelancer who can meticulously remove text watermarks from various photographs. - Primary Task: Accurate and subtle removal of text watermarks from my photographs, without affecting any area of the images adversely. - Output: Photographs should retain their original quality after the watermark removal. Ideal freelancer must: - Have a proven track record of handling similar projects and using image editing software competently. - Be detail-oriented to ensure that there is no damage to the original image. - Deliver high-quality, original-retaining photographs promptly. Your handling of this task must uphold the integrity of the photographs while removing the watermarks completely.

The project requires a freelancer with exceptional attention to detail and expertise in Excel to conduct a thorough review of a spreadsheet for any data inaccuracies and anomalies. The primary tasks involve identifying and rectifying incorrect or illogical entries, ensuring the consistency and integrity of the data, and highlighting any variables that require correction. The ideal candidate for this role should have strong proficiency in Excel and data handling, as well as experience in data quality assurance. This meticulous review is crucial to maintaining the accuracy and reliability of the data, which is essential for making informed decisions based on the spreadsheet information. Attached with...

...values data, I'm looking for a talented individual who can handle a medium-sized excel database (1000-5000 rows) that comprises of numerical, categorical and textual data. Key Tasks: - Data Entry: The selected candidate will need to input some outstanding data into the excel database accurately. Great attention to detail is vital for this task. - Data Analysis: I want someone who can decipher patterns and trends from raw data. This may include evaluating figures, trends, and other areas to draw practical insights. - Data Visualization: After carrying out an in-depth analysis, I want the extracted information to be presented visually to aid understanding and decisio...

As a beginner, I'm in need of someone skilled in typing data into Excel spreadsheets. The data entry will involve basic formulas and functions for simple data analysis, and I'm looking for someone who can make this process easy to understand and execute. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Able to explain basic formulas and functions in a clear and concise manner - Attention to detail to ensure accurate data entry - Patience and understanding of beginner level tasks

I need a meticulous and responsible professional to help me with cataloging 1000-1200 books. Here is a detailed breakdown of the project: - **Data Entry**: I need all of the books' titles and their respective authors accurately entered into an Excel spreadsheet. This will be done manually, so you must have excellent typing skills and attention to detail. - **Turkish Characters Proficiency**: An essential requirement for this job is a strong proficiency with Turkish characters. As some of the books will have titles and authors in Turkish, you should be able to accurately interpret and enter these characters. - **Handling Missing Data**: In the event that a book's details are missing or illegible, I would like you to...

Laravel Report loading slow. There is minor difference in the report and actual. Developer who able to work with ftp.

Hello there, I hope this message finds you well. I am reaching out to invite you to collaborate on an exciting project aimed at revolutionizing heat insulation solutions for metal sheet applications. We are in need of your expertise as a formulation chemist to develop a cutting-edge heat insulation coating that can significantly lower the internal temperature of metal sheets upon application. Our goal is to create a coating that not only provides excellent thermal insulation but also maintains the structural integrity of the metal sheet. More details are in the attached file. Thanks Mahesh

I'm in need of a freelancer who can help me create a visually appealing PowerPoint presentation and handle some moderate data analysis in Excel. PowerPoint: - Your role will be to make my content visually engaging through simple transitions and animations. - Creativity and a good eye for design are essential to make the presentation impactful for the audience. Excel: - You will also be tasked with handling moderate levels of data analysis and visualization. - I will require you to work with pivot tables, conditional formatting, and possibly other mid-level Excel skills. Ideal Skills: - Proficient in PowerPoint with a strong design sense. - Comfortable working with Excel and able to hand...

Please DONT APPLY of you dont have the experience an...(Retrieval-Augmented Generation) applications. The main objective of this project is to build a chatbot based on a repository of documents. Key Responsibilities: - Implementing PDF parsing capabilities to extract textual data for processing - Integrating OpenAI APIs to enhance the chatbot's responses - Building a RAG-based chatbot system for providing contextual answers The ideal candidate should have: - Proficiency in NLP and experience with developing language models - Strong skills in integrating APIs - Previous experience in building chatbots or conversational AI systems - Familiarity with RAG applications and question answering systems If you have the necessary skills...

I'm seeking a skilled app script professional to improve functionality in my current Google Sheets. The job entails creating connections with external APIs, and add a multiple drop down function in Google sheet. This is different than dependent drop-down and I require to use just one cell for the multiple drop down rather than using the next cell. Key requirements: - Add two dropdown menus - The menus need to feature a predefined list of words - Experience with Google Sheets and App Script Recommended skills: - Google Sheets - Google App Script - API Integration

I'm looking for a Python programmer who can create custom code to extract text, numerical data and dates from an Excel spreadsheet and populate PDF fields using the PDFMiner library. You should be confident writing Python scripts and have experience manipulating Excel and PDF files. Familiarity with PDFMiner is a essential. - Must Haves: - Proven Python programming experience. - Familiarity with the PDFMiner library. - Ability to extract and manipulate data from Excel. - Experience in PDF field population.

I'm looking for a skilled developer to create an online interface which can upload a Word document and extract key pieces of information to populate a database. Key Requirements: - Extract multiple fields: The tool should be able to efficiently parse and extract a range of fields from the Word document, such as Title, Author, Date, Description, and Quantity. - Metadata Extraction: The primary focus of this project is to extract specific metadata from the document, specifically Date, Description, and Quantity. - Populate Database: The extracted data should then be used to populate a database. Ideal Skills and Experience: - Proficiency in programming languages and tools for working with Word ...

I require proficient help to tackle a substantial data cleaning and organization job. The task involves over 2000 records that must be meticulously cleaned and streamlined. You'd be working directly in Excel, so a thorough knowledge of this software is essential. Understanding of data organization, deduplication, and data cleaning is required. Aptitude for managing large quantities of data would be advantageous. A keen eye for detail and commitment to delivering high-quality results are crucial.

I'm looking for a financial analyst who can help me with my small business's financial data. Key responsibilities and requirements include: - Analyzing income statements, balance sheets, cash flow statements and projected profits. - Conducting financial analysis twice a year (bi-annually). - Focusing on revenue trends, expense breakdown and profit margins. The ideal candidate should be well-versed in financial analysis techniques and should have experience in dealing with small businesses. A deep understanding of income statements, balance sheets, and cash flow statements is crucial as well. This is a great opportunity for a financial expert who can deliver accurate, actionable insights to help me make informed decisions about my bu...

I'm looking for someone proficient in data entry to help me transform scanned PDF documents into an organized spreadsheet format. Ideal Candidate: - Proven experience in data entry from PDF to excel or similar - Precise attention to detail to ensure accuracy of the data - Efficiency to meet deadlines with minimal supervision Principal Duties: - Convert scanned PDFs into an Excel spreadsheet - Focus on extracting and entering text content from the PDF documents - Maintain the overall integrity of the original information - Ensure the accuracy and reliability of the final spreadsheet data

I'm in need of an experienced data entry specialist to input text-based data from typed documents into an Excel spreadsheet. I have a series of typed documents that need to be transferred into Excel. The data consists entirely of text, with no specific formatting required. It's important that the freelancer pays close attention to detail in order to ensure the accuracy of the data entry. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong attention to detail - Previous experience in data entry - Time management skills to meet deadlines - Ability to do research - Fluency in English

I'm looking for a diligent freelancer who can help with entering text data from handwritten documents into a digital format. Requirements: - Entering text data from handwritten documents - Ensuring general accuracy (minor errors are acceptable) - Organizing the data in a clear and coherent manner Ideal Skills: - Proficiency in data entry - Attention to detail - Patience and perseverance - Basic understanding of the English language The task requires someone who is meticulous and can maintain a good level of accuracy throughout the process. If you have experience with data entry and can ensure timelines are met, I'd love to hear from you.

I am in need of a seasoned data entry professional who can attentively transcribe information from various online databases into Google Sheets. The role is strictly manual data entry. Skills and Experience: - Proficient with Google Sheets and similar spreadsheet management tools. - Past experience with database interaction, particularly online databases. - Must have a keen eye for detail to ensure accurate data transcription. - Excellent time management skills are essential as deadlines are strict. Although this position emphasizes manual data entry skills, experience in data cleaning and validation pave the path for optimal efficiency. The successful candidate must provide proof of prior similar projects. Yo...

I need a Word file created from the content I will provide. The content will be used for a legal documentation/report. Key Requirements: - Type the provided content into a Word file - Ensure accuracy and appropriate formatting - Comprehension of legal terminologies and conventions is preferred, though not mandatory Ideal Skills: - Fast and accurate typing - Experience with Word processing - Understanding of legal terminology (preferred) Please note, the content will be provided in raw form and will need to be transformed into a cohesive, well-structured document. If you have experience in legal document creation, it would be a huge plus.

...seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to...

I'm seeking a skilled freelancer to analyze data provided. I can provide an excel file which will have -Customer -Invoice Number -Date -Product Details -Quantity -Unit Price -Purchase Amount I have this data for last two years in monthly files. We want to observe the trends in sales, most selling product, most profitable product, least profitable product etc. We want to see the customers trends and see which customers are buying less and vice versa. Please recommend technology we are open to feedback. Along with this i will like another separate file for another user who will look after the Customer Service and sales side of the business. I would like this second file to extract selective data ...

...Translating and reclassifying financial statements from Italian and Romanian to English. - Aggregating financial statements from various group companies to form a single consolidated financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal years. Requirements: - Certific...

I need a Google Doc converted to Google Sheets while maintaining the formatting of the original document. This will ultimately be a printable document, so the Sheets version should look identical to the original Doc. Key Tasks: - Move all content from the Google Doc to Google Sheets - Copy all the imagery over and have it formatted for easy editing - Ensure that the content is laid out exactly as the Google Doc (as it is a proposal document) - Implement specific formatting requirements such as: - Header and footer - Page numbering - Font styles and sizes (as per a style guide) - Imagery and pictures Ideal Skills: - Proficient in Google Docs and Google Sheets - Strong attention to detail - Experience with docume...

I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.

I require a software solution that can extract and unlock full calibration data from a sensor for further analysis. The software must have the ability to interact with the sensor via USB connection. Key Features: - should be able to fully extract the calibration data from the sensor - the tool should be user-friendly and have a clear interface - the software should have a USB connection for the sensor - the software should be able to output the data in a readable format for further analysis Ideal Skills: - Proficiency in software development - Experience in sensor calibration and data extraction - Familiarity with USB connections and software interfacing - Strong understanding of data...

...director, I am in need of a highly skilled secretary who can handle a variety of tasks. From scheduling my appointments and managing email correspondence to organizing my documents and files, this role is vital to the efficient running of my office. Key responsibilities include: - Scheduling appointments and meetings: You should be adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel...