For loop in excel formula jobs

I need a comprehensive dashboard created from the ra...primarily be centered around different product categories. Understanding which categories are driving sales will be crucial. The visualization of the monthly sales trends should be done using a Bar Chart. You will need to sift through the raw data, extract relevant insights and conclusions that could help improve sales for the upcoming year. Ideal skills for this job include: - Proficiency in data analysis and visualization tools (like Excel, Tableau, etc.) - Experience in creating sales dashboards - Strong understanding of retail sales metrics - Ability to derive actionable business insights from data. Please note, the ultimate goal of this project is to provide insights and conclusions that can...

I need a short Python program that can extract transaction details from my PDF bank statements into both CSV and Excel formats. All my statements are in the same format, so consistency won't be an issue. Ideal Skills: - Proficiency in Python - Experience with PDF data extraction - Knowledge of CSV and Excel programming This project is a great opportunity for a skilled Python developer with experience in data extraction and a keen eye for detail.

At SignsAtelier, we operate in the advertising industry, creating logos, banners, business cards, and other printed materials that best represent our clients’ brands. **Job Description** • Convert client logos into vector illustrations. • Design one or more printed materials such as logos, banners, or business cards. • Ensure your designs are creative and align with our clients’ brand identities. **Qualifications** • Advanced proficiency in at least one vector design program (e.g., Adobe Illustrator, CorelDRAW, or similar). • Specialization in the design of any printed material such as logos, banners, or business cards. • Ability to work remotely with discipline. **Benefits** • No experience in printing or...

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files. Key Tasks: - Importing data from one Excel file - Creating three files using VBA and Macros - Data cleaning - Data merging - Data filtering The data filtering will involve: - Applying numerical ranges - Text matching - Date ranges Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

I need a professional to analyze some data from an Excel file. The project primarily involves numerical analysis with a focus on identifying trends and patterns in sales data. Ideal candidate should: - Have proven experience in data analysis, particularly with Excel. - Be skilled in identifying and summarizing key trends and patterns in numerical data. - Be able to present findings in a clear and concise manner. - Have a good understanding of sales trends.

...existing database is a real estate MLS using a very well established RESTFUL API standard called RESO Web API Core 1.0 (). The reason for using the RETS system to do the initial download is that the number of historical records in some of the data fields has proven to be impractical (tens of millions of records) to download using the API as it is simply too slow. I am open to alternative methods here though. There will be a limited number of transforms (calculated fields) based upon the existing data structure, perhaps 15-20. Ideally, once the database is set up, I'd like to create a system (Excel or custom) to connect to the database and run a series of statistical queries on it. That does not need to be part of the original scope of work, but if the same d...

I'm looking for a professional visual style for an interactive schedule planner in Excel. This project will require some experience with the developer tab. Key Requirements: - The schedule planner should feature automatic updates, conditional formatting, and data validation. - It should have a polished, professional appearance. - User interaction will be primarily through selecting from drop-down lists. Ideal Skills: Provide ideas that will make the spreadsheet user-friendly - Advanced Excel skills including developer tab proficiency. - Excellent understanding of conditional formatting and data validation. - Strong design skills for creating a professional layout. - Experience with creating interactive Excel tools. Please provide e...

...(azure appinsights) that monitors the CPU for a Azure web app in my resource group group. The alert rule will trigger if CPU goes above 90%. Here are the Azure portal alert rule details for automating this via a PowerShell script using the Azure CLI syntax. Here the settings and how they are configured in the Azure Portal. Scope: "webappname-insights" I will replace my web app name in this variable. I will also replace my subscription and resource group in these two variables. Condition: signal name - process CPU Alert logic Threshold - static Aggregation type - Average operator - Greater Than Threshold - 95% When to evaluate check every - 5 minutes Loop back period - 5 minutes Actions: Use action group that already exists. ...

I’m looking for someone to search for products on Amazon and list them in an Excel or Google Sheet. What you’ll do: Search for products in specific categories that I will provide. Record the product title and the link to the product page. Requirements: Basic knowledge of Excel or Google Sheets.

I need a professional to set up an email notification system for my staff, using Excel and Outlook. Key requirements: - The system should send an email to each staff member whenever a cell related to them changes value. - The cells are populated with dropdown list values. - The emails should be simple text, not HTML or pre-designed templates. Ideal skills for this project include: - Advanced Excel skills - Proficiency with Outlook - Experience with setting up automated email systems - Good understanding of drop down lists in Excel This is an opportunity to help me streamline communication with my staff and ensure they are updated in real time.

I require assistance with cleaning up my Excel files. I have three Excel files, and I need duplicates in one specific column of the first file removed from all 2 files. The structure of all files is the same, with identical columns. Ideal skills for this project include: - Proficient with Excel - Attention to detail - Experience with data cleaning Please be prepared to delete identified duplicates from all files. Budget $5

...content or action items. Goals & Objectives Provide a structured template where I can easily add, categorize, and prioritize keywords. Include columns/tabs for capturing key SEO metrics (search volume, CPC, competition/difficulty, intent, etc.). Offer a clear workflow: from brainstorming seed keywords to final content mapping. Maintain consistent formatting that remains stable when exporting to or opening in Excel (if using Google Sheets) and/or in platforms like AppSheet. Make it intuitive and visually organized, with instructions or user notes so anyone on the team can use it easily. Key Features / Requirements Data Collection Tab Columns for keyword metrics (search volume, CPC, keyword difficulty, search intent, etc.). Ability to easily sort/f...

I'm looking for a PHP web application function that can compare two Excel sheets. - The function should highlight the differences between the two sheets. the web app should provide the output excel as coded. Ideal candidates for this project should have: - Strong skills in PHP and web app development. - Experience with Excel sheet manipulation and comparison. - Ability to implement a user-friendly interface that highlights differences clearly.

I need a spreadsheet that calculates the compression capacity of concrete piles. The formulas within the spreadsheet should be able to perform financial calculations, statistical analyses, and data summarizations related to engineering pile capacity. Your expertise in civil engineering and data analysis is crucial.

...specifically tailored for a real estate operator. I've provided four recordings detailing the three deliverables needed: overview deliverable 1 - prospect outcomes tracking deliverable 2 - identify highest CLV attributes deliverable 3 - prospect velocity thru 5 deal stages All three deliverables are of interest to me, but if you can solve 1 or 2 that is fine. I don't have a specific tool or software preference. I'm open to using Excel, data analytics platforms - whatever can solve the job accurately and that you're comfortable with. As for the format of

I'm looking for a detail-oriented professional to help with spreadsheet data entry. The task involves transcribing product information from PDF files into a spreadsheet. Ideal Skills: - Proficiency in using spreadsheets (Excel, Google Sheets) - Attention to detail - Ability to transcribe data accurately from PDF files - Understanding of product inventory management (preferred but not essential)

I'm seeking a diligent data entry expert to assist with transferring information from an online database into MS Excel. Key Requirements: - Proficient in MS Excel; familiarity with data manipulation tools within Excel is a plus. - Attention to detail to ensure accuracy of data entry. - Ability to work independently and manage time efficiently. - Prior experience with data entry from online databases preferred. Please note, the data type is mixed (both numeric and textual), so a good command over both types is essential.

...seeking an Excel expert who can help me with a project needing to build a client pipeline excel sheet which provides the ability to multi select checkboxes from a drop down for certain columns. Also need to have the checkboxes grouped under a heading with indentation/ categorization The project requires the development of advanced macros and VBA scripts. Ideal Skills: - Extensive knowledge of Excel - Proficient in writing complex VBA scripts - Experience in creating advanced macros Key Responsibilities: - Develop an excel sheet with certain columns having the ability to list checkboxes and support multi selection. - this drop down multiselect checkbox list also will be categorized under a few main parent checkbox - upon multi selection...

I'm looking for a comprehensive search for M&A advisory firms across Southeast Asia, specifically in Singapore, Malaysia, Thailand, Indonesia, Philippines, and Vietnam. Key Requirements: - The search should encompass all types of firms: local, international with local offices, and boutique firms. - The information gathered should include, for each firm: - Name of company - Contact details - Services offered - Client portfolio - The final output should be a detailed spreadsheet with all the information. Ideal Skills: - Proficient in internet research - Experience in business analysis - Familiarity with M&A advisory firms is a plus - Proficient in Microsoft Excel or similar spreadsheet software. Looking forwa...

... Ability to leverage social selling using tools such as LinkedIN. A High Energy and extremely organized individual will be most successful in this position. Superior verbal and written communication skills Prospecting, Presentation, Negotiation, and Closing Skills Ability to proactively communicate, engage, and influence proper decision makers Ability to execute sales strategies, think clearly and overcome objections Strong personal accountability with track record for delivering on expectations/commitments with focus, perseverance, and tenacity Requires knowledge of and the ability to use computer software such as MS Office Suite (Word, Excel, PowerPoint, Salesforce, and Outlook)...

I urgently need someone to splice 10 YouTube videos together for me. I have a trade show tomorrow and Sunday, and I need the video on a continuous loop. Key Requirements: - The individual videos are 30 seconds to a minute. - The splicing needs to include smooth transitions between each video. - There should be no text or graphics overlaid on the videos, just the videos themselves. Ideal Skills: - Proficiency in video editing software. - Experience with YouTube video splicing. - Ability to deliver high-quality work under tight deadlines. Please, only apply if you can deliver this ASAP. Thank you!

I need a skilled web scraper who can extract data from a members area of a website. The data should be compiled and delivered in an Excel file. Website Scraping of Members Area Ideal Skills: - Web scraping expertise - Proficiency in Excel - Attention to detail

I need an expert in Excel to help me with an Index Match formula. It's intended to locate numeric data from a single table based on 2 criteria. Key Requirements: - Proficiency in Excel, particularly with Index Match formulas - Experience working with numeric data - Ability to match data based on multiple criteria If you have the requisite skills and experience, I would greatly appreciate your assistance.

Hi. I would like to scrape oddsportal for game results,closing and opening all odds import them into excel. I am interested in soccer matches. The scraper should be able to scrape data according to date i.e. I would like to input a date range and sport (soccer) and get the match details for those matches. Further details will be discussed with bidder. I should also mention that date range for scrapping data could be quite long (i.e. months) so the output xls could be quite big. It is very important to me that scraping is done as quickly as possible (seconds) with as less clicks as possible and without hanging-up or crippling my PC while scraping. PROJECT DETAILS: Sport:----------------------Football Bookmaker:------------------Bet365, BWIN, Pame Sto...

I'm looking for an expert in AI tools to scrape a website for me. The goal is to extract specific contact information and organise it neatly in an Excel sheet. Data to be Scraped: - Email addresses - Phone numbers - Names - Zip Codes The ideal candidate should have prior experience in web scraping and data management. Proficiency in using AI tools for this task is crucial. Data Formatting: - I need the data to be sorted into separate sheets for each type of information. Please provide examples of previous similar tasks you have completed successfully.

I'm looking for a freelancer who can create an Excel spreadsheet containing names and verified email addresses of businesses located in specified postcodes in Sydney, Australia. The project entails: - Collecting data on approximately 1500-2000 businesses - Including business names and email addresses in the spreadsheet - Ensuring that all email addresses are verified The ideal freelancer for this project should have experience in data collection and spreadsheet creation, with a keen attention to detail. Prior experience in sourcing business data will be an added advantage. Please note that the types of businesses and additional data points (like physical address, phone number, or website URL) are yet to be determined. The prima...

I'm looking for a skilled Excel expert to create a comprehensive Excel sheet for managing our swag items. The sheet should include the following columns: - Brand - Category - Campus - Item - Cost per item - Quantity - Item link - Dropbox link to the design The sheet will primarily be used for order planning and will need to be updated weekly. It should contain calculations for the total cost and a summary of quantities. Pricing details for various items are provided, and the Excel sheet should accurately reflect these costs. Ideal Skills: - Proficiency in Excel - Experience with inventory management - Ability to create complex formulas Key Features: - Order planning focus - Weekly updates - Total cost calcula...

I'm looking for a skilled designer to vector and animate a logo for me. This will be a simple loop animation, intended for branding purposes. The style of the vector image should be detailed rather than minimalist or cartoonish. Key requirements: - Proficiency in vector design - Experience with creating detailed graphics - Ability to create simple loop animations - Strong understanding of branding and logo design Please get in touch so I can provide more details.

I need a proficient Excel professional to assist me with some office work. My data is currently organized in a single spreadsheet with multiple tabs. The tasks I need help with involve: - Formula creation and calculations - Data analysis and reporting - Organizing my data according to specific requirements It's worth noting that I have a combination of prepared data and data that needs to be gathered. The ideal freelancer for this project should be well-versed in Excel, with a strong understanding of data organization, formula creation, and data analysis. Good communication skills are essential, as well as the ability to follow specific instructions for data arrangement.

...financial expert to create an Excel spreadsheet that projects the financial trajectory of an investment portfolio as it transitions from an operating company to three holding companies. These holding companies will serve the purpose of funding life insurance premiums. Key components of the project include: - Annual funding of a life insurance policy from the investment portfolio, coupled with a life insurance premium loan each year. This should detail the interest rate, annual deductions, and the net cost of the loan. - Retirement amounts for each of the three holding companies, sourced from both the insurance and investments, from ages 71 to 90. - Demonstrating the accumulated growth of the portfolio, with $3.9M in each holding company, and life insurance death be...

I need a HIGHLY skilled professional to calculate existing numerical entries and add formulas for additional numerical entries to automatically calculate. Currently doc is in Word, but not opposed to Excel if it is faster and easier. Doc also needs page numbering (no page number on first page). Will need a grand total at end of doc. Deadline is Saturday, 01/25/25 or Sunday, 01/26/25. Key Requirements: - Add formulas to calculate the sum and averages of current and future entries. - Ensure calculations update automatically when new entries are added. Ideal Skills: - Proficiency in Microsoft Word and Excel. - Experience in creating automated calculations in documents. - Ability to translate numerical data into meaningful insights. Your exp...

I'm seeking help with web research and data entry in Excel, specifically focused on finding contact details for dentists in Kuala Lumpur. Key responsibilities: - Conduct web research to find business contact details of dentists in Kuala Lumpur - Email out scope to professional dentists in Kuala Lumpur - Data entry results into an Excel spreadsheet Important skills and experience: - Proficiency in Excel - Strong web research skills - Previous experience with data collection preferred I am particularly interested in collecting the following contact details: - Email addresses - Phone numbers - Physical addresses Deliverables: - An Excel spreadsheet with the collected data Please note: I am looking for...

I need a comprehensive Excel sheet designed for cabinet selection geared towards order processing. The Excel sheet should have dropdown menus facilitating the selection of different categories, automated calculations for cost and dimensions, and conditional formatting to visually represent data variations or thresholds. Key Features: - Dropdown menus for selecting material types, color options and various construction components (like doors, drawer fronts, hardware etc.) - Automated calculations to keep track of totals, dimensions, and other necessary metrics - Conditional formatting to help easily identify key data points or anomalies I will provide you with a detailed list of all the necessary construction options, which will encompass standard...

Please Sign Up or Login to see details.

I need help with an Excel form that involves mathematical calculations, specifically sum and averages. The calculations need to consider certain specific conditions or criteria. Ideal Skills: - Proficient in Excel, particularly in creating and troubleshooting formulas. - Strong understanding of mathematical calculations. - Experience with conditional calculations, such as IF statements. Please provide your experience with similar projects in your bid.

I'm looking for a skilled Excel VBA expert to create a macro that converts data from my Excel file into PDFs and sends them to multiple email addresses. The Excel sheet has several tabs, each corresponding to a different group of recipients. Key requirements: - The macro should be able to handle 4 or more separate groups of recipients, as per the different tabs in the Excel file. - Email addresses are provided in a comma-separated list format. - Each tab contains sales reports that need to be converted into PDFs. Ideal candidates should have: - Extensive experience with Excel VBA and macro programming. - Previous work with automating PDF conversion and email sending from Excel. - A strong understanding of handling and so...

I'm looking for a skilled Visual Basic programmer to assist in automating my reporting process through Excel. Key Responsibilities: - Utilize Visual Basic to streamline the reporting process - Source data exclusively from Excel spreadsheets - Generate detailed reports Ideal Candidate: - Proficient in Visual Basic and Excel - Experienced in creating and automating detailed reports - Capable of understanding and executing complex data manipulation tasks.

I'm seeking an experienced Excel specialist to create a software-based Gantt chart for me. This chart should incorporate task dependencies, progress tracking, and resource allocation capabilities. Key Requirements: - Proficiency in Excel with a strong understanding of its advanced features. - Experience in creating interactive, software-based Gantt charts within Excel. - Ability to incorporate task dependencies, progress tracking, and resource allocation into the Gantt chart. Ideal Skills: - Advanced Excel skills - Project management software experience - Strong attention to detail - Excellent communication skills

I need an Excel sheet that encompasses tracking for staff attendance, leave, and performance. Key Requirements: - Attendance Tracker: Should facilitate daily attendance logging. - Leave Tracker: Must include leave balance tracking. - Performance Tracker: Primarily focused on monitoring task completion rates. Ideal Skills: - Proficient in Microsoft Excel. - Experience in creating tracking systems in Excel. - Understanding of HR metrics and performance tracking. The freelancer should be capable of producing a comprehensive yet easy-to-use Excel sheet tailored to these requirements.

I'm seeking a professional who can integrate Power App with Power BI primarily for automation purposes. This integration should streamline data entry, facilitate report generation, and improve workflow management. Key requirements: - Proficiency in Power App and Power BI - Experience in automating data entry, report generation, and workflow management - Ability to work with Excel spreadsheets as the primary data source Please provide examples of similar projects you've completed.

I'm looking for a skilled freelancer to create Excel templates and dashboards using data from our IT Service Now ticketing system. The dashboards should track multiple metrics, allowing us to gain insights into our ticketing process. Ideal Skills: - Proficient in Microsoft Excel - Experience with data visualization - Familiarity with IT Service Now Key Requirements: - Create Excel templates and dashboards - Use IT Service Now ticketing data - Track multiple metrics Preferred Visualizations: - Bar charts - Pie charts - Line graphs

I'm looking for a spreadsheet that can track my sales performance metrics and is visually appealing for a female. The spreadsheet should have a pleasant color scheme and theme, as well as incorporate various graphs and charts to display the data. Key Requirements: - The spreadsheet should be easy to use and intuitive. I will be manually inputting data, so it should be simple to plug information in and see the results. - A strong understanding of Excel or Google Sheets is essential. - Experience in creating visually appealing spreadsheets is highly desired. - Familiarity with sales tracking metrics is a plus. Please provide examples of similar projects you have completed in the past.

I'm looking for a personal assistant to help me manage my day-to-day tasks as a small business owner. While familiarity with my industry is not a strict requirement, a basic understanding would be beneficial. daily routine - ask everyone on which project-task they spend their time, update budget for project and timesheet (for hourly engineers) weekly routine - check timesheets for hourly project, and invoices - check progress for fixed-price engineers, update project budget and schedule, report update in a minute of meeting - Review the internal project folders and check if they are aligned with quality standards (the order is in the right subfolder, requirements, technical documentation) - update this list of routine and on-deman...

I have 52 A3 Excel pages filled with handwritten data that need to be typed up into an organized Excel document. This is an urgent task that needs to be completed by tomorrow morning. Requirements: - Typing up handwritten data into Excel - No additional data processing or analysis required, just typing Ideal Skills: - Proficient in Excel - Fast and accurate typing skills - Excellent attention to detail

I'm seeking a professional Excel expert to build a comprehensive costing job sheet for me. The job sheet should encompass all aspects of our project costs including materials, labor, and overhead. A briefing will be required and shown what is required Key Requirements: - Inclusion of materials, labor, and overhead costs - Development of automated calculations for cost totaling and profit margin assessments - Skillful presentation of the data in a clear, user-friendly layout Ideal Skills: - Advanced Excel proficiency - Experience with job costing sheets - Ability to create automated calculations within Excel The ability to understand and reflect our costing needs in the job sheet is essential. Please ensure that all aspects of our p...

I am a project manager handling diverse projects and need a professional Excel dashboard to track and manage my work efficiently. The dashboard should provide a clear, user-friendly interface and visual insights to monitor progress, timelines, budgets, and key metrics for the following: CSR Fund Tracking: Monitor inflows, outflows, and utilization of CSR funds across multiple initiatives. International University Collaboration: Track milestones, agreements, events, and communications with international universities. Hub and Spoke Model: Manage operations, performance, and data flow in this healthcare delivery model. Share4Care Online Fundraising: Track donor statistics, funds raised, and campaign performance. Ayurveda Marketing: Monitor marketing initiatives targeting...

I am seeking an Excel Macros expert to assist in managing investor statements for my business. I have about 100 rows of data in Excel and need the following tasks performed: - Create approximately 100 personalized PDFs based on the data - Save each PDF - Email each PDF to the corresponding unique email address Additionally, I will provide a specific template that the PDFs need to adhere to. Each email should also contain a personalized message tailored for the recipient. Ideal Skills: - Proficiency in Excel Macros (intermediate level or higher) - Experience with PDF creation and formatting - Email automation skills - Ability to follow specific templates and formatting - Excellent attention to detail to ensure each PDF and email i...

...need an expert in Python and visualisation. YOU MUST HAVE EVIDENCE YOU CAN DO THE JOB OR DONT APPLY AS YOU WILL BE IMMEDIATELY REJECTED. Please supply proof with your submission. DONT SUBMIT WITHOUT EVIDENCE OF EXPERIENCE IN THIS SPECIFIC REQUIREMENT I DO NOT CARE ABOUT ANY OTHER QUALIFICATION YOU HAVE LETS NOT WASTE EACH OTHER TIME EH! I need someone to take data turn it in to a dashboard. I need the data to be segregated by user account so one user cannot see another users details. Background We have 50 different locations. Some locations are owned by more than client so lets say we have 40 clients We have reports for each location which need to see individually We need to see rolled up accounts per client We need all client reports rolled up i...

I need assistance with entering data into an Excel sheet. The data consists solely of text extracted from printed documents. Your task will be to analyze these documents and summarize the information before inputting it into the Excel sheet. Ideal Skills: - Proficiency in Excel - Excellent reading comprehension - Strong summarization skills - Attention to detail - Experience with data entry

I need an InDesign specialist to convert my Excel data into a printable and fillable form. This task includes making certain elements from the Excel sheet functional in InDesign, specifically: - Creating a printable form in InDesign. - Incorporating text fields as interactive elements in the PDF. - Ensuring that all relevant Excel formulas are functional in the InDesign form. Ideal freelancers for this project are those with extensive experience in Adobe InDesign and Microsoft Excel. Understanding how to create forms in InDesign and make them interactive is crucial. Please provide examples of similar projects you have completed in your bid.