Excel data table lookup trabalhos

As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. Key Features: - Automatic Calculations: The plugin should be capable of performing automatic calculations, saving time, and minimizing any possible errors. - Data Validation: Ensuring data accuracy is crucial, thus the plugin should include data validation steps that help identify and correct any inaccuracies promptly. - Customizable Formatting: To enable smoother navigation and interpretation, the plugin should allow for customizable formatting tailored to my data and personal preferences. - Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me ...

I have a list of addresses for invitations that need to be transcribed from a handwritten list into an Excel spreadsheet. The addresses should be formatted consistently in the following structure: Name, Street Address, City, State, Zip Code. - Handwritten list will be provided, and should be transcribed accurately - Standardize the address format for consistency - No correction needed for typos, just ensure the format is standardized The ideal freelancer for this project would have: - Proficiency with Excel for data entry and formatting - Attention to detail to ensure accuracy and consistency - Experience with handling addresses or similar data is a plus

I'm seeking an experienced Excel professional to assist with the implementation of various financial formulas and functions in my spreadsheets. I am trying to create an excel sheet for sales people to put some data entry and get final pricing. i have the basic excel sheet ready, and if you willing to work on it i can share it and explain in more details In particular, I need help with: - The execution and application of financial functions specifically. - An ability to accurately conduct cost and estimating calculations. - Strong problem-solving skills to fine-tune formulas for efficiency and accuracy. A background in finance and substantial experience with Excel's wide array of financial functions would be very advantageous for the successful compl...

...Modern home space and kitchen on a Budget - I am looking for a freelancer to help me remodel and redesign my home in a modern style., the scope of work for each area: Kitchen: - Reconfiguring the layout to improve functionality and flow - Adding storage solutions such as cabinets and pantry space Dining Area: - Creating a defined dining space that complements the kitchen - Selecting a dining table and chairs that fit the overall aesthetic - Incorporating lighting fixtures to enhance the ambiance Living Room: - Redesigning the layout to optimize seating and entertainment areas - Choosing furniture pieces that suit the style and size of the room Bathrooms: - Maximizing natural light through window expansion or skylights - Incorporating storage solutions for toiletries and line...

Please check this link: The job is to create HTML + CSS code for the following: 1. A table representing the “day view” of an agenda with a fixed top row; 2. Each row of the table represents half an hour; 3. Appointment DIVs that will attach to the “hour row” and be as height as the end time of the appointment demands, overlapping several table rows accordingly; 4. Appointment DIVs will be able to overlap each other when many appointments occur in the same hour row; 5. Same line of thought applies to Week view and Month view (please reffer to the document attached)

...in the conversion of a PDF and an Excel file into a CSV format, specifically tailored for WIX integration. Key Requirements: - Conversion of a PDF file into a CSV format. The PDF contains crucial information that needs to be extracted and transformed into an easily readable and usable format for WIX. - The Excel file contains customer data, specifically including names, email addresses, and phone numbers. This information should also be integrated into the CSV file. Ideal Skills and Experience: - Strong expertise in data conversion, particularly from PDF and Excel to CSV. - Familiarity with WIX Integration - including the ability to format the CSV file in a way that is ready for immediate use in WIX. - Experience handling customer data and ma...

As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel...

I need a 2D construction drawing of an iron and recycled plastic lumber picnic table, ideally sized at 7' long. The primary purpose of this table is for public park or space furniture. We have been provided the exact details to follow by the owner. We do not have access to the CAD drawing therefore it has to be created from scratch. Drawing to be formated as 36" long x 24" high (Arch D) The font style used should be arial and all caps. A new title box will be required. see provided example in template. Key Features: - Wheelchair Accessibility: The table should be designed to accommodate wheelchair users, ensuring they can easily access and use the table. Skills and Experience: - Experience with 2D drafting and designing furniture is essen...

I am looking for a professional who can help me create static QR codes that will be used on my product packaging. The primary purpose of these QR codes is to direct customers to a specific website URL that is related to the product. The content of the QR code will not change over time, as it is intended to be static. Ideal Sk...product. The content of the QR code will not change over time, as it is intended to be static. Ideal Skills and Experience: - Proficiency in creating and managing static QR codes. - Experience in linking QR codes to specific website URLs. Please note that the information to be contained within the QR codes will be provided by me. I am looking for someone who can bring technical expertise to the table, ensuring that the QR codes are functional and readily ...

I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases

I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should incl...

I'm looking for a ...help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specifica...

...Word. The successful freelancer will excel in the following areas: - Expertise in formatting documents in Microsoft Word, particularly in the context of books. - Knowledgeable in setting up appropriate page layouts that will represent my content in a visually pleasing and easy to navigate manner. - The ability to create stylistically consistent and engaging chapter headings. - A keen eye for selecting and applying font styles that enhance readability and match the tone of my book. Past experience in similar book formatting projects would be considered an asset. This project consists of: -Assuring uniform layout of pages -Insert rectangle shapes behind certain areas of text -Making sure the numbering is consistent -Using Styles for headings -Adjusting Table of Contents t...

I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the over...

In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with your expertise.

I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?

My Excel file is very heavy and unorganized. I want it to get cleaned and effecient

I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a definitive plus.

...that, through a form, allows the configuration of API usage parameters, such as headers and HTTP method (GET or POST), and the selection of data to send as filters, such as by name, identification number, or both, similar to the functionality of Postman for configuring requests on endpoints. This form should enable the creation of multiple API configurations for consumption. The initial response must be mapped with a list of preset fields and then generate a new response with the mapped information to standardize the response from all external sources to be configured. The results will be displayed independently in each API connector created in a table viewer as it comes from the source to perform mapping within the detail of the record. Simultaneous connection with all ...

We're on the lookout for skilled animators adept at infusing life into our milkbag persona through captivating and witty Instagram Reels and animated content. Our ideal candidate possesses a solid grasp of animation principles and consis...of content we're aiming for. We aspire to achieve a similar level of ingenuity and amusement in our milkbag character Instagram Reels. How to Apply: If you're passionate about animation and possess a talent for crafting entertaining Instagram Reels and understand cryptocurrencies and trading we're eager to hear from you! Please include your portfolio and a brief statement outlining why you'd excel in this role in your application. Additionally, feel free to share any relevant experience or ideas on bringing our milkbag c...

I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes

...that, through a form, allows the configuration of API usage parameters, such as headers and HTTP method (GET or POST), and the selection of data to send as filters, such as by name, identification number, or both, similar to the functionality of Postman for configuring requests on endpoints. This form should enable the creation of multiple API configurations for consumption. The initial response must be mapped with a list of preset fields and then generate a new response with the mapped information to standardize the response from all external sources to be configured. The results will be displayed independently in each API connector created in a table viewer as it comes from the source to perform mapping within the detail of the record. Simultaneous connection with all ...

I am working on a travel memoir; a blend of non-fiction with a twist of fiction. In need of an enticing book cover for Amazon KDP, aiming to entice readers at first glance. Key project requirements are: - Creating a...in the travel or memoir genres. - A good understanding of Amazon KDP's book cover guidelines. This job requires a creative mind, as it will entail striking the balance between my personal vision and your professional expertise. I look forward to collaborating with a designer who can help bring the identity of my book to life with a memorable and compelling cover, not using AI! I can supply a Table of Contents to give an idea of how the book is written, as well as a few photographs that could be incorporated into the design if you see fit. I look forward to he...

I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation

...1 link), Services (multiple choice. 1 to many link), Date and Time, Minimum Number of User needed to support the Event - Creation of “Access Pass” in pdf format for each User with User Name, Surname, QR code, Dates and Events - Administrator Dashboard showing Number of user registered, Events, Services, Places, Calendar where are displayed events, visualization of new User registered, access to table of all User where can be found User with filters - Standard User Dashboard showing the events where the User can check the events to which is assigned, View Webinair and other multimedia material loaded by the Administrator for all the User - Internal Communication: the Administrator can send mails to all the Users or subsets of Users - Communication via App: the Administ...

summarize in a specific table in Excel

Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the ...

Answer the attached question correctly, and briefly explain. using principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Answer the attached questions, the provide table of the subnets Accepted file format Excel or Word

I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may...type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a ...

I am seeking a skilled freelancer with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH W...

...seeking a Python developer who can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of a...

I need assistance with entering inventory data into Quickbooks Desktop from an Excel file. - I'm looking for a professional who has experience with Quickbooks Desktop. - The job involves bulk data entry, focusing specifically on inventory. - You will be provided with an Excel file containing the inventory data. - Attention to detail is crucial to ensure accurate and efficient data entry. Ideal skills: - Proficiency with Quickbooks Desktop - Experience with data entry, particularly inventory - Attention to detail and accuracy in data entry - Familiarity with Excel files and their import into Quickbooks

I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on the head of your bid if you are not a bot.

I'm looking for proficient freelancers who can effectively input both text and numerical data into Excel from physical documents. The task does not require any formulas or calculations, but attention to detail is crucial to ensure the accuracy of data. Key tasks include: - Manual entry of text and numbers from physical documents into Excel - Ensuring accurate data entry and quality checks Ideal freelancers should: - Have experience in data entry tasks, particularly with Excel - Be detail-oriented to ensure accuracy - Have strong organizational and time management skills.

I require the expertise of a part-time remote accountant who can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely...can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely and accurate manner. - Financial analysis: Monitoring, identifying and interpreting financial trends. The ideal candidate should have a good command of QuickBooks and Excel spreadsheets. Familiarity with these tools is crucial for performing tasks efficiently and a...

I'm looking for an expert in Excel who can help me with applying conditional formatting and creating complex formulas that involve multiple conditions. Please watch this video for what i need Key Requirements: - Applying Conditional Formatting: The Excel file will require conditional formatting to visually represent data based on specific criteria. - Creating Complex Formulas: The project includes creating formulas that are not limited to basic arithmetic, and instead, involve multiple conditions. Ideal Skills and Experience: - Proven expertise in Excel: The ideal candidate should have a strong background in working with Excel and creating complex formulas. - Understanding of Conditional

...recognizing the number, it needs to check if that number is included in the PadresTable, in the Numero column. 3) If the phone number belongs to that column, I want it to go to the HijosTable and associate all children associated with the parent. Then, the bot should ask the parent with which child they want to schedule a tutoring session from the previously associated ones. If the number is not in the table, show a message indicating it doesn't belong to this school. 4) Once the parent selects the child they want to schedule a tutoring session for, I want to give them the option to schedule with the desired teacher. The selected child will be associated with the teachers they have through the ProfesoresHijosTable, and I want to give them the option to choose the teacher the...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

I'm in the process of opening a Caribbean cuisine restaurant and need a creative designer to help me craft a beautiful, modern menu. Key Requirements: - **Design Style**: The ideal menu should embody a 'Modern' aesthetic, reflecting a contemporary take on traditional Caribbean elements. - **Format**: This menu will be a print version, not digital. Ideal Skills...appealing and cohesive designs. - **Menu Design Experience**: Previous experience in designing menus, especially for restaurants, is a major plus. - **Understanding of Caribbean Aesthetics**: While not mandatory, a familiarity with or an appreciation for Caribbean visuals would be great. If you have a keen eye for design, love the Caribbean culture, and can bring a fresh, modern perspective to the table, I...

I am looking for an efficient data entry expert to assist me in entering textual, numerical, and image-based data. The project involves a medium amount of data that needs to be meticulously transferred to an Excel file. Your responsibility will include, but is not limited to: - Inputting textual data while maintaining accuracy. - Adding numerical data precisely. - Uploading images correctly. An ideal freelancer for this job would have a keen eye for detail, substantial experience with Excel, and the ability to handle different types of data. Prior knowledge in image uploading and handling is a plus. You should also pride yourself on accuracy and efficiency. In your proposal, please share a brief summary of your experience, includ...

Automated report using dashboard in Excel The report interface should be similar look to the pic attached. The Excel file for data source should be able to be used for Power BI. Two dashboards: 1- for multiple project management status reporting 2- for ad-hoc task management The data source is in an Excel sheet with a manual entry

I'm looking for a data engineer with solid Pyspark knowledge to assist in developing a robust data storage and retrieval system, primarily focusing on a Data Warehouse. Key Responsibilities: - Implementing efficient data storage solutions for long-term retention and retrieval - Ensuring data quality and validation procedures are in place - Advising on real-time data processing capabilities Ideal Candidate: - Proficient in Pyspark with hands-on experience in data storage and retrieval projects - Familiar with Data Warehousing concepts and best practices - Able to recommend and implement appropriate real-time processing solutions - Strong attention to detail and commitment to data quality. Specifically, I have a Jira ti...

Necesito combinar un archivo excel que lo extraigo de un programa extranjero (1r archivo), y que debe añadir de otro archivo (plantilla proveedores) un dato para obtener una excel final (plantilla). El programa debe permitir insertar el archivo inicial, que consulte otro excel para añadir su CIF (el software es extranjero i no lo incluye) i transformarlo en el final (plantilla). Lo suyo sería, inserte archivo inicial, para extraer el archivo final

I'm in need of a professional who can develop a scraping tool that will track market announcements and releases on a financial website using specific keywords. - The tool should scrape this data on a daily basis. Accuracy and reliability are key. - the scraped data should be filtered for the current date, daily. - I need this table of data to be automatically filtered for keywords. -the filtered results to be emailed automatically to an email list. - the tool to run automatically on a website or server. I'm looking for someone who has a proven track record in web scraping with a focus on financial data. Experience in creating automated scraping tools, particularly those that operate on a daily basis, is a huge plus.

I'm on the hunt for an experienced video/photo editor who can create reels and posts of Hindu idols. Here's what you need to bring to the table: • Mastery of classic and elegant aesthetics. • Knowledge and execution of trending content in the world of reels and posts. • Proficient with photo editing tools including cropping, resizing, applying filters & effects as well as adding texts & stickers to the media content. If you possess these skills and are able to handle this task with a keen eye for detail, I'd love to hear from you.

I'm looking for a skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements. Thanks :

2 pages of data sheet need to be recreated with zero mistakes and dito copy i am attaching the 2 pages i need to be recreated same to same, the top logo will change which i will provide you the screw picture and the text i am attaching with this for your review the sheets should be totally editable either make in word or excel or it should be edited in PDF the lowest quote below the price of $15 will be awarded the project thank you

When replying, reply with the text: "Forensic 4 Project"...qualifications you have? 7) If you have any experience in working in Singapore financial projects do highlight those as well. 8) What do you understand of the SIBOR / SOR / LIBOR scandal and how could it have affected borrowers? Work scope: Go through letter of offers and loan statements, find the faults, calculate the excess paid, calculate damages All works should be done in Google Sheets or Microsoft Excel with formulas to prevent any calculation errors. Your output should clearly show what was charged, what should have been charged, difference and damages. Need someone who has a decent amount of time available, if you do not have alot of time to spare, this may not be ideal as this will take some time to co...