Excel spreadsheet vba data entry formpekerjaan

...looking for a freelancer who can help me with gathering current data on Open Interest and Volume from the NSE and BSE option chain. The ideal candidate should have experience in data collection and analysis, with a strong knowledge of the stock market and options trading. Specific requirements for the project include: - Gathering current data on Open Interest and Volume from the NSE and BSE option chain - Presenting the data in web page with filters - Ensuring that the live data is up-to-time and accurate The freelancer should have the following skills and experience: - Proficiency in data collection and analysis - Strong knowledge of the stock market and options trading - Experience working with Excel and creating tables for data...

...professional to develop a financial model using Excel that relies on total return over a variable number of days and volatility for stock selection and risk differentiation. This model will employ adaptive allocation methods. Ideal qualifications: - Deep knowledge and experience in financial modelling and analysis - Proficiency in Excel - Understanding of portfolio selection and allocation - Familiarity with financial metrics such as Return on Investment (ROI), Standard Deviation, and Sharpe Ratio Project details: - The model should incorporate total return over a flexible duration for stock selection. - Volatility should serve as the basis for managing risk within the portfolio. - The financial model will need to be updated with new data on a daily basis. If...

I'm seeking an Excel expert who can design and build an org chart that visualizes my company's structure. The primary requirements of the project are: - Creating an innovative org chart with 5 to 10 levels of hierarchy. This should lucidly identify reporting relationships and aid in future workforce planning. - Chart must be dynamic and editable, allowing easy updates when there are organizational changes or expansions. Ideal candidates for this project should demonstrate: - Proficient knowledge and experience with Excel. - Previous examples of detailed, dynamic org charts created in Excel. - Strong understanding of organizational structures and how to best represent them visually. - Excellent attention to detail and accuracy.

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future...

I am in need of an Excel guru to assist with my project involving fewer than 5 sheets. Help is needed to organize and format data effectively. Beyond just basic formatting, the project also requires the use of advanced formulas, specifically VLOOKUP and INDEX MATCH. The ideal freelancer for this task should have: - Expert knowledge in Excel formatting and data organization - Proven experience in creating and using advanced Excel formulas like VLOOKUP or INDEX MATCH - Strong attention to detail and focus on data accuracy - The ability to complete tasks efficiently and on time. Rest assured, if this project is successful, there could be more opportunities for similar jobs in the future. Looking forward to your bids.

I'm looking for a proficient Excel expert with extensive experience in data cleaning to assist with a key task. Your primary responsibilities will include: - Identifying and removing duplicate data entries in Excel, Data cleaning - Creating Pivot tables and data aggregations - Efficient dashboard and visuals that showcases trends and patterns via graphical data representation. Please only bid if you are seasoned in creating pivot tables, using Power query and generating visually appealing data insights. Precision and attention to detail are essential skills for this project.

...skilled developer to create a data visualization webpage, similar to Google Earth. Ideal candidates should have a strong background in JavaScript, Python, and HTML/CSS. Key components: - Design: I have a specific design in mind for the webpage, details of which will be shared with the selected freelancer. - Data: The website's function will be to display GPS coordinates (latitude and longitude) alongside relevant site information when hovered over. This would include Site Name, Site Description, and Site Statistics. - Source: All required data is contained in an Excel sheet which I will provide. The ideal freelancer would have experience in data visualization, and expertise in the programming languages mentioned. Additionally, a proficiency i...

I'm in need of data entry professionals who have exceptional skills in gathering text data from online resources and flawlessly entering it onto a spreadsheet. Key Responsibilities: - Sourcing text data from specified online resources - Accurately entering data onto a spreadsheet with minimal errors - Ensuring data entries are formatted correctly and uniformly within the spreadsheet Ideal Skills and Experience: - Proficiency in using spreadsheets: Microsoft Excel or an equivalent is required - Strong attention to detail: This is crucial to avoid mistakes in data entry - Experience in online research: Being able to quickly and efficiently find reliable online resources - Previous experience in ...

We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.

...writing product data, and proficient in managing new product systems. The ideal candidate should also be capable of creating accurate and comprehensible spreadsheets. I need an assistant to take our inhouse recipes we have written down and transfer the data onto a refined PDF formatted deck to sell as an individual recipe, and upload each recipe onto our Shopify store. We need about 20-30 recipes completed each day. I'm looking to hire someone to commit to about 6 hours a day, 5 days per week. completing about 4-5 recipes per hour. we have about 150 that we need uploaded in the next 7 days. We'll be writting and creating about 10 new recipes each day then after. Your responsibilities will include, but are not limited to: - Creating daily operational reports...

Hi Lin F., you have completed a scraping job for me for the last two years, I need it done again. Please have a look and apply: https://www.freelancer.com/projects/excel/Scrape-data-from-unprotected-URL

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'm seeking a talented architect to design a modern retail store with a prime focus on a outside building appearance. The project demands an innovative thinker who can sketch out a future-focused retail premise that not only wows customers upon entry but ensures functionality and practicality within the store’s operation. We a Skills and Experience: - Proven experience in retail architecture (portfolio required) - Familiarity with modern design principles - Proficiency in design software (AutoCAD, SketchUp or similar) Responsibilities: - Developing an architectural design for a modern retail store - Concentrating on an effective cashier counter area design - Considering customer flow, space utilization, and aesthetics. I look forward to your innovative design solutio...

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.

Logo needed for brand offering Tow Service Designs should include iconic logo and text. *Important; only *creative and original* designs that you yourself have created should be entered. *Please do not dupli...be identified and either commonly and freely available or be included with the design files. > Submissions should be made as soon as possible, as they need to be reviewed by multiple parties before a decision is made. Early submissions will have a greater chance of being reviewed and selected. > Award of the contest prize will convey all ownership rights to buyer. All files used to create the entry should be delivered when prize is awarded. Mockup files can be linked if necessary. If you have any questions, please ask. We appreciate your help! All entries are welc...

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.

We are a security camera distributor local distributor located in California USA. We require a professional who has knowledge of HTML and proficient with adding products from other websites to our site. You will required be edit images and descriptions. Graphic design skills is high recommended when applying. We will require you to check our vendor sites for products that are not already on our site, if it's on our vendor site and not on our own site then we will add the product. We are willing to pay per product added since there are thousands of products that need to be added. We use x-cart shopping cart software. Contact me for more details

...writer to summarise domestic violence incidents on an existing Excel spreadsheet. The document will serve as a detailed historical record of events for various professionals including lawyers, therapists, law enforcement and anyone else who might be involved. Key Details: - I require a proficient writer to edit and rewrite summaries of events which are already on an Excel timeline sheet (also on Airtable if writer prefers). - Add key words to summaries. - There are more than 21 instances that need revisiting. Ideal Skills For This Job: - In-depth knowledge of Family Domestic Violence Law. - Excellent writing, editing, and proofreading skills. - Ability to translate legal jargon into easy-to-understand language. - Experience with Excel is a plus. Your ta...

...question I'm in need of a reliable and efficient virtual assistant to help me with online job applications. Payment will be made per job application submitted. Your tasks will revolve around: • Finding suitable job postings in the finance industry, specifically for entry-level roles. • Filling out and submitting online applications on my behalf. • Keeping track of all job applications submitted. The ideal assistant should have: • Proficiency in navigating online job platforms. • Knowledge and understanding of the finance industry and entry-level roles. • Excellent attention to detail to accurately represent my credentials. • Strong organizational skills to keep track of the applications. • Prior experience in virtual support...

Looking for an expert in web scraping and data transfer to copy both text content and images from one website to another. Responsibilities would include: - Copy listings from one site to another. - Copying corresponding images tied to the text - Ensuring all data is accurately transferred with the original integrity maintained Please note, I do not have access to the source website, so the ability to effectively extract data without such access is required. Ideal candidates should have proven experience in web scraping, data transfer, and data-entry tasks. Familiarity with setting up automated processes would be a plus.

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...

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 require an expert in Google Sheets and ChatGPT to create a system where column A holds factual statements, and column B generates a ...from column A changing the outcome. Ideal Skills: - Google Sheets proficiency - Experience with OpenAI's ChatGPT or similar AI based conversation models - Strong understanding of how to integrate API-based response generators into spreadsheets - Ability to execute tasks seamlessly without creating duplicates or errors. Experience: - Past projects involving integration of AI chat models and spreadsheet software will be advantageous. Note: There is no need for verification of the uniqueness of responses, so your focus should solely be on generating these responses efficiently. If posible I need this for TODAY! just send me a video showing...

I'm looking for a dependable Virtual Assistant with an intermediate experience level, proficient in data entry and administrative work. Key responsibilities will include: -Content creation: This could involve writing blog posts, articles, social media posts, or creating graphics, presentations, or videos. - Administrative tasks: This includes managing emails, scheduling appointments, organizing calendars -Social media management: Help with scheduling posts, responding to comments or messages, and analyzing social media metrics. -Project management: Assist with project coordination, setting up workflows, assigning tasks, and ensuring deadlines are met. -Personal tasks: making reservations, or managing household expenses. Other Requirements: - You may be expected to ...

We need help with an easy, but time consuming process, to estimate flooring installation for commercial properties. We provide training of the step by step proc...calculate quantities based on architectural drawings, which is called take-off. Skills and experience necessary for this job include: - Willing to learn and skilled with computers. Need one large screen as this work involves opening large images that need to be zoomed in and out back and forth. - Preferably (not required) entry level skills for flooring estimation especially in commercial properties - We provide access to in-house web application that handles all the data entry. - No need to submit work any paperwork nor send emails or prepare documents. Everything resides in the webapp. Availability bet...

...responsibilities will include: - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. To excel in this role, you'll need to work approximately 6 hours a day, 6 days a week. This schedule is designed to ensure continuity in my operations while allowing flexibility for you. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. Your ability to harness the full potential of these tools is crucial. - Familiarity with accounting ...

...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 unders...

Hi everyone, I will need a computer network analyst (ideally with cisco certification) with experience in measuring network delays, calculate jitter (with tools povided), do some graphs in excel etc. Analytical specific requirements in chat Deadline: 4/4 Budget: $20 USD

...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 o...

I need an experienced WordPress developer who can skilfully implement a private page utilizing the WPForm plugin. The content that users should be able to submit includes text fields, image fields, and attachment fields, among others. Al...image fields, and attachment fields, among others. Although this page will not be publicly accessible, there will be multiple types of users with special access. The ideal candidate should possess: - Profound knowledge of WordPress and WPForm plugin - Understanding of access restriction and user roles in WordPress - Capability to create versatile fields for user submission - Experience in ensuring data privacy and user-access control - Attention to detail and prompt communication skills Please include examples of similar work in your proposal. ...

I need professional help to design invoices and various internal and external documents crucial ...crucial for operating my business. The primary use for these documents will be communication. These business documents should incorporate: - My company logo - Field forms for data entry - Company contact information - Specific customer/vendor information - Job-specific requirements Ideally, freelancers bidding for this project should have experience in graphic design, specifically in creating business documents using the 3rd party software called Precision Forms by Bottomline. Understanding of corporate branding and attention to detail is critical. Familiarity with the required elements such as fields for data entry, placement of logos, inclusion of contact infor...

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!

I need a paralegal to download bankruptcy application for Chapter 7 and form 103B. And fill it out. Very simple Very simple I do not have any cash or cash assets or nothing completely nothing only debt owed. I have only Social Security income and $1000 in the bank. Completely homeless I don't need representation, I will be representing myself. I need you to find all my creditors and who I owe 3 major credit reporting agencies. I probably have less than 10 creditors

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 fo...

I need a diligent freelancer who can manage the task of entering image data. Key Responsibilities: - Entry of 100-500 images into Word. The ideal candidate will have: - Strong experience with data entry. - High proficiency in using Word. - Attention to detail for accuracy. - Ability to handle image data entries. Please note that proficiency and speed are paramount in this task. This is a short-term project with potential for future similar projects.

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 looking for someone who can help create a digital copy of a 100 page PDF document. Key responsibilities: - Efficient and accurate retyping of content from PDF to digital format - Maintaining original formatting, headings, and overall structure Ideal candidate skills: - Strong typing and data entry abilities - Experience with retyping PDF documents - Detail-oriented with excellent proofreading skills - Ability to adhere to deadlines - Proficiency in English language for any necessary comprehension Please note, this work will require reading and typing the content as it appears on the PDF files, manual effort is necessary. This is for those who take pleasure in typing and reformatting documents. Please provide samples of prior work if possible. Looking forward t...

1. We need a JavaScript/HTML application that renders a web form. 2. The application must be deployed as a static website in an AWS S3 bucket (no other technology) 3. The architecture of the system is 4. The fields in the web form should be configurable based on 5. The webform must have a CSS where various web elements must have styles associated with it 6. A user who loads the web form and enters data, on clicking submit must be written into a second AWS bucket (no other technology). The data file should be similar to . The number is the epoch

...resulting in ABC company not finding suitable talents in actually planned costs and hampering the hiring, the focus here is to find a viable solution to hire more talents with in the time line of December 2025. And why this is Global Issue?: This is making the clients to rethink upon providing new business in ROW. I am in midst of completing domain discussions and PESTEL analysis, also in search of data related to the same. Possible Solutions: • Training and upskilling the technically qualified refugees. • Connecting and partnering with local universities and tab the local talent. • Connecting and partnering with local universities to implement the curriculum with required skills. • Moving the talents from offshore to onsite Articulation: • Issue Id...

Sila Dafter atau Log masuk untuk melihat butiran.

As a professional involved in the field of data analytics, I'm in need of an expert to develop advanced lab 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 an...

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 s...

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 trou...

Need to upgrade my existing excel macro, very simple project

I need a diligent freelancer who can manage the task of entering image data. Key Responsibilities: - Entry of 100-500 images into Word. The ideal candidate will have: - Strong experience with data entry. - High proficiency in using Word. - Attention to detail for accuracy. - Ability to handle image data entries. Please note that proficiency and speed are paramount in this task. This is a short-term project with potential for future similar projects.

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.