How to automate excel spreadsheetpráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.
...PyAutoGUI to control keyboard inputs, with a specific focus on interacting with a Firefox web page. Key Requirements: This is basically like a macro, or autohotkey, whoever finishes first with working code, wins. I will text the code in chronological order. - The script should use two hot keys #7 for one pattern of tabs and keyboard maneuvers Primarily tab, tab, tab, (then a spacebar for other keyboard method to select) I only want to use keyboard to get to a set point on a specific static website. , I do not want any mouse clicks. The second hotkey #9 will select a different group of item selects on that same exact web page. You must work with the user to determine how focus will be secured before you can make the hotkey or key...
I'm seeking a proficient individual who can efficiently execute data entry tasks. The primary task will be the accurate transcription and input of both numerical and text-based data from scanned documents into Excel spreadsheets, requiring: - High attention to detail for accurate data entry - Ability to transcribe both numerical and text data - Proficiency with Excel and its functionalities - Previous experience with data entry and analysis from scanned documents Your knowledge and precision in data entry will play a crucial role in ensuring data accuracy, which is integral to the success of this project.
I'm seeking a freelancer who is adept at typing fo...for a task that involves transcribing handwritten notes into Excel. The legibility of the handwriting is average, so this job demands patience, careful observance, and excellent data entry skills. - Your task would be to transcribe the data from handwritten notes into an Excel file. - The content you'd be dealing with primarily includes text. I'd prefer individuals who have previous experience in data entry, especially tasks that require extracting data from handwritten sources, and are proficient in using Excel. Attention to detail is a must, as accuracy is paramount in this job. Your ability to decipher moderately legible handwriting would be a great advantage. Please bring a...
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to...
I'm seeking a professional who can help me leverage Azure OCR Document Intelligence in order to automate the data entry process for a set of invoices. Requirements: - Utilize Azure OCR for extracting text from invoices - Implement an automated system for data entry based on the extracted text Integration: - I require the system to be integrated with my accounting software. Ideal Skills: - Proficiency in working with Azure OCR Document Intelligence - Strong experience in automating data entry processes - Prior work in accounting software integration is a plus
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
The attached PDF lists every musician who played for the St. Louis Symphony between 1907-1908 and 1978-1979. I would like the data copied into a spreadsheet. To illustrate the desired format, I have entered the first 11 rows into the attached spreadsheet. The PDF is 34 pages long and I estimate it lists 1500 musicians. I would estimate the job will take 15 person-hours to complete. Thanks for your consideration!
I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO
I need an expert in data capturing to mine specific information from websites and organize it efficiently into spreadsheets. The ideal candidate should be meticulous and comfortable with the following: - Data Capturing: The primary task involves extracting and compiling data from various websites. - Web Research: Ability to navigate and find required data efficiently. - Spreadsheet Proficiency: Experience with spreadsheets and data organization. Please bid if you have a strong eye for detail and a proven track record in data entry and web research.
...around 50 image folders with less then 1000 files in jpg format, each with GPS metadata. I need an expert to convert this metadata into Google Earth points. Key requirements: - **Automatic Generation:** The points should be created by extracting metadata from the images, not manually added. - **Output Format:** I need the final points to be saved in KML format, for easy integration into Google Earth. - **Quality Assurance:** Accuracy is key, the points should correctly represent the image positions. They will be broken into 3 colours depending on the date they were taken, the data is in the folder name and file name. Ideal Skills: - **GPS Data Handling:** Understanding of how to extract and work with GPS metadata from images. - **Google Earth Profi...
...challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, CSS, and JavaScript to understand the struct...
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
...S3 storage, RDS databases, and Elasticache for memcached. Currently, we're managing our infrastructure manually, so we're looking to transition to Infrastructure-as-code, specifically Terraform. Although we already have a template that implements EKS, we need enhancements and further integration of the other AWS services. Key requirements and responsibilities include: - Proficiency in AWS services, with a focus on EC2, S3, RDS, and Elasticache - Experience in configuring and managing infrastructure with Terraform - Ability to enhance and integrate an existing EKS template - Implementing Infrastructure-as-code best practices - Working to streamline and automate infrastructure management - Prior experience with DevOps practices and tools Idea...
I require an experienced data analyst conversant with Excel to create a detailed spreadsheet and comprehendible report about compression pay between LPN & RN nurses, as well as nurse supervisors. Key data points to include: - Hourly pay rates of each role - Years of experience in each position - Total number of employees in each role - Comparison of compression pay between the nurse employees and nurse supervisors The compression pay should be calculated using a ratio comparison method, highlighting the variation in detail. I am also looking for a detailed analysis in the report explaining the compression shown. Required skills: - Proficient in Microsoft excel - Experience in generating analytical reports - Strong attention to detail ...
Hello, I'm looking for someone to create a Google Sheets spreadsheet filled with YouTube URLs that meet the following criteria: * License: Must be Creative Commons licensed. * Visuals: - Full face visible, speaking directly to the camera; the rest of the body can be included. - Only one person in the shot and speaking throughout the entire video (no cuts to other people). * Quality: High definition (HD or better), not grainy. * Editing: Minimal editing; should be a single take (intro and fade out are acceptable). * Audio: Clear speech; background noise or music is okay if it does not overpower the speech. * Occlusions: No obstructions, such as hands or microphones, in front of the face. * Emotion: Videos displaying significant emotional exp...
...need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - Expertise in Amazon SEO and PPC ads, with a specific focus on product listing optimization. - Experience with book listing, preferably in the coloring books category. - Proven track record in improving visibility and sales on Amazon with optimized product listings. Your responsibilities will include: - Optimizing the titles, descriptions, and other pertinent details in each coloring book listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 alg...
... - **File Format**: The directory should be in Excel (.xlsx) and easily editable. - **Data Required**: The spreadsheet should include Business Name, Address, Phone Number, Email (if available), and any other relevant contact details. - **Usage**: I'll be using this directory for sales lead generation, so it's crucial that all the information is up-to-date and well-organized. - **Categorization**: The businesses should be categorized by specific industry (e.g., Hospitality, Retail) to help with targeted marketing efforts. I would like this done for the retail/hospitality e.g. butchers, newsagents, cafes, and convenience stores. We are not targeting large chains or franchisees. **Ideal Freelancer**: - **Excel Expert**: Proficiency in Exc...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
...using Zoho CRM to manage the patients who want to seek second medical opinion from expert doctors in India . This is the ideal workflow that we want to implement 1. Patient submits basic information like name, email, and location via Zoho Forms 2. The information is saved to Zoho CRM 3. The Patient is sent an invite to the portal 4. The patient sets up their account. The patient can view their treatment progress and edit their details. For the treatment progress, it needs to look like a timeline or steps that display this user journey. Something like this: 5. The patient is given an option to book a call. They must submit their medical records and a brief description of their illness. They are given the option to book either
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in...
...programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires stro...
...expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skill...
I require assistance to set up a cronjob using Django cron-tab for my professional project. The main purpose is to automate tasks, specifically to - Send scheduled, automated reminder notifications to our clients. Ideal Skills and Experience: - Expertise in Django and cron-tab - Experience in setting up automated scheduled notifications - Knowledge on programming for customer interaction. Need simply a person to help me with enabling already set-up cronjob in my Django project(professional work).
...professional to diligently run through LinkedIn, identifying and documenting HR higher-ups within Fortune 500 companies. Ideally, I'm interested in Director of HR or VP of People roles. Your main task will involve: 1. Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulou...
To help manage my work efficiently, I am in need of a proficient virtual assistant. Using Google Sheets, your initial task entails creating a spreadsheet listing festivals held in Louisiana and Mississippi. This sheet should include: - Festival names - Festival locations - Festival dates Apart from spreadsheet creation, I'll also require assistance with customer service tasks. This role best fits someone that is skilled in utilizing Google Sheets and who possesses excellent customer service skills. Prior experience in a similar role is a bonus, but not a must.
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
...skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communicati...
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a good fit for this role.
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
One excel file with macro as per the customer requirement
I'm looking for a HubSpot expert to assist me with automating lead generation and email marketing tasks for my project. - Automate Lead Generation: The focus of this project is to automate various lead generation tasks using HubSpot. This would involve setting up workflows, lead scoring, and implementing strategies to increase lead generation. - Email Marketing Automation: Additionally, I'll need help with automating email marketing campaigns. The goal is to generate more leads and improve lead nurturing through a mix of promotional emails and educational content. The ideal freelancer for this job should have: - Proven experience with HubSpot automation - A strong background in lead generation and email marketing - Creative skills f...
...tester to evaluate our PHP Laravel website. Your responsibilities will include both manual and automated testing. Manual Testing: - Focus on Functionality, Usability & Compatibility: I need the tester to pay particular attention to these aspects of the website. - Test Case Creation: You will be required to create test cases for the website as they are currently unavailable. By doing so, you will essentially be putting yourself in the shoes of our users and assessing the website's strengths and weaknesses. Automated Testing: - Browser Compatibility: I need the website to be compatible with three major browsers (Chrome, Firefox, Safari) and require you to automate this testing. Ideal Candidate: - Proficient in PHP and Larave...
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forward to your proposals.
