Excel automation step step jobs

I’m looking for an experienced programmer who can create an automation script for a website. Key Requirements: - Automation Tasks: Your main job would be to automate various tasks on a website. This could involve anything from data entry to form submissions, and possibly content scraping. The specific tasks will be shared with you in detail. - Python Expertise: Given the nature of this task, your proficiency in Python is a must. If you have experience with automating websites using Python, that would be a huge plus. - Experience: Your application should showcase your relevant experiences and past projects. I’m looking for someone who has a proven track record in this field. Please include relevant examples of your past work in your application. Looking forward t...

...script written for Google Sheets. Here are the specific requirements for the project: Project Objectives: 1. Script Functionality: - Automatically fetch Arabic text from a specified Twitter account and insert it into Column B of a Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - Include functionality to fetch tweets within a specific date range through an added menu in Google Sheets. 3. Data Integrity: - Ensure that existing data in Column B is not overw...

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

My primary goal is to create a specialized automation software for Facebook. I'm looking for freelancers who have demonstrated experience in this area. Key Requirements: - Automation Skills: I need someone with a proven track record in creating automation software for Facebook. The tool should be able to automate various tasks on the platform efficiently. - Experience: Please provide examples of your past work in automating tasks on Facebook or other similar platforms.

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

Please Sign Up or Login to see details.

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

I'm looking for a detail-oriented researcher to help me gathe...charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be referenced with t...

I'm looking for a skilled freelancer who can develop a program for the Click PLC to control a Variable Frequency Drive (VFD) hoist. Key tasks would include: - Implementing a start/stop control which can be manually triggered. - The program needs to possess speed control, allowing adjustments in ...Implementing a start/stop control which can be manually triggered. - The program needs to possess speed control, allowing adjustments in the hoist's operating speed. - Including direction control within the program functionality would be vital as well. An understanding of PLC programming and specific proficiency with Click PLCs is crucial for this project. Previous experience with VFDs, industrial automation, and manual switch controls would give any potential freelancers a si...

I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.

I'm looking for a skilled freelancer who can create a system that automatically downloads building and road data from OpenStreetMap in CSV format on a monthly basis or with a html frontend site, where we can "click" in Downloadbutton. Key requirements: - Automate the retrieval of building and road data from OpenStreetMap - Download the data in CSV format - ...City, District of City, Federal State, District, Street, Housenumber If available the Community and the Code of the Community Ideal skills and experience: - Proficient in OpenStreetMap data retrieval - Programming experience to automate data downloads - Strong understanding of CSV data formatting - Ability to create a system for scheduled, monthly data retrieval If you're able to deliver this automation...

I have an existing STEP file that needs to be modified, completed and technically prepared. The file will need to have its dimensions changed, features added or removed, and overall technical data checked and corrected. The ideal freelancer will have the following skills: - Proficiency in CAD software, especially working with STEP files. - Attention to detail and ability to correct technical data. - Understanding of material properties and assembly constraints. - Experience in converting CAD files to PDF and DWG formats. The end deliverable will be the modified STEP file, in two different dimensions (3750mm and 5000mm as opposed to the original 4375mm), exported into both .PDF and .DWG formats.

I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...

...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally. If you...

need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.

I need a Flutter developer for a website, I want you to create an automation website that generates ( SMS iPhone videos ) the website is gonna be like this 1- there is an empty SMS template 2- the user adds the text in every part ( sender - receiver ) 3- click okay and the website generates the video 4- the video has to be like that ( one message at a time, voice over for every message, background video game ) here is an example of what I want exactly: @

... The system should have the following key features: - **Tiered Commission Structure:** The system must support a 4-tier commission structure. These tiers should be clearly defined and adjustable by an administrator. - **Daily NAV Calculation:** The daily NAV should be calculated based on historical data. This data should be accurate and reliable, and the calculations should be precise. - **Automation:** The system should automatically trigger commission calculations at the end of each business day. This ensures that the process is efficient and error-free. The ideal freelancer for this project should have: - Proficiency in designing and developing commission systems - Advanced skills in historical data analysis - Experience in building automated systems If you have the exper...

I need assistance from a skilled professional who can efficiently convert a DXF/DWG 3D object to STP/STEP format. The primary intent behind this conversion is to perform Finite Element Analysis (FEA). Essential Requirements: - Your work must be compatible with SolidWorks. - The detail level in the converted model should only be basic. Ideal Skills and Experience: - Proficiency in DXF/DWG and STP/STEP formats - Experienced in 3D object conversion for FEA - Familiarity with SolidWorks software You are expected to make the model ready without any issues hindering the analysis process. Your ability to convert 3D objects quickly is highly valued in this task.

...requiring development haven't been specified, but the key components will include: Brief description: Members can also upload items (only to designated columns set by administrators). Assumption: The administration will set up a category column—Card Trading. Members who log in can upload related items to sell, but only to that column; they cannot upload to other columns. Let's break it down step by step: User Column: Modify the administrator's product management template. The administrator will set up a category, such as the Card Trading Market. Then, all items uploaded by users will be categorized under this classification. To purchase items in this category, users must log in. When a member purchases an item uploaded by another member, relevan...

...considered Payment? - you estimate in a WBS (optimistic, expected, pessimistic, where optimistic < expected < pessimistic) after getting the task - we discuss about clearances and effort - we mutually agree to effort - we assign you the task after mutually agreed - you implement, test and deliver - you provide also unit /integration tests to ensure code is always working - you document each required step to make interaction of systems to work - we test on our premise (you maybe help to fix issues) - we pay (basically the rules of freelancer) Closed book vs open book? We work only on open book. Closed book means you are unwilling to define a WBS for the work and you add only a price tag to the task. We are sorry we will not hire you in such a case! documentation require...

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good communication skills to provide regular updates a...

I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for handling and managin...our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd exc...

I need an adept freelancer who can efficiently assist with workflow automation. Their features and capabilities should be second-nature to them, to tackle custom tasks at any level. Key Responsibilities: - Create, fine-tune and manage workflow automation on Ideal Candidate: - Be an expert in workflow automation on - Have ability to respond and work quickly - the project needs to be completed ASAP Note: This does not involve any external tool integration, only Monday.com.

For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected will directly influence fur...

...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...

I require a freelancer to type text data into an Excel sheet from printed documents. Scope of work: - Convert printed text documents into digital format via Excel - Ensure data is accurately entered The project does require specific formatting: - Data should be arranged in rows Ideal candidate: - Must have proficient Excel skills - Experience with data entry - Attention to detail, to ensure accuracy in work - Able to follow specific instructions for data organization

I'm in need of a developer to add a custom subscription multi-step ordering functionality to my new Woocommerce site. The site will be built using Divi, and I'm aiming for a modern and sleek design. The custom subscription package should allow customers to: - Choose delivery frequency - Select product combinations - Use a date picker to specify delivery dates The ideal freelancer for this job should have: - Proficiency in Woocommerce and Divi - Prior experience in setting up custom subscription packages - An eye for modern and sleek design This is a sample for reference: Looking forward to seeing your proposals. Thank you.

...tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner - Strong...

I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accur...

I am in need of a well-versed Python expert to assist in manag...assist in managing a Linux server. This project is task oriented and requires specific skills including: • Working with server data analysis • Implementing web scraping techniques • Establishing automation processes The role also demands a comprehensive understanding of Linux operations and the ability to print headers. A background in server security, setting up database servers and performance optimization would be ideal, but the focus is primarily on Linux server management via Python. Proficiency in Python, Linux, server data analysis and web scraping are must-haves. Experience in automation and server management will highly be appreciated. Looking forward to your knowledgeable and expert ...

I'm seeking a skilled developer to help me deploy ChatGpt model for Customer Support Automation. Key specifics include: - Application Audience: The target audience for this app is primarily businesses. It's crucial that the developer understands this specific user base and can ensure the app is tailored to their needs. - Primary Functionality: The main functionality of this app will be customer support automation. This includes features such as automated responses, ticket management, and potentially even sentiment analysis. The ideal candidate should have experience in developing and implementing such functionalities. - Deployment: The ultimate goal is to get this app up and running, so deployment knowledge is essential. Experience in deploying ChatGpt-based Model...

...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, proficiency...

I need an organized mind to help with research and data entry of a list of companies in a specific industry. Your main responsibility will be organizing this data. While basic Excel skills are a must, experience with data organization, particularly in a business context, would be highly beneficial. The data will be divided into 4 separate categories, so whoever takes on this task needs to have a keen attention to detail and an understanding of categorization. This project is perfect for an individual who thrives in organizing and systematizing data.

As a fast-growing business, I urgently need a skilled Node.js developer to focus on backend development. The primary task is to integrate a payment gateway. , we encountered an issue retrieving the transaction, which should have been provided but is not available. We were advised to handle callbacks and decrypt the response, but we're facing difficulties in doing so. Handling callbacks and post-success payment URLs did not resolve the issue. We now need the transaction ID, which we are unable to obtain. We need someone who can do the final step here and complete the integration on the website. The website is in React Js and Node Js. The solution should be configurable for other websites also. Please check the PDF

**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit Require...

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.

...designated "Yes" or "No" button on the Firefox page. - The interaction with the Firefox web page should be done at regular intervals. After the selection is made , it must return to its original focus to be ready to select one of the two keys. Ideal Skills and Experience: - Proficiency in Python and experience with PyAutoGUI. - Strong understanding of web interactions and experience with browser automation. - Ability to design and implement accurate keyboard inputs. - Experience in handling focus switching between applications. The script is not required to include error handling for instances where the Firefox browser is not open or the specified page is not loaded. The primary focus of the script is on accurately interacting with the designated elements o...

...roles and user levels. o User Instructions: User agreement and privacy policy. • User Profile and Settings o Personal Profile Management: Users can create and edit personal profiles, including nicknames, avatars, and personal signatures. Set personal privacy options to control who can view their profiles. o Account Security: Provide strong password policies and security measures such as two-step verification. Account recovery and notification of abnormal logins are possible. o Message Privacy: End-to-end encryption to protect message content from being intercepted by third parties. o Contact Management: Manage the contact list, including adding, deleting, and editing contact information, as well as setting special attention or do-not-disturb contacts. o Hel...

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 our project's completi...

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!

I'm looking for a skilled developer who can help me integrate a chat feature into my Telegram account. The chat should be capable of receiving inquiries an...specifics: - **Manual Responses with Automated Greetings:** The chat should greet the user automatically upon initiation, and then respond to their queries manually. - **Scheduled Messages:** I need the feature to have the capacity to send scheduled messages to users at specific times. The ideal candidate for this project should be familiar with Telegram bot development, have experience with chat automation, and be able to deliver a user-friendly and efficient solution. The ability to understand and meet user needs is crucial. Please provide examples of similar projects you've worked on in the past. Looking forward ...

I'm currently in need of a proficient developer who can create an automated tool which can secure, efficiently execute, and dispatch BEP20 tokens to an e...execute, and dispatch BEP20 tokens to an extensive user base. Key Requirements: - Capable of dispersing BEP20 tokens to 15,000 users, each in isolated transactions. - Fitted with an automatic transaction feature. - Incorporates password-protected verification. The perfect candidate: - Proven experience creating similar tools. - In-depth knowledge of BEP20 token transactions. - Skill-set in automation and security measures. This high-volume transaction requirement necessitates a developer who can provide a robust, reliable solution. If you're a seasoned developer with the required skills for building this tool, ple...

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

Please Sign Up or Login to see details.