How to create a lookup table in excel 2016Jobs

Hi BVM Solution, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...plans with a furniture layout. Your application should highlight your past work on similar projects. No need for every tiny detail, just the essential information will do. Skills and experience in using relevant software for floor plan design will be a huge plus. If you have a keen eye for design, spatial understanding, and able to meet deadlines consistently, I'd love to see what you can bring to the table. We are dividing a space up and want to turn it into two different 1 bedroom 1 bath apartments with kitchens. I need someone to create the floor plan so I can share with my contractors. We already have doors and windows in place for the units and we want to utilize those. Also due ...

I need a seasoned freelancer to increase sales on my Leather Chairs listings on Amazon, through PPC ads and listing SEO optimization. Responsibilities include: - Boosting the visibility and organic rankings of my existing listings - Creating new effective PPC campaigns - Incorporating proven strategies to design eye-catching new listings The ideal candidate has: - Extensive experience with Amazon PPC and SEO - Sound knowledge of the Home & Kitchen category - A track record of increasing sales for relevant products I'm looking forward to seeing your proposal and discussing how we can skyrocket my leather chair sales on Amazon.

Description: We are seeking a skilled financial modeling specialist to create a comprehensive financial model for a vending project. This one-time task involves analyzing various metrics, such as conversion rates, visitor traffic, and other relevant data to forecast the profitability and feasibility of the project. Responsibilities: - Create a financial model based on the specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, pr...

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.

I'm in need of a master in Excel. Your task will include: - Inputting both textual and numerical data into Excel. - The data to be entered is categorized, meaning that you'll need to pay close attention to how and where the data is entered. Ideal candidates have extensive experience with Excel and a sharp eye for detail. Familiarity with categorized data entry is a plus. Please apply if you think you've got these skills.

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.

I have a form in which I need to create a cascading field urgently This is a tiny task, however, we can hire you for more projects in future

I want to improve the search function of a webshop. I want to do this by adding extra data to the products (in the form of tags). I have a list of 11,000 product names in Dutch. These product names consist of a piece of proper name, noun and then sometimes some content information. For example: Orange Cleaner degreaser 5L c We are looking for a quick way to see the noun plural in the column next to it. Also, one or more synonyms in the column(s) next to it would be nice. Example: degreasers (=plural) I understand this can be done with a Python script that performs these tasks. This script uses the Natural Language Toolkit (NLTK) library to identify multiples and synonyms. Thi...

I am in need of an Excel expert who can assist me with data analysis. The level of complexity I am aiming for is basic sorting and filtering. Crucially, I would like the data analysis to be interactive for users. Key Requirements: - Data analysis in Excel - Proficiency in creating drop-down menus for sorting/filtering - Experience with basic Excel functions and formulas Ideal Skills: - Strong understanding of Excel and its data analysis functions - Ability to create intuitive and user-friendly interfaces with drop-down menus - Excellent communication skills to help with user instructions This project requires someone who can provide a clean, well-structured, and user-friendly Excel file.

...sales enthusiasts ready to make money from the comfort of their homes selling physical products on a full e-commerce platform. Whether you are new to the field or have seasoned experience, join our team to help us broaden our company's online sales. While no experience is required, those with a background or interest in sales could excel in this role, as you will be responsible for maintaining a broad product knowledge of our inventory. Requirements and responsibilities: - Sell a variety of physical products online - Display strong communication skills - Maintain product knowledge - Be reliable and committed Being tech-savvy, having prior experience with eCommerce platforms, or proven sales experience are al...

...looking for a skilled trainer to deliver a comprehensive Excel training targeted towards beginners. The training will cater to a larger group of participants, around 15-20 individuals. Key Learning Objectives: - Understanding of Excel formulas and functions - Mastery of data analysis and manipulation The ideal candidate for this project would have a strong command of the above topics, with a proven track record in delivering effective training to large groups. Experience in breaking down complex concepts for beginners is essential. Practical demonstrations and hands-on activities should be incorporated to ensure the understanding and application of the learnt skills. Please, when making a...

I need a skilled python developer to create a JSON to Excel converter. Key Requirements: - You'll be working with Flat JSON data - How to handle missing data is up to you - Mapping of JSON fields to Excel columns is flexible Ideal Skills: - Proficient in Python - Experience with JSON parsing - Excel manipulation skills I'm open to suggestions on the best way to map the data, so please include your ideas in your bid. Let me know if you have any questions.

Hi, The task is to scrape a pdf that is downloaded on website. Steps: 1. Go to website 2. Enter code in search and click search. (We provide list code) 3. On the results page Click on pdf document and open or download it 4. Extract 14 pieces of data from the PDF and export into excel sheet. There are about 150.000. Some codes do not have any data then skip. I have attached a word document with pictures and flow for you to review. Thanks!

I'm looking for a talented writer with a knack for research to create a comprehensive Wikipedia article about a specific brand. As a beginner freelancer, you should be eager to sift through available resources to distill essential information. Don't worry, I am patient and willing to guide the right person. You should demonstrate: - Ability to follow Wikipedia's strict content guidelines. - Strong research skills. - Basic understanding of brand marketing. - Some level of experience with Wikipedia article creation, though not necessarily extensive. This project requires accurate content, so attention to detail is a must. You might be a good fit if you're technology-ori...

I'm seeking a skilled Photoshop editor to assist with a picture editing task. The main requirements for the job are: - Removing objects: There are a cup and some candles on the table in the picture that need to be removed. I have circled them in red in the second image provided. Precision and attention to detail are crucial for this task. - Background cleanup: The desired background for the picture is the same as the original. This means the area where the objects have been removed must seamlessly blend with the rest of the image. Ideal skills and experience for this job include: - Proficiency in Photoshop - Experience in object removal and background cleanup - Attention to detail and abi...

More details: What genre would you like the movies to be? Drama What is the intended age group for these movies? Adults Are there any specific themes or topics, integral to the plot, that you would like included in the movies? Romance, Mystery, Social Issues

I am looking for an expert who can create MIS reports encompassing sales, financial, and inventory data. The frequency of these reports will be based on my requirements which can vary. Those equipped with excellent skills in data analysis, report generation, and detail orientation will be ideal for this role. Knowledge in handling Excel is a must as the reports need to be delivered in this format. Here's what is expected: - Data compilation and report generation as per my request - Proficiency in Excel for creating and delivering reports - Adherence to strict timelines for report submission - Maintain confidentiality of all the data involved If you have prior experience in creating MIS reports of these ty...

...looking for an expert to help me integrate an execute all steps of installing, configuring and preparing a full android simulator along with configuring the android dependencies. Requirements: - install waydroid for ubuntu 22.04 (and mac + windows) - install game "Last War:Survival Game" on a waydroid - suggest alternative simulators Ideal Skills: - Experience in using different android simulators This project could be a great opportunity for someone who is getting started in game development and wants to earn some positive reviews. Looking forward to your bids! MS1: - install the simulator on ubuntu 22.04 - install app in simulator and ensure it works there fully - provide each required step in a...

For this project, I require a meticulous freelancer with skills in data entry, and specifically in converting images with somewhat legible handwriting into Excel data. Key Responsibilities: - Accurate conversion of handwritten text from images into digital format in Excel. - Ensuring the integrity of the data by carrying out data validation and verification. Required Skills: - Proven experience in data entry, particularly involving handwritten text. - An eye for detail for data accuracy. - Proficiency with Excel is mandatory. - Ability to decipher and transcribe somewhat legible handwritten text. This project suits someone with patience and diligence due to the level of legibility of the handwritten text.

...seeking guidance and support to excel in the AI certification, emphasizing on concepts and theories. - The primary focus of this project is on improving my understanding of AI principles, concepts, and theories. - As I'm aiming to complete the certification, I need a mentor who can explain complex AI concepts in a clear, concise, and readily understandable manner. - Given the current circumstances, I'm specifically looking for online resources to guide me through this journey. Ideal candidate for this project should have: - Proven experience in Machine Learning, ideally with certifications themselves. - Excellent teaching and mentoring skills, particularly in breaking down complex topics. - Good understan...

Add column to existing table Amend existing API. Only ftp will be provide for work

I'm in need of a skilled graphic designer who can help me with character animation in a 3D setting. We're looking to create an engaging animation incorporating a character. The level of detail we're aiming for is medium, including textures. Key Responsibilities: - Create a character animation in 3D - Incorporate medium-level details with textures into the design Ideal Skills: - Proficient in 3D character animation - Skilled in applying medium-level detail with textures - Experience with graphic design, specifically in character animation - Ability to bring creative ideas to the animation process

...looking for a skilled freelancer to create a custom quoting template in Microsoft Excel for my business. The template should be intuitive, easy to use, and visually appealing. Key Features: - The template must be fully customizable in design, enabling me to adapt it according to my branding and specific needs. - I'd like the template to incorporate conditional formatting for data visualization. This feature will help better present the data, making it easier to understand and interpret. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly in creating templates. - Experience in designing visually appealing and user-friendly templates. - A s...

...Description: As a Software Auditor, you will be crucial in conducting thorough assessments of software usage within client organizations. You will analyze software licenses, usage patterns, and deployment data to ensure compliance with licensing agreements and identify potential areas of risk or non-compliance. Roles and Responsibilities: • Conduct software audits for client organizations to assess compliance with software licensing agreements. • Analyze software deployment data, license entitlements, and usage metrics. • Verify the accuracy of software license records and documentation. • Identify discrepancies, unauthorized software usage, or potential non-compliance issues. • Prepare detailed audit reports outlining findings and...

I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to work...

...looking for a talented web designer to create a website aimed at showcasing my computer training services. Key Features: * Comprehensive presentation of services offered which include training in programming languages, IT certifications, Tally, Advanced Excel, and Graphics Designing. * A design that is engaging and encourages user interaction. Ideal Project Bidder: The ideal candidate for this project will have a strong background in web design with excellent knowledge in user interface and user experience (UI/UX). Familiarity with the tech education industry will be appreciated. The successful bidder should be able to demonstrate a portfolio of similar completed projects. Deliverables: * A ...

I am in need of a proficient excel wizard who can simplify my day to day tasks. While the specifics aren't in place, ideally I'm looking for someone who can efficiently perform data entry, come up with efficient formulas and functions, and provide comprehensive data analysis. Proper data formatting is key, for which I don't have a specific preference, however, creating simple tables, color coding cells, or using pivot tables and charts are all strong possibilities for this recurring project. Since no specific criteria was given, please do include your past work, experience, and a detailed project proposal when you apply. Skills and experience preferred: - Familiarity with advanced Excel functions and formulas. - Expe...

...data analyst to clean and integrate data from excel files into a Power BI dashboard. Key Project Details: - The primary data source is excel files. It's crucial that the freelancer is proficient in Excel for extracting, cleaning, and transforming the data. - Dataset is farmers data including demographics and crop details. - The main focus of this project is on data visualization. I need the dashboard to present the data in a clear, visually engaging way. - The dashboard will be updated quarterly. Ideally, the freelancer should set up a process for this to be done efficiently and accurately. The task involves: - Understanding the data and the requirements for visualization - Cleaning the data to m...

Bonjour, je suis archéologue. J'ai du texte, des photos, des images, un document Excel a insérer dans un seul rapport paginé. Il faut faire la mise en page et transformer en PDF.

I'm looking for an Excel expert to create a costing sheet for a product. Key details for the job include: - It's mainly a costing sheet that will help me calculate the final price of my product based on material costs. Ideal Skills and Experience: - Proficiency in Excel - Solid understanding of financial calculations - Previous experience in creating costing sheets for products Looking forward to receiving your bids.

I'm looking for a comprehensive website that can facilitate the sale, rent, and auction of various products, including books, games, and much more. Key Features: - A smooth functioning cart system: This will be crucial for users to easily add and remove items they wish to purchase or rent. - Online payment system: An integrated payment system is necessary to ensure seamless transactions for customers. The site will have an extensive product range, with over 100 items. Hence, it's essential that it can handle a large inventory. Ideal Skills: - Proficiency in e-commerce website development, with experience in handling complex product ranges - Expertise in cart systems and online payment gateways - Understanding of ...

I need a list of 5,000 unique contacts in the United States of Businesses that meet the following criteria: 1. Service Based (Consulting, Coaching, Accounting, Legal, Event Management, Engineering, Financial Services, Insurance) 2. Less than 5 years old 2. Less than 5 employees The file should contain: 1. Company Name 2. Industry 3. First Name 4. Last Name 5. Title 6. Phone Number 7. Email Address 8. City 9. State/Province

I'm in need of a skilled and creative hat designer to help me bring my vision to life. I want to create a range of hats for men, women, and children. Key Requirements: - I'm looking to create hats with a modern and sporty theme. - The ideal hat designer for this project should be able to work with a variety of materials, specifically wool, cotton, leather, and lace. Skills and Experience: - Experience designing hats, particularly in the fashion industry - Familiarity with working with a diverse range of materials - Strong portfolio showcasing modern and sporty designs - Understanding of varied head sizes for men, women, and children. I expect the freelancer to bring fresh ...

I require a detailed, easy-to-use Excel invoice template. The main features needed include: - Line items for products or services delivered: It's crucial that you add functionality for categorizing and detailing all the products or services delivered within the invoice. - Contact Information of both parties: The invoice must have dedicated sections to clearly present contact information of both the issuing and receiving party. - 1 page invoice in A4 size (fixed) with calculations based on user input amount. It's beneficial if you have profound knowledge of Excel and understand accounting principles to design the template in a highly organized and straightforward manner for ease of accounting tasks. Prior experienc...

I'm looking to engage a freelancer skilled in data entry and Microsoft Excel to help type significant amounts of text data into an Excel sheet. Your responsibility will include: - Typing text data into an Excel sheet in an accurate and efficient manner. - Maintaining a consistent style and format throughout the entirety of the data entry. - Reviewing and proofreading your work to ensure absolute accuracy. You should display proficiency in Excel, attention to detail, and commitment to maintaining a consistent, professional style across all data. Please submit your bids along with an estimate of timeframe. Though the project completion timeframe was not specified, a timely d...

I am in need of a skilled Python expert to transform a raw excel report into a final template version of excel. The project requires two main tasks: Formatting and re-arranging of columns along with calculation updates for one column. Key Points; - Need 3 open reports to pull the information and split the reports at the end. - Formatting Changes: The report needs specific columns to have pre-defined blank values for certain columns: Col B, E, J, R, W, AB, AE, AJ, AV, BG, BI, BJ, BQ, BU, BV, BW, BX, BY, BZ. - Calculation Updates: The calculation layer within the excel report needs to be updated and finalized. The ideal freelancer for this project should have a profound understanding of Python and extensiv...

Everyday I have to extract some datas from around 100 invoices (PDF files) and copy it to an Excel file. I do it manually (copy/paste), but I need a tool to have it done automatically. These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file. The automation process must execute without fail, ensuring that the location of highlighted fields - wh...

Hey Mate, got a job for you. Please see attached sheet. Need to report on data sheet, data will be updated month to month. Not sure if this can be done with pivot table? but I'm not familiar with dealing with time calculations. Tab 1 Data table 1 + summary by driver: Average Total time (F) by driver (B). Tab 2 Data table 2 + summary by Sub function code: Average Total time by Sub Function (C). Need ability to exclude rows where F is blank or greater than 17 hours.

I'm looking for a professional Excel user with a strong grasp of nutrition concepts to develop an advanced tool for me. Here's what I need: - A comprehensive Calorie Calculator - Macronutrient Calculator to recommend the optimal amounts based on three different goals: Weight loss, Muscle gain, and Maintenance - BMI Calculator - Be able to calculate these based off body weight, height, activity level, age and gender inputs The ideal candidate should not only be proficient in Excel, but also have a good understanding of nutrition principles. The faster this can be completed, the better.

I need an expert to create a Video for a Facebook ad for an English learning Website. The video will be in Spanish language since the target audience will be Spanish speakers in South America who wish to learn English. I therefore need someone who is a native Spanish speaker (from South America) but who is also proficient in English. I prefer someone currently living in South America. The target platform will be primarily mobile and secondarily laptop users. The video should be a sketch/testimonial of sorts highlighting the effectiveness of the language learning approach taken by the website (see below). Creative, performance, acting, and video producing/editing skills are required. About the website's lang...

I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a...

...searching for a talented full-stack developer to establish an e-commerce site akin to Shopify but entirely focused on the upload and download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payme...

I'm seeking a talented manga-style artist for my upcoming horror webtoon project. The primary requirement is for an artist with a proven ability to create gripping and vivid horror scenes while maintaining the manga art style. Your role will involve: - Creating detailed, expressive, and dark characters in the traditional manga style - Designing terrifying environments and settings - Setting the mood with your art and paneling - Working closely with me to ensure that the art matches the script It's essential that you bring a passion for horror and a knowledge of the genre to the table. Your work should be both visually engaging and contribute significantly to building the tension and atmosphere of...

...looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to de...

Hi we have small web application on PHP we have face issue to save or publish some data and some table shorting please bid if you can fix this quickly

Create a form in google Sheets following the pre-determined options. The results of the answers must be recorded in a second tab

I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)

Hi, I am in need of a skilled professional who is proficient in developing a Customer Service CRM with a key focus on the functionality of issue tracking and resolution. As the priority of the project, I require the CRM to systematically record and track customer issues, from initial identification through to final resolution. The ideal candidate for this project will have: - Strong experience in creating web-based CRM platforms - Expertise in developing customer service focused CRM systems - Proven track record in integrating issue tracking and resolution functionality - Proficiency in customer database management and optimization The deliverable is a Web-based CRM application that is easy to nav...

...seeking a proficient expert with skills in APA 7th edition format for configuring research tables. Even though proficiency in APA 7th edition standards is paramount in this project, having an insightful understanding of data organization and presentation will be appreciated. In this project, efforts will be channeled towards changing 7 existing SPSS tables to match APA 7th edition requirements, including double-spacing, 12 point-font, Times New Roman font style, and, if needed, notes under the table or necessary italicization or bolding of headers/keywords. Manual entry of descriptive text and data values to form each independent table is needed. In other words, raw data cannot be provided to manipulate or re...