Vba com port excel jobs

I'm in need of an expert who can build an Excel spreadsheet for me that pulls live data from Whoscored.com. I want to be able to see columns outlining player name, team, age, height, rating, positions, appearances per position, strengths, and weaknesses, with a focus on current season statistics. Data Requirements: - Real-time updates - Automatic data refresh Ideal Skills and Experience: - Proficient in Excel and data scraping - Familiarity with or similar sports data websites - Experience in building automated Excel spreadsheets - Understanding of football player statistics

I'm in need of a detail-oriented freelancer to assist with a data entry project. The task involves sourcing text data from online databases and inputting it into an Excel sheet. Key Requirements: - Exceptional attention to detail to ensure accurate data entry - Proficiency in using online databases - Strong skills in Excel, including knowledge of basic functions and formulas - Ability to work independently and meet deadlines Ideal Candidates: - Previous experience in data entry is preferred - Familiarity with online databases is a plus - Excellent command over English for accurate text data interpretation

I need a proficient biostatistician to analyze my Excel spreadsheet. The results will be used for a research publication, so accuracy and clarity are paramount. You'll mainly be using descriptive statistics to interpret the data. Key Tasks: - Conduct biostatistical analysis using descriptive statistics, students T test to show significance etc - Present results in clear, organized tables Ideal Skills: - Proficiency in biostatistics - Expertise in Excel - Experience in preparing data for research publications Please note, the final output should consist of tables only. Graphs and summarized text reports are not required.

I need a well-structured Excel spreadsheet to monitor employee details and calculate their compensation. Key Features: - Tracking Information: The spreadsheet should keep a record of each employee's name, Department, hours worked per day of the week, and their individual hourly rate. - Compensation Calculations: It should automatically compute the total compensation based on the hours worked and the hourly rate. - Bonus Calculations: The spreadsheet should also include a section to calculate bonuses for each employee. Ideal Skills: - Proficiency in Excel, including the use of complex formulas and functions. - Experience in creating employee tracking and compensation spreadsheets. - Understanding of payroll, bonuses, and general HR practices. This tool will assist m...

I'm looking for a professional who can create an organized and comprehensive Excel contact list for my business. Key Requirements: - Include contacts from various categories: clients, suppliers, and subcontractors. - Collect and input specific information for each contact: their names and addresses, phone numbers and emails, as well as their company details and roles. Ideal Skills and Experience: - Proficient in Excel, with experience in creating structured spreadsheets. - Excellent research skills to gather necessary information. - Previous experience in creating business contact lists is a plus.

I'm looking for an Excel expert to create a database specifically tailored for my sales reporting needs. Key Requirements: - The database should primarily serve the purpose of reporting. - It will be focused on sales data specifically. Ideal Skills: - Advanced Excel skills. - Good understanding of sales metrics. - Experience in creating databases for reporting purposes.

My Python3 code for Excel on Mac is experiencing issues that need to be addressed. The main problem lies in the calculations, particularly with logical comparisons. Ideal skills and experience for the job: - Proficient in Python3, with a focus on data analysis and Excel integration - Experience troubleshooting and debugging code - Familiarity with Mac's version of Excel - Able to understand and rectify logical comparison errors - Attention to detail to ensure all equality checks function correctly

I'm in need of a proficient data entry expert to assist with handling information from Excel sheets and CSV files. The work primarily involves data entry and updating records. Ideal skills and experience for the job include: - Proficiency in Excel and familiar with CSV files - Attention to detail to ensure data is entered accurately - Experience with data entry and record updating - Ability to work independently and meet deadlines

I'm working on an economic development project and I need someone skilled in Excel and writing to assist me. The primary focus of the project is financial forecasting. Many different financial data points will need to be forecasted, including revenues, expenses, and cash flows. Your tasks will include: - Using Excel to analyze and forecast various financial data - Writing clear and concise documentation of the financial forecasts for the project - Assisting with the preparation of the documentation for the financial forecasts - Helping to prepare the final presentation of the financial forecasts for the project Skills and experience ideal for this job: - Proficiency in Excel, with experience in financial forecasting - Strong writing skills, with the ability to ...

I have an Excel file that requires some urgent corrections, specifically related to fixing errors in the formulas. The primary focus is on logical conditions, particularly with the Data Validation function. The ideal freelancer for this project should have: - Extensive experience with Excel and its formulae - Specific expertise in troubleshooting and rectifying issues with logical conditions - A keen eye for detail to ensure all errors are identified and corrected Please bid if you are confident in your ability to rectify these issues swiftly and accurately.

I'm seeking a data extraction expert to help me gather real estate listings from OLX for four cities in the State of Pará, Brazil. These cities are Belém, Altamira, Marabá, and Castanhal. The data should pertain to residential properties and land. Ideal Skills: - Data mining and we...of Pará, Brazil. These cities are Belém, Altamira, Marabá, and Castanhal. The data should pertain to residential properties and land. Ideal Skills: - Data mining and web scraping - Proficiency in using OLX and similar platforms - Experience in collecting real estate data Data Requirements: - Residential properties - Land Delivery Format: - The data should be compiled and delivered to me in an Excel spreadsheet. Please ensure that your bid reflects you...

I'm looking for a skilled Excel Add-In developer to create a tool that automates various tasks in Excel. Key Features: - Automation of tasks such as data import/export, report generation, and data validation. Requirements: - The Add-In needs to interact with external databases. Ideal Skills: - Proficiency in Excel Add-In development - Experience with database connections - Strong understanding of task automation within Excel Experience in developing similar tools will be highly regarded. Please include examples of your previous work in your proposal.

I'm looking for a professional who can help me calculate trend lines using statistics and math. The input data will be numerical, provided in an Excel spreadsheet, and I'll need a linear trend line calculated. Ideal Skills: - Proficiency in statistics and mathematics - Expertise in Excel and data analysis - Experience in calculating trend lines Please only bid if you can provide high-quality work in a timely manner.

I will complete the redesign of your E-Book with more infographics, as well as add the BIG excel file into the e-book, making sure it looks as visually appealing as possible.

Excel Bookkeeping services for 2023&2024

Project Overview – https://love248.com Main tasks the. Automate live streaming initiation for streamers without manual OBS setup. b. Redesign public rooms to match the design and functionality of . w. Optimize user-streamer interaction, load times, and public room navigation. d. Automate user access control and session termination for private rooms. and. Add real-time room status notifications for streamers and attendees. f. Fix misaligned buttons, inconsistent margins, fonts, and visual design issues. g. Standardize page layouts, button styles, and visual feedback elements. h. Improve the usability of new and existing features. i. Test and ensure all payment methods are operational. j. Validate the implementation of revenue sharing between the site and

As a small retail store owner, I'm looking for an Excel expert who can help streamline my product labelling process. Currently, I'm using an application that creates a single label at a time, which is consuming a lot of my time. I need a custom Excel sheet that can generate labels with a barcode, product name, and price from my invoice Excel. The sheet should create labels for all different products from the invoice, in the specified quantity. Key requirements: - Proficiency in Excel, with experience in creating custom sheets for specific tasks. - Understanding of retail labelling requirements. - Ability to incorporate barcodes into the Excel sheet. - Experience in creating label formats of custom sizes. Please note, I will not require addit...

I'm in need of a diligent data entry professional to assist with transcribing handwritten documents into Microsoft Excel. Ideal Skills: - Excellent attention to detail - Proficient in Microsoft Excel - Fast and accurate typing skills - Prior experience with manual data entry Your tasks will primarily consist of: - Manually transcribing data from handwritten documents into Excel - Ensuring data is entered accurately and in a timely manner It's essential that you can commit to maintaining the confidentiality of the information contained within the documents. Please provide examples of similar projects you've completed in your proposal.

Excel spreadsheet to track 10 game poker tournament 20 players Amount paid needs to equal $1000 for green box (this is total for tournament not each night), if less than $1000 paid in keep yellow fill in that box Columns at the top (total of 14): Player name - Amount Paid (must total $1000 to get green box)-Game 1- Game 2 - Game 3 - Game 4 - Game 5 - Game 6 - Game 7 - Game 8 - Game 9 - game 10 - Total Points - Total $ Won Under each Game (total of 10 games) there needs to be 3 columns = Points - Bonus Points - $ Won Total number of rows down the left side will be 20 for 20 players Each night we play starting with game 1, first guy out gets one point...we would put a 1 in the Points column for that player Second guy out that night gets a 2, Third guy out that night gets 3 points (t...

I am seeking an experienced web scraper based in India, proficient in extracting data from news websites on a monthly basis. The data will need to be compiled into Excel and delivered over a total of 22 days each month. Key Requirements: - Expertise in web scraping, particularly from news websites. - Excellent data organization skills. - Proficiency in Excel. - Based in India. Please respond with the word RED to confirm you've read this message.

I need an Excel specialist to refine my existing payroll template. The task involves adjusting formulas, formatting cells and adding new functionalities to improve efficiency and usability. Please bid only if you have experience with Excel.

I am seeking an experienced Power BI freelancer to create a comprehensive and interactive dashboard tailored to my business needs. The goal is to transform raw data into actionable insights for better decision-making and operational efficiency. Project Requirements: Data Integration: Connect and integrate multiple data sources (Excel, SQL, or Google Sheets) with Power BI. Dashboard Design: Develop user-friendly dashboards with interactive visuals, including KPIs, charts, and slicers. Data Analysis: Perform data cleansing, trend analysis, and provide actionable insights. Visualization: Create visually appealing dashboards that allow drill-down and export options for reports. Documentation: Deliver brief documentation for using the dashboard and provide initial support for adjustmen...

...create a custom scraper tool that can extract specific member information from a designated website. The primary data points will be names and contact numbers. Key Project Deliverables: - Efficient and accurate scraping of member names and contact numbers. - Ensure the scraper is designed to avoid potential blocking by the website. - Data should be organized in a structured format, like a CSV or Excel file, for easy analysis and use. - The tool should be user-friendly, with clear instructions on how to use it for subsequent scrapes. Ideal Candidate Skills: - Proven experience in web scraping and data extraction. - Knowledge of programming languages such as Python, PHP, or similar, with a focus on web scraping libraries and frameworks. - Familiarity with ethical scraping practi...

I am seeking an experienced web scraper based in India, proficient in extracting data from news websites on a monthly basis. The data will need to be compiled into Excel and delivered over a total of 22 days each month. Key Requirements: - Expertise in web scraping, particularly from news websites. - Excellent data organization skills. - Proficiency in Excel. - Based in India. Please respond with the word RED to confirm you've read this message.

...are looking for an experienced Kubernetes expert to assist with setting up and managing our k3s clusters on Hetzner's dedicated servers. Below are the details of the tasks involved: ### Requirements: 1. **Cluster Setup:** - Set up k3s clusters on Hetzner dedicated servers. - Configure Kubernetes mutual certificate authentication for secure communication. - Implement a firewall to secure port `6443` or utilize a virtual switch for added security. 2. **Networking:** - Configure MetalLB in layer-2 mode with a virtual switch and public IPs. - Ensure proper load balancing and network reliability. 3. **Ingress Management:** - Set up NGINX Ingress Controller alongside Traefik for managing different endpoints. - Install and configure Cert-Manager for SSL cer...

I'm seeking a professional to assist me in exporting specific user activity data from a web page into an Excel spreadsheet. The primary purpose of this data export is for data analysis. Key Tasks: - Identify and extract relevant user activity data from the specified web page. - Ensure the data is accurately exported into Excel. - Include transaction details as part of the sales data export. Ideal Skills: - Proficient in data extraction and analysis. - Experienced with Excel and data management. - Attention to detail to ensure data accuracy.

I'm in need of a detail-oriented freelancer to assist with a data entry project. The task involves sourcing text data from online databases and inputting it into an Excel sheet. Key Requirements: - Exceptional attention to detail to ensure accurate data entry - Proficiency in using online databases - Strong skills in Excel, including knowledge of basic functions and formulas - Ability to work independently and meet deadlines Ideal Candidates: - Previous experience in data entry is preferred - Familiarity with online databases is a plus - Excellent command over English for accurate text data interpretation

...You will be responsible for coordinating with maintenance staff or service providers to ensure the property is well-kept and any issues are addressed promptly. Current Tools: I currently use Excel or similar spreadsheets for managing my Airbnb property. Proficiency in Excel is a must. Ideal Skills and Experience: - Previous experience working as a virtual assistant, particularly in the hospitality sector, is highly desirable. - Excellent communication skills are a must, as you will be interacting with guests on a regular basis. - Basic knowledge of property maintenance is a plus. - Proficiency in Excel is required, and experience with other property management software is a plus. I am looking for someone who is organized, reliable, and has a good understanding o...

I need a sophisticated Excel file capable of performing data analysis. The exact type of analysis may vary, so flexibility in the design and function of the file is key. This project requires an expert in Excel with a strong understanding of data analysis techniques. Ideal skills and experience for this job: - Advanced Excel skills - Strong data analysis expertise - Flexibility in creating a multifunctional Excel file

...should call out numbers and metrics as applicable. Wherever you would make assumptions please call them out appropriately. Specifics as below: _______________________________________________________________________________________________________ Imagine you're responsible for the Marketplace business strategy at Snapdeal. Please prepare a plan and roadmap for (Strategy in PPT and 3Yr Plan in Excel) doubling the revenues in 3 years profitably. Your plan should answer the following questions, but not be limited to that: · How would you drive growth while improving profitability? · Margin architecture to position Snapdeal's marketplace business well in the value eCommerce space · Seller acquisition strategy to achieve optim...

...Number of staff. - ABN and ACN (if available). 3. Output: - Save scraped data into Excel/CSV format. 4. Advanced Capabilities: - Handle scenarios where information is displayed indirectly (e.g., website info via clickable buttons). - Include a "catch-all" mechanism to adapt to potential changes in the webpage structure. - Diagnose and report errors via output logs for debugging. 5. Reliability: - Scrape data accurately even if the website layout varies. - Ensure robust error handling for seamless operation. Deliverables: - Python script with clear instructions on how to run it. - Output logs for error diagnostics. - Scraping results exported in a clean, structured Excel/CSV file. Ideal Developer: - Experience with web scr...

I'm looking for a skilled data analyst with extensive experience in Excel. The primary focus of this role is to create dashboards and reports that help identify sales trends from our sales data. Key Responsibilities: - Create dynamic, user-friendly dashboards in Excel - Generate insightful reports based on sales data - Perform in-depth data analysis Ideal Skills: - Proficient in Excel (including advanced functions and features) - Experience with sales data - Strong analytical skills - Ability to create clear, concise dashboards and reports - Detail-oriented and able to identify trends and anomalies in data.

I have a project that involves organizing customer data. The raw data is currently in PDF documents, and I need it transformed into well-structured Excel spreadsheets. Ideal Skills and Experience: - Proficient in data entry and management - Experienced in working with PDF documents and Excel - Detail-oriented with a focus on accuracy - Capable of delivering organized and actionable insights from raw data

I'm looking for freelancers who can efficiently qualify and follow up on leads generated by our marketing efforts. The leads will be provided in Excel/CSV files. Key Responsibilities: - Qualifying leads based on predetermined criteria - Following up with potential leads to gauge interest and initiate conversation Ideal Qualifications: - Previous sales experience is crucial - Strong communication skills are a must - A good understanding of our industry will be a significant advantage Skills and Experience Required: - Proficiency in Excel/CSV handling - Sales and customer support background - Experience in lead qualification and follow-up tasks

I'm looking for an experienced Excel VBA developer to create a macro that will help me automate repetitive tasks, specifically report generation and data consolidation from my inventory data. Key aspects of the project: - The macro should be able to automate the generation of reports from the data - It should also assist in consolidating data efficiently - The macro will primarily be working with inventory data, so understanding of this type of data will be beneficial Ideal skills for this project include: - Proficiency in Excel and experience in creating macros - Strong understanding of inventory data - Ability to automate tasks efficiently - Experience in report generation and data consolidation

I'm in need of an Excel spreadsheet designed for analyzing operational metrics. The primary functionality of this spreadsheet should be to allow me to input price data and subsequently identify the cheapest option by the kilogram. This project is perfect for someone with a strong background in excel

I am looking for a skilled freelancer to extract specific data from predefined websites and organize it into an Excel spreadsheet. The task is a one-time project focused on collecting structured information for further analysis. Details: Scope: Extract data from a list of targeted websites (these will be provided). The required data fields will also be clearly specified. Output: The extracted data should be neatly organized in an Excel sheet with a well-defined format to ensure clarity and usability. Accuracy: The project requires a high level of attention to detail to ensure data accuracy and completeness. Tools: You can use web scraping tools, scripts, or any other method that ensures efficient and accurate data extraction. What I Expect from You: Experience with we...

I'm looking for a freelancer to help me organize an Excel workbook for bookkeeping and stock and funds analysis. This workbook will track the money pending to be received from franchises to the franchisor. Key Features of the Excel Workbook: - Automated Data Entry: The workbook should be designed to facilitate manual input from users, reducing the likelihood of errors and streamlining the data entry process. - Financial Reporting: The workbook needs to generate financial reports, with a particular emphasis on Income Statements. - Stock Analysis: The workbook should also be capable of analyzing stock, helping me keep track of assets and their value over time. Ideal Skills and Experience: - Proficiency in Excel, with a strong understanding of its more advanced fea...

I am overwhelmed with my business paperwork I have a mid term rent...have a mid term rental business and need assistance in organizing it, entering my expenses, and categorizing my transactions. Key Responsibilities: - Organize my business paperwork - Enter expenses into pre-made Excel spreadsheets - Categorize transactions in my accounting platform I will provide pre-made Excel spreadsheets designed to calculate everything. I need someone who can spare a few hours a month to help me get organized, track my income and expenses accurately, and ensure all transactions are categorized correctly for tax purposes. Ideal Skills: - Proficiency in Excel - Experience with bookkeeping or business administration - Familiarity with accounting platforms I prefer communicatio...

Project Description: I am looking for a skilled freelancer to extract specific data from predefined websites and organize it into an Excel spreadsheet. The task is a one-time project focused on collecting structured information for further analysis. Details: Scope: Extract data from a list of targeted websites (these will be provided). The required data fields will also be clearly specified. Output: The extracted data should be neatly organized in an Excel sheet with a well-defined format to ensure clarity and usability. Accuracy: The project requires a high level of attention to detail to ensure data accuracy and completeness. Tools: You can use web scraping tools, scripts, or any other method that ensures efficient and accurate data extraction. What I Expect from Yo...

I need a proficient excel/google sheets expert to create an interactive sales performance dashboard for me. The dashboard should be able to: - Filter data, design important fields - Reflect important KPIs - Allow multiple users to edit without losing formulas, i prefer google sheets as multiple people need to enter data without loosing formulas. The dashboard will initially be used in google sheets, with an aim to eventually upload data to visual software such as Tableau or PowerBI. (not in this scope) Key Requirements: - Must include a sorting option for date range and geographic regions - Should reflect performance KPIs in interactive graphs/tables etc Please review the sample data I have shared. Prior experience with dashboard creation and performance KPI metrics preferred.

...purposes. The survey will be distributed to prolific participants on Prolific. Key Requirements: - Expertise in designing surveys on Qualtrics - Experience in crafting surveys for Prolific participants - Knowledge of randomization and data input functions in Qualtrics The survey requires pulling data from an excel spreadsheet and using it as input for respondents: the survey includes a list of names that the respondents need to google and copy paste information into a free text (the attached excel spreadsheet provides a templte). Each respondent should be presented with only a portion of the data (e.g. the first 50 entries) but there should be a small amount of overlap, such that each name is presented to at least two participants. The attached document has all the copy ...

Hello, As we have talked, i will need the excel file adjusted + all the questions asked in the ppt resolved in a ppt :)

I require an Excel file with a trend analysis of sales data, along with a PowerPoint presentation summarizing the key findings. The Excel file should include charts and graphs for data visualization. Ideal Skills: - Proficient in Excel, particularly in trend analysis. - Able to create comprehensive and clear PowerPoint presentations. - Experienced in data visualization using charts and graphs. Requirements: - Analyze sales data to identify trends. - Use Excel to create various charts and graphs. - Summarize findings in an easy-to-understand PowerPoint presentation.

As discussed for 1 file. As discussed for 1 file. As discussed for 1 file.

...compile data. • Gather email addresses and build lists. • Prepare and send email correspondence. • Generate simple reports and summaries. • Perform other small, online-based tasks as needed. Requirements: • Basic understanding of online research tools and techniques. • Familiarity with email platforms (e.g., Gmail, Outlook). • Ability to work with spreadsheets and organize data (Google Sheets/Excel). • Attention to detail and strong organizational skills. • Reliable internet connection and own computer. What We Offer: • Flexible working hours. • Training and support provided. • Opportunity to grow with the business. • Starting budget-friendly pay (negotiable, depending on experience). How to Apply: I...

I'm looking for a talented freelancer to create a Power Automate flow for renaming my PDF files stored on OneDrive. The new names should be sourced from a specific column in an Excel sheet. Key requirements: - Develop a Power Automate flow that correctly identifies each PDF file and matches it with its corresponding row in the Excel sheet - Apply the new naming conventions as specified in the Excel sheet Ideal candidates will have: - Strong expertise in Power Automate and Excel integration - Proven experience in automating file management processes If you're efficient, detail-oriented, and can ensure seamless operation of the flow, I'd love to hear from you!

...- After logging into the application, users will see a list of remote computers (e.g. John, Mercury, Violet). Each name corresponds to a remote server with its IP address, VNC port, view-only password and admin password stored in the database. - With every name, the user should see two links - one for accessing the remote computer in view-only mode and another one for accessing the remote computer with admin password. Clicking on the link should initiate a NoVNC session with the respective server, while keeping the server details hidden from the UI. - User should not have the option to enter an IP address and/or port to start a VNC session - The user should not be asked to enter any password for VNC - since the user should be able to access only after logging into the Djan...

PDF to Excel Transcribe only 2 pages and need to maintains table & row

Sales Representative Job Description The ideal candidate for this role will excel in identifying, creating, and closing new opportunities. By employing a consultative sales approach, you will leverage your expertise to identify and qualify leads, ultimately generating sales opportunities with both new and existing customers. Responsibilities 1. Achieve and exceed sales targets consistently. 2. Develop new business opportunities and maintain existing customer accounts. 3. Lead complex negotiations with senior-level executives. 4. Build strong, long-term relationships with customers to foster trust and loyalty. 5. Qualifications Experience: 2-5 years of quota-carrying sales experience. CRM Knowledge: Proficient in using CRM systems to manage leads and customer relationships. Proven...