Data web excel macro jobs
I have a project that requires meticulous input of numerical data into Excel. The task will involve not only data entry but also ensuring that the data is validated and formatted according to specific guidelines. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience in data entry and validation Key Requirements: - Input of numerical data - Use of Excel for data input - Ensuring data validation - Following specific formatting guidelines in Excel
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.
I need a solution for transferring text from Word to Excel and vice versa. The templates I work with change frequently, so I require a fully automated system to handle the conversions. Ideal Skills: - Proficient in Microsoft Word and Excel - Experienced in creating automated systems - Able to handle frequent template changes Your task will be to create a system that can seamlessly manage this process, freeing up my time for other tasks.
I'm looking for an Excel expert who can help me with applying logical functions (IF, AND, OR, etc.) primarily for data validation across multiple ranges. Key tasks: - Assisting in the use of logical functions for data validation - Implementing these across multiple ranges Ideal skills and experience: - Proficient in Excel, particularly in logical functions - Experience with data validation in Excel - Able to apply skills across multiple ranges
I'm seeking assistance with my Power Automate system. Currently, I am performing data entry from a single sheet Excel file into a web platform, specifically filling in text fields. I've encountered some hurdles while trying to automate this process. Ideal skills and experience for this job include: - Proficiency in Power Automate - Experience in automating web data entry - Familiarity with Excel, particularly with single sheet data organization Your expertise could save me a lot of time and frustration. Looking forward to your bids.
I'm seeking an expert in Excel to create a comprehensive dashboard that focuses on project management. The primary use of this dashboard is to monitor resource allocation, specifically equipment, for various tasks within a project. Ideal Skills and Experience: - Proficient in advanced Excel functions and features - Experience in project management - Understanding of resource allocation and tracking - Ability to create user-friendly and visually appealing dashboards
I'm looking for a professional to improve the user interface of an Excel-based governance document. This document is used to track initiatives and actions from a strategic plan. Key Focus Areas: - Navigation and layout: The document needs to be more intuitive and user-friendly. - Form input and validation: Streamlining the process of data entry and ensuring accuracy is crucial. - Color scheme and styling: Aesthetic improvements are needed to make the document visually appealing. No specific design guidelines are in place, so creativity and adherence to general best practices will be appreciated. Ideal candidates should have a strong background in UI design, particularly in Excel, and be able to deliver a document that balances functionality with an enhanced user...
I'm in need of a custom Excel worksheet for tracking business card orders. The worksheet has specific requirements and needs to be completed today. Please see the details below. - The worksheet needs to be separated by name, title, address, phone, fax, cell and email address, and quantity. - The first sheet should be named 'AIM', the second 'CC', the third 'TT', and the fourth 'ACT'. - I will provide the names, but you need to format the Excel sheet according to these specifications. - The quantities for each type of business card should be recorded in separate columns. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to work under tight deadlines.
I'm seeking a professional to scrape my WordPress website for 1100 entries related to our different offices. The data needs to be exported into an Excel file, without any specific filters or sorting. In addition to data scraping, I need a thorough code review of my WordPress site. This should encompass: - Documentation and review of custom code - Optimization where necessary - Plugin review for updates - Recommendations for optimization This project requires a deep understanding of PHP, as well as experience with WordPress and data scraping. The ideal freelancer will have a strong background in website code review and optimization.
I am seeking to hire an excellent Compliance and Administrative member to join my team. Skills Required: * Confident on the phone * Speaks & communicates clearly by phone * Excellent written communication skills * Proficient in Microsoft Excel, Word and Power Point * Can multi-task and complete projects on time * Must be able to learn on the go and figure out solutions to problems * Is an excellent self-learner * Finish projects in a timely manner, doesn't procrastinate * Proficient with Adobe Acrobat in creating forms and documents * Proficient with DocuSign. Understand how to send out documents for signature * Excellent with follow-up. If you promise something to a client or team member follow-through * Understand how to use DropBox and grant/deny access to users * Excel...
I'm in need of a professional and detail-oriented writer who can compose structured daily reports for our company. The ideal candidate should have: - Experience in business writing - Excellent attention to detail - The ability to present information clearly and professionally Please note that the specifics of the reports, their primary purpose, and...professionally Please note that the specifics of the reports, their primary purpose, and the preferred format have not yet been determined. Therefore, flexibility and adaptability are key. Skills and experience that would be beneficial for this job include: - Prior experience in corporate communication or report writing - Strong understanding of business terminology - Proficiency in Microsoft Word and Excel - Ability to meet ...
I've got a Net Cost Calculator in Excel that needs to be embedded into my WordPress site, built with Elementor. This calculator is quite straightforward; it primarily employs simple arithmetic. Key Requirements: - The calculator will require users to manually input data. - It needs to be styled to match the theme of the rest of the site, rather than a simple and clean look or a completely custom design. - The calculations performed by the calculator are all simple arithmetic, not complex formulas or financial projections. Ideal Skills and Experience: - Proficiency in WordPress, particularly with Elementor. - Strong understanding of Excel, especially in terms of transferring content to a different platform. - Good eye for design to ensure the calculator matches ...
We are looking for an experienced developer to create a web-based Financial Requisitions Management System. The system will manage various requisitions (e.g., services, transportation, raw materials) with role-based access for users, approvers, and admins. Below are the key requirements: Technical Requirements: Web-based solution using modern frameworks (Flutter or ASP.NET Blazor). Backend to use GraphQL with Node.js (TypeScript) or ASP.NET Core. Authentication and authorization through MSAL, integrated with Microsoft Entra for SSO. PostgreSQL database (SQL Server is not allowed). Well-documented code or external documentation. Fully localized frontend (default in English, translation-ready). Functional Requirements: Role-based access: Users: Create, view, and edit their r...
I'm seeking an Excel expert who can compile and analyze the income statement for Woolworths Group Limited over the past three years. The report should include sales, expenses, and profit, as well as charts to visualize the data. Ideal Skills: - Proficient in Excel - Financial analysis experience - Data visualization skills Please note, while I've left the specific expense categories open-ended, the comprehensive nature of your analysis will be appreciated. Your ability to deliver a clear, insightful report is key. Deadline in 28 hours
I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!
I'm seeking an Excel expert to help me compose a mailing list. The ideal freelancer should have experience with data handling and Excel's various functions. Key requirements: - Create a comprehensive mailing list in Excel, including names and addresses. - Potentially assist with data analysis and visualization using Excel's tools. - Prior experience with similar tasks will be highly beneficial.
I'm seeking a Microsoft Excel professional to create a comprehensive spreadsheet for my retail and service-based business. The goal is to meticulously track all expenses and personal payments. Key Components of the Spreadsheet: - Record and categorize various expenses: Office supplies, Travel expenses, Utilities, Gas, Rent, Professional Development, Flights, Hotels, Credit Card fees, Business registration fees. - Monitor different income sources: Product sales, Service fees, Consulting fees. Ideal Skills: - Proficient in Microsoft Excel - Experience in creating business tracking spreadsheets - Understanding of retail and service-based business expenses - Ability to categorize and track diverse income sources. Your expertise will help me maintain a clear overview of ...
...detail-oriented developer to build an automation tool that will facilitate the extraction of real estate data from multiple platforms, including Zillow, Redfin, StreetEasy, and others. This tool will allow users to download property listings and seamlessly extract additional zoning and building-related data from Zola NYC and NYC Open Portal, all within an easy-to-use Excel interface. Responsibilities: Download Listings: Create a system that can pull real estate listings data from sources such as Zillow, Redfin, StreetEasy, and other relevant platforms. Enable users to paste or upload property listing data into an Excel sheet for further processing. Data Extraction: Automate the extraction of zoning data for each property from Z...
I'm seeking a skilled Python programmer to automate the handling of mixed data inputs into an Excel spreadsheet. Historical trades will be used as a reference point to retrieve data based on a number of conditions and variables from various financial instruments utilising historical data from 2016 onwards. This process will need to be scheduled to complete on weekly and ad hoc basis utilising API connection for historical price capture. Once the above is completed the same datasets will be used to simulate and output data based on the conditions set out in the simulation. Some understanding of trading terminology and bar/candle charts would be useful as this will would make it easier to comprehend the conditions and variables but is not a pre-requ...
...HMilao App. This app will digitize cash memos, extract data using OCR, and allow for manual corrections through an editable table interface. Core Features: - Upload Cash Memo: The app should support image uploads from both the camera and gallery in JPEG, PNG, and PDF formats. - OCR Data Extraction: Using Tesseract OCR, the app should extract and structure data into a table, with low-confidence fields highlighted for review. - Editable Table: The app should feature a grid layout with inline editing, error detection, undo/reset, and save options. - Automatic Calculations: The app should perform totals, subtotals, and discounts, with real-time error detection. - Export/Save: The app should allow users to export corrected data to PDF/Excel or save it loca...
I am seeking an Excel expert with extensive experience in spreadsheet automation. The ideal candidate will help me automate the following tasks: - Data entry - Generating reports - Data cleaning The Excel spreadsheet will need to interact with a database. Therefore, experience with database interactions in Excel is crucial. Skills and experience needed: - Advanced Excel knowledge - Expertise in spreadsheet automation - Proficiency in data manipulation and cleaning - Experience with generating reports in Excel - Familiarity with database interactions in Excel Please provide examples of similar projects you've completed in your bid. Thank you.
I need assistance in modifying an existing index in my Excel sheet. The goal is to enhance the accuracy of the index. Please help me make the index work better. Ideally, you should have a strong background in data analysis and Excel functions.
...language messages, access data stored in Storj, process it via Akash, and respond in a clear and actionable way to users. Main Functionalities Integration with WhatsApp Configuring the WhatsApp Business or Twilio API. Sending and receiving messages. Support for text messages and sending simple files (such as PDF or Excel reports). Natural Language Processing (NLP) Understanding questions such as: "How is campaign X performing?" "Should I increase investment in campaign Y?" Interpreting intent and extracting key information. Data Access and Processing Storing campaign data in Storj. Processing and analysis in Akash for: Calculating ROI, CTR, engagement and other KPIs. Identifying relevant anomalies or trends. Returning clear...
Working on converting 1200 images from PDF to Excel.
Description: We are launching an exclusive premium coaching service designed to help candidates excel in the CFA (Chartered Financial Analyst) exams. Recognized as some of the most challenging professional exams in the world, CFA preparation requires tailored support and strategies that go beyond the traditional offerings. To ensure our service delivers maximum value, we’re seeking CFA candidates and charterholders to provide critical feedback and suggestions before our April 2025 launch. Your insights will play a pivotal role in shaping this transformative service for future candidates. Project Objectives: > Review: Participate in an online video call to review our planned offering. > Feedback: Provide constructive insights on all aspects of the service, identi...
I am looking to extract product information from a website into an Excel sheet. I just need the product name, description, and price from the product listings on the site. Please let me know if you're experienced with web scraping and can finish this task. I just need an Excel Sheet and not a tool. Thank you!
I'm in need of a lead generation expert to extract emails and WhatsApp numbers from all interior and architecture companies in the UAE. Also all digital agencies consultant at dubai Key deliverables: - An Excel spreadsheet containing: - Company names - Contact persons - Company addresses - Email and WhatsApp numbers of owners - Locations -Sector Data Verification: - I prefer that the authenticity of the collected data is verified manually. Ideal skills and experience: - Familiarity with the interior and architecture sector in the UAE is a plus - Proficiency in Excel - Experience in lead generation - Strong attention to detail for manual verification tasks.
I need assistance with removing a password from 1-3 specific sheets in my Excel workbook. The task involves accessing these password-protected sheets, so proficiency with Excel and experience dealing with password removal are essential. Ideal Skills: - Excel Proficiency - Experience in Password Removal - Attention to Detail
I'm seeking an Excel expert who can help me code a MACROS to automate a process in Excel. The task involves analyzing employee data and generating results related to loans and other similar data entries. Key Responsibilities: - Develop a MACROS script to automate data analysis on employee data. - The macro should be able to provide results for specific data entries related to loans and other similar metrics. Ideal Skills and Experience: - Proficient in Excel and VBA programming. - Prior experience in developing Excel MACROS for data analysis. - Understanding of employee data metrics. - Able to deliver efficient and effective solutions for data processing and analysis.
...bidding strategies. Requirements: • Educational Qualification: Bachelor’s degree in any field (preferably Business Administration, Commerce, or related domains). • Experience: Minimum 2 years of experience in tender management, with hands-on expertise in GEM portal operations. • Strong knowledge of hospital equipment and OT table specifications is preferred. • Proficiency in MS Office (Word, Excel) and GEM portal functionalities. • Excellent communication, organizational, and analytical skills. • Ability to work under tight deadlines and multitask efficiently. What We Offer: • Competitive salary and benefits. • Opportunity to work with a dynamic team in the healthcare equipment industry. • A supportive and growth-orien...
...and automating my Excel data. I'm unsure if everything is possible to do, but maybe a few steps can be disregarded. The perfect scenario would be: Create a simple form to add 'ID number' to process and file name for the new file. The automation: Open designated file with info. Create columns (based on character lenght) Format columns (set length, add '0's eg '234' formated to '000234'. Get only rows where Column C matches the input 'ID number', and column B has fixed value. Insert row at top with column header titles. Save file (as excel 97-2003 format), with the input filename. If all works out well, I will have another project where similar things are needed. Ideal freelancers for this project shoul...
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.
...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 production is required. • Each area of expertise is evaluated separately, so you will only work on the areas you excel in. For example, a designer specialized in business cards will not be assigned packaging design tasks. • Workload is evenly distributed among multiple designers in the team. **Application Process** **Before applying, we recommend learning more about our company by searching “SignsAtelier” on Google and visiting our website.** • Plea...
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.
...worth of historical data from an existing real estate MLS server. 3. Use RESTFUL API to set up daily, incremental downloads of the same data. The 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...
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 examples of sim...
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
...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/filter based on priority or relevance. Brainstorm/Seed Keywords Tab A simple “dump” area to collect raw ideas. Minimal formattin...
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'm seeking assistance with customer analytics specifically tailored for a real estate operator. I've provided four recordings detailing the three deliverables needed: overview https://www....5a96621c 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 the final deliverables, I'm flexible, whatever can present the deliverable accurately.
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.
I'm 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 and pressing o...
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 shoul...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. Lookin...
...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)...
