Excel conditional formatting formula if cell contains text jobs

I'm in need of an expert who can efficiently extract text data from about 160 unstructured PDFs and enter it into a database. Key Responsibilities: - Extracting unstructured text data from PDF files - Accurately entering this data into a database Ideal Skills: - Proficiency in data entry - Experience handling unstructured data - Attention to detail The work will require a computer, a stable internet connection, and the ability to commit to accurate and efficient data entry. Experience with unstructured data is highly preferred.

I'm looking for a Jira specialist to help me create a custom automation that will generate a ...issue based on that paragraph. A way for Jira automation to identify a double line break needs to be created. The automation should auto populate all the child issue field with the same attribute as the parent. See attachment for example Key Requirements: - The child issue should be created in Jira Cloud. - The automation should be triggered when a parent issue's description is updated and contains a double line break. - The child issue should mirror all attributes of the parent issue. The ideal freelancer for this project would: - Have prior experience with Jira Cloud automation. - Be familiar with creating child issues within Jira. - Be able to implement condition-based t...

I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth anal...

...- Valuation: A comprehensive evaluation of the company's worth. - Business summary: A concise overview of the company's operations and key strengths. - Risks: Identification and analysis of potential risks the company faces. - Industry analysis: Understanding the company's position and performance in the context of its industry. - Reach format report with 10k words, charts and infographics. - Excel modeling and native file is part of the deliverable. Ideal candidate would have: - Proven track record in financial analysis - Strong understanding of financial principles and methodologies - Previous experience in company valuation - Ability to present findings in a clear, concise and actionable format - Attention to detail and high analytical skills Please provide ...

Excel task to do the task t0 d0

...professional who can meticulously handle the editing of more than ten Word documents, with each document being less than three pages on average. This work includes the following: • Formatting: Tasks will involve refining and improving the existing layout, ensuring consistency and clarity. It is crucial for the freelancer to have a keen eye for detail. • Proofreading: After the preceding stages, a final proofread is necessary to identify and rectify any remaining grammar, punctuation, spelling or typographical errors. The perfect freelancer for this role will have professional experience in document formatting, content editing, and proofreading. Proficiency in Microsoft Word and a sound understanding of the English language are essential. Lastly, the freelance...

Developers Wanted: Thorough Examination of Example Website's Internal Structure and Registration System Essential! ...and Registration System Essential! We're seeking skilled developers to undertake a detailed review of an example website's internal structure and registration system. It's crucial to adhere closely to these guidelines, as we're aiming for a system that operates flawlessly. An example website has been provided as a reference point and must be followed closely. Please note that the attached item contains extremely important instructions and specifications that must be followed meticulously. We're looking for a system that functions seamlessly, and this example website serves as our blueprint. Thank you for your attention to detail. We l...

I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.

...tackle a formatting task. The task involves taking my 400-page fiction manuscript (170 K words) and preparing it for publication in EPUB and PDF formats. Requirements: - Significant experience working with similar projects, especially in the fiction genre. - Knowledgeable in current eBook and paperback publishing standards and industry requirements (the files must meet Ingram's requirements since I'll use them for paperback printing). - Exceptional attention to detail, guaranteeing a high-quality product ready for digital distribution. Ideally, prospective freelancers will be adept with eBook creation tools/software and come equipped with a discerning eye for aesthetics, ensuring the final product is functional and visually appealing. Your skills and experience in bo...

I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My expectat...

I require a WORDMARK logo for a fitness company, I prefer the logo to have n...called Pro Teemz you can join the two words together (ProTeemz) or separate them (Pro Teemz). Attached you will find the file ProTeemz Colour Codes, the logo must only contain these colours or a combination of them. Post your entries on a black (#000000) background please. All "mockup" designs will be immediately rejected, I am looking for something original not generic, similarly any design that contains an element that I can download from shutter stock will also be rejected. I will comment and give positive feedback on all submitted designs each day to make the process as efficient as possible. The contest will run for the full length, there will be no winner decided or announced until the...

I'...processing, with a particular focus on training models for Text-to-Speech (TTS) applications. In this project, I require assistance in training a dataset from scratch to create a functional, ready-to-use model for Coqui AI TTS specifically designed for the French language using a specific voice. Key requirements: - Intermediate to Advanced level experience in machine learning and NLP. - Previous experience in training TTS models, especially with Coqui AI. - Proficiency in French is a plus. - Familiarity with working on a model for a specific voice. The ideal candidate should be able to guide me through the process of dataset preparation, model training and fine-tuning, and assist in making the model ready for deployment. Please only apply if you have a proven trac...

I'm seeking a flexible skilled coder with robust experience in Pinescript and TradingView platform who can modify my existing Pinescript indicator. Key Modifications Include: - Parameter calculation changes: This includes both adjusting current indicator inputs and modifying the calculation formula to maximize the efficiency and effectiveness of the indicator. - Adding options to the settings interface to allow for customized user experience. - Based on testing, would need to accomodate any suggested changes realtime Your skills and experience in TradingView and Pinescript will be vital for the successful completion of this innovation-focused project. Your keen attention to detail and understanding of financial markets will also be advantageous.

I need an experienced Wordpress website designer who can work precisely on three aspe...Foremost, the site needs to be thoroughly secure to protect both admin and users. Additionally, I plan to expand the range on my site by including digital products. So, I need the designer to arrange these products on the site in an appealing way. Experience in developing online stores would be appreciated. Lastly, I need content (both text and media files) from another website to be moved to the new site. It's crucial that the layout and formatting remain consistent during the move. In summary, you need to be proficient in Wordpress, SEO, security enhancement, and preferably have experience with digital product presentation and content migration. I look forward to working wit...

I'm in need of a detail-oriented architectural drafter to create a comprehensive 2D construction plan for a Marathi temple, measuring 17 m by 30 m, using AutoCAD. Your responsibilities will encompass: - Developing an intricate architectural layout that contains a floor plan, elevations, and sections. Extra attention to detail to accurately capture the unique design elements of a traditional Marathi temple is crucial. - Incorporating electrical and plumbing layouts into the construction plan. Ideally, you should have: - Extensive experience with AutoCAD in creating detailed construction plans. - Proficiency in architectural layouts, especially temples or similar cultural structures. - Strong understanding of electrical and plumbing elements in architectural design. Your ...

I'm in need of a skilled professional who can help me scrape text data from e-commerce sites for data analysis. Key Requirements: - Data Scraping: The primary task is to extract text data from various e-commerce websites. This includes product descriptions, reviews, and any other relevant textual information. - Data Cleaning: Ensure the scraped data is accurate, clean and ready for analysis. - Data Analysis: This project is focused on data analysis, so experience in this area is a must. The ability to extract meaningful insights and trends from the scraped text data is crucial. Ideal Skills and Experience: - Proficiency in Web Scraping: A strong background in web scraping and working with text data is essential. - Data Analysis Skills: Experience in data ...

I require an experienced professional to obtain text and images from a blog and store them in a CSV file. The ideal candidate should: - Have experience in scraping content from websites - Be adept at data management, specifically CSV files - Be proficient in handling both texts and images and store in easy way to manage and retrieve A strong track record of similar projects will be a plus. This job requires accuracy and attention to detail. I look forward to seeing your bids.

We're seeking a talented 3D artist capable of producing captivating photorealistic renders and videos for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong portfolio sho...

I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE ...

I need an expert proficient in SwiftUI to help with specific text alignment and truncation issues in my project. Key Requirements: - Proficient in SwiftUI: You should have hands-on experience in SwiftUI to effectively address the text alignment and truncation issues. - Text Alignment: The project requires specific text alignment to fit the text into designated UI elements. - Text Truncation: You will also be responsible for implementing text truncation strategies. Ideal Skills and Experience: - Strong command over SwiftUI is a must. - Prior experience with text alignment and handling in SwiftUI. - Experience with fitting text into specific UI elements, will be a plus. Your primary goal would be to ensure that the text...

I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.

I'm looking for an experienced freelancer to tackle data entry. The focus is on text data, which needs to be accurately inputted into a structured database. While attention to detail is important, issues checking for spelling or grammar errors will not form part of the job scope. In line with this, the ideal candidate should: - Have a proven track record with data entry projects - Have expertise in structured databases - Be able to work accurately with text data - Have the ability to complete tasks effectively within the given timeline.

I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and a...

I am looking for a skilled developer who can help me develop a custom Liquid code editor to be integrated into the Braze platform. This editor should support custom liquid code snippets. I first need someone to troubleshooting existing code and determine why the color displayed is blue Key Responsibilities: - Troubleshooting...troubleshooting existing code and determine why the color displayed is blue Key Responsibilities: - Troubleshooting existing and building new Liquid code in Braze Ideal Skills and Experience: - Proficiency in Liquid programming language - Experience in developing custom code editors - Prior experience with Braze platform - Proficiency in Syntax: {% if ... %} ... {% elsif ... %} ... {% else %} ... {% endif %}: This is the syntax for conditional stat...

As someone needing assistance with managing data in an Excel sheet, my ideal freelancer would be highly proficient in Excel and able to work accurately and efficiently. The role includes: - Adding new entries to the Excel sheet including the fields: Name, Email, and Phone number - Updating existing entries with the same data fields - Removing any outdated entries The data should be organized into separate columns for each field for straightforward visibility and access. Besides Excel work, this role involves effective email management related to this data. The ability to multitask while maintaining a sharp eye for detail will be vital for this project. Experience in data management and email handling will be advantageous.

I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .

I'm in need of a talented designer who can create a text-based logo for my business. The design process should consider specific colors that I'll define to align with my existing branding. Above all, the logo needs to emit a sense of professionalism. An ideal candidate for this project would have: - Proven experience with graphic design, particularly in logo creation - Familiarity with color theory and its applications in branding - Ability to transform abstract concepts, like professionalism, into compelling visuals. Your keen eye for design and understanding of the brand identity are critical to this project's success.

Looking for someone to take a text-based news story and turn it into a short form video highlighting the most important parts. The background will be the booking photograph, with snippets from the news story animating throughout the video.

Please Sign Up or Login to see details.

I'm in need of a professional video editor experienced in creating entertainment and creative content. Requirements: - Execute advanced editing techniques with special effects - Prior experience in creating content for entertainment or creative purposes - Fa...content. Requirements: - Execute advanced editing techniques with special effects - Prior experience in creating content for entertainment or creative purposes - Familiarity with the latest trends in video editing - Ability to deliver polished and engaging videos within the deadline The final content will be published on various platforms, so knowledge of optimal video formatting for different platforms is a plus. If you believe you're the right fit for this project, please provide examples of sim...

I need a professional to remove a white text watermark from each photo. The watermark is not consistent in placement and varies across the images. Ideal Skills: - Strong image editing skills, particularly with watermark removal - Familiarity with working on images with randomly placed elements - Attention to detail Experience: - Previous experience removing watermarks from images - Portfolio demonstrating successful watermark removals - Knowledge in image manipulation techniques Please include examples of similar tasks you have successfully completed in the past.

I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.

I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.

I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.

I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex data set...

I currently have a text-only PDF document that I need to be accurately converted into a Word document while preserving the original formatting. This includes any headers, bullets, and other formatting elements present in the original document. The final deliverable should be in Word format. I won't accept any re-converted PDFs or email attachments, only the raw Word document. Ideal candidate will have: - Prior experience with PDF to Word conversions - Attention to detail to maintain document formatting - Ability to deliver work in Word format directly. Please note, any bid that doesn't meet the stated requirements will be rejected outright. Your attention to detail, quality control, and adherence to the project specs are paramount.

I'm looking for a detail-oriented professional to transcribe content from a PDF file to a Word document. The aim is to make the content editable for future needs. Key Requirements: - Transcribe accurately without errors - Preserve original text formatting where possible - Images from the PDFs are not required in the Word files Ideal Candidate: - Has experience and proven skills in data entry and transcription - Is meticulous and detail-oriented - Can deliver the work in a flexible timeframe depending on the project’s volume Please include previous similar projects and references in your proposal.

I have an app develop in xcode. This app contains a webview control but when i click in any amazon link my aplication call de app amazon. I need to avoid this.

...document. The attached word document has many formulas and some are a bit blurry ( I suspect because they are images, not text). That becomes worse when the file is converted to PDF, as it must be for our purposes. The formulas should be in a format that allows me to edit the text within Word. This will involve creating a clean and readable representation of complex mathematical expressions and also testing that they can be converted to pdf in a clear manner. Ideal Skills: - Strong background in algebra and mathematical notation - Proficiency in Microsoft Word and its equation editor - Attention to detail to ensure correct transcription of equations - Familiarity with formatting mathematical expressions in a way that's easy to work with in Word - Ability to...

I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budget as w...

I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the past.

I need an expert formatter to clean up and streamline my PowerPoint presentations. Your work will include accurately aligning text, correctly using headings and subheadings, and ensuring a consistent overall look and feel. Skills and Experience: - Proven experience in document formatting, specifically PowerPoint presentations - Strong attention to detail - Mastery over Microsoft PowerPoint software - Ability to adhere to deadlines will be a major advantage.

I'm looking for a talented video editor who can enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency ...storytelling, even though I've not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, this could be a...

I'm looking for an experienced data scraper who can extract text data from marketing websites for subsequent data analysis.

...writer who specializes in Information Technology resumes. Ideally, you will know the key skills and buzzwords to highlight for this industry, specifically in Singapore. Skills and qualifications: - Proven experience with IT resume writing - Familiarity with the current state of the Singapore job market - Ability to highlight my coding languages skills appropriately - Exceptional language and formatting skills Your task will be to create an engaging, professional resume that effectively sells my expertise in the IT industry and makes me stand out to employers in Singapore. It is not about simply listing my experiences and skills, but presenting them in a way that suits the demands of this fast-paced industry. Your work will be instrumental in securing my next career move. Prior...

...of a skilled Photoshop designer who can add a modern and sleek text overlay to an existing design. The work is straightforward and should be easy for someone with the right skills. Key Requirements: - Add a modern and sleek text overlay to an existing Photoshop layered file. The design should be in a monochrome color scheme, specifically black, white, and grays. Ideal Skills and Experience: - Proficient in Photoshop, with a strong understanding of layered files. - Experience in text overlay design, ideally in a modern and sleek style. - Ability to work with a monochrome color scheme effectively. This project is perfect for someone who enjoys working on design details. The final outcome should seamlessly integrate the text overlay into the existing desi...

I need a Windows-compatible MS Word editor that has robust document formatting tools and advanced editing features. It should be a basic editor, without the need for advanced functionality such as macros and scripting capabilities. Ideal Skills and Experience: - Proficient with MS Word on Windows - Strong understanding of document formatting tools - Skilled in advanced editing features Please provide me a list of your previous projects and an example of your work if possible.

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.

...designs - Proven expertise in Android device optimization - A strong background in designing user interfaces aiming at seamless navigation This project doesn't involve e-commerce functionality or interactive elements, but if you have experience in these areas, it could be beneficial for future collaborations. An ideal candidate will be one who can take these requirements and provide a product that is not just functional, but also offers an excellent user experience in terms of navigability. Scope of the work: - Redesign page to make the cell phone navigation inviting (particularly the "What to expect" section) without impacting the regular computer navigation. - Redesign the Login/Sign-in section to make it more user friendly. - Redesign the titl...

For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets. This analyst should prioritize accuracy, prec...