Excel data table lookupproiecte

I need a freelancer with a deep understanding of Excel ,data management and social media to extract info from profile list that we have . As the project involves organizing approximately 20,000 rows of data, proficiency in handling large datasets will get you far in this task. Key Project Details: - Data Type: The data primarily comprises email addresses and phone numbers. - Links in Profile - Other profiles in the profile - Formatting: The data files contain labels, so you'll need to distinguish this information keenly. Ideal Skills: - Proficient in Excel - Expertise in data management - Data Scraper

I need an expert with strong Excel skills to create two simple line graphs. Though I didn't provide specifics, these will be used to illustrate financial data, so experience in creating graphs for financial analysis would be ideal. Fast turnaround is critical. I will share 2 images of sample graphs. You need to put same data but have to create it line graph and in excel. I need this now. If you can't do now then please dont waste my time.

I require a professional who can develop a detailed sales forecasting report leveraging Power BI. The project needs to be done within one day. Key Requirements: - Utilize data from Excel spreadsheets for the forecasting. - The sales forecast should be detailed, breaking down sales by product/service. - The forecasting model should be based on regression analysis. Ideal Skills: - Proficiency in Power BI. - Strong experience in Excel data analysis. - Proven track record in regression analysis for sales forecasting. - Ability to work under tight deadlines.

I am in need of a Visual Basics code in Excel that specifically focuses on equipment check-in and check-out functionality, while also automatically creating a record for each transaction. Key Features: - Equipment Check-in and Check-out: The primary purpose of the program is to allow users to easily check equipment in and out. - Automatic Inventory Status Update: The program should update the inventory status automatically, ensuring that the availability of each item is always up to date. Additional Features: - Daily Reports: The program should generate daily check-in and check-out reports - this would be beneficial for managing equipment usage and tracking. - Statistics: The program should also provide statistics on equipment usage. This could help in determining patterns of usag...

Transferring data from a jpg file to an excel table. With online access via google

I'm looking for a Power BI expert to help me set up a robust sales forecasting system. Responsibilities: - Integrate my Excel spreadsheets into Power BI Desktop - Design visually appealing and intuitive dashboards that clearly display sales forecasts - Utilize Power BI's capabilities to predict sales trends Ideal Skills: - Proficiency in Power BI Desktop - Expertise in Excel spreadsheet integration - Proven track record in sales forecasting - Strong communication skills to understand my business and its sales forecasting needs This project requires someone who can not only set up the technical aspects but also has a deep understanding of sales forecasting.

I'm seeking an experienced and professional individual who can create a fillable PDF form tailored to recommenders. While the specifics of the fields are flexible, I will value a detailed project proposal on how you plan to develop this form. Your experience with such tasks and any innovative suggestions you might bring to the table will be highly considered. Key skills and experience: - Proficiency in Adobe Acrobat, FormStack, JotForm or other similar programs - Experience with creating fillable PDF forms - Strong understanding of form design principles for ease of use - Ability to include detailed project proposals in the application. **attatched is an example of the document that I need to be filled. Where it had bracket is where I was the PDF to be filled in.

I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more d...

I am seeking a proficient web data scraper to extract specific information from a prominent South African property portal and organize it in an Excel spreadsheet. Key Project Requirements: - Extracting and organizing the following data: property information (e.g., price, location) and size. - No need for continual updates, just a one-time extraction. Filtering Criteria: - The data to be scraped should be from a particular property portal and should extract information like : property type (industrial/retail/office), size, address, price. Ideal Skills: - Proficiency in web scraping techniques and tools. - Strong experience with Excel and organizing large sets of data. - Familiarity with the South African property market would be a plus. The g...

...locate and verify the schools that meet our criteria. - Mapping: Proficiency in using online mapping tools is essential. - Data Management: The final report should be in Excel format. Experience handling and analyzing data in Excel is a must. - Need to confirm they have sports facilities - Data needed is Name of school - distance to tube - address - Phone number off the school site There is a list of 151 schools already on the list these will be provided and can not be used. The budget is $25 to start but if it goes well will become full-time for 4 to 12 weeks. We have other areas outside London coming up as well. The final output should be a comprehensive Excel spreadsheet that includes the name and address of each school, along with the...

>>Read first stop waisting time it is unprofessional << this is not a project this is a full-time job ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>Your bid should be your monthly salary or it will be ignored <<< ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Don't bid blindly you will be ignored if you don't reply and start your text with >>Full ...where you've focused on these two platforms. Showcase your ability to adapt to different project scopes and requirements. If you can handle this dual-platform project with efficiency, we are looking to form a long term collaboration. Take this opportunity to be a part of an exciting, evolving project, while honing your Wordpress and Laravel skills. I am excited to see what you can bring to the ...

convert gramms per second to litres per m thermodynamics fluid in excel calcualtor pv=nrt

I have a number of JPEG images with text which I need to be transcribed into an Excel spreadsheet. The task should take around 2 - 3 hours to complete. Key Requirements: - Convert text from JPEG images to an Excel spreadsheet - Organize the data into categories as requested - Implement numeric data validation checks for accuracy Ideal Skills: - Proficient in data entry and data management - Familiarity with Excel and its functionalities - Strong attention to detail and accuracy - Experience in implementing data validation checks Please ensure that before submitting, you are confident in your ability to deliver an error-free and well-organized Excel spreadsheet.

I have a PDF catalogue that I need converted into an Excel spreadsheet. The PDF contains a mix of text and images which are crucial for the data. Key requirements: - Extract the data from the PDF and input into an Excel sheet. - Embed the images within the corresponding cells in the Excel file.

I require an accurate and efficient individual to input a combination of numeric and text data into a spreadsheet. This will involve less than 1000 entries. The primary task will be to input shipment data from Bills of Lading (BOLs) into an Excel file (.xlsx). The data must be organized based on specific categories found in the BOLs. Therefore, attention to detail and a keen eye for categorization is crucial. NOTE: BOL's shipped to the same location (multiple BOL's) must be added together on the same line. EXAMPLE: 1/1/2024 (5 Pallets) To Store #2595 2/1/2024 (4 Pallets) To Store #2595 NOTE: There are two types of BOL's a. Multiple Stop BOL"s. These will have 4-5 store location drops / entries to be made. b. Si...

Having set up a site on Wix, I'm now envisioning a more engaging design layout. I need a Wix expert who can bring this vision to life through: - Changing the layout, with prima...engaging design layout. I need a Wix expert who can bring this vision to life through: - Changing the layout, with primary focus on: - Menu navigation: Give the website a more user-friendly navigational setup. - Content structure: Layout restructuring aimed at improved coherence and streamlining of the content presentation. Not only do you have to bring design customization experience to the table, but also a deep understanding of Wix's features and a knack for user-experience best practices. Apply within if you have the skillset to juggle these requirements effectively. Note : I will pr...

I'm in need of a skilled blockchain developer with experience in Ethereum testnet specifically sepolia, to assist me in developing smart contracts. The key points of the project include: -**Fully Functional Frontened working with smart contract functions - **Smart Contracts Development**: Your primary role will be to develop smart contracts on the Ethereum testnet for a project funding platform...(Sepolia) - A solid understanding of smart contracts and token standards - Previous experience in developing platforms for project funding (token funding)and marketplaces - Good communication skills and the ability to work collaboratively Your work will be pivotal in making this project a reality, so I'm looking for someone who can bring both technical expertise and a creative approach ...

I'm seeking a talented logo designer to create a unique and sophisticated logo for my cosmetic brand. The ideal candidate for this project should: - Possess a strong portfolio with prior experience in creating elegant and so...with prior experience in creating elegant and sophisticated logos. - Be able to deliver a sleek, modern design that embodies the essence of the brand. In your application, please provide links to your past work, specifically any relevant examples that exhibit your ability to create sophisticated designs. The successful freelancer will be expected to bring a fresh and refined perspective to the table, so I'd like to see evidence of your creativity and originality in your previous projects. Concept link in dm All details will be sent in Dm .. Previo...

Expert in MS excel for automation of sheets

I'm looking for a skilled freelancer to help me customize my Excel alerts with WAV files. - I have the specific sounds in mind for each type of alert, but I need someone who can skillfully integrate these into Excel's alert system. - You should have experience in both Excel and sound file manipulation, in order to create a seamless and professional system. - Please provide examples of past work to showcase your compatibility with this project.

...an Excel file that I'd like to convert to a Google sheet. I need the Google sheet to keep all the formulas that are present in the Excel file. Key Requirements: - The Google sheet should have all the formulas intact from the original Excel file. - Include Data validation rules to ensure the data entered is accurate and meets certain criteria. - Implement Conditional formatting to visually highlight important information. - Custom scripts or functions to automate certain tasks and enhance the sheet's functionality. - Preserve font styles and retain cell borders from the original Excel file. - Maintain the column widths as in the original Excel file. Skills and Experience: - Proficiency in Excel and Google Sheets, includ...

I'm looking for a professional who can help me develop a comprehensive Excel workbook for RFQ analysis and purchasing. The primary goal of this tool is to streamline our purchasing process. Key Responsibilities: - Develop an Excel spreadsheet for RFQ analysis and purchasing. - Implement basic formulas and functions to automate data analysis. - Ensure the tool is user-friendly and easy to navigate. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of its functions. - Experience in developing purchasing and analysis tools. - Ability to streamline processes through automation. This is an exciting opportunity for someone with a keen eye for detail and a strong understanding of purchasing processes. Looking forward to your proposals...

We already have a figma template for our design, you should use the same to design the onePager Description: We are seeking a talented UI/UX designer to join our team and help create an intuitive and visually engaging OnePager for our graphic generation platform. As a UI/UX designer, you will be responsible for designing the interface and user ex...as Adobe Photoshop or Illustrator. How to Apply: If you are passionate about UI/UX design and interested in working on an exciting project, please submit your proposal along with your portfolio showcasing relevant work samples. In your proposal, include your approach to designing a user-friendly OnePager for our graphic generation platform and any relevant experience or skills you bring to the table. We look forward to reviewing your app...

I'm looking for a diligent researcher who can compile a list of tire processors across different US states and organize the information in an Excel spreadsheet. Key Responsibilities: - Conducting online research to identify tire processors in each state. - Collating specific information (company name, contact person, phone number) for each processor. - Inputting the data into an Excel spreadsheet with consistent formatting. The ideal candidate should have: - Proficiency in web research and data entry. - Excellent attention to detail. - Strong Excel skills, with knowledge of maintaining consistent formatting. - Prior experience in conducting similar research would be an added advantage. The final list should be organized by state, with each entry c...

I'm looking for an expert in data analysis to assist with a project in Excel. The data provided is well-structured and needs extensive examination to extract meaningful insights. Ideal Candidate Skills: - Proficient in Excel and its data analysis tools - Strong analytical abilities - Excellent understanding of data organization Deliverables: - Clear analysis of the structured data - Relevant insights extracted from the data - Detailed reporting on the findings This project is particularly suited to those with a keen eye for data and the ability to utilize Excel's functionalities efficiently. Thanks!

I have a one-time task of converting data from an HTML table to a CSV file. The HTML contains a table that I need to extract, sort, and organize into a CSV. Key requirements: - Extraction of table data: The HTML file contains a table, and I need all the data from this table to be correctly extracted into a CSV file. - Sorting: The CSV file needs to be sorted based on a specific column in the HTML table. Ideal Skills and Experience: - Proficiency in HTML parsing and data extraction. - Experience in CSV file handling and organization. - Ability to sort data based on a specific column. - Attention to detail to ensure all data is accurately transferred.

I am looking for a dedicated and detail-oriented data entry operator to assist with a large volume of data entry tasks. Key Responsibilities: - Typing, copying and pasting, data validation - Handling a large volume of entries Ideal Skills and Experience: - Proven experience in data entry - Expertise in handling large datasets - Proficiency with text documents (Word, PDF) and spreadsheets (Excel, Google Sheets) - Attention to detail and accuracy - Time management skills to handle large volumes of data

I need an Excel spreadsheet that allows me to input a starting point's latitude and longitude, a heading (in degrees), and a distance (in kilometers), and then calculates the new latitude and longitude based on a rhumb line calculation. This tool will be primarily used for navigation purposes. Key Features: - Input fields for starting latitude, starting longitude, heading, and distance (all in kilometers) - Calculation of a new latitude and longitude based on the input - Utilization of the Rhumb line formula for the calculation Ideal Skills: - Advanced Excel proficiency - Understanding of geographical coordinate systems and navigation - Experience with mathematical calculations in Excel - Prior experience in developing navigation tools would be a plus This proj...

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.

Change the column to store for table. Laravel work

I'm currently struggling with severe connectivity issues on my Ubuntu VPS server, version 22.04. The server frequently fails to connect, creating significant interruptions in service. I recently made changes to the server configuration, and since then, the problem has been occurring. I was working in my Wordpress with Elemenator on the 19th of April...connectivity problems. Use WinSCP to access files. 2. Recommending and implementing a solution that can restore optimal server performance. 3. Ensuring any implemented configuration changes do not negatively impact server performance in the future. This job requires immediate attention, so if you have the necessary skills and experience, I encourage you to bid. Bring your Ubuntu expertise to the table and let's get this VPS...

I am seeking a PowerBI expert to incorporate Row Level Security (RLS) to specific column (and not rows )in a PowerBI table depending on who is signed in. Will share details with interested freelancers. Should be done within a few hours.

need to websrapp amazon , flipkart and get current prices of sa list of laptop models on an excel sheet

...trasladar 50 facturas en formato PDF a una hoja de Excel. Las facturas contienen información vital para mi negocio, por lo que es crucial que esta transcripción sea realizada con precisión. La información que necesito en mi hoja de Excel incluye: - Fecha - CIF - Nombre de la empresa - Importe Requerimientos: - Conocimiento y experiencia en el uso de Excel. - Habilidad para transcribir información de forma precisa y rápida. - Habilidad para trabajar con documentos en formato PDF. - Comprensión de la importancia de la confidencialidad en el tratamiento de información empresarial. Adicionalmente, necesito que la información transcrita sea organizada y categorizada por fecha. Finalmente, necesito q...

...intuitive, comprehensive online exam system similar to that of IELTS. Key Features and Interface Requirements: - User registration and login: Prospective test-takers should be able to register themselves and log in independently. - Payment platform integration: Users should be able to pay directly on the website before taking the examination. -Ability to import questions and exam material from excel or csv - Exam result delivery: Post-exam, users must receive their scores directly presented as a percentage score on their screens and via email. Successful applications to work on this project should include past work that directly speaks to these requirements. Experience in developing online exam systems or similar educational platforms will be a strong advantage. A thorough...

I'm on the lookout for a talented video editor armed with advanced video editing skills. I need a captivating product video that doesn't just show a product, but tells its story in a gripping way. Here's what you'll need to bring to the table: • Advanced video editing capabilities. I expect more than just basic cuts and transitions. Be ready to demonstrate your understanding of complex editing tools. • A deft hand at video length control. The final cut should run anywhere from 1 to 3 minutes. • Skill in integrating various elements. The video must include text overlays, sound effects, and a voiceover to create a rich, engaging user experience. If you've successfully executed such projects in the past, I can't wait to see your portfolio....

...website, grab financial statement data and inject that data into an Excel worksheet. Key Requirements: - The program should be able to access Fidelity Brokerage website. - It should grab financial statement data and inject it into Excel. - Specifically, the program should insert this data row by row into a Microsoft Excel Worksheet. - Each stock symbol which the program should enact on will be in one column - The data rows should be organized by having one row per stock symbol. Ideal Skills: - Experience in API and data extraction. - Strong proficiency in Python, VBScript or other programming languages suitable for this task. - Prior experience in creating Excel macros or programs that interact with ...

...option to select h,d or t and a small table showing past 10 users bets and their results. Additional Pages: -Referrals -Contact Us -Privacy page (TOS, Privacy Policy, referral Policy) -Recharge -Withdrawl -Account Details -Verification Page -Forgot Password -404 E-Commerce Part: 1) Landing Page -Hero section (BootStrap Carousel) with products 2) Product Search Page - Same products from landing page but with a search bar 3) product View Page - product view page where can see a demo product with quantity selector, price and 'add to cart' button Admin Panel Part With Bootstrap Nav bar NOT bottom mounted icon consisting nav bar 1)Tab 1 (Users) - Table mentioning all users providing functionality to view all user info and ban or edit funds 2) Tab 2 (Events) - Ta...

Extract data from pdf documents into an excel template. No software needed for the job. This is a complex project that requires accuracy and being organised. Must have strong numeracy and proven track record of attention to detail. Knowledge of European languages an advantage. We have over 100 files that will be allocated depending on ability and capacity. If you are interested please get in touch. Work will begin in April.

I'm seeking a professional with comprehensive Google ads experience to set up and optimize a campaign, with the objectives of increasing website traffic, generating leads or sales, and enhancing brand awareness. Here's what the ideal freelancer should bring to the table: - Adept at setting up Google ads campaigns. - Proven track record in driving website traffic and generating leads and sales. - Strong understanding of brand building strategies. The campaign should focus on: - Interest-based targeting: creating ads that capture individuals interested in the type of products or services my business offers. - Retargeting: designing strategies to re-engage people who have previously visited my website. My budget for this project is less than $500 per month. Please provid...

...Linux-based barcode printing application that supports both QR codes and 1D barcodes. The application must also be capable of importing data from Excel/CSV files. Key Components: - A Linux-based application: The application should be specifically designed to run on Linux operating system. - QR Codes and 1D Barcodes: The barcode printing application should support both QR codes and 1D barcodes. - Excel/CSV data import: The application should be able to import data from Excel/CSV files for generating barcodes. Ideal Skills: - Proficiency in Linux application development. - Experience with barcode generation and printing. - Ability to work with Excel/CSV data import. - Understanding of QR codes and 1D barcodes. If you have prior ...

I am in need of a Python script that can read CSV files and push the data into SQL Server Management Studio database. Key Requirements: - The script should be versatile enough to handle multiple CSV files. - It should map the CSV file column names to the respective SQL Server database table columns. - I would like to have two versions - one for single CSV files and one for bulk import to optimize performance when dealing with a large volume of data. Key Skills: - Proficiency in Python to develop the script. - Familiarity with SQL Server Management Studio to manage the database. - Previous experience with CSV file handling and database import/export is a plus.

I'm looking for an experienced programmer who understands MATLAB inside and out. Specifically, I need someone capable of optimizing a data analysis script. This script primarily uses arrays and matrices as its predominant data structures. It's crucial that you excel in: - MATLAB programming - Optimizing code for efficiency - Deep knowledge and understanding of working with arrays and matrices data structures If you are an expert with these requirements and have the know-how to streamline and optimize for speed and stability, your skills are highly valuable in this project. I look forward to reviewing your bid!

I'm seeking an expert in Excel who can efficiently merge two sets of numerical data sourced from different spreadsheets. Key tasks include: - Cleaning similar columns to create a unique identifier for perfect merging - Conducting statistical analysis on the merged data to find the mean, median, mode Ability to analyze data meticulously, professional experience in using Excel and familiarity with advanced statistical functions are essential for this project. Stringent attention to details is appreciated, as the data to be handled is delicate and the outcomes crucial. An understanding of data cleaning techniques in Excel would be an added bonus.

I am seeking an individual with a flair for communication to call selected tire recyclers and propose a potential collaboration opportunity. The highlighted aim of these calls will be: • Present the long-term benefits that the partnership can yield for both organizations. • Stress upon the significant expertise and credibility that my company brings to the table. During the discussion, it's crucial to elaborate on the unique benefits our company can provide, such as: • Helping them realize increased revenue. • Facilitating access to fresh, untapped markets. The ideal candidate for this project should have excellent conversational prowess and a proven track record in business negotiation and partnership development. Knowledge about the tire recycling indu...

Saludos, busco un experto en vba excel para la solución o complementación de un proyecto. Adjunto dejo una imagen del userform que funcionará cómo buscador y modificador de una base de datos en excel, la principal necesidad es lograr que el listbox genere la data con sus respectivas columnheads cómo se muestra en imagen, y que a su vez en el apartado del buscador, se pueda filtrar por el campo requerido y se genere correctamente la nueva fuente de datos. El error que se me ha presentado es que por usar el método .rowsource para mantener los encabezados, no me permite utilizar el método .additem.

Proyecto de automatización con sharepoint, Excel, power automate y power bi

I am seeking an Excel expert capable of preparing a comprehensive document comprising more than 10000 rows and columns. The scope of the project involves processing substantial data sets, namely: Organizing Scanned documents and extracting the data, organizing the data in different corporations by department and years. Be able to extract a P/L and AR for all companies. Project is to be done in stages - Text - Numerical data - Date Information The ideal candidate for this job should have: - Expert knowledge of Excel and related functionalities. - Strong attention to detail. - Proven experience of data entry in large volumes. - Familiarity with basic mathematical operation functions within Excel. The deliverable will be a well-...

En busca de un analista de datos freelance, estamos emocionados de ofrecer una oportunidad única para aquellos apasionados por la analítica y el crecimiento continuo en el dinámico mundo del Multinivel (MLM). Si te entusiasma generar reportes precisos, limpiar y administrar tablas de datos, y tienes un sólido entendimiento de Excel, DAX, PowerPivot y tablas dinámicas, ¡este podría ser el proyecto perfecto para ti! Necesitamos un analista junior que no solo posea habilidades en análisis de datos, sino que también tenga experiencia comprobada en el análisis de datos específicos de empresas de MLM. Es crucial que puedas interpretar planes de compensación y entender profundamente los volúmenes de ...

I have to download everyday +- 3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where: - I'll write the day, month and year - I'll write the first invoice number and last invoice number that I want your tool to search - I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL. The URL for these files is a standard URL. It's always an URL like this: The only part that changes is day, month, year and invoice number. Example: if I want to download any available invoices between numbers 5000