Excel collection macro jobs

I need an expert to masterfully apply and tweak formulas and functions across entire rows and columns within my Excel spreadsheet. Your tasks will be to: - Implement formulas and functions - Apply them to entire rows and columns Ideal skills and qualifications for this job would include advanced proficiency in Excel, especially in applying lookups and mathematical functions like SUM, AVERAGE, COUNT. Proven experience with similar projects is highly preferred.

I am in need of a dynamic Excel tool to perform data analysis tasks. The tool must be designed using autofill drop down list, and it will be utilised for: - Employee name selection - The drop down list should offer an autofill option for employee names. - Tallying Totals - The drop-down list selections should be capable of tallying totals. For this project, the ideal freelancer will have strong experience with Excel, particularly with creating and managing drop down lists. Experience with data analysis in Excel will be beneficial. Your task will be to create an easy to use, and automated system that can manage complex quantitative data.

I'm seeking an expert in data collection to gather email addresses from a list of retail shop websites I have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A spreadsheet in either .xlsx or .csv format with the email contact for each retail shop. Desired Skills: - Data Collection - Data Entry - Attention to detail - Proficiency in Excel or similar spreadsheet software - Familiarity with web research.

I need a skilled and detail-oriented professional web scraper. Your task will be gathering data from specific sources - LinkedIn, Google Your focus will be on gleaning real estate information, precisely property listings. Ideal Skills & Experience: • Profound web scraping and data collection capabilities • Familiarity with LinkedIn, Google • Knowledge or prior experience with real estate industry is a plus • Fast learner, able to adjust methodologies as needed for optimal data extraction This is a great opportunity for someone with a keen eye for detail and a passion for data-driven decision-making. Your work will directly inform our strategy and operations.

Looking for a skilled developer who can automate the process of extracting text content from RTF code and organizing it in a categorized structure in an excel spreadsheet. On github, I see someone has tried to some success. The file is located: To begin with I am interested in the English file Years Foundation to Year 10. English MRAC/2023/07/LA/ENG HTML RDF/XML JSON LD SPARQL You goal is to extract the hierarchy and structure as a usable document to teachers. Learning Area (English) --> Year Level --> Aspect of the Achievement Standard (A sentence) : it may then have General Capabilities

I am seeking a proficient Excel expert to enhance macros within an existing spreadsheet. My primary concern involves re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will b...

I need a data expert who can perform inferential analysis on a dataset that is less than 1000 rows and columns. This task requires absolute proficiency in Excel, including functions and formulas associated with inferential statistics. Your ability to draw meaningful insights from raw data is essential. Skills Required: - Excel proficiency - Familiarity with inferential analysis - Ability to handle small to medium-sized datasets Experience preferred: - Previous experience in Excel-based inferential data analysis - Proven track record of data interpretation and insights extraction

I'm in need of a skilled developer with expertise in AppSheet, Excel, and ERP systems. Your task will be multifaceted, involving various aspects such as: - Data analysis and visualization - Spreadsheet automation - Developing an AppSheet app designed for ERP, focusing on billing, data collection, and data management The main functionalities I am looking for are: - Ability to generate and track invoices - Data entry and validation capabilities - Incorporation of Google Maps API - Budgeting features - Ability to export data to Excel A strong understanding of ERP systems, proficiency in AppSheet, and advanced Excel skills are essential to this role. Experience with Google Maps API is a significant advantage. You should be able to understand the essenc...

I am in need of an advanced Excel spreadsheet that will help track and output several key performance indicators (KPIs) on a monthly basis. The KPI dashboard should integrate the following parameters: - Sales pipeline - Revenue - Over $2,000,000 Per month - Overheads Average 3.75% of revenue for month - Gross profit 12 % - Projects on time >90 % - Defects closed <20 working days - Customer Satisfaction - Employee Productivity - Health and Safety The desired freelancer should have: - Proficient skills in Excel including pivot tables, charts, and formulas - Experience in creating KPI dashboards - Strong understanding of business metrics Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of interpretation of the...

I'm seeking a professional who is capable of carrying out a focused market research on yogurt products in less than 10 supermarkets in Costa Rica. The research should center around the price, size and lid diameter of each yogurt product photographed. Ideal candidate for this job would have: - Proven experience in market research and data collection - Be based in Costa Rica, or have a good understanding of the local supermarkets - Strong analytical and reporting skills - Good photography skills, as clear images of the yogurt products are crucial to the project.

I'm seeking a skilled freelancer to scrape specific product data from Amazon. This project involves extracting product names, prices, descriptions, images, and categories. It's important for this project that you have: - Proficiency in data scraping with a focus on e-commerce sites - Understanding of structured ...and categories. It's important for this project that you have: - Proficiency in data scraping with a focus on e-commerce sites - Understanding of structured data and ability to deliver in a usable format - Demonstrated experience with Amazon product data A critical part of this task involves filtering the extracted data to ensure only items from specific categories are included in the final collection. Your proposal should highlight your ability to fulf...

I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.

We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!

...Botox for Bruxism - 360 usd Foxy Eyes - 550 usd Dark circles - 350 usd Cheekbones - 350 Rhinomodeling - 450 usd Bichectomy - 550 usd Lips - 450 usd Mandibular marking - 850 usd Lipo dewlap 400 usd Depigmenting vitamins - 200 usd X Hyaluronidase: 250 usd to remove previous fillers PAGE 5 Transport services Car rental: Lexus Sedan 70 usd per day Porsche Macan s 400 usd per day Shelby Cobra collection 900 usd per day Land rover discovery 330 usd per day Chevrolet silverado pickup 200 usd per day Ford mustang 500 usd per day Ask directly about Ferrari/Lamborghini A security deposit of 1000 usd is taken Suv driver 200 usd per day Van driver 350 per day Hummer limousine - 400 usd every 3 hours Transfer to Ski Centers 160 usd per day Helicopter to Ski Centers 365 usd per person Ot...

Hello, im looking for a java microservices expert, the idea is to create an API that provides "real time" information. for this proj...Milestone (I have to review ur gitrepository, github or bitbucket don't care where it will be): 1: in 1 or 2 days > Skeleton, controllers, dbrepository, dockerfile 25€ 2: in 4 or 5 days > DEMO, I will review ur progress, and I will deploy ur current progression in my hosting, you can just develop 1 of the external apis, but full functionality, if I miss some funct will tell you to fix it. postman collection will be appreciated 100€ 3: in 10 days > project finished. 200€ Honestly I don't care about deadline it may be more than 10 days (not more than 15d), but the functionallity must be all done. front end ...

I'm seeking a talented photo editor with a keen eye for naturalistic editing. This task primarily involves enhancing and optimizing a collection of photos for social media usage. It will require an understanding of current aesthetic trends on social platforms and the ability to maintain the original essence of the photos. Skills and Experience: - Advanced photo editing techniques. - Familiarity with naturalistic editing style. - Experience with social media-focused projects. - Ability to adhere to brand guidelines. - Good sense of color and composition. - Time management skills to meet deadlines. The result should be a captivating collection of photos that not only offer visual delight but also drive interaction on my social media profiles.

I am in need of an Excel specialist who can handle a large dataset of over 51,000 records. The data centers around employee contributions to political candidates. Specifically, I require detailed analysis on: - Contribution patterns - Candidate preferences - Employee demographics As an Excel expert, you should be proficient in working with pivot tables and be able to identify trends within large sets of data. Your experience managing, analyzing, and interpreting datasets should be well demonstrated. In addition, there is a particular interest in providing a thorough analysis of contributions based on political parties. This will help to understand better the political leanings within the dataset. To apply, please highlight your relevant experience. I look forward to seein...

I urgently need proficient help with excel. The tasks to handle include but not limited to; - Data entry. - Data analysis using relevant tools. - Leverage advanced excel formulas and functions to streamline data processing. The data to handle resides within 1-5 sheets and contains both numeric and categorical data. Ideal skills for the job include; - Advanced proficiency in Excel. - Deep knowledge of data analysis methodologies. - Quick data entry skills. - Understanding of Excel functions and formulas. Experience in processing both numeric and categorical data on Excel is crucial.

I'm seeking a detail-oriented freelancer with strong skills in text data entry, Excel, and who is comfortable working with less than 500 pages of data. Key Requirements: - Proficiency in text data entry - Strong familiarity with Excel - Able to handle less than 500 pages of data The ideal freelancer should efficiently turn raw data into an organized Excel spreadsheet. Accuracy is vital in this job, as any mistake could lead to incorrect data analysis. Please provide evidence of your past experience in text data entry and working with Excel.

I'm on the lookout for an experienced customer care executive who can assist me in delivering a vital part of our feedback collection initiative. We need to gain and record video testimonials from our clients. Key Responsibilities: - Conduct phone interviews with our clients. - Cooperatively shape fitting questions for these interviews. - Record client feedback as a video testimony. Skills Required: - Experience in conducting phone interviews. - Ability to structure questions for practical feedback. - Experience in recording testimonials, including handling technical aspects and ensuring high video quality. - Efficient communication skills to foster a comfortable environment, encouraging open and genuine customer testimonials. So, if you are proficient with capturing impact...

I am in need of a graphic designer who can breathe new life into my accessory collection presentation. With all information and illustrations readily available in a Canva PowerPoint, your creative touch can transform it into a digital fashion portfolio that accurately represents my brand. While I don't have a concrete format in mind, I trust you'll innovate and bring suggestions on how to achieve the colorful and creative aesthetic that I desire. My only requirements are: - Excellent graphic design skills with a proven portfolio - Strong understanding of color harmony, aesthetics, and patterning - Proficiency in digital design tools like Adobe Suite - Strong attention to detail - Creativity and openness to provide suggestions No specific elements were requested on my e...

I'm looking for a freelancer with solid sk...date and time, and receive email confirmations. Key Website Features: - Booking Functionality: The site should allow for booking appointments with the ability to choose a suitable date and time. - Email Confirmation: After booking, users should receive confirmation via email. Payment System: - The website should also integrate a simple but secure credit card processing system for payment collection. Ideal Candidate: - Expert in modern web design principles - Experience in implementing booking systems - Strong knowledge of email integration for appointment confirmations - Proficient in secure credit card payment processing Please bid if your skills align with my project needs. I look forward to a functional, trendy, and user-fr...

...exercise materials for Excel, with a particular focus on Excel Macros, Array formulae, forecasting, countif, if statements, and all LOOKUPs. All exercises should come from dataset or data files KEY REQUIREMENTS: - The labs should cover 10 advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros and VBA programming - Proven experience in developing training materials or lab exercises. - Familiarity with financial modeli...

I'm in need of an expertly designed Excel spreadsheet that will serve as a dynamic sales reporting template. This tool will play a significant role in tracking and analyzing data related to various aspects of sales. The successful candidate in this role will incorporate tracking capabilities for variables such as: - Product sales - Revenue by customer - Customer % of revenue Furthermore, the spreadsheet should provide robust reporting on seasonality, current month vs prior year, and fiscal year to date (FYTD) vs the prior year. This comparative analysis is crucial in understanding trends and informing strategic decision making. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating dynamic reporting tools - Understanding of sales data analysis - ...

This project entails creating a Power BI report that is linked to Excel spreadsheets for trend analysis purposes. The main user of this report will be the sales team. I'm seeking a professional with: - Expertise in Power BI and trend analysis - Proficiency in handling and linking Excel spreadsheets to Power BI - Familiarity with sales data and crafting useful reports for sales teams. Your primary objective will be to create a functional, insightful Power BI report, providing our sales team with meaningful trend analysis based on our historical data stored in Excel spreadsheets.

For Excel sheet data typing, you'd be looking for someone proficient in data entry and manipulation, preferably with experience in Excel. Here are the ideal skills and experience: Proficiency in Microsoft Excel Accurate and fast typing skills Attention to detail to ensure accurate data entry Familiarity with common data manipulation tasks in Excel such as formatting, sorting, and filtering Ability to handle large amounts of data efficiently Knowledge of basic formulas and functions in Excel for data analysis and manipulation Experience in working with different types of data formats and structures Strong organizational skills to manage and organize data effectively Ability to troubleshoot and resolve data entry issues Understanding of data privacy a...

Need to upgrade my existing excel macro, very simple project

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

Unify TXT files into Excel. (This data is good) This is a data merge project. Merge data from 3 txt files into excel. This is NOT a simply copy paste. The data needs merged. The data from 2 of the files will become columns of data in the 'master file' (see below) Download 2 files from here: Download 1 file from here: Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

...need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid understanding of finance principles is necessary. Experience with develo...

Hi Anubhab M., due to your great work, I want to hire you to do a national search and data collection on Duck Duck Go search engine.

Hi Anubhab M., due to your great work, I want to hire you to do a national search and data collection on Bing.

I'm facing an issue with my Google Firebase Cloud Function, written in Node.JS. While trying to query a Firebase document collection via document reference from another collection, the function is producing incorrect results. I need this function to execute successfully and return the matching documents. The snag seems to originate while querying the document collection with following kind of scenario: fetch all blogs of an author. So we are running a query in blog document with document reference of AuthorId Skills necessary for this project include: - Proficiency in Google Firebase - Strong understanding of Node.JS - Experience in debugging and fixing code - Proficient in querying document collections I look forward to collaborating with a developer experien...

I am currently seeking a resourceful and proficient web scraping expert capable of working under unclear directives. The specific scope of this project is undetermined at this point. The exact data to be scraped, its purpose and the websites to be targeted were not specified. Your responsibilities: * Ability to extract various data types like i...various data types like images, text, and tables from various websites. * Determining the purpose of the data and how it's to be used for optimal results. Skills and qualifications: * Strong knowledge of web scraping tools and principles. * Excellent problem-solving skills and ability to work with ambiguity. * Excellent communication to clarify project parameters as needed. * Experience in data collection, competitor analysis and pr...

...proficient with Blazor C#. Our project currently has few runtime error that needs a fix. Specifics about when and where this error occurs will be provided after we've started. There are only two pages that needs your fixing. 1. location page Show Message that data has been edited, saved or delete. When user clicks on specific item data to be loaded in textbox Search is not working Export data to excel with formatting 2. Login page Issue with adding new user (password not getting captured) Add roles and claims (department) When user click on user form the table it should Edit user details including email address Only admin user to have right to Add/edit this page. Other user can only view the details. Search is not working. When new user is create a Confirmation email shou...

I urgently require an adept designer with proficiency in graphic design, logo creation, and branding. Mastery in Adobe Illustrator will be beneficial to the successful completion of the project. Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organizat...Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organization. * Incorporate engaging animation effects. * Execute graphic design tasks including logo design and branding. Candidates with keen attention to detail, a commitment to meeting tight deadlines, and a background in corporate or formal PowerPoint presentation design will excel in this role. Immediate ability to start on the project is a ...

I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term collaboration.

This job requires programming experience to create and design an app based on the attached PowerPoint where I have detailed each page of the app. The data needed for the app will be supplied in an Excel file. The bid is to create the app for both iPhone and Android. App programming and graphic design experience is mandatory for this project and will require more than a basic knowledge of app creation. The rough project should be completed in 1-2 months. Please review the PowerPoint as it has very detailed information and don't hesitate to ask any questions.

macro based excel project with auto copy data and paste in chrome through selinium

Please Sign Up or Login to see details.

Your report/dashboard should answer the following questions posed by the sales director of the client: 1. What is the total number of orders catered by the firm? There should be a date filter in the dashboard. 2. What is the revenue earned by the firm? 3. What is the total discounted value (base price - check out price) * number of orders? 4. What is the overall discount %? 5. What are the top 5 selling categories? 6. Does the operational area of the store influence number of orders? 7. Are emails & product features on the homepage an effective mode of promotion? 8. What will be the next 5 weeks forecasted weekly quantity sold for each center, city, and meal category (you may use a simple trend-based forecasting method)? You need to submit your PBIX file work as a zip.

I'm in need of a proficient Data Entry operator who can efficiently handle tasks like data entry, content management, and file organization on a daily basis. The job requires some familiarity with basic Web and Network technologies like Wordpress, Godaddy, etc . General understanding of website operation are needed. Wo...handle tasks like data entry, content management, and file organization on a daily basis. The job requires some familiarity with basic Web and Network technologies like Wordpress, Godaddy, etc . General understanding of website operation are needed. Workloads will vary, as the work requirements are not on a fixed schedule or volume. Proficiency with data related software is highly advantageous. Excel knowledge is must. If worked on Tools like Zoho etc, it wil...

I need a thorough data collection process to collect Ceramic & Porcelain Tiles Importers within Vietnam. This project requires: - Collection of contact information and company details. - The data needs to be organized in an Excel spreadsheet. - Include data for all importers, regardless of volume or frequency of importing. Ideal skills and experience for the job: - Strong data scraping and crawling capabilities. - Proven experience with swift and accurate data entry. - Proficiency in Excel.

I'm in need of a Python programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requir...programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requirements: - Extensive experience in Python and specifically Python libraries for web scraping. - Should deliver the extracted text content in an Excel file. Ideal Skills: - Experience in PDF scraping, especially text-based. - Strong Python programming skills. - Excel file formatting. This will involve working with mostly text-based PDFs and programming a Python script to scrape the text content, and subsequently placing that data into an Excel file. Experience with similar projects will be highly advantageous. The ability...

Is a task require basic Excel skills with four tasks in total need it in 5-6 hours

I require a qualified specialist to generate sales leads for my green fertiliser project targeted at farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website codi...farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website coding in PHP - Creating engaging and informative web content and blogs - Using LinkedIn Sales Navigator for lead generation Your understanding of the farming world will be a great asset for this project. Delivery of the sales leads should be through an Excel spreadsheet, Emails, and my CRM platform. Past experience in a similar role, particularly within the agricultural industry, will be highly...

I'm looking for a comprehensive study on international homicide cases. This requires deep investigation, data collection, and analytical skills, as both a detailed report and data set will be the final deliverables. - Experts in criminal law, criminology or forensic science are ideal. - A background in statistical analysis is a plus due to the data set requirement. - Strong research, analytical, and writing skills are necessary. - Lastly, an understanding of international laws and homicide cases is crucial. Your bid should demonstrate your experience and expertise in these areas.

I am looking for a developer to create a multilingual WhatsApp chatbot. The chatbot must be built on Twilio, and should be capable of answering user queries promptly and effectively in both Arabic and English. Skills and experience needed for this project: - Proficiency in chatbot development, specifically on the Twilio platform - Experience in designing chatbots that excel in query resolution - Strong command of both Arabic and English in a development context Please make sure to highlight any similar projects you've completed in your proposal, with specific details on chatbot functionality and multilingual support.

Completion of Ecovadis Questionaire. *ISO Documents Documents to be submitted *Environ...regarding Labour & Human Rights *Ethics - Corruption - Responsible Information Management - Reporting Procedures Templates for the below can be made available and adjusted to suit: * Integrated Management System for Transport and Warehousing Aligns with International Standards AS/NZS ISO 45001, 14001, 9001. Microsoft Word Format (fully editable). Document Control. Comprehensive collection of Checklists, Forms & Registers. Customising Instructions. * HR Package Contents: Comprehensive HR Manual (containing all our HR Policies) Employee Handbook Employee Agreement We could look at various other Business Ethics & Conduct Policies & Procedures also...