How to insert if function in excel jobs

...Chatbot Developer to create a customer service-oriented chatbot for both web and mobile platforms. Key Requirements: - Cross-Platform Development: The chatbot should seamlessly function on both web and mobile. - Customer Service: The primary focus of the chatbot's role will be to handle customer service inquiries, providing prompt and accurate responses. - Multilingual Support: The chatbot should be capable of understanding and responding in multiple languages. Ideal Candidate: - Proficient in AI Chatbot Development: You should have prior experience in creating and deploying AI chatbots. - Full Stack Development: Knowledge of full stack development is a plus, as it may facilitate the chatbot's integration into the platforms. - Multi...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

...developer to create a Session Initiation Protocol (SIP) client for specific platforms. This client will cater to Windows and Linux operating systems. Key Requirements: * The core capability of the Python SIP client will be to facilitate audio calling. Therefore, the developer must focus primarily on this function. * For safety and security, a basic username and password system will suffice for user authentication. Ideal Skills & Experience: * Proficiency in Python language is mandatory. * Prior experience in developing communication applications, specifically in SIP, will be beneficial. * An in-depth understanding of user authentication using basic username and password systems is required. * Familiarity with Windows and Lin...

...someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase ...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

The target is to write a Java, console program (public static void main) that will generate a docx Word file. Program needs to use docx4j library () Programm needs to generate many parts: Heading1, Heading2, Heading3, every with some content (lorem ipsum) Make a table of contents (showing on which page is a given Heading1, Heading2, Heading3 - not hard coded, but detected) Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 In the text put links to a concrete Headings, eg. "read in Heading2 - abc (page 4)" - it should be link to this section and "(page 4)" should Make a footer showing the numb...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I'm looking for a skilled developer to help create a custom content management system for my website. Key Requirements: - **Purpose:** The main goal of this system is to manage content effectively on my website. - **Primary Users:** The system should be designed for use by the general public. This means it should be user-friendly and intuitive, to cater to a wide range of users. Key Features: - **Automated E-invoicing:** The system should include a function that can automatically issue e-invoices. This is a critical feature for my business operations. Ideal Skills & Experience: - Experience with developing content management systems, particularly for a wide user base. - Proficiency in e-invoicing systems and related technologies. - S...

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I am...experienced Python Django developer to take care of the back-end work for a web application intended for specific industry professionals. The required functionalities include: - User authentication and registration: Candidates should have experience implementing secure user authentication and registration systems. - Database integration and management: We need someone with proficiency in integrating and managing databases, ensuring smooth operations for user data handling. - API Integration: Expert skills in API integration are required to establish seamless communication between applications. Your primary goal is to build a strong, reliable backend for our professional web app. We need an expert who can ensure excellent function and optim...

I'm in need of a skilled developer to create a custom Forex indicator that counts bars from a specific origin point. The indicator should work on Tradingview Key Requirements: - The primary function of the indicator should be to count bars rather than identifying trend reversals, highlighting entry/exit points, or measuring volatility. - The indicator should be capable of accurately counting bars. Ideal Skills and Experience: - Proven experience in developing custom Forex indicators. - Proficiency in working with a variety of trading platforms. - Strong understanding of Forex trading and technical analysis. - Prior experience in creating bar counting indicators would be a significant advantage. Please provide a brief overview ...

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I'm currently in search of a Python developer with specific expertise in data insert and search in vector data based on keyword * custom logic which i will brief in DM Budget 6,000 INR Day - 1 Day Task

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attentio...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be req...

...experienced in Tailwind CSS and FormioJS to adjust the design of FormioJS so that it integrates seamlessly with my current Laravel + Livewire project. The goal is to ensure that the forms generated by FormioJS look and function correctly with the Tailwind CSS framework. Currently, FormioJS does not have native support for Tailwind CSS, so the existing styles will need to be adapted. Project Details: - Main Framework: Laravel + Livewire - Used Packages: - Livewire - Jetstream - MaryUI - daisyUI - Tailwind CSS - Vite Requirements: 1. Style Integration: Adjust the styles of FormioJS to look and function correctly with Tailwind CSS. 2. Full Compatibility: Ensure that the styles are compatible with existing MaryUI and daisyUI components and ...

I'm seeking a developer to create a comprehensive members' social media software. This software should be responsive and functional across both web and mobile platforms. Key Functionalities: -Instant messaging: Members should be able to privately communicate with one another. -Photo and video sharing: A core function should include the sharing and commenting of multimedia content. -Blogging and forums: Members must have the ability to write posts and create threads for discussions. The platform should optimally support a user base of 1,000 to 5,000 members. Applicants should have a robust background in social media software development and be experienced in implementing the functionalities listed above. An understanding of scala...

Create a Google Sheets system for managing alcohol inventory. Includes columns for Brand, Name, Number of bottles, Country, Rating. Dropdown for rating (1-10). Show stats: unique bottles, total bottles, countries. whit a front page where i can insert the above items, and get under a reading of stats.

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm look...

I'm in need of a skilled Android developer to help create a Telegram clicker bot application. The bot should be able to perform various interactions within the Telegram app, primarily for mining purposes. The main functionalities the bot should have include: - **Automated Clicking:** The bot should be able to click on specific buttons within the Telegram app. - **Mining:** This is the main function, the bot is expected to mine in the app. The ideal candidate should have: - Proficiency in Android app development. - Experience in developing Telegram bots. - Knowledge of mining capabilities. The project is to be completed within a reasonable time frame. Please provide examples of previous similar projects.

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

...developer to create a top-tier B2C eCommerce website. While I have not settled on a specific platform, potential candidates should ideally be experienced with popular choices such as Shopify, WooCommerce, or Magento. This website's primary function will be selling physical products, so experience in developing product listings, secure payment systems, and efficient delivery information sections is a must. The perfect candidate for this task will be able to brainstorm and implement a user-friendly design that can attract and retain consumers. Skills and Experience: - Proven knowledge of popular eCommerce platforms (Shopify, WooCommerce, Magento) - Experience in creating websites oriented towards selling physical products - Ability to des...

...expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involv...

I am looking for an expert in LLMs, who can create a chatbot that is capable of using Knowledge Base for information like a RAG Database, and Function Calling with the help of LLM, eg: Calendar Booking, Chat Transfer and similar functionalities. Person must have ample experience with LLMs and RAG and should know how to use LangChain and similar technologies.

...need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I wan...

...specifically designed for our nightclub. The primary function of this app is to efficiently track sales. However, there are additional features that are essential for improving our business operations and customer experience. Key Features: - **Customer Loyalty Program Integration:** I want this app to seamlessly integrate with our customer loyalty program. This will help us retain existing customers and attract new ones. - **Employee Management:** The app should allow our staff to easily manage transactions, track their sales, and communicate with customers through the app. - **Songs Queue Requests:** It is important that the app allows our staff to manually select songs for playback from a queue of requests. Ideal Skills and Experience: - Proficien...

...automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experi...

I'm in need of an experienced Flutter Web App developer to develop a one page sample app that uses Firebase as back end. The app should be able to list Excel files from the server and allow the user to select a file and email the file as an attachment. The function must work on Android devices including Chromebook. The development environment must be on a MacBook with Android Studio IDE. Sending URLs instead of attachments is not acceptable. Key Requirements: - Utilize Flutter for the front-end development. - Incorporate Firebase for back-end data management. - Implement support for Excel files specifically. - Provide means to list the documents stored in the Firebase account. - Include functionality to email these...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be per...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

...looking for a skilled developer to create a phone control application that will run on my Windows PC. The primary function of this application should be remote control of both Android and iOS devices. Key Requirements: - Development of a phone control application compatible with Windows OS - The application should support remote control functionality for both Android and iOS devices - Ensuring smooth and responsive performance of the application - Interested in any additional features or suggestions for improvements from the developer Ideal Candidate: - Proficient in app development for Windows OS - Experienced in creating remote control applications for mobile devices - Familiarity with both Android and iOS operating systems - Excellent problem-sol...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

...seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-fr...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in ...

...processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second image and pants from a third image. Ideal Skills and Experience: - Proficiency in image processing algorithms and techniques. - Familiarity with AI te...

I am in need of detailed administrative work. It involves segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page numbe...

Hello, I will need 2 different versions of a very simple booking android app. the important part is the communication with our simple Java (eclipse) backend. Analytical step-by-step details will be sent in doc, together with helpful code and matterial, as well as the java eclipse project of the backend. We will need 2 completely different versions of the same app (completely different gui, comments on code, approach where possibble, all variable and function names, structure and order) Budget is $200 USD for both (2 milestones $140 USD and $60 USD) Deadline: 27/5 for the first and 30/5 for the second

I'm looking for a Python developer to assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scr...

...looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page

...top-notch technical solutions to improve our system. The project is urgent and needs to be completed ASAP. Key Requirements: - Customization of Sales & CRM, Payroll, Project task management, HR modules: We are looking for someone to tailor these modules to our business needs, ensuring they function optimally. - Seamless integration with erpnext: We need the developer to integrate our system with erpnext seamlessly, without any disruptions in our current workflows. The ideal freelancer for this job would have: - Proficient in ERPnext: Experience working on ERPnext projects and a deep understanding of its functionality. - Integration Skills: Capable of integrating systems smoothly and efficiently. - Urgency: Able to work...

I'm seeking an expert freelancer with strong abilities in automation for a technology focused project. The main function of the project is to drive automation across several processes. However, the specific processes to be automated still need definition. Thus, proficiency in identifying and streamlining operational inefficiencies is critical. Ideally, candidates will have proven experience in tech-related projects, a detailed understanding of automation and a knack for problem-solving.

...developer to create an AI customer service chatbot for my business. You will be using OpenAi api. You will need to extract all email from our gmail account to train the model. The model should be able to create response to customer queries using the training data. This will be a chrome extensions. The primary functionality I need is for it to be able to effectively respond to frequently asked questions (FAQs). Key Project Details: - Platform: The chatbot should be developed specifically for my business - Functionality: The primary function of the chatbot should be to accurately answer customer's FAQs. - Language Support: I am not sure if multiple languages will be required at this stage, but the ab...

...editor to accurately insert a person from a given photo into a distinct group photo. I require precise merging skills to blend the person naturally into the intended image. Specifics Include: - I do possess both the images that need to be worked upon. - The critical change is to incorporate an individual from one picture into a group photo in an unnoticeable and flawless technique. - I want the person from the first image to be precisely positioned next to a specific individual in the group photograph. The ideal freelancer for this project must have extensive experience in photoshop or equivalent photo editing software, a keen eye for detail, and a strong understanding of lighting and shading to match the ad...

I have a backend code for a pre-existing fully function website and mobile app. The backend code is currently all written in php. I need someone to convert this existing php code into fully functional python code which I can deploy.

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.