Microsoft excel vlookup jobs

I'm looking for an experienced Excel Power-BI professional to assist me with various tasks. Key requirements: - Proficiency in Excel Power-BI. - Demonstrated experience in data analysis, dashboard creation, and report generation. - Ability to work with minimal supervision. I will share more details in via chat box. Only interested person placed a bid Thanks

I'm seeking a Django and Python Fullstack developer who can lend their expertise to my application project. The chosen freelancer should excel in creating: - Robust user authentication and authorization systems - Seamless database integration - Responsive design that adapt to various devices I have certain design ideas but I would highly appreciate guidance to help realize these concepts. The freelancer should possess a strong grasp of user-centric design and prove instrumental in translating these concepts into a streamlined, functional, and easy-to-use interface. Ideal skills: Python, Django, Database Management, User Interface Design, User Experience Design, and Responsive Web Design. It's a bonus if the candidate has a knack for making technical functionalities sim...

I have a Microsoft Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word

I'm looking for help with a professional writing for a business loan application forms to fill in and send back to me. Key requirements: -fill in the question and write a user-friendly loan application form for high success rate. - there are 3 forms to fill in Business plan template cash flow template, Cash flow forecast Personal surviving budget they are in Microsoft excell file, once filled in just save and return to me so it is ready for the application upload. Ideal freelancer will have: - Proven experience in English literature - Strong understanding of business planning and growth. The application form is an essential part of the loan application process, with few questions which asks how the business growth and planning , once is written I can review for the f...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

...conducting variance analysis. - Skilled in implementing break-even analysis. - Previous experience in creating comprehensive business financial forecasts. The end goal of this project is to have a detailed yearly overview of my business's financial health, with a focus on identifying trends and outliers, and ensuring our financial strategy is aligned with our business goals. Ideal Skills: - Advanced Excel proficiency. - Expertise in financial analysis and forecasting. - Strong analytical and problem-solving skills. - Excellent communication and reporting abilities ( need it finished by today )....

I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.

...data to a database. Here are the specifics: - **Export Data:** The form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience with exporting to databases and Excel - Proficiency in generating PDF documents fro...

I need to migrate our current Microsoft Teams calling system to RingCentral. This is a critical project for our organization and I'm looking for an experienced professional to handle it seamlessly. Here's an overview of the key aspects of the project: - Migrate from existing VoIP system to RingCentral including porting existing phone numbers - Ensure all the features we need are properly set up in RingCentral, specifically call forwarding and auto-attendant - Complete the migration with minimal downtime and disruption to our business operations - Provide training to 11-50 employees on how to use the new RingCentral system Ideal skills and experience: - Proven experience in VoIP system migration - In-depth knowledge of RingCentral system and its features, particularly cal...

I am looking for a personal mentor who can help me improve my understanding of Microsoft Dynamic365 finance and operation, specifically in the area of financial management. As a beginner in this field, I need someone who can guide me through the basics and help me gain confidence in navigating and using the software effectively. Ideal Skills and Experience: - Strong knowledge of Microsoft Dynamic365 finance and operation, with a focus on financial management - Previous experience mentoring beginners in this field - Excellent communication and interpersonal skills - Ability to provide clear explanations and step-by-step guidance Mentoring Sessions: - Twice or more a week - In-depth discussions and hands-on practice - Assistance with specific tasks and challenges - Regular fe...

I have a Google document that I need converted into a Word document, specifically in .docx format. Special Requirements: - The Word document's formatting should mirror the existing Google document's ...Google document that I need converted into a Word document, specifically in .docx format. Special Requirements: - The Word document's formatting should mirror the existing Google document's formatting. - The Google document includes images that need to be accurately transferred into the Word document. - No other specific formatting is required. Ideal Skills: - Proficiency in Google Docs and Microsoft Word. - Experience in handling image transfers between different document software. - Attention to detail to ensure the final Word document looks identical to...

I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure the accuracy and fun...

I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.

I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.

I need a virtual assistant who can help me with a range of...key for this role, so I need someone who is comfortable with various communication channels. I expect you to be responsive to emails, phone calls, and instant messages. Ideal Skills and Experience: - Proven experience as a virtual assistant or in a relevant role - Excellent organizational and time management skills - Strong communication skills, both written and verbal - Proficient in using Microsoft Office and Google Suite - Ability to handle customer inquiries and provide basic support Please apply if you have a part-time availability and the right skills to take on this multi-tasking role. YOU MUST BE A LATERAL THINKER NO EXCUSES WILL BE TOLERATED $100 AUD PER MONTH AFTER U GIVE ONE MONTH FREE TO PROVE UR ATTITUD...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I'm looking for a professional who is proficient in converting PDF files to Word documents. This project entails: - Working with a PDF file that primarily contains textual content. - Ensuring the Word document mirrors the PDF format exactly, from text placement to style. - Operating within a Windo...PDF files to Word documents. This project entails: - Working with a PDF file that primarily contains textual content. - Ensuring the Word document mirrors the PDF format exactly, from text placement to style. - Operating within a Windows environment. The ideal freelancer should have superb attention to detail, and should deliver the work in a timely manner. Experience with Adobe Acrobat and Microsoft Word is highly desirable. Accuracy and format preservation is of utter importanc...

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

I have a simple text-based PDF file that I need converted to a fully editable Microsoft Word document. Key Requirements: - The purpose of this conversion is to allow for easy content modifications, so the document should retain the same content layout as in the PDF. - No complex formatting is present, just the text that needs to be edited. - The final Word document should be compatible with Microsoft Word only. Ideal Skills and Experience: - Proficient in PDF to Word conversion tools or manual typing to maintain document integrity. - Expertise in Microsoft Word to ensure the best conversion for editing purposes.

I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaningful analysis - Opportunities t...

I'm in immediate need of a skilled data entry operator located in Pune, India, to rectify a Microsoft Office Word document. This task is essential as it requires meticulous attention to detail. Key Tasks: - Rectify the formatting errors and spelling/grammar mistakes in the document. - Make necessary table and layout adjustments for improved readability. - Remove the 'Year' field from one of the rows in the table. This project demands: - Proficiency in Microsoft Office Word. - Exceptional eye for detail to correct formatting, spelling, grammar, and table-related issues. - Ability to follow instructions meticulously. - Excellent communication skills for any clarification or feedback. Please only apply if you're located in Pune, India, and have the necessa...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

Please Sign Up or Login to see details.

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes over time...

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

business profit loss reporting excel(Jan, Feb & March)

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static...

...belongs to Sors Markets Ltd. • Future work I hope that one day you can be good enough to handle some of the simple payments and research on, for example, flight and train tickets. If you can handle the preliminary work, more admin work can be shifted to you, and the number of hours on the task will increase. If you have any questions, please send us a message. Key skills: - Proficient in Microsoft Excel / Google Sheet - Strong attention to detail - Previous experience with VAT calculations is a plus...

...belongs to Sors Markets Ltd. • Future work I hope that one day you can be good enough to handle some of the simple payments and research on, for example, flight and train tickets. If you can handle the preliminary work, more admin work can be shifted to you, and the number of hours on the task will increase. If you have any questions, please send us a message. Key skills: - Proficient in Microsoft Excel / Google Sheet - Strong attention to detail - Previous experience with VAT calculations is a plus...

...significantly. Links or a portfolio will be highly beneficial. - **Experience Level:** I'm targeting someone with an intermediate level of experience. You should have a solid track record and be comfortable tackling the complexities of IT development without needing extensive oversight. - **Skills and Expertise:** - Proficiency in relevant programming languages (Must have: Codeigniter, WordPress, Microsoft technologies like Azure, Power Apps) - Strong understanding of the full development cycle - Experience with both front-end and back-end development (specific skills depend on the project type) - Problem-solving abilities and a keen eye for detail This collaboration could span multiple projects, so I'm keen to establish a reliable, long-term relationship. If...

I'm in need of an office assistant residing...appointments, and help in daily activities. The role will require 50 hours of work per week. Key responsibilities: - Responding to emails and managing my inbox - Scheduling appointments and managing my calendar - Assisting in daily activities and other office related tasks as needed The ideal candidate for this role will have: - Proven experience in managing emails and scheduling - Proficiency in Microsoft Office suite - Strong organizational skills - Previous experience in customer service would be a plus Candidate has to be from Pune, India Your ability to prioritize tasks, communicate efficiently, and maintain a high level of confidentiality will be critical for this role. A proactive approach and attention to detail is also...

...causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previo...

...and operational procedures. Provide ongoing support and troubleshooting to ensure system stability and user satisfaction. Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for project lifecycle management, including CI/CD pipelines and agile project management. - Experience with Microsoft Azure, especially Azure Service Bus and Azure Functions. - Strong knowledge of database management with MySQL and SQL. - Ability in RESTful API development and OAuth security practices. - Excellent problem-solving skills and ability to work effectively in a team environment. Education and Experience: - Bachelor’s or Master’s degree in Computer Science, Software Engineer...

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach thi...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I need assistance with pagination in my 200+ page Word for Mac document, specifically in certain sections. The main issue I'm facing is inconsistent numbering, which seems to be disturbing the flow and continuity of my work. The chosen freelancer should have: - Proficiency in Microsoft Word for Mac (I'm using version 16.85 copyright 2024). - An excellent understanding of pagination issues and how to resolve them. - Experience with document formatting in large Word files. Please only bid if you're confident you can rectify this issue quickly and efficiently.

...entire scientific thesis in Microsoft Word. The document needs to be formatted to a high academic level. This will require the following: - Ensuring the entire document is formatted consistently for a professional and cohesive look. This includes font, headings, and spacing. - Creating and formatting a Table of Contents - Setting up headings and subheadings in the document according to the specified style. - Ensuring font, spaces and tables are properly formatted ensuring a professional look. The preferred formatting details are as follows: - Font: 12pt Times New Roman - Headings and Subheadings: Italicized with the same font size Ideal candidates for this job should have: - Solid experience in formatting academic or scientific documents. - Proficiency in Microsoft Wor...

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-function...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (mi...algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • ...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I need a word background editor for my CV and cover letter that's creative and understands a che...background editor for my CV and cover letter that's creative and understands a chef's profession. She/He must comply with this video tips: This tool must have: - Customizable templates for versatility. - The ability to alter font and color options. - Image insertion functionality to make visually engaging documents. The editor needs to work well with Microsoft Word and other word processing software. Ideally, it will offer designs specific to the culinary profession, creating a bold but professional impression of a head chef. Skills in graphic design and software development are preferred. Expertise or understanding of culinary aesthetics is a bonus.