How to count colored cells in excel using countif jobs

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I am in urgent need of someone skilled in Human Resource Management (HRM) who can offer support in cert 4 HRM assessments specifically for: - Essay writing - Case studies The prospective freelancer will ideally have: - Proven experience in HRM and understand corporate environments, human resources procedures, and policies. - Strong written communication skills in presenting clear and concise essays and case studies. - Exceptional research skills to create comprehensive and detailed case studies. Note that the word count for assignments is yet to be confirmed, but you must be available for quick turnarounds as final deadlines are a few weeks away.

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

Hi The task is to set up a password protected instance of the OWASP WebGoat running in AWS that is internet facing. To be successful the deployment must be: * Entirely automated using CloudFormation and bash scripts. * The landing page must be a public page protected with a username/password authentication block, this should rely upon CloudFront to perform authentication. The username and password should be configurable in the CloudFormation template. The landing page can be simple HTML that displays the username input, password input and login button. * A user friendly domain name should be configured via Route53 that is configurable in CloudFormation. The domain name can be provided if required. Obviously a AWS TLS1.3 PKI certificate is...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data m...

...for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. ...

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for M...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic ...

...talented logo designer to create a classic and elegant logo. I am using a competition so that I can find a talented designer to compelete the logo design. The aim is to have a logo that is not only visually appealing but also timeless and suitable for both online and print applications. I shall work with the best designers to make small changes before selecting the winning design. The winning designer will need to complete the design in web and print formats in pdf (vector), jpeg and ai. before receiving the prize money. Key Responsibilities: - Craft a classic and elegant logo that embodies our brand's essence as per the design brief attached - Ensure the logo is versatile and works well across both online and print medium...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a p...

I need a single form to register two different types of users on my wordpress website. See the attachment. I'm looking to set up a WordPress site that supports dual user registration - customers and instructors. Key Requirements: - The registration form should be able to collect specific information from both user types including name, email address and phone number. - Customers should have the ability to search for instructors and book lessons with them. - Instructors should be able to create, manage and edit their profiles. I'm seeking a skilled developer who can implement these functionalities seamlessly. Experience in WordPress and user registration systems is a must. The ideal candidate should also have a good understanding of da...

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.

Develop macro-enabled Excel file to handle CSV

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF docume...

...written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple...

I need to have the design of a face mask made. It will cover the whole face (refer full face ). The design should look like a funny, cartoonish, smiling red colored car. It should have at least eyes and smile. If I print it and put it on my face, the eyes should be in place of real eyes, the smile should be in place of real smile i.e. the proportions of the final image should match accordingly. The resolution should be at least 2160x3840. Also check other reference images. The mask should be a standard size that fits most people comfortably. Don't give me a random quote, give me a real quote.

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

Specs: Grid Cells select format 1-the color picker: first time open (no previous coclor selected), defaulted luminance to 50%. If previous color selected, default to that color. 2-the selected color needs to be on the button after first selected. 3-a radio button (format button appearance) for each format type: backcolor, forecolor, bold, italic, underline. same like color, needs to select and change the cell. 4-the cell select needs to toggle the format on and off. 5-checkbox to save the format between reload of grid data source. Bid with 1-22-333 in you bid to filter bot

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Categ...

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

I am in need of a competent translator who can accurately translate a set of vaccination cards from Kurdish to English (US). Precision and a strong grasp of relevant terminology in both languages is essential. The total word count of the documents falls in the range of 600 to 1200 words. Key Requirements: - Fluent in English and Kurdish - Proven experience in professional translation - Familiarity with relevant language and terminology - Attention to detail and commitment to quality - Ability to meet deadlines Ideal Candidates: - Kurdish native speakers with a rich translation background - Professionals with experience in personal document translation - Individuals who can demonstrate their expertise ...

I need a professional to change the color of an object in a JPG image. This is an urgent project, so I need someone who can start immediately and has a strong track record for meeting tight deadlines. Key Requirements: - The object to be colored is currently black. It needs to be changed to: 1- Beige. 2- Gray. - I need 2 JPG images. - The strap, the square at the bottom of the object need to maintain it color. - The person should be able to deliver high-quality work.

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

More details: *What specific type of claims do you expect the expert consultant to identify? Delays, Cost overruns, Scope changes *How many projects do you need the expert consultant to review? 4 *Project documents will be supplied. *Reference Contract: FIDIC Red Book *How soon do you need your project completed? ASAP

...on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. If you're a Power BI exper...

I'm in need of a skilled professional to layout my non-fiction book to meet the formatting requirements of Amazon. Here's what I'm looking for: - Layout: I need a professional layout and formatting for a non-fiction book according to Amazon standards. - Elements: The book will have footnotes or endnotes which need to be incorporated into the design. - Word Count: The book is under 50,000 words which should make the task easier and less time-consuming. The ideal freelancer for this project would have: - Experience in book layout and formatting, particularly for non-fiction genres. - Familiarity with Amazon's book formatting standards. - Ability to seamlessly incorporate footnotes or endnotes. - Strong eye for deta...

...stock trading. My goal is to target users who are interested in trading stocks, with the aim of improving: - Video Views - Likes and Shares - Follower Count I'm already quite advanced in my knowledge and experience with trading stocks. Therefore, the primary focus of this project will be to create content that will attract and engage this specific target audience. The ideal candidate for this project should have a deep understanding of the stock market and how to communicate complex trading concepts in a clear and engaging way. Key Responsibilities: - Develop a content strategy that resonates with a stock trading focused audience - Create engaging content that attracts and retains viewers - Monitor performance and adjust s...

...programmer who can create a bot that will be used for automated trading on Binary.com. Key Functionalities: - The bot will be designed to execute trades based on predefined strategies. This means it should be able to analyze market conditions and place trades automatically as per the set strategy. Ideal Skills and Experience: - Proficient in Python: Since Python is my preferred programming language for this bot, you should have demonstrable experience in programming with Python. - Knowledge of Binary Trading: A good understanding of binary trading platforms and how they operate is a considerable plus. - Experience with Automated Trading: Prior experience in developing bots for automated trading is highly preferred. - Familiarity with : Gi...

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently usi...

...looking for a skilled content writer to create engaging and informative blog posts for my health-focused website. The topics will revolve around various health-related subjects, including nutrition, fitness, mental wellness, and preventive care. Each post should be well-researched, original, and tailored to our target audience. Project Details: - Scope: 5 blog posts - Word Count: Each post should be approximately 800-1000 words. - Tone: Conversational, engaging, and informative. - Research: Each post must be well-researched and include credible sources. - SEO: Incorporate relevant keywords naturally for better search engine visibility. - Originality: Content must be original and pass Copyscape. Requirements: Proven experience in content writing, preferabl...

I'm looking for a skilled freelancer to help with setting up a basic WordPress site. Also, I need the sites to be connected to the hosting account and Google Workspace. If you have logo design abilities, that would be preferred. Key Requirements: - **Design Style**: Minimalist preferred. Please keep the design clean, with a focus on simplicity and usability. - **Page Count**: The site will have between 1-5 pages. I'll provide the content and some guidance on the layout. - **Functionality**: I'll need a contact form and a blog section. Additionally, I need a quote page, similar to the contact form. This is a crucial part, as visitors should be able to request quotes easily. Ideal Skills & Experience: - **WordPress Design**: P...

I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround

I am in need of a skilled Machine Learning Developer who can help me build a causal model. I have a specific dataset that I would like to use for building the model. This dataset is of moderate complexity, featuring multiple variables. The primary goal of the model will be to understand the relationships between these variables. Key Responsibilities: - Utilize the provided dataset to develop a causal model - Ensure that the model is capable of effectively illustrating relationships between variables - Optimize the model for performance Ideal Candidate: - Proficient in Machine Learning and Python - Experience with building causal models - must have worked on techniques like robust synthetic control, dowhy, econml, trigamite, DECI and other double ML/c...

Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract

I am looking for someone to specifically increase the number of subscribers on my YouTube channel. I want real subscribers Key Details: - My channel focuses on daily vlogs, so it's important that the growth strategy aligns with this content style. - I currently upload new videos weekly, so the growth strategy should be paced accordingly. Ideal Skills and Experience: - Proven track record of increasing YouTube channel subscriber count. - Understanding of the daily vlogs content genre. - Familiarity with strategies to enhance subscriber engagement. - Experience in growing channels which post content weekly. Please share your experience in growing YouTube channels when applying.

...looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge o...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

I am in need of a Wordpress developer who can design a Wordpress websitefor professionals. The site will need to have a Learndash integration and customization, as well as be built on Elementor for easy management and updates. Key project requirements include: - Creation of a professional and user-friendly website with Elementor - Integration and customization of the Learndash feature - Focus on user registration and login for course access - Ensuring a seamless e-commerce functionality for course purchase. Ideal candidate should have: - Proven experience in developing Wordpress sites with Elementor - Strong understanding and experience with integrating and customizing Learndash - Ability to create a user-friendly and visually appealing interface - Previous ex...

I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accu...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

Money and all it takes to make it in easy steps even a 14 y/o can deal with

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently usi...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and c...

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

I need a logo for my publishing house: RAVENOUS PUBLISHING I want it to include a lion like this in the colors similar with gold font for the name. Make it look like a publisher logo. Will need vectors and PNGs. Rose gold, rose colors, pink, red, magenta, yellow, oranges.

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations.

Please Sign Up or Login to see details.