Excel macro enter data emply cells jobber
tengo 1.5gb y 350 archivos en tablas pdf que necesito pasar a excel, son muchos datos y no tengo el conocimiento.
...existing Excel template to make it more efficient and user-friendly. Currently, I'm having trouble with regular data updates which is time-consuming. This overhaul should include: - Incorporated automated calculations to minimise manual input. - Refined data entry process, making it smoother and more intuitive. - Make the $$ rates per role updatable. - Make the role titles updatable. - Ensure all the lines calculate correctly. Freelancers interested in this job should have substantial experience in Excel, especially in the development of automation, data management, and user-friendly interfaces. Showcasing your experience in similar past projects will be particularly appreciated. The goal here is to create a streamlined Excel template tha...
I'm in need of an accountant who is not only reliable and skilled, but also affordable as I'm on a tight budget. New Comers are welcome. Due is Next Two Days i.e. Friday 11AM IST The main task for this position is bookkeeping using Microsoft Excel for expense tracking. Experience in this field is preferable, especially those who are well-versed in maintaining and organizing spreadsheets, data input and analysis. Newcomers are welcome to pitch their abilities, showcase their Excel expertise and how they can assist in expense tracking efficiently. This job might be a stepping stone for a long term professional relationship for the suitable candidate.
Vennligst Registrer deg eller Logg inn for å se detaljer.
...Screen: - Customers can register themselves on the app using this screen. Data must persist in DB. - This screen must capture all the required information from the customer along with a password. Check for reference. - Do not capture latitude and longitude in the registration. Use the entered address to get the coordinates using Forward Geocoding. - Admin do not need to register. You can pre-register admin details in the DB. Login Screen: - Admin and Customers can use this screen to log in. Home Screen (logged in as admin): - Logout button: To logout from the app. - Fetch all the customers from Core Data and list them on the Home Screen using a Table View with custom cells showing actionable information about them: o Name o Phone o City o
...Customer Relationship Management and Job Management and Scheduling. - This involves data entry, storage, retrieval, add/change/delete functionalities, raising of documents, scheduling and extensive reporting. - It is a multi-user system. - It is used to look up and enter data during telephone conversations with clients, so 100% access, and speed and accuracy in finding relevant information, are of the essence. Database Specification: The relational database is split into a front end and a backend: The Back-end has 24 tables. The largest three related tables currently have approximately 85,000, 60,000 and 30,000 records and are constantly growing. The first and most urgent phase is to transfer the data tables with their relational linkages to a fas...
Develop macro to merge data from workbooks
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. Successful completi...
...someone proficient in data analysis, specifically dealing with significant quantities of survey data. I'm seeking an expert statistician to analyze data from both pre and post-surveys we have conducted. The goal is to identify trends and patterns in our data, compare results between the pre and post surveys, and assess statistical significance. ****Here are some specifics about our data and requirements: -Data includes 83 participants who completed the same three pre and three post-surveys at different times (the participants are random in the Excel document) -Data is based on pre and post-Likert scales -The usage of Excel for the data handling and analysis is necessary; -As a part of the project, I'd like ...
...Python expert capable of parsing an RDF document. The purpose of this task is to extract specific data related to "curriculum alignment". PLEASE NOTE: I did post this job earlier, but I didnt focus on PYTHON, which I should have done. Key Tasks: • Parse through the RDF document to identify curriculum objectives and instructional materials. Aspects of achievement standard --> Content Descriptions --> General Capabilities (Set 1) --> Elaborations --> General Capabilities (set 2) - develop a python script that then can be used for other Learning Areas. For this one, it is attached. • Extract these elements and clearly present them, demonstrating their interconnectedness, in an Excel format. Ideal Skills: • Proficiency in Python...
I am in need of a statistics expert well-versed in SPSS for data analysis and chart creation. Here are the specifics: * You'll find survey results of likert scale in an Excel spreadsheet form. * Your main objective is to enter these data into SPSS for accurate data analysis. * Closely study the correlation between gender and response, as well as the diagnosis and response. * From your analysis, create bar charts to clearly present the findings. A solid knowledge of excel, SPSS, statistical analysis, and data interpretation skills would be crucial for this project. Experience in creating insightful bar charts is a must.
I'm looking for a freelancer with a strong background in statistical analysis and Excel to perform a detailed examination of my numeric data. KEY REQUIREMENTS: - Perform descriptive statistics to analyze my dataset's central tendency, dispersion and shape of distribution. - Proficiency in handling numeric data, with a focus on identifying patterns and interpreting results. - Prior experience with Excel, particularly with its statistical functions, is essential for this project. Your role will be to help understand the dataset through your analysis and provide actionable insights. Proficiency in English and excellent communication skills will be highly valued, as I'll expect a comprehensive report of the data, the methods used, and your f...
...looking for an experienced professional skilled in Microsoft Excel to help with spreadsheet formatting and implementing complex functions. Your responsibilities will include: - Implementing sound and effective conditional formatting to enhance the presentation and ease of use of our spreadsheets. - Adjusting cell borders, shading, and a range of font and text formatting to make the data more readable and visually appealing. - Creating customized functions, although specific formulas are not defined yet, a strong understanding of Excel's capacities (like sum and average, vlookup and hlookup or if statements and logical functions) is required. Qualified candidates must have advanced knowledge of Microsoft Excel, experience in data organization and visual...
I'm looking to partner with a knowledgeab...looking to partner with a knowledgeable freelancer who's adept with R language for a descriptive data analysis project. I need top-notch analysis done on my Excel data files. Essential skills needed for the task: - Proficient knowledge of R language - Familiarity with Excel data - Strong analytic abilities with experience in descriptive data analysis - Ability to deliver results accurately and promptly The ideal candidate would be required to sift through my Excel data files and perform a thorough descriptive data analysis using R. It's not just about performing the analysis, you must also be able to meaningfully interpret the data and provide clear reports. ...
I am in need of a meticulous professional with strong attention to detail for a data entry project. Your task will be primarily focused on entering data into spreadsheets from handwritten English documents. Duties would include: - Converting handwritten documents to electronic data - Ensuring accuracy and consistency of data - Commitment to meeting a deadline within a month Required skills and experience: - Proficient in English for clear understanding of handwritten documents - Strong Excel skills for data entry and management - Proven accuracy in prior data entry work - Ability to meet deadlines. If you meet these requirements, have a knack for efficiency, can keep data confidential and have relevant prior experience, please p...
I am seeking a Microsoft Excel expert to enhance the functionality and calculations of an existing test and to add more data. The task specifically involves: - Augmenting the functionality: I would like the Excel test to include summation, average calculations, and percentage calculations. An insightful understanding of these functions is needed. - Incorporating additional data: The tests should be widened to include more data, specifically text data and numeric data. Extreme attention to detail is highly required for this part. Ideal candidates will have substantial experience working with Excel, handling engine functions, and dealing with different data types. Knowledge of mathematical functions, precise data entry,...
I'm seeking the assistance of an experienced data entry professional who can handle a project that will involve primarily text and numerical data. What is essential for this job: - Proficiency in data entry with an emphasis on detail and accuracy - Experience is a must. Successful applicants should highlight their previous data entry projects, especially those involving spreadsheet data management. - Knowledge of MS Excel or similar spreadsheet software is a must to organize data Key Requirements: - The data primarily comprises text and numerical data. The format required for these entries will be in spreadsheets. - The successful freelancer must demonstrate a rich background in handling similar projects. - A keen eye ...
I'm looking for an expert mobile app developer who can build a golf stat tracking application for our small community, exclusive to the iOS platform. It's a simple, functional and user-oriented app, designed for a niche audience. Key Deliverables: - Functionality for tracking golf stats throughout the season. - Mechanism to enter accomplishments by dates in an easy and user-friendly manner. - In-app group alert notifications system that advises the community when accomplishments are registered. Though I'm undecided on user authentication and profiles, I encourage developers bidding to provide their recommendations on ensuring user security without compromising on usability. Ideal Profile: - Experienced in mobile (iOS specific) app development. - A strong understand...
Looking for someone who can assign the correct number of leads column to the right number in the zip code column. I have a video here instructing exactly what I need. Essentially, we have two lists of zip codes and we need the first list of zip codes align to the number of leads we have assigned to list #2 of zip codes.
I am looking for an expert in MS Excel and navigating a website. We will provide a list of colleges and universities in the United States, 955 of them. Got to and type the name of the school, then type “athletics staff directory” and hit enter/search. The first site listed will be the staff directory for the athletic department. Scroll down to the Men’s Basketball staff (make sure it is Men's Basketball and not Women's Basketball). For every member of the Men’s Basketball Staff who has an email address listed, you need to enter that staff member’s information (School Name, First Name, Last Name, Title, Email Address) into the spreadsheet. This is a single project that would need to be completed each year. Pay would be made upo...
This project requires a design professional who can create an engaging, modern, and clean landing page that will appeal to both our existing and potential new customers. Key Objectives: - The primary goal...Significant experience in creating landing pages that convert. - Proficiency in modern and clean design aesthetics. - Knowing how to balance aesthetics with functionality. - An excellent understanding of user experience. Invest time in understanding our services and products so that you can use our brand voice and values in your design. This is a fantastic opportunity for creative designers who excel in creating high converting landing pages. I am excited to see your innovative ideas in action! You will also be required to create landing page content as well (can use chatgpt ...
...comprehensive investigation should be based on specific equations that will be provided from a relevant paper. Duties and Responsibilities: - Acquire a thorough understanding of the project by reviewing the provided research paper - Use MATLAB or Excel to conduct a detailed, step-by-step sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis - Proficiency in using MATLAB or Excel for scientific computations - Strong understanding of Pressure Swing Adsorption processes - Knowledge of CO2 capture using zeolite 13X - Excellent documentation and report writing skills - Ability to interpret a...
Data Collection Excel Project I am looking for a freelancer who can help me with a data collection project. The project requirements are as follows: Type of data to be collected: - Sales data Source of the data: - Public records Organization of the data in the excel sheet: - By date Ideal Skills and Experience: - Proficiency in data collection and organization using Microsoft Excel - Strong attention to detail and accuracy in data entry - Familiarity with public records and their sources - Ability to work efficiently and meet project deadlines If you have previous experience in similar data collection projects and possess the necessary skills, please submit your proposal.
I am seeking a skilled Python developer who can create a script tool that can s...developer who can create a script tool that can scan and assess both grade sheets and answer bubble sheets. Here's what I need: - A system that can accurately scan different types of sheets and convert the data into actionable information. - All assessments must be stored in an Excel format, organized by school. - In addition to other relevant details, I need the tool to extract class data from the scanned sheets. - read paper by scanner(desktop_application) Experience with OCR (Optical Character Recognition) would be a major advantage, as well as a firm understanding of data management and Excel formats. Proficiency in Python is absolutely necessary. Please ensure y...
I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term collaboration.
I need an experienced data entry professional to help me with an Excel task. The task will be centered around accurately entering data, with no more than 10 columns and 50 rows. Your responsibilities will include: - Accurate data entry into excel forms, resumes, or sheets - Understanding data entry forms and capturing information efficiently - Ensuring accurate, up-to-date entry of the data To excel in this role, you should be proficient in Excel and have meticulous attention to detail. Essential skills needed for this job include: - Strong Excel skills - Accuracy and attention to detail - Strong data entry skills By the end of this project, I expect to have an accurate and updated Excel sheet. Knowled...
I need a competent developer to create a Material Management System that specifically focuses on an Inword and Outword System. This system is aimed to efficiently manage and track our internal communication and revisions of documents. Main Features Needed: - Inventory tracking - Purchase order management - Document storage and organization Ideal Skills: - Proven experience in developing robust management systems - Proficiency in coding and database management - Superior understanding of material management principles - Attention to detail and excellent problem-solving skills. This project requires a keen eye for detail and a robust understanding of how to manage materials effectively. With your help, we can streamline our internal processes and improve our overall productivity.
I am in need of an expert Word VBA programmer to: ...documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the website (PDF to WORD Converter) or free API (similar like quality). The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your bids. Please look attachment.
I am seeking an experienced, proactive sales representative skilled in SAS software and cold calling to drive sales among small to medium-sized businesses. The successful applicant needs to excel in prospecting and presenting, and have an impressive track record of exceeding targets. The key responsibilities will include: - Making a high number of sales calls each day - Converting a substantial number of leads to sales The ideal applicant will have: - Proven knowledge of SAS software - Excellent interpersonal skills - Extensive experience in cold calling - A previous B2B sales role is preferred Let's smash these targets together. Apply now! Strictly commissioned based on 20%, with the possibility for long-term employment if targets are met.
I am looking for a freelancer proficient in Excel who can efficiently handle data entry tasks. These tasks involve inserting text, numbers, and dates into Excel tables for a set of up to five tables. Each table will feature six columns and a variable number of rows. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in data entry - High attention to detail - Familiarity with text, numerical, and date-focused data - Ability to work within specific formats and structures. Your role is critical in ensuring these tables are filled accurately and promptly. Clear communication and commitment to the deadline are also imperative in this project.
For my evolving project, I am looking for a freelancer adept at data extraction and conversion from a webstore to CSV. Your task will be: - Convert an online store’s catalogue, currently in Excel format, into a CSV file. - The CSV file needs to include the following fields: Product Name, Product Price, Product Specifications, Picture URL, and Product Category. - Specifically, full resolution images are required for the Picture URLs. To align with my requirements, you need to have: - Strong Excel skills - Experience in data extraction - Familiarity with CSV file format - Understanding of image URL extraction and handling. This is an exciting opportunity to demonstrate your technical prowess in data manipulation and we look forward to potential co...
Looking for an expert who can assist with Excel automation, specifically for data analysis purposes. Proficiency in Excel 2016 is crucial. - Skills Needed: * In-depth knowledge of Excel 2016 * Proven experience in automating Excel functions * Ability to troubleshoot and unlock password-protected files * Strong understanding of data analysis techniques The project involves enhancing the efficiency of routine tasks around data analysis. As I have elected not to provide specifics on the types of data analysis procedures to be automated, I would appreciate your input on leveraging the capabilities of Excel to streamline these processes. Please note, we will be dealing with a password-protected file, so a solid experien...
I require a dedicated professional who can take a series of scanned, handwritten PDF files and accurately translate them into an Excel format. The potential freelancer will need: The documents strictly contain textual data. Please note, it is not clear whether the documents contain discrete sections like tables, headers, footers, or they follow a simple paragraph style, so flexibility in dealing with various scenarios is essential. Excellent knowledge of Excel and strong data organization skills are crucial for this project, as my ultimate goal is a clean, easily readable, and sortable Excel document.
...Word or Excel files) can be opened without a hitch once saved. The ideal candidate for this job should: - Be proficient with Microsoft power automate, Outlook and OneDrive. - Have experience with automating tasks related to email and cloud storage. - Understand and remedy potential issues related to file accessibility after storage. Your role will involve: - Creating a streamlined process or application to automate the saving of email attachments to OneDrive. - Ensuring the saved files remain accessible and openable. - Testing the process to ensure all PDF, Word, and Excel attachments from Outlook seamlessly transition to OneDrive and remain functional. A successful delivery of this project means I'd be able to receive an email in Outlook, have its attachments (...
I need to convert an Excel file into a Google Sheets document. The main objective is to facilitate data sharing with colleagues and partners efficiently, hence the need for the conversion. Key Responsibilities: - Convert Excel files to Google Sheets without changing the data structure - Ensure data integrity during the conversion process The ideal candidate for this task should have: - Proficiency in Microsoft Excel and Google Sheets - Experience with data management and conversion - Great attention to details ensuring no data loss or distortion occurs during the conversion No need to worry about macros, as there are none in the original Excel file. This should be a straightforward conversion task. Please only apply if you...
I am in need of an education verification specialist for a preemployment opportunity based in Hanover. Though it is not explicitly stated, thoroughness is an implied demand of this position. Either degree, diploma or course verifi...Include any relevant experience in education verification. - Provide a track record of their past work, if any. - Draft a detailed project proposal to demonstrate an understanding of what the project demands. Although the format for the education verification information wasn't specified, preference would be given to freelancers who can work and are versatile across all formats (PDF, Word document, Excel spreadsheet). Applicants must possess good organizational skills, attention to detail, and the ability to work effectively under the pressure of t...
I'm in need of an expert in Excel with a strong command of mathematical calculations, conditional formatting, and data analysis. You will be primarily working with numeric and date/time data. Key requirements: - Mastery of mathematical calculations within Excel - Proficiency in using conditional formatting - Solid understanding of data analysis techniques The outcome of this role involves: - Generating comprehensive reports from complex data - Automating tasks for increased efficiency Experience in automating tasks and generating reports within Excel is highly valued.
Vennligst Registrer deg eller Logg inn for å se detaljer.
I need a proficient Excel professional to handle some text data entry tasks, specifically focusing on detailed product descriptions. Your main responsibility will be: - Inputting product specifications into Excel spreadsheets The ideal candidate must have a keen attention to detail and excellent Excel skills. Knowledge in product specifications will be a great advantage. Please submit your bid with any relevant data entry experience and we can discuss further.
I require an experienced data entry specialist with proficiency in Microsoft Excel to assist me. The tasks involve: - Inputting and organizing relatively small amounts of data (less than 100 rows) - Analyzing data and generating reports Ideally, the freelancer should be familiar with Excel formulas and macros. Good data interpretation skills and attention to detail are needed to accurately analyze and reports the results. A capacity for hard work is also appreciated, as I am dedicated to this work and will need someone who can keep up.
I'm in need of a Virtual Assistant based in South America who can assist with cold calling businesses. Your primary responsibility will be to reach out and set appointments for me. Here's what I'm looking for: 1. Fluency in English language. 2. Capable of doing outbound cold c...skills. 4. Proven experience in appointment setting, preferably from a B2B context, is a must. 5. Must have the ability to persuade and deal with objections professionally. 6. Should be self-directed, assertive and have the ability to work in a fast-paced environment. Your success in this role will be measured by the number of appointments you can set. This is a fantastic opportunity for those who excel in telemarketing and appointment setting. If this matches your skills and experience, I...
I am in need of a talented PCB designer who can assist with the basic design of a circuit board. This project's main aim is to replace an existing circuit board. Details related to the project: • This is a fairly simple task with only a few components involved, making it very suitable for those who excel in basic PCB design. • I have a schematic diagram that I will provide. Your task will just be to take that schematic and translate it into a PCB design. Ideal Skills and Experience: • Extensive experience with PCB design • Familiarity with basic components • Ability to translate schematics into PCB designs • Strong attention to detail This project is a fantastic opportunity for someone looking to showcase their PCB design skills on a basic yet...
I hope this message finds you well. We are reaching out from Immortal Ventures a dynamic and forward-thinking IT company, to share an exciting opportunity for skilled freelancers in the technology sector. Our company specializes in delivering cutting-edge IT solutions, including software development, web design, mobile app development, and more. As we aim to expand our project portfolio and enter new markets, we are looking for talented individuals to join us on a commission-based partnership. Opportunity Overview: We are seeking a proactive and motivated freelancer to assist in acquiring new IT projects. This role is ideal for someone with a strong network, excellent communication skills, and a keen eye for identifying potential business opportunities in the IT industry. The sele...
I'm in need of a skilled professional who can manage the daily tasks involved in my accounting and bookkeeping. Your responsibilities will include: - Handling accounts payable - Reconciling bank statements - Generating financial reports I use QuickBooks, Xero, and Excel spreadsheets in my daily operations. Therefore, experience and proficiency in these tools are highly required. Experience with daily accounting tasks is a big plus. Attention to detail, high reliability, and a keen understanding of finance protocols will be ideal for this role.
I'm urgently seeking a talented developer (or team) to create a comprehensive Android and iOS app, along with a corresponding website, for my wholesale pharmaceutical business. The main features of the app and site should include: - Daily stock upload: The system must have an interface that supports daily stock uploads using Excel files, ensuring seamless updates on available products. - Order Placement: Customers should be able to browse my products, fill their baskets, and place their orders with ease. - User Registration and Login: Users should be able to create profiles, providing details such as contact information, billing/shipping addresses, and prescription details. Logged-in users should have the option to track their orders and view order history. Freelancers appl...
I need an expert in Excel who can optimize my current dashboard. Specific tasks will include: - Enhancing the data analysis function of the dashboard - Improving the visualization of sales and HR manpower data The data will be updated on a monthly basis. Therefore, the dashboard should be designed for easy updating and automation. If you have relevant experience in designing and optimizing Excel dashboards, especially for sales and HR data analysis, your skills are highly desirable for this project.
I'm seeking a skilled professional who can diligently perform data entry tasks. The prime responsibilities will be: - To accurately input text data into an Excel spreadsheet and web-based forms. - The task requires complete fluency in English. - The data needs to be arranged according to a specific, custom layout in the Excel spreadsheet, the details for which will be provided during the project. The ideal freelancer would be adept in data management, ensuring accuracy, and should possess advanced Excel skills. Prior experience in specified data entry and a thorough understanding of English is a must for this project.
...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...
