Vba excel as400 jobs

I'm in need of a seasoned data scraper with extensive experience in collecting information fr...from LinkedIn Sales Navigator. I am aiming to gather data on 77K HR professionals. Specific Data to be Scraped: - Name - Job Title - Company - Email Address - Phone Number - LinkedIn Profile URL - Location - Industry - Years of Experience - Gender Deliverables: - The collected data should be delivered in an Excel spreadsheet. - This is a one-time data collection project. Ideal Skills and Experience: - Proven experience in data scraping, particularly from LinkedIn. - Proficiency in Excel and data management. - Excellent attention to detail to ensure data accuracy. - Ability to handle and process large volumes of data. Please only apply if you have the required skills and ...

I'm in need of a seasoned market analyst who specializes in chart patterns. The primary focus will be on identifying entry and exit points using specific patterns: Head and Shoulders, Double Top/Bottom, and Cup and Handle. Ideal skills for this project: - Expertise in chart pattern recognition - Proficiency in stock market analysis - Ability to ...Shoulders, Double Top/Bottom, and Cup and Handle. Ideal skills for this project: - Expertise in chart pattern recognition - Proficiency in stock market analysis - Ability to identify potential entry/exit points - Proficiency with technical indicators like RSI, MACD, and Bollinger Bands. Your role will be crucial in helping me effectively navigate the stock market. Please provide the analysis in an Excel spreadsheet with all releva...

I'm seeking a meticulous data entry specialist to help me input product details sourced from the internet into an Excel spreadsheet. Key Responsibilities: - Researching and sourcing product details from online platforms - Accurately inputting the data into an Excel spreadsheet Ideal Skills: - Proficiency in Excel - Strong attention to detail - Experience in data entry and online research - Ability to meet deadlines The project will involve entering details for between 100 and 500 products. The freelancer can use a customized format for organizing the product details in the Excel spreadsheet. The data entry will include collecting and entering the product name and price. Please include the product description as well. Please include the following detai...

I'm looking for an Excel expert to create a recipe calculator for me. This calculator should have the functionality of scaling recipes by a percentage. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating complex Excel tools - Understanding of recipe scaling Please let me know if you can help.

I'm seeking a professional to assist with a creation of 10 photos for a my website. - Existing photos : I need you to create gif with my photos and videos for my tree products - Data Format : need you to list what you have done in a Spreadsheet (Excel/CSV).

Project Description: We require an experienced professional to create a customized report from an Excel database. The project involves: 1. Extracting and organizing specific data from the Excel file. 2. Designing a visually appealing and functional report format. 3. Ensuring the report can be generated dynamically if required. 4. Delivering the final report within 01 hours. Requirements: • Proficiency in Excel (advanced functions, pivot tables, macros, etc.). • Experience in report generation and formatting. • Attention to detail and ability to deliver on tight deadlines. • Knowledge of integrating Excel data into other reporting tools. Please include examples of similar projects in your proposal and specify how quickly you can comp...

I'm in need of a skilled programmer who can create an Excel VBA plug-in for me. The primary function of this plug-in will be to detect user actions within Excel and display selected messages on the top corner of the screen. Ideal skills and experience for the job include: - Proficiency in Excel VBA programming - Experience in developing Excel plug-ins - Knowledge of creating and linking macros to buttons Please only apply if you can deliver a high-quality, efficient solution.

Hello, i've some troubles with Vlook and i need help, see attached file

Determine if an employee came late or early, left late or early, took a 30 minute break or not when applicable

Hi, I want this website to be scrapped. Please check the sample page which I want following data to be extracted Name,Designation,Mobile No, Email There is also data of the Sarpanch and Secretary on the same page but not in the table. Somehow I also want their contact information. I want all data of U.P to be extracted and put in Excel sheet. the scrapper shud go into each District Panchayat Name> Panchayat Samiti Name> Village Panchayat Name> and then take out members name/contacts/emails.

...will parse XML files and extract relevant details into a predefined Excel format. Essential Features: - The software should specifically extract relevant information from the XML files. - The utility should follow a modular approach. This means every component should be independent and interchangeable. - A key requirement is the reusability and extensibility of the codebase. The software should be built in such a way that it can be easily adapted for future use or extended with new features. - The software should include robust error handling mechanisms to manage various XML parsing errors and data extraction issues. Ideal Skills and Experience: - Proficiency in Java is a must. - Prior experience with XML parsing and Excel file creation. - Strong understanding of modular...

I'm looking for a machine learning expert who can help me analyze my financial data in Excel. The main aim is to identify trends over time which could help in forecasting future performance. Key Requirements: - Proficient in Excel and machine learning techniques - Experience with financial data analysis - Ability to identify and interpret trends over time The ideal candidate will have a strong background in data analysis and machine learning, specifically with financial data. You should be able to deliver insights that could help in forecasting future performance based on identified trends.

Project: Next.js-Based Peer-to-Peer Package Delivery...functionalities, including registration, package management, order tracking, payments, chat, and more. Key technical aspects include REST APIs, MongoDB, JWT authentication, Stripe Connect, WebSockets, and KYC integration. The project also requires advanced features like multi-language support, support tickets, and restricted item management. Crucially: The attached Word document and the Breakdown Excel table are integral parts of this proposal and define the detailed requirements and scope of the project. The developer is required to comprehensively read, understand, and sign these documents, committing to implementing all aspects outlined within them. These documents are legally binding and form the basis of the contractual ...

I'm looking for a skilled data extractor to assist me with a project involving a large PDF file. The...extractor to assist me with a project involving a large PDF file. The document has over 800 pages and contains tables with more than 3000 rows. Here's what I need: - Data Extraction: The data is mixed, containing both text and numerical values. - Excel Representation: The extracted data should be accurately represented in an Excel file. The tables in the PDF have a consistent layout throughout the document, making the extraction process more straightforward. Ideal skills for this project would include: - Proficiency in data extraction - Advanced Excel skills - Attention to detail to ensure accurate data representation. Please reach out if you have th...

I'm seeking an Excel expert for a 2-hour project. Example work : i have 10 sheets with C column as commodity column in excel. i want distinct names from all those sheets in my existing sheet named "LEDGER" I have asked ai, but i need someone who can do. The data to be processed will include financial data.

I want to convert my Google Slides presentation to Video and my Google Slide's Narrator Notes/Editor notes should be Artificial voice over for the output video. After Video conversion Video should be uploaded to my YouTube channel at specific mentioned time. (Approx Every day 4:00PM) Points to consider below: 1. This automation shoul...Different customizations will be applied for each regional language. Please ensure the Artificial voice over files are provided in MP3 format. Implement a weekly backup schedule for all video files and project data to avoid data loss. The initial videos will be reviewed and approved by the client before final upload. The separate data for video titles, thumbnails, and descriptions will be provided in Excel format. No subtitles will be included...

I need an Excel specialist who can help me with a project focused on financial tracking and budgeting. Key Responsibilities: - Design an Excel sheet for comprehensive financial tracking. - Create a budgeting tool within the Excel sheet. - Incorporate graphs and charts for visual interpretation of data. Ideal Skills: - Proficiency in Excel, particularly with budgeting and financial tracking tools. - Experience with data visualization in Excel. - Strong understanding of financial management.

We have PDF copies of timesheets from our construction crews (approximately 100–150 sheets, each covering 5–20 personnel). These timesheets are submitted by the end of the day on Monday, and we require them to be entered into an Excel spreadsheet for upload into our software by Tuesday morning when the office opens. This task will be required once a week for the next three months. We can provide the employee names in Excel format, enabling data validation to improve accuracy. This is an urgent requirement. Please let us know if you can assist. Thank you!

I'm looking for an Excel expert to help me consolidate information from individual staff timesheets into a master view. Key tasks: - Total hours worked and all related hours into a comprehensive weekly view. - Utilizing separate Excel files for each employee's timesheet. - Designing the master view in a standard table format with appropriate graphical representations (charts). Ideal candidates will be proficient in Excel, have experience with data consolidation and analysis, and be able to create clear and informative visual representations of data. Please utilize bar charts for graphical representations.

I'm seeking a professional to create a project management spreadsheet for a small team of 1-5 users. The spreadsheet needs to have specific functionalities: - Task assignment and tracking:...management spreadsheet for a small team of 1-5 users. The spreadsheet needs to have specific functionalities: - Task assignment and tracking: The ability to allocate tasks to team members and monitor their progress. - Timeline and milestones: A clear representation of project timelines and key milestones. - Googlesheets -Top overview of the days todo Ideal candidates should be proficient in Excel or Google Sheets, with a strong understanding of project management principles. Experience in creating similar spreadsheets is highly desirable. Please include examples of your previous work in...

I require a statistics expert to analyze some survey data using descriptive statistics. The analysis should be done in Excel. Ideal Skills and Experience: - Proficient in Excel for data analysis - Strong understanding of descriptive statistics - Experience with survey data analysis - Ability to present findings in a clear, understandable manner

I need an expert in Excel Macros who can create a workbook that can filter data based on specified criteria and generate both Word documents and PowerPoint presentations. Our corporate team should be able to click through the applicable criteria in the excel workbook and then have this generate a word doc and/or powerpoint with all the needed information.  The output should be well-structured and organized chronologically, although custom-lay out and creative ideas are welcomed. The data to be included in these documents will encompass: - Tables and graphs - Text summaries - Images and diagrams Ideal candidates for this project should possess the following skills: - Proficient in Excel Macros - Experience in automating Word and PowerPoint from Excel...

I need a precise Excel spreadsheet that will automatically pull player statistics from Breaking Point. The spreadsheet should be user-friendly, allowing me to add new data weekly without complications. Requirements: - Expertise in Microsoft Excel: The freelancer should be highly skilled in creating complex, automated spreadsheets. - Web Scraping: The project involves extracting data from the internet, hence the freelancer should be proficient in web scraping. - Understanding of Sports Statistics: Familiarity with player statistics and sports data will be advantageous in understanding the project's requirements. - Good Communication Skills: The freelancer should be able to explain how to update the spreadsheet in simple terms. Please note, a good payment will be provide...

...ODOO system is used to manage leads, sales, inventory, and finances, but there are gaps we aim to address to optimize our workflow. --- ### **Current System Overview** 1. **Lead and Proposal Management:** - CRM is fully configured and operational for managing leads and opportunities. - Proposals are created in Odoo, but material and labor cost calculations are performed externally using Excel spreadsheets. This is what we aim to unify within the system. 2. **Inventory Module:** - Fully configured, with tracking for material entries and exits. - Not connected to proposals or projects, and there is no material traceability by project. 3. **Purchasing Module:** - Suppliers and products are registered in the system. - Purchase orders are not yet generated autom...

...into a single Excel sheet. Key Requirements: - Transcribe both textual information and numerical data accurately - Import all data into a single sheet in Excel - Attention to detail to ensure all information is captured correctly - Provide specific guidelines for data formatting within the Excel sheet. - Clearly specify the date formats to be used if the handwritten notes contain date information. - Ensure that all data remains confidential and is handled securely. - Establish a procedure for dealing with unclear handwriting to minimize errors. Ideal Skills and Experience: - Proficiency in Excel - Experience with data transcription - High level of accuracy and attention to detail - Ability to work with mixed data types Please use a table format for the la...

I'm currently seeking a skilled professional to help me improve my proficiency in Excel and other Microsoft Office applications, with a specific focus on data analysis and visualization. Ideal Skills: - Extensive knowledge of Microsoft Excel - Proficiency in other Microsoft Office applications - Excellent teaching and communication skills - Experience with data analysis and visualization techniques Key Areas of Focus: - Mastering Excel: I need to focus on data analysis and visualization techniques in Excel. - Proficiency in Microsoft Office: I want to enhance my overall Microsoft Office skills. I'm looking for someone who can provide me with practical lessons and exercises, tailored to my current skill level and learning pace. Your ability to commu...

I'm looking for an Excel expert who can create a workbook for us that includes all relevant case management forms, like client intake forms and progress notes. The workbook should also be able to accommodate purchase orders, check requests, budget analysis, and other forms. Key Requirements: - Automation of as much as possible, particularly data entry - Creation of auto-filled fields - Use of logical formulas and calculations for case management-related tasks - Design of a user-friendly interface for ease of use Ideal Skills: - Advanced knowledge of Excel - Experience with case management systems - Strong skills in creating automated spreadsheets - Excellent attention to detail - Ability to create intuitive and easy-to-use interfaces The priority for automation featu...

Position: Genesys Trainer Location: Remote/On-site (Specify as applicable) About Us: We is a premier provider of training and consultancy in contact center technologies. Specializing in platforms like Genesys Cloud CX and AWS Connect, we empower individuals and organizations to excel in the ever-evolving CCaaS landscape. Job Description: We are seeking a highly skilled Genesys Trainer with expertise in Genesys Cloud CX to join our team. The ideal candidate will deliver engaging and comprehensive training programs to students, professionals, and corporate teams, enabling them to master Genesys Cloud CX functionalities and best practices. Responsibilities: Design and deliver training sessions on Genesys Cloud CX, including architecture, implementation, configuration, and troublesh...

...into a single Excel sheet. Key Requirements: - Transcribe both textual information and numerical data accurately - Import all data into a single sheet in Excel - Attention to detail to ensure all information is captured correctly - Provide specific guidelines for data formatting within the Excel sheet. - Clearly specify the date formats to be used if the handwritten notes contain date information. - Ensure that all data remains confidential and is handled securely. - Establish a procedure for dealing with unclear handwriting to minimize errors. Ideal Skills and Experience: - Proficiency in Excel - Experience with data transcription - High level of accuracy and attention to detail - Ability to work with mixed data types Please use a table format for the la...

I'm looking for a creative designer to help me design a promotional post for Instagram. The main goal of this post is to generate leads or sales. Please note: - The design should be engaging and tailored for Instagram. - Experience in designing social media posts and understanding of the platform's best practices is a plus. - A knack for creati...this post is to generate leads or sales. Please note: - The design should be engaging and tailored for Instagram. - Experience in designing social media posts and understanding of the platform's best practices is a plus. - A knack for creating visually appealing designs that drive sales will be highly appreciated. The main goal of the post is to convince CEO to switch from managing process using excel files into getting a ...

...error-handling mechanisms to manage failures gracefully and provide meaningful error messages. - Implement data validation checks to ensure the accuracy and integrity of the extracted data. - Ensure that the software can scale to handle increasing amounts of data as the company grows. - Software MUST be self sufficient, meaning it must be able to run independent of any human interaction and scan an excel file with data source links (example below) and print thousands of rows based on parameters. - Implement robust user authentication and authorization to secure sensitive data. - US HEALTHCARE INSURANCE EXPERIENCE PREFERRED. Example .pdf and .html links to be scraped (you MUST be able to have country access) -

...categorize and organize data effectively - Attention to detail and accuracy in data collection. A keen understanding of the Indian education system would be a plus. Please provide relevant samples of your past work in your proposal. The project should be completed within 3 weeks The total entry is 15000. Can refer to any websites containing collage details. The final data should be delivered in an Excel file format....

I'm seeking a professional lead generator who can fill out missing data of 32 companies. Data already in attached Excel sheet. Just need to add missing data and founder details. The task is: 1) fill in all the missing blanks for each company and 2) list all the founders of the company in another sheet Thanks Use online databases to find missing information and founder details. Freelancer may use any reputable online databases to find the missing information and founder details. Primarily focus on missing contact information such as phone numbers, emails, and addresses.

I'm seeking an expert to assist with using the XLOOKUP formula in Excel for data retrieval purposes. The task primarily involves retrieving numeric data from multiple columns. Ideal skills and experience: - Proficiency in Excel, particularly with the XLOOKUP formula - Strong understanding of data retrieval techniques - Experience working with numeric data - Ability to work with multiple columns - Attention to detail to ensure accurate data retrieval

Data scrape per excel file.

I have a project that involves transcribing handwritten documents into an Excel spreadsheet. This job requires careful attention to detail and the ability to accurately interpret handwriting. Ideal Skills: - Excellent typing skills - Proficient in Microsoft Excel - Strong attention to detail - Good understanding of English - Experience with data entry from handwritten documents

...Easy for Techs who work remotely to access • We can design excel template for the timesheets which can then easily be cut and pasted into Xero (our accounting package which also does our payroll). • The documents are live However, we are unsure as to whether Google Docs will allow us to do the following: • Have 1 x Google Doc with individual tabs which can be quarantined/separated so that Techs can only view their own (and not other Techs) time sheets/tabs? • Allow 2 x payroll staff working at separate locations to edit the time sheets (individual tabs?) submitted by Techs and also make comments that are visible to payroll staff only and not to Techs. Please advise if you think you can assist and set up something for us with an excel template that we...

I'm running a digital marketing agency and I'm in need of a skilled virtual assistant to help with specific projects that require the use of emulators. Your role will involve creating and managing processes on virtual platforms according to precise instructions. Key Skills: - Excellent proficiency with digital tools, especially emulators. - Impeccable organization and abi...problem-solving skills. - Highly proficient in French. - Strict adherence to confidentiality and handling of sensitive data. - A computer capable of supporting emulators like Bluestack. - Fast internet connection. - Quick response time. What We Offer: - Attractive remuneration based on your skills. - A stimulating work environment with varied projects. - Potential for long-term collaboration if you exc...

I'm looking for a professional to create a reporting module for EspoCRM. Essential Features: - Comprehensive daily sales reports focused on product and salesperson performance. - Ability to track 'Sales by Product' and 'Sales by Salesperson'. - User-friendly interface. The module must allow generating reports and being able to download them in Excel, with the possibility of filtering and viewing graphs (optional) Ideal Candidates: - Proficiency in EspoCRM and CRM systems. - Strong background in data analysis and reporting. - Excellent software development skills.

I'm in need of an Excel automation expert to help me with streamlining a master Excel sheet for online use on SharePoint. Key Tasks: - The master Excel sheet should be capable of updating multiple existing files on a daily basis. - It should also generate PDF reports as needed. - I require assistance with data validation and error checking to ensure the integrity of the data. Ideal Skills: - Proficient in Excel with experience in automation. - Familiar with SharePoint. - Capable of creating a robust system for data management. - Able to ensure data integrity through effective validation and error checking processes. The goal is to have a seamless, automated system that can take the burden off manual updates and checks. Looking forward to your bids!

I'm looking for a skilled developer to connect the user reports section of my web application to SAP Crystal Report. The application is built using HTML, CSS, JavaScript, and PHP, and the database is MSSQL. Key Requirements: - Integration of user reports with SAP Crystal Report. - Generation of reports both on-demand and at regular intervals. - Conversion of reports into PDF, Excel, and HTML formats. - Provide options for custom filters in the report generation. - Ensure the generated reports are compatible with mobile devices. - Enable sending scheduled reports via email automatically. Ideal Skills: - Proficiency in HTML, CSS, JavaScript, and PHP. - Strong experience with SAP Crystal Report. - In-depth knowledge of MSSQL. - Ability to set up automatic report generation. - S...

I have a project that involves sorting and combining data in Excel. The task is to identify all the bins for each SKU we keep in stock, and combine all the bin names into one cell, with the total units in the next cell. Data Overview: - Total SKUs: 5000 - Total Lines: 15000 Requirements: - I will provide a specific format/template for the final output. Ideal candidate should have: - Proficiency in Excel, particularly in data sorting and consolidation. - Experience in handling large datasets. - Ability to follow specific instructions and adhere to provided templates.

I'm in need of an Excel specialist to set up an accounting system for LPG gas cylinders. The tasks the Excel sheet needs to handle are tracking inventory levels, generating financial reports, and monitoring cylinder movements. Key Requirements: - Proficiency in Excel - Experience in creating inventory and financial tracking systems - Ability to suggest effective templates and structures for the Excel sheet - Skills in setting up data importing from other sources The ideal freelancer for this project should have a strong background in data analysis and accounting.

I'm in need of a macro for Outlook that can facilitate the downloading of attachments from a selected batch of emails. Key Requirements: - Manual selection by the user to determine which emails to download from. - Post-download, the emails should...can facilitate the downloading of attachments from a selected batch of emails. Key Requirements: - Manual selection by the user to determine which emails to download from. - Post-download, the emails should be moved to a specific folder. - All file types from the email attachments should be downloaded. Ideal Skills and Experience: - Proficiency in creating macros for Outlook. - Familiarity with VBA (Visual Basic for Applications). - Previous experience with email automation tasks. - Attention to detail to ensure all attachments ...

I'm seeking a professional lead generator who can fill out missing data of 32 companies. Data already in attached Excel sheet. Just need to add missing data and founder details. The task is: 1) fill in all the missing blanks for each company and 2) list all the founders of the company in another sheet Thanks

Preferred simulation tool is ANSYS. The project requires fluid dynamics simulation. The fluid to be simulated is Water. The specific flow rate to be simulated is 0.1 m/s. Please provide the results in contours and Excel data. The simulation should use specific geometry provided. The project timeline is 2 weeks. The primary objective of this simulation is performance analysis. The specific geometry will be provided in a CAD file. Include pressure drop measurements in the simulation results.

I'm seeking a freelancer to assist in editing my CSV file. The task involves removing 2 numbers from a specific column. There are 250 entries left. it can be in 1/2 hours. Please use Excel for the CSV editing. Please save the final file as .xlsx. Create a backup of the original CSV file before editing. Please move the removed text to another column. List each removed text value in separate rows in the new column. Remove single digits only from the specific column. Please edit the first column. List the removed single digits separated by commas in the new column. Format the new column with each removed digit in individual rows. Please name the new column 'Removed_Digits'.

I need a freelancer who can help me extract specific data from a website. This is a one-time project. Data Extraction Details: - The data to be extracted primarily includes text content, images, and structured data like tables and lists. - The extracted data needs to be compiled and delivered in an Excel file. Ideal Skills and Experience: - Proficiency in data extraction techniques and tools. - Experience with web scraping. - Excel expertise for data organization and presentation. - Experience in data cleaning and preprocessing to ensure the accuracy of extracted data. - Proficiency in using automated scraping tools like BeautifulSoup or Scrapy. - Familiarity with programming languages like Python or JavaScript for web scraping. Please note, this project involves a one-tim...

I need a freelancer to compile a comprehensive Excel sheet of Indian colleges. The data should encompass: - Fees Range - Course Offered - A brief description about the college (under 100 words) - Highest package offered - NIRF Ranking - College Name - City - State - Ownership The college data should specifically cover institutions offering the following degree programs: - MBA - BTech - MBBS - LLB The following cities college should be included are: bhubaneshwar chennai bangalore mumbai pune kolkata delhi hyderbad adndhra pradesh dehradun guwahati sikkim haryana gujrat bhopal lucknow noida kanpur patna ranchi raipur raurkella bbsr jamshedpur siliguri nagpur kolapur wardha mangalore maisore goa bhillai chandigarh tyrchi Coimbatore Ideal candidates for this project should have pr...

I'm looking for a comprehensive Excel spreadsheet that lists all the accountant firms in South East Queensland, Australia. The spreadsheet should contain detailed information such as the firm's name, email, contact number, address, and names of accountants. Key requirements: - Email verification: All contact details need to be verified via email. - Use of google searches and business directories: I prefer that you source the firms from google searches and business directories. The final deliverable should be in Excel (.xlsx) format. Ideal candidates for this project should have experience in data collection and verification, proficiency in Excel, and access to google searches and business directories. The project should be completed within 1-2 weeks.