Vlookup excel 2016 practice exercises jobs
I need an Excel version of a fillable PDF. The PDF is using JavaScript. I need the JavaScript converted to VBA. I have created the PDF in Excel, but not the VBA code. The Excel file should function exactly like the PDF, with features including: - Form fields and input validation - Interactive buttons or clickable elements All standard validation and interactions from the PDF should be replicated in Excel. Ideal skills for this project include: - Proficiency in VBA programming and JavaScript - Experience with creating interactive Excel files - Understanding of form field and input validation
I need a professional who can assist me with generating QR codes from an Excel file and add them to a PSD file along with the corresponding names -> Then export as pdf CMYK. Bleed is already included in the psd. What is required: - Creating 122 QR codes from 10-digit codes in the provided Excel file. - Inserting these QR codes into pre-existing PSD files along with corresponding names. - Naming each QR code file according to the name it contains. - Exporting and delivering 122 CMYK JPEG files created from the PSDs. Specifications: - QR Codes should be generated in PNG format. - Size of the QR Codes should be Medium (4x4 inches). - Style of the QR Codes is strictly Black and White. Ideal Skills: - Proficiency in graphic design software, especially Adobe Photoshop - Exp...
I'm in need of a seasoned CFO from the United States to assist in a thorough review of my financia...Depreciation and CapEx. Key responsibilities: - Review of financial documents for forecast accuracy improvement - Proforma consisting of Cashflow Summary, Income Statement, Income & Utility Cost, Depreciation, Loans & Interest, Data Entry Personnel and CapEx spreadsheets via Excel. - Assessment of data entry accuracy and formulas are reflecting correctly The completion of this project is expected by 2/13/25. Ideal Skills and Experience: - Proven experience as a CFO - Extensive knowledge of financial forecasting via Excel - Exceptional attention to detail - Project Financial Expert - Startup Company Please take note that this project is only open to freelance...
I need a professional Excel expert to create a spreadsheet for analyzing my sales data. Key Requirements: - An Excel spreadsheet created specifically for analyzing sales data - Incorporation of a feature to calculate an even percentage discount to reach a desired total Ideal Skills and Experience: - Proficient in Excel with a strong understanding of data analysis - Experience with sales data analysis - Ability to create custom Excel features for specific needs
I have a schedule of rates document in an Excel spreadsheet that needs to be translated into a quote in a PDF document. Key Requirements: - The quote should include my company logo and details - The terms and conditions - Client details - Possible photos Ideal Skills and Experience: - Proficient in Excel and PDF conversion - Graphic design skills for logo placement - Attention to detail for including all relevant information - Ability to incorporate potential photos in a professional manner
I'm seeking a tutor from Portugal, with a strong command of the Portuguese language, to help me improve my skills. Key Requirements: - You should be a native Portuguese speaker from Portugal. - You should have experience teaching Portuguese to intermediate learners. - You should be capable of providing structured lessons focusing on conversation practice, grammar and writing, as well as vocabulary building. Preferred Learning Resources: - Your lessons should primarily utilize online articles and videos. - You should be able to select appropriate resources and guide me through them. Availability: - I need 4-5 hours of tutoring a week. Skills & Experience: - Native Portuguese speaker from Portugal. - Proven experience teaching Portuguese at an intermediate level. - Abi...
Hi, I have a project with a Word dotm template with a code to control graphs. User copies a graph from Excel or Word. Choose the graph and click one of the buttons in the menu I created. The code fetch a quick part with a graph and transfers data from the selected graph. I have used Copilot a lot to create the code and I expect you to do as well (if it saves time). Right now it works quite well, but I know of 1 issue. Plot by. The plot by property (by row/column) creates a lot of problems. What is X and what is Y. Is the source by row and target by column? Maybe we need to create a quick part by row and one by column. Who is ready to help?
I'm in need of a proficient English-speaking virtual assistant with experience in Excel spreadsheets. The assistant will primarily be responsible for data entry tasks related to product inventory, invoces, and customer templated outreach. Key Responsibilities: - Extracting Text from Photos. - Managing product inventory through Excel spreadsheets - Creating product descriptions and attributes, along with photos and prices. - Performing data entry tasks on a regular basis Ideal Skills & Experience: - Proficiency in English - Strong experience with Excel spreadsheets - Previous experience with ZOHO CRM is preferred - Good understanding of data entry tasks and product inventory management. Availability: - Must be available from 10am-6pm EST time zone.
...crafting, code auditing, and evasion tasks. 2. Screenshots of code execution and LLM outputs. 3. Detailed reports on LLM analysis, geolocation reasoning, phishing strategies, and logo comparisons. Deadline: February 19, 11:59 PM EST Preferred Qualifications: - Experience with LLM jailbreaking or adversarial prompting. - Background in cybersecurity, phishing simulations, or red-team exercises. - Familiarity with Google Cloud or local LLM deployment (e.g., Ollama)....
I am looking for optimisation services for an existing GoogleAds account with existing campaigns. The existing campaigns are not successful and need to be reworked and reorganised. If necessary, new campaigns can also be created. This is a medical practice in a major German city. The campaign is intended to generate new patients. The aim is to arrange appointments. The campaigns are in German.
I require an Excel professional to create several tables for data analysis purposes. The ideal candidate should be proficient in using VLOOKUP/HLOOKUP functions. I have not yet determined the specific type of data the tables will contain, but it can be financial, sales, or inventory data. Key Responsibilities: - Design and build Excel tables for data analysis - Implement VLOOKUP/HLOOKUP functions to enhance table functionality Ideal Skills: - Expert level proficiency in Excel - Strong understanding of data analysis techniques - Previous experience with designing Excel tables - Proficiency in VLOOKUP/HLOOKUP functions
I need a proficient Excel expert to convert my Google Sheet into an Excel file. The conversion should retain all functionalities such as: - Formulas and calculations - Data validation rules - Visualizations and charts The Excel file will only need to incorporate data from the Google Sheet, with no external data links required. Moreover, I require the addition of automation and macros in the Excel file. This will not only improve the functionality of the file but also streamline my data processing tasks. The ideal freelancer for this project should be highly skilled in Excel with a strong understanding of data validation, complex formulas, and chart creation. Experience with creating and implementing macros and automation in Excel is a must. Ple...
I'm in need of a skilled Excel expert who can create a spreadsheet for financial tracking specifically focused on payroll calculations. The project involves: - Designing a user-friendly Excel spreadsheet for tracking financial aspects related to payroll. - Incorporating functionality for overtime calculations and bonus calculations based on hours worked. - Ensuring the spreadsheet can effectively calculate gross pay No taxes need to be calculated Ideal candidates should have extensive experience in Excel, and a solid understanding of payroll calculations. Prior experience in designing financial tracking spreadsheets is a plus.
...Pair between the sites and The first one is a paid website, credentials are: qwerty @ , 957jfhODY@(*. The second is free. You have to scrap all symbols from both websites, including types like: - Crypto - ETF - Forex - Nasdaq - NYSE - Mutual Funds - Options - Stocks - Etc. From each symbol of each website I need the following Excel columns: - Symbol - Name - Price - Type - url address For the Price of Wallet Investor, I need "Tomorrow's Forecast Price". Please see sample for Symbol MSFT (Microsoft Corporation) on Image 01 The problem is that, at least in Wallet Investor (in Yahoo rarely that happens), there are multiple ITEMS with the same Symbol. See Image 02. (File attached) You may see that in Wallet Investor, 5 ITEMS
...template and corresponding Excel sheet. The purpose of the PowerPoint dashboard is to report project status to executives. Key Requirements: - The design should be corporate and professional, suitable for an executive audience. - The Excel sheet should seamlessly integrate with the PowerPoint for ease of use and consistency. Ideal Skills: - Proficiency in PowerPoint and Excel - Strong graphic design skills - Experience creating corporate presentation materials - Understanding of project management reporting Please provide examples of similar work you've done in the past. Scope of Work: Design of PowerPoint Dashboard Template and Excel Sheet Objective: Create a user-friendly PowerPoint slide template for a comprehensive project dashboard, along with ...
I'm seeking a proficient Excel expert to refine our progress tracker for the warehouse surrounding our manufacturing site. Key requirements for the job include: - Implementing formulas to efficiently track project timelines. - Creating a system to log the date when a specific status is reached. Ideal skills and experience: - Advanced knowledge of Excel formulas and functions. - Previous experience in developing or enhancing Excel sheets for business purposes, particularly in a warehouse or manufacturing context. The primary use of this Excel sheet is to monitor the progress of various projects as they are sent to the warehouse post drawing submission. Your expertise will help us better manage our inventory and improve our operational efficiency.
I'm in need of a professional who can assist in correcting logical formulas in my Excel spreadsheet. - Software: Microsoft Excel - Issue: Data calculations - Specifics: Primarily with logical formulas like IF statements Ideal candidates should have extensive experience with Microsoft Excel and a strong understanding of logical formulas and data calculations. Please include your relevant experience in your proposal.
I'm in need of a skilled Excel programmer to assist with creating a financial model. The project primarily involves using basic formulas and functions, with a focus on financial modeling. Ideal Skills and Experience: - Proficient in Excel, particularly with basic formulas and functions - Previous experience in building financial models - Strong attention to detail and ability to work to deadlines.
...избежать блокировки (например, рандомные задержки между отправками). Ведение базы данных с полной историей: Автоматическое ведение базы данных (SQL, NoSQL или другое оптимальное решение), которая содержит: Дату и время отправки письма. Найденный email-адрес. Полные данные клиента, извлеченные со страницы и вложенных страниц. Статус отправки (успешно/ошибка). Возможность экспорта данных (CSV, Excel). Встроенная фильтрация и поиск по параметрам (например, по дате, email-адресу, компании). Логирование и безопасность: Поддержка логирования всех действий бота: Входы на сайт. Успешные и неудачные попытки парсинга. Ошибки при отправке email. Возможность просмотра логов через интерфейс. Поддержка антидетект-функционала: Ротация user-agent. Использование прокси. Задержки...
I'm looking for a professional interior designer with experience in the hospitality sector, particularly hotels. The project involves creating interior design schedules specifications for various areas of the hotel, which include: - Guest Rooms (king/twin guestroom, executive suite, presidential suite) ...presidential suite) - Lobby and Reception - Dining Areas (All Day Dining, Speciality Restaurant Pool Bar) - Spa (with a Gym, yoga studio and a M/F salon) - Executive Lounge - Recreation Areas for Adults, Teens, and Kids (2 spaces) -Prayer Rooms -Corridors and Lift Lobbies The ideal freelancer should have a an understanding of creating schedules and specifications for materials and FF&E items in Excel, have attention to detail and understand the technical aspects of speci...
...for an expert in Power Automate Desktop who can help me schedule a flow for daily productivity recording. The flow needs to interact with a web-based productivity tool according to an Excel file containing my daily activities. This Excel includes three columns: - The date of the activity in dd/mm/yy format - The start and end time of the activity - A description of the activity The automation will select and interact with the web page based on the logic from the Excel file. The flow's final objective is to record the productivity of each activity that matches the date, time, and description in the Excel. Key Interactions: - The flow will be submitting forms and clicking buttons on the web page. Error Handling: - If there are no matching tasks for...
I'm seeking an Excel professional who can provide on-the-job support as needed. I primarily require assistance with: - Using Excel formulas and functions for data manipulation and cleaning. Your role will involve helping me navigate complex datasets and teaching me how to use Excel's capabilities to their fullest. Ideal Skills: - Proficiency in Excel, particularly with formulas and functions. - Experience in data manipulation and cleaning. - Ability to explain complex concepts in a simple, understandable way.
Saya sedang memulai bisnis yang berfokus pada layanan entri data dan membutuhkan freelancer berbakat untuk membentuk inti tim data entry. Saya mencari individu yang memiliki kemampuan sebagai berikut: - Kecepatan dan ketepatan dalam mengetik - Pengalaman dengan Microsoft Office (khususnya Excel) dan Google Sheets - Kemampuan untuk bekerja dengan data yang sensitif dan rahasia - Kepiawaian dalam memperhatikan detail - Kemampuan untuk bekerja dalam tenggat waktu yang ketat - Pengalaman dengan platform entri data online adalah nilai tambah Freelancer yang ideal akan bergabung dengan tim saya untuk membantu mengelola dan memproses data dengan efisien dan akurat. Saya menghargai komunikasi yang baik dan kemampuan untuk bekerja secara mandiri maupun dalam tim.
I'm seeking an Excel professional who can provide on-the-job support as needed. I primarily require assistance with: - Using Excel formulas and functions for data manipulation and cleaning. Your role will involve helping me navigate complex datasets and teaching me how to use Excel's capabilities to their fullest. Ideal Skills: - Proficiency in Excel, particularly with formulas and functions. - Experience in data manipulation and cleaning. - Ability to explain complex concepts in a simple, understandable way.
I need someone to assist me in downloading multiple documents (PDF, Word, Excel) from specific folders in a system. The task is straightforward but requires accuracy and timely delivery. Requirements: - Access and download files from provided system using login credentials - Download from specific folders - Timely delivery If you're interested, please let me know your availability and rate.
I'm looking for a Power BI specialist with Python experience to help me analyze customer data. The focus will be on understanding purchase behavior and customer retention. Key Responsibilities: - Develop a Power BI dashboard ...specialist with Python experience to help me analyze customer data. The focus will be on understanding purchase behavior and customer retention. Key Responsibilities: - Develop a Power BI dashboard to analyze customer data - Utilize Python to integrate complex calculations or data manipulations into Power BI - Provide insights into customer purchase behavior and retention Data Sources: - Primarily Excel/CSV files and Databases Ideal Skills: - Expertise in Power BI and Python - Experience in customer data analysis - Ability to deliver clear and insigh...
I'm looking for a cheep lead list of autodetailers and roofers in the US 2000 roofing UK 2000 roofing US 2000 autodetailing UK 2000 autodetailing US The lead list should be .xlsx spreadsheet and include the following details for each row: - Name (at least 50% cases) - Email - Phone Number - Second Phone Number (optional) - Website (if they have one) - Company Name - Company Address (at least 50% cases) MUST BE NO DUBLICATES If 1 company has a lot of numbers e.g 100 (or more then 10) then just skip rest onces Ideal candidates already have subscription for some lead scraping software. Please note that the primary source of the leads is not specified, so a mix of different sources could be beneficial. (e.g D7 Lead Finder / Apollo / Hunter / Google maps etc) You will be provided a rea...
I'm looking for an expert in data analysis to help me determine correlations in my dataset of electric use and temperature by hour. Key Focus: - Identify correlations specifically related to electric use attributable to radiant fl...expert in data analysis to help me determine correlations in my dataset of electric use and temperature by hour. Key Focus: - Identify correlations specifically related to electric use attributable to radiant floor heat (i.e., when the system is on and off). - Use the provided Excel dataset to assist in this analysis. Ideal Candidate: - Proficient in data analysis and able to demonstrate experience with similar projects. - Skilled in identifying patterns and correlations from large datasets. - Comfortable working with Excel and using it ...
I'm seeking a modern, vibrant and striking logo for my business. This logo will need to incorporate an icon or symbol. Key Requirements: - Proficiency in logo design and brand identity - Experience with...with modern, minimalist design principles - Ability to create bright and bold color palettes - Creativity in designing unique icons or symbols Please note, I currently have a logo and this is attached to the email. The current logo is dated / old fashioned, and I require something more modern and simple. I do not like the Harp symbol. Please note that the business is a professional consultancy practice offering Quality / Environmental / Health & Safety Auditing and Management System Support I also require a letter head an Business card template. I look forward to see...
...SimplePractice for daily billing operations - Maintain compliance with insurance and industry regulations Qualifications: - 5+ years of mental health billing experience - Proven leadership abilities in a billing or RCM role - Experience in Tebra and SimplePractice is a plus - Strong knowledge of CPT, ICD-10, and EOBs for mental health - Excellent communication and organizational skills If you excel in team leadership and have a deep understanding of end-to-end mental health billing, we’d love to hear from you. Please share your relevant background, platform expertise, and approach to optimizing revenue cycles. We look forward to working with someone who will guide our billing team toward greater efficiency and accuracy....
I have a project involving the conversion of mixed data (text and numbers) from printed documents into an Excel sheet. The data needs to be organized into tables with headings. Ideal Skills: - Proficiency in Excel - Excellent attention to detail - Data entry experience - Ability to follow specific formatting instructions Please ensure your bid reflects your experience with similar tasks.
I'm looking for an experienced data entry specialist to help me input mixed data (text and numerical) from online databases into a spreadsheet. Key requirements: - Proficient in Excel or Google Sheets - Experience with data entry from online databases - Attention to detail to ensure accuracy of data - Ability to handle mixed data types Please provide your past experience related to this job.
I'm looking for an experienced data specialist to help with my customer information in Excel. The data needs to be reformatted into CSV, and I need assistance with skip tracing. Key Requirements: - Format customer data from Excel into CSV - Help with skip tracing using customer data Ideal Skills: - Proficient in Excel - Experienced in data formatting - Knowledgeable in skip tracing techniques - Familiar with CSV file structure - Able to handle customer information with discretion and confidentiality
I am seeking a skilled data entry professional to assist in transferring and organizing my inventory details from PDF documents into Excel. Your task will involve: - Accurately inputting data from PDF documents into Excel. - Organizing the data in a clear and logical manner. While specific formatting instructions for the Excel file are not provided, a keen eye for detail and ability to create standard columns and rows will be crucial. The ideal candidate for this project should have: - Extensive experience with Excel and data entry. - An ability to meet deadlines while maintaining a high standard of accuracy. I appreciate your interest in this project and look forward to working with you.
I need assistance with a data verification task. I will provide a scan of an image containing numbers, and I need you to check these numbers against an already prepared Excel sheet. Details: - The scan consists of approximately 102 pages with about 25 lines per page, totaling around 2550 numbers. - The Excel sheet already has the numbers and corresponding cells prepared. - Once you find a number in the Excel sheet that corresponds with the scan, I need you to mark it with a check symbol (✓). Skills and Experience: - Proficiency with Excel is essential. - Attention to detail is crucial to ensure all numbers are checked accurately. - Experience with data verification tasks would be advantageous. - Ability to work with image scans. This project entails a high vo...
I'm in need of a Power BI expert who can build a comprehensive model for data analysis and insights. The data sources are primarily Excel files, and the focus will be on deriving performance metrics. - The ideal candidate should have a strong background in data analysis and Power BI, with experience in building models and visualizations. - Proficiency in Python is necessary for scripting visualizations. - Skills in interpreting performance metrics and providing insights are crucial. - Experience working with Excel as a primary data source is required.
...the perimeter of the image (top, bottom, left, and right). Text should be the same on all four sides. Top text should be upside down. Bottom text should be upright. Left and right texts should be rotated accordingly. Add icons or images along the text line. The images may vary in size, but text size will remain consistent. Images should be centered vertically with the text. Source Data (CSV or Excel): Column A: Location of the source image file. Column B: Location of the output file (this is likely the same for each run). Columns C-Z: Text, numbers, or icon image file paths. The images should maintain their original size, and any adjustment to text size should automatically adjust the image sizes if necessary. Customization Options: Ability to modify: Text height in pixels. Pad...
I need assistance in creating an engaging PowerPoint for an educational lecture, alongside managing data analysis and visualization in Excel and formatting a Word document. Key Tasks: - Excel: Analyze and visualize data effectively. - PowerPoint: Design an educational presentation. - Word: Format text in a professional manner. Ideal Skills: - Proficient in Excel for data tasks. - Experience in crafting educational PowerPoint presentations. - Strong Word formatting skills.
### Project Proposal: SEO and Google Ads Optimization for Hudson Aesthetics MD **Project Title:** SEO and Google Ads Optimization for Hudson Aesthetics MD **Project Overview:** Hudson Aesthetics MD is a small, local medical aesthetics practice seeking to enhance our online presence and attract more clients. Our goal is to improve our website's visibility in local search results and optimize our Google Ads campaigns. We aim to start with Hudson Aesthetics MD and evaluate the outcomes before potentially expanding these efforts to our other businesses. **Scope of Work:** 1. **SEO Optimization:** - **Website Audit:** Conduct a basic audit of our website to identify SEO and user experience improvements. - **Keyword Research:** Identify relevant local keywords for our servi...
...c. Contact Information: i. Contact Person’s Name ii. Contact Person’s Title iii. Mobile Number iv. Main Number v. Email Address 2) Specific NGO Focus: Ensure the search targets Muslim-based NGOs only. 3) Use array aggregation to optimize credit usage, grouping multiple data points into a single data object. 2. Output Requirements: 1) Export the aggregated data into Excel format. 2) Automatically upload the Excel file to a designated Google Drive folder. 3) Provide sample outputs for the following locations: a. Malaysia, Selangor b. Indonesia, Jakarta c. USA, New York d. England, London 3. Documentation: 1) Create a Microsoft Word instruction manual covering: a. How to run the workflow. b. Adjusting search parameters for countries, states, and categories. c. En...
Please Sign Up or Login to see details.
Compilation of Annexes from Annual Health Reports (Excel Format) Project Overview: I am looking for a detail-oriented freelancer to extract, compile, and organize all annexes from multiple Annual Health Reports (approximately 195 annexes across 10 years) into a single, well-structured Excel file. Each annex should have its own dedicated tab, and the data should be compiled historically, ensuring accuracy and consistency across years. Scope of Work: Create a Master Excel File The first tab should be a Table of Contents listing all annexes. Each annex should have its own dedicated tab, labeled accordingly. The Table of Contents should include clickable links to each tab for easy navigation. Data Compilation Process Start with the 2023 annexes and go back historically...
I'm in need of an Excel template that aligns with the Tricorn production system. This template should help to generate quotes based on varying product quantities and different variables in a pricing table. Key Features: - The pricing table will account for: - Product quantities - Variable costs - Discount rates - Quotes should be generated automatically based on inputs Ideal Skills & Experience: - Proficiency in Excel, particularly with creating complex formulas and functions - Experience with pricing tables and quote generation - Familiarity with production systems, ideally Tricorn - Strong attention to detail to ensure accuracy in pricing and quotes The goal of this project is to streamline the quote generation process and make it more efficient and accur...
I need an Excel sheet that can help me track my sales. I want to work with quantitative data specifically focused on sales. The sheet should be able to show monthly sales totals. Ideally, the candidate for this project should have: - Proficient skills in Excel - Experience in creating tracking sheets - Understanding of sales metrics
Project Overview: I am looking for a talented designer to replicate the homepage mockup into a functional and polished UI design. The initial design is in an Excel template, which needs to be converted into a high-quality design using Figma, Adobe XD, or Photoshop (feel free to use the software you are most comfortable with). The final result should be a ready-to-develop design, and you will be required to deliver all source files. Assets, fonts and colour palette can be found here This project may lead to further design work of the services page and the contact page. Key Requirements: • Replicate the mock up closely without making any design changes • Adhere to
I need someone to convert tables from my PDF files into an Excel sheet. Key Requirements: - Convert tables from PDF files to Excel - Attention to detail to ensure accurate data transfer Ideal Skills: - Proficient in Excel - Experience with data entry and PDF to Excel conversions - Strong attention to detail
I need an Excel sheet designed for inventory management. It should include features such as automatic stock updates. Ideal skills and experience for the job: - Expertise in Excel - Experience in creating inventory management systems - Understanding of supply chain and inventory metrics
I'm looking for a freelancer for simple numeric data entry from Excel sheets. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to accurately input data - Experience with data entry tasks
I am an experienced data analyst seeking help with cleaning and visualizing existing data sets in Excel. Key tasks will include: - Data cleaning and preprocessing: Ensuring the data is accurate, complete, and ready for analysis. - Building dashboards and visualizations: Creating clear, effective visual representations of the data to uncover insights. Ideal skills for this project include: - Proficiency in Excel, particularly with data cleaning and visualization tools. - Experience in data analysis and interpretation. - Ability to create engaging and informative dashboards. Please note, the project does not require gathering or compiling new data, but focuses on working with existing data sets. Your expertise will be crucial in helping me make the most of the data at hand.