How to create a lookup table in excel 2016 jobs

I'm in need of an experienced C# desktop programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored p...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

...looking for a skilled graphic designer who can help me create a logo for my brand. There are a few things I need to be considered in this project. - Logo Design: I'm looking for a logo that truly represents the essence of my brand. The design should be creative and memorable, while also being versatile enough to be used across various platforms. - Branding Elements: I'm in need of a complete branding design, which includes a color scheme and the selection of fonts. The branding elements should complement the logo and create a cohesive and consistent visual identity for my brand. I am open to suggestions regarding the logo design, and would appreciate a designer who can b...

We are seeking a talented animator to create a captivating 1-minute video showcasing our innovative transportation solution. This project involves animating a shuttle moving through a tube, aiming to revolutionize how people and goods travel. The animation will serve as an introduction to our invention to the general public, highlighting its unique features and benefits. *Requirements:* - Experience in creating engaging animations, preferably with a portfolio showcasing similar projects. - Proficiency in Blender, as the models for the shuttle and environment are pre-designed and available in Blender format. - Ability to convey the concept of futuristic transportation vividly and convi...

I'm in need of a realistic apparel print for tee shirts, featuring a unique scene. The artwork should be in portrait style and include a group of animals - specifically a shark, tiger, golden bear, black knight and rainbow umbrella. This group will be depicted at a table, enjoying cigars and sipping glasses of scotch. The background for this scene should resemble a men's club, giving the impression of a sophisticated and exclusive setting. Key requirements: - Realistic artwork style - Unique and engaging animal choices - Men's club background

We are a curly hair ecommerce in Italy and we are looking for a AR beauty experience professional to create this type of videos We need Someone to add in our team who brings unique set of skills and idea to the table. We only have products pictures so the animate of the product will be recreated from a 'fake 3d' of the .png image You must find the video to use free from copyright

I'm in need of a skilled freelancer to embed a clean, sortable, and filterable table into my personal blog, which will continuously pull data from a Google Sheets document. The key points of the project are: - **Table Embedding:** The primary task is to take the data from my Google Sheets and convert it into a visually engaging table on my blog. This table should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization...

I'm in need of a skilled photographer with their own studio or location to take professional photos of a variety of home decor items for my ecommerce website. Requirements: - The products that need to be photographed include bedsheets, pillow cases, cushion covers, table covers, and mats. - The photography should be done in a studio setting. - The photos will require color correction, but background removal is not necessary. Ideal skills and experience for this job include: - Prior experience with product photography - Proficiency in studio photography - Strong understanding and experience in color correction techniques - An understanding of e-commerce photography standards - Attention to detail and c...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant ex...

I'm working on a meme coin project and I need a digital illustrator who specializes in creating realistic illustrations. Key Requirements: - **Realistic Style:** The illustrations should be realistic in nature. - **Squirrel Character:** I have a specific squirrel character in mind. It will have to be designed with the following attributes: - **Wearing a Hat:** The squirrel should be depicted with a hat. - **Smoking a Pipe:** The squirrel should be smoking a pipe. - **Holding Cards:** The squirrel should be holding some cards. - **Other Ideas:** I'm also open to hearing any other creative ideas. Additional information: Need up to 50 different illustrated image of the character, and...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm look...looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant...

Site Location: Parel East, Mumbai Date:19/5/24 I am in need of a videographer who can film the process of installing a surface protection film on marble dining table. Specifically, the project entails: - Filming the installation of a surface protection film on medium-sized marble surfaces such as a dining table. - Capturing promotional footage to demonstrate the efficiency and effectiveness of the installation. -Make a reel using the clips shot. The ideal candidate should have: - Experience filming in varied working environments, especially in work sites. - Attention to detail to accurately represent the installation procedure and product use in the video.

I have a vision for a logo that's modern and minimalistic. I've got some rough ideas in mind but I'm open to suggestions and want to see the creativity freelancers can bring to the table. Key Requirements: - Modern and Minimalist: The logo should reflect a contemporary and clean design aesthetic. - Company Name: The primary element to be included in the logo is the company name. Ideal Skills and Experience: - Proven experience in creating modern, minimalist logo designs. - Ability to take rough ideas and turn them into polished, professional designs. - Strong creativity and an eye for detail. Delivery Time: I'm looking for a quick turnaround on this project without compromi...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

Implement Mac Filtering to allow specific Mac addresses to connect to a Windows Server 2016 and Windows 10 via Remote Desktop Protocol (RDP). Disable Right Click functionality for RDP users. Restrict Copy-Paste functionality (Ctrl+C, Ctrl+V) for RDP users. Implement measures to disable file transfer capabilities for RDP users.

I'm in need of a skilled photographer to take professional photos of a variety of home decor items for my ecommerce website. Requirements: - The products that need to be photographed include bedsheets, pillow cases, cushion covers, table covers, and mats. - The photography should be done in a studio setting. - The photos will require color correction, but background removal is not necessary. Ideal skills and experience for this job include: - Prior experience with product photography - Proficiency in studio photography - Strong understanding and experience in color correction techniques - An understanding of e-commerce photography standards - Attention to detail and creative flair for achieving appeal...

I am looking for a seasoned mobile app developer to create a social networking application geared towards professionals. Key Features: - User Registration and Profile Creation - Messaging System - Networking and Connection Building Features - News Feed for Professional Updates - Job Listing and Recruitment Section - In-App Search and Filter Functions - Notification System - Integration with Existing Social Media Platforms Skills and Experience: - Proficient in mobile app development - Previous experience in creating social networking applications - Strong understanding of user experience and design principles - Ability to integrate various APIs - Familiarity with data security and privacy standards This is ...

Hello, Looking for someone to create video ads from a mobile game, you will need to play the game, get footage from and then give me 5 horizontal video and 5 vertical ads each video needs to be between 15-30 seconds long If you understand that you need to create everything from scratch and can do it in a short time frame please type GREEN at the beginning of your proposal. Proposals without it will be ignored.

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does no...

Hello, I need complet the Amazon categories catalogue excel in french

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Exce...

MAX $60 As a business owner, I'm looking for a skilled freelancer to help me transfer an application from my old Windows server to a new one. The server is currently running on Windows OS and the application is built with Visual FoxPro 9 and ASP.NET Key Requirements: - Proficiency in Windows server management and application migration. - Experience with Visual FoxPro 9 and knowledge of its compatibility requirements. The new server must have the following installed: - ASP.NET Framework 3.0 or higher - Visual FoxPro 9 - Office 2019 Please make sure to include in your proposal any related experience and specific skills that make you a suitable candidate for this project. Project Description I'm currently in...

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I'm seeking a digital marketing specialist to assist with managing my social media accounts and creating engaging content for my business. Key Responsibilities: - Social Media Management: The core of this position will be managing my Facebook, Instagram, and Google accounts. This includes creating and scheduling posts, monitoring engagement, and responding to comments/messages. - Content Creation: I need someone who can create compelling content for my digital marketing campaigns. This will involve creating posts across various platforms to engage with our audience and attract new customers. The Ideal Candidate: - Proficiency in managing various social media platforms, especially Facebook, Instagram, and Google. - Strong copywriting and con...

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

I'm in need of a proficient PHP developer to take on a range of responsibilities for my project. You'll be handling both the front and back-end development, as well as maintaining the website. I'm looking for someone who has a strong background in PHP, not just with creating and managing dynamic and interactive web pages, but also maintaining them for optimised performance. Key Responsibilities: - Handling front-end and back-end development - Carrying out website maintenance You must provide examples of your past work in your application. We appreciate attention to detail and a deep understanding of PHP. Since I will provide all the content needed for the website, you can focus solely on the programming side o...

h...vue et interaction j'ai mes truc et je mantant très bien avec les allégorite des resaux socio? I'm in need of a skilled video editor who can help me bring my creative stories to life. I have some great ideas that I want to turn into engaging videos, and I need someone who can help me with this. Key requirements: - Proficient in video editing software - Ability to turn raw footage into a polished, engaging final product - Creative and able to bring fresh ideas to the table - Strong storytelling and narrative skills - Experience with editing videos longer than 5 minutes If you have a keen eye for detail, a passion for storytelling, and enjoy bringing creative ideas to ...

...of , a website offering software that generates personalized greetings featuring historical events from the past. Our target audience includes client-focused industries such as financial companies and dentists, event-focused organizations, and individuals seeking unique greetings for friends and relatives. The key advantage of our software is its ability to create personalized greetings for each recipient. As a Software Engineer, I am planning to rebuild the software to introduce a fresh, user-friendly interface. I have developed wireframes that outline the necessary functionality and approximate element locations. I am seeking a talented UI/UX designer to review and refine these wireframes in line with UX principles...

I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logic...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

...have prepared a 2D drawing of the fair (floor plan) and based on it we would need to process a realistic 3D model of the entire fair. The output should be a 3D model of the trade fair with advanced textures and should look realistic. We would need to make certain shots from the 3D model, which we will subsequently use for presentations and promotion of the event. It is therefore important for us both the visuals, but also the 3D model itself, with which we will subsequently work, e.g. if we want to make some changes in the layout, placement of elements. It is important that the dimensions according to the drawing are exactly preserved. We are able to supply a DWG file in CAD with the dimensions of the area ...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

...seeking a talented screenplay writer to craft a 3-hour movie script for an action-packed and thrilling adaptation of the popular video game "Mega Man". Ideally, I'm looking for a script that retains the core essence of the game but is open to some creative liberties. Key Requirements: - Create an engaging, 3-hour screenplay - Include intense action sequences, heroic battles against bosses, and characters with special abilities - Maintain the action-packed and thrilling tone throughout - Stay moderately close to the original video game storyline, while allowing for some creative freedom Ideal Skills and Experience: - Proven experience in scriptwriting, particularly for action-based movies - Strong understa...

...looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing comprehensive plans that can be used for obtaining necessary permits. Your understanding of local building codes and regulations will significantly contribute to the project's success. - Ensuring these detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residentia...

I'm looking for a talented graphic designer to help me establish my brand with a minimalist approach. The project involves creating a logo and designing a matching theme for my upcoming website. Our website domain is - not yet online. The business is going to be called Daily Brewers. We will sell high end boutique coffee equipment. Key Deliverables: - A unique, memorable logo that embodies my brand - A website theme that complements the logo and reflects the minimalist style Things to Consider: - Please note that I have not finalized a color scheme. I'm open to hearing your suggestions on colors that could enhance the minimalist style. - I'm particularly interested in a modern and ...

I'm in need of an experienced graphic designer who can help me create several T-shirt designs. These designs are intended for adult humor enthusiasts and should reflect this audience's interests. Key Requirements: - Design Style: While the design should cater to adult humor enthusiasts, I'm open to a range of design styles. From minimalistic to vintage to cartoonish, I'm looking for a creative expert who can bring unique and engaging ideas to the table. - Quantity: I need assistance with creating around 1-5 T-shirt designs. - Original Artwork Files: Once the designs are finalized, I will need the original artwork files to ensure high-quality reproduction when uploaded to our supplier....

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical condi...

I'm in need of a seasoned Mechanical Engineer with specific expertise in heat transfer, fluid dynamics, and thermodynamic cycle analysis to assist in the development of a revolutionary solar thermal engine patent prototype. Key Requirements: - Conducting in-depth thermodynamic cycle analysis for the solar thermal engine. - Designing the engine layout and key components to optimize its performance. - Understanding and managing the behaviors of steam vapor and condensate. - Proficiency in analyzing fluid flow, power, and pressure drop. - Knowledge of steam hammer and heat pipe behavior for this application. - Experience with developing engines within the 1-5 kW power output range is essential. Ideal Skills: - Pr...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I'm looking for a skilled graphic designer to create a poster for my son’s wedding seating assignment. The design should be open to interpretation as I'm unsure about the style, but it should certainly incorporate pastel colors. Essential details on the poster should include the guests' names and table assignments, along with the names of the bride and groom. The ideal freelancer for this job would have experience designing wedding stationery and a keen eye for blending color schemes seamlessly.

Are you a creative and experienced web designer with a knack for crafting captivating online experiences? Join us in shaping the future of Rush Rooms! **About Rush Rooms:** Rush Rooms is a cutting-edge platform revolutionizing the rental industry, offering seamless experiences for renters and hosts alike. Our mission is to provide a modern, convenient, and trustworthy platform for anyone seeking or offering rental accommodations. **Project Overview:** We are seeking a talented freelance web designer to develop dynamic landing pages for Rush Rooms. These landing pages will serve as the gateway to our platform, showcasing its features, benefits, and offerings in an engaging and visually appealing manner Also abilit...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers ...

Please Sign Up or Login to see details.

I'm seeking an expert in Google Sheets to help me create a functional document geared towards tracking paint and repair tasks, and cleaning schedules across a busy summer camp campus. This sheet will be regularly updated by our facility maintenance team. The ideal candidate should: - Have substantial experience in creating dynamic and user-friendly Google Sheets. - Understand logistics and scheduling in a maintenance setting. Key features of the Sheet should include: - A system for recording painting/repair locations. - Fields for indicating the type of paint or repair needed. - An integrated cleaning schedule that doesn't disrupt ongoing summer camp activities. - A remark section to note if the cleani...