Excel automation step step işler
I need an Excel expert for creating an inclusive internal database. You'll work with a variety of data formats including text, numbers, and dates. Your tasks will include: - Importing data manually, from files, and through web scraping. - Ensuring that the Excel database houses all the necessary data we collect. It's important that you're skilled in data entry, file importation, and web scraping, because we're working with data from files and possibly scrapped data. Knowing your way around Excel and managing a large amount of data is a must for this job. Your expertise in database management can help streamline our work processes.
Hi Aisha, Thanks for your swift response. There are another 41 new companies to enter - the usual work at £2.75 per company = £112.75. I will send the Excel sheet showing the relevant page numbers and send the PDFs. Thanks again, Steve
I need an experienced Excel developer who excels at spreadsheet automation and formula creation. The project will involve working with mixed data, both numerical and textual. Key tasks include: - Implementing automation solutions to existing procedures Day End Accounts Closing that includes revenues, expenses, commissions and stock level management - Crafting efficient formulas that meet the specific needs of the dataset While there's no specific Excel feature or function in mind yet, we're open to any that might generate the needed outcome. Therefore, a sound knowledge of Excel's advanced functionalities is ideal. Excited to collaborate with someone who enjoys problem-solving and creating seamless Excel workflows.
Job Title: Raspberry Pi & Servo Motors Automation Project Description: We are seeking an experienced automation engineer to oversee the automation of our machine workflow using Raspberry Pi and servo motors. The project involves configuring hardware, developing software for control, and integrating the Modbus TCP/IP protocol. The successful candidate will demonstrate expertise in Python programming, servo control, and Modbus communication. Scope of Work: Phase 1: Raspberry Pi Setup & Servo Motors Control Description: Set up the Raspberry Pi 4b to control servo motors, including connecting it to the Delta Touch Screen (DOP-110WS) and configuring communication with the Panasonic Minas Driver (MADLN05NE) and Panasonic Servo Motor (MHMF092L1U2M). Install Modbu...
I'm in search of a professional video editor, skilled in crafting compelling, high-quality wedding videos. My needs revolve around making our video look like a documentary/cinematic that perfectly captures behind-the-scenes and ceremony footage. Here's a snapshot of what's required: - Work on wedding video editing, primarily involving behind-the-scenes and ceremony footage. - Must excel in executing a documentary style, making the content immersive and real. - A keen eye towards telling a story through the footage; maintain continuity while also capturing the distinct moments. Ideal skills and experience: - Proven experience with wedding video editing, specifically documentary/cinematic style. - Profound understanding of video editing software and tools. - Effective...
I am in search of an expert in Excel to create a comprehensive dashboard from an already existing spreadsheet. The dashboard should be interactive and incorporate multiple filters. Key Characteristics: - Able to embed filters for Date range, Project name, Status, Size, and Material, with possibilities of extending to more which will be provided upon project award. - You should be able to creatively build an intuitive, user-friendly interface that allows for easy navigation through huge data sets. Ideal Candidate: - Has significant experience and skill in Excel and data management. - Can provide examples of other Excel dashboards they've created. - Communicates effectively regarding project status and any barriers met. Timeframe is not an issue, providing the p...
I am seeking an expert in Excel 365 who can highly perform simple data entry tasks. You should ideally have: - A deep understanding of Excel 365's functions and user interface - Precise attention to detail - Simply u have to enter issued number against received number - For example :- In department of DSC you have to 1st go to DSC sheet then 1st enter date like as per photo that was 28/01/2024 than 1st find number "574" by finding function than entry "147" in 28/01/2024 column. Please understand first approx. 5000 entry u have to enter as per above mentioned. After confirmation total entry detail will be send.
I need an expert in API automation, specifically utilizing , for specific tasks. Your main duty will be to automate keyword ranking searches on Google. Please, to succeed in this project, you'll need: • In-depth understanding of API automation • Previous experience with Octopbrowser automation and API • Excellent skills in creating real-time dashboards Your responsibilities include: • Setting up an automated system for Google keyword ranking • Ensuring the real-time dashboard that presents these ranking results is functioning seamlessly • Regular testing and debugging to ensure the system runs smoothly. If you have the relevant experience and a proven track record in similar projects, feel free to place your bid. We are on the look...
I am in need of a capable YouTube editor who can give my automation channel an informative style. The editor doesn't necessarily have to be very experienced, even those new to editing are welcome to apply. Key points: - Editing focus: Your task will involve enhancing video content to create an informative and engaging viewing experience for our audience. Mastery of basic video editing principles is enough for this project. - Past Work Examples: Please provide samples of your past work during application. This will give me an insight into your style and proficiency. - Style Focus: The editing style should primarily be informative, it should make the content clear, concise and easy to understand. Skills and Experience: - Basic to Intermediate video editing skills - Understand...
...all GMB platforms. • Platform: The chosen platform for developing this solution is Make, due to its cost-effectiveness. Therefore, proficiency in leveraging Make for automation tasks is critical. • Functionality: The software should have the ability to take a post created on one GMB profile - containing text and images - and duplicate it exactly across all GMB profiles I manage. • Requirements: There should be no limitations on the format of the post to be copied - it must copy the exact content, text and images, from the originating profile to the others. Ideal candidates should have prior experience with Make, automation of tasks, and knowledge of Google My Business. Past work showcasing similar projects will be highly advantageous. Any experience wit...
...this project is on creating Workato recipies for seamless integration with Netsuite to automate the process of Employee onboarding/offboarding into/out of the system. The ideal freelancer would be someone who has: - Considerable experience with Workato, particularly in creating recipies - Strong understanding and exposure to the Netsuite platform - Proven track record of implementing workflow automation for similar systems The specifics of the project entail: - Crafting new Workato recipies aimed at creating records within Netsuite - Harnessing the Employee data fields from Netsuite for this integration - Automating the onboarding and offboarding of employees via this Workato-Netsuite integration Your expertise in handling integration projects of such nature will greatly cont...
I am in need of an experienced individual who is proficient in using Microsoft Word and Excel, particularly in areas of formatting, styling, creation and implementation of formulas and functions, as well as data analysis and visualization. Additionally, academic writing is crucial for the success of this project, therefore, the potential freelancer should have excellent research and writing skills to ensure content quality and sanity. The ideal candidate should possess the following skills and experience: - Expert knowledge in Microsoft Word and Excel - Ability to manipulate data, implement formulas and create visualization - Strong academic writing skills - Critical thinking and problem-solving abilities PLEASE READ AND UNDERSTAND THE WORD FILE THOROUGHLY AND UNDERSTAN...
Description: We are seeking an experienced automation engineer to oversee the automation of our machine workflow using Raspberry Pi and servo motors. The project involves configuring hardware, developing software for control, and integrating the Modbus TCP/IP protocol. The successful candidate will demonstrate expertise in Python programming, servo control, and Modbus communication. Scope of Work: Phase 1: Raspberry Pi Setup & Servo Motors Control Description: Set up the Raspberry Pi 4b to control servo motors, including connecting it to the Delta Touch Screen (DOP-110WS) and configuring communication with the Panasonic Minas Driver (MADLN05NE) and Panasonic Servo Motor (MHMF092L1U2M). Install Modbus server software and develop custom Python scripts for Modbus communic...
I'm seeking a skilled designer to create an industrial automation design that will be integrated with our production equipment. The key objective of this project is to develop an automation design that significantly minimizes labor requirements. Ideal Skills and Experience: - Extensive exposure to industrial automation design - Prior experience in working with production equipment - Proven capabilities in labor reduction techniques via automation
I urgently require a HubSpot expert to integrate our existing marketing automation with the HubSpot CRM. Task: mapping the contact out from pipedrive Mapping the leads set email sequence and copy all our email templates from pipedrive integrate with 3cx phone system finish migrating from pipedrive I am only availble on Saturday after 10:30 am Sydney time
I've taken the first step in installing the react gatsby plugin on my website and now, I need an expert who can properly configure it to work with my site. I am interested in creating URLs for Spanish, French, Arabic, and Chinese. Specifically, here's what I need help with: - Configuring React Gatsby plugin for Spanish, French, Arabic, Bangla, Urdu, Chinese and other languages - Assisting in establishing the terminology or the specific words for each language URL Here's what successful applicants must have: - Significant experience in website configuration, specifically with the React js or Gatsby plugin Please include your relevant experience in your application. Look forward to working with you!
As a client, I am in search of a developer with a strong background in Microsoft C#, AI, and machine learning to develop a customized web scraping automation tool. This tool will be mainly focused on finding specific contacts based on my specific webpage and online search criteria. Key Functionalities: -I am particularly interested in the contact search functionality. This will allow me to search and extract contact data effectively. Contact Information: -The tool should be able to scrape and filter contact names, email addresses, and job titles. These elements are critical to my search functionality and data mining needs . Search Queries: -I am not sure about how I want the tool to handle contact search queries. I'll need your professional advice and recommendations in this...
As someone who requires an excel table with specific information - names and addresses, sales data, as well as inventory data, all neatly arranged into separate columns - I seek assistance from a freelancer with high expertise in data analysis and excel. A commendable skill level in organization and attention to detail will be necessary. Due to the urgency of this project, I'll need you to complete it as soon as possible, making efficiency and speed vital traits.
I'm seeking a talented logo designer who excels in creating modern, 3D designs. The perfect individual for this project will: - Have prior experience with modern 3D logo design - Have a keen eye for color (primarily red and white) - Excel in creativity to incorporate abstract shapes into the design The finished logo needs to reflect the identity of my company and must incorporate abstract shapes to resonate with our ethos. Your design should favor a modern look that enhances our brand awareness. Please showcase your skills and experience with 3D designs when you bid.
VBA basics but no time to do it. I have already started the 1 step of the project () Can you please finish it ? Everything is explained on
For this role, I need a professional who specializes in adding email verification scripts to API for an existing PHP saas system. The email address validation is the primary requirement. Rather than direct server connection, we will send our script to be examined and require a step-by-step guide on every action necessary to be executed. Required Skills: - Experience with API integration - Proficiency with PHP, Laravel - Excellent written communication skills for document preparation
I have 120 products on WooCommerce WordPress. They are all tires. I need you clean them up with the data that is provided on the Excel document but also cross reference online the proper descriptions and attributes. I need you to make sure the titles are proper and not through the SKU or long product description. I need you to make sure they are all properly categorized and tagged as well and that its respective image shows. There's also some that repeat themselves as they are the same tire, so it's just making sure the variants apply to the product rather than create separate products for a product that can house variants for different tire sizes. Need completed by Sunday.
Key Tasks: - Establish an API with to facilitate workflow automation. - Integrate and automate transmission of data between open ai and my backend Qualifications: - Experience with ,OpenAI, and my backend. - Knowledge in automated workflow design and execution. The project's goal is to automate specific processes within my workflow, focusing on data transmission between APIs and condition-based task execution. You'll need to demonstrate familiarity with and proficiency in managing and integrating APIs. The successful execution of this project requires a solid understanding of workflow automation and data integration strategies.
Key Tasks: - Establish an API with to facilitate workflow automation. - Integrate and automate transmission of data between open ai and my backend Qualifications: - Experience with ,OpenAI, and my backend. - Knowledge in automated workflow design and execution. The project's goal is to automate specific processes within my workflow, focusing on data transmission between APIs and condition-based task execution. You'll need to demonstrate familiarity with and proficiency in managing and integrating APIs. The successful execution of this project requires a solid understanding of workflow automation and data integration strategies.
Θέλω να μου δημιουργήσεις ένα αρχείο excel με τις κατηγορίες επαφών για τις οποίες ενδιαφέρομαι και αφορούν στην περιοχή της Κρήτης. 0.ΦΡΟΝΤΙΣΤΗΡΙΑ ΞΕΝΩΝ ΓΛΩΣ&Sigm...
I need a dedicated and detail-oriented virtual assistant proficient in both English and Spanish, who can carry out specific bookkeeping tasks. Tasks Include: - Data entry - Managing accounts payable/receivable - Bank reconciliations The ideal candidate must have extensive experience with Excel as it is our primary tool for bookkeeping. Please share your previous work experience in these areas, as well as proof of your bilingual proficiency (English and Spanish). This is essential for effective communication and smooth operation. Can't wait to work with you!
I have an SQL database and I need to export data sets into an Excel spreadsheet. I would need the following data exported into individual spreadsheets: - Customer information - Bill of materials - Materials inventory - Supplier details I have examples from previous exports of the required data that should be presented in each spreadsheet Ideal candidate should have the following skills: - Extensive experience with both SQL and Excel - Understanding of data extraction techniques - Excellent attention to detail to ensure that the data transfer is accurate. - Prompt communication and commitment to meet deadlines. You should be able to handle sensitive customer information responsibly and maintain strict professional discretion at all times during this assignment.
...copies 2. Smush Installed and activated 3. Yoast SEO Need to optimize 2 pages Installed activated Both SEO and Readability should be ALL green smiley faces Theme You need the child theme for this project - If the theme already includes the child theme, you can use that. If not, you can create the child theme. Source a WordPress theme online to use for project, view images attached. This step ensures that you indicate the source from which you downloaded your theme! If you submit a Theme that simply changes the images or text, this is not okay, I should not discover too many commonalities in design, layout, or color between your work and chosen theme. -Choose a Block theme -Child Theme activated and used Child Theme to add extra styles -Use of Parent Theme or Paren...
I have a project that requires the creation of functional Excel spreadsheets using data sourced from images. These images are primarily composed of numeric data and will need to be meticulously converted into a spreadsheet format. The key elements of this project are: - Converting data in image format to a neat, organized Excel spreadsheet. - The data to be converted is purely numeric. Furthermore, there are requirements around data validation rules. Primarily: - Date-specific data is included. Thus, knowledge of date formatting and validation protocols in Excel are essential. The ideal freelancer for this job should have: - Strong experience with Excel, particularly in the creation and management of spreadsheets. - Prior experience with data conversion f...
... - Your task will be to replace the existing face in the target image with mine, making sure to blend the skin color to ensure a realistic appearance. - I have a specific picture of me that should be used for this purpose. This picture will be provided during our discussions. - Once the face has been effectively replaced, I will also require some retouching work to be done on the photo. This step helps in ensuring a polished and sleek final look. The ideal candidate should have considerable experience in photo editing, retouching, and in-depth knowledge of photoshop including color correction, blending, and light adjustment, to ensure realism and naturalness in the final output. Please submit your proposals including portfolio or relevant work examples. Communication and prom...
I'm seeking a senior-level bookkeeper with a knack for spreadsheets and modeling. On this project, your key responsibilities will include: - Conducting a thorough financial audit - Developing comprehensive financial reports Preferably, you should have a strong proficiency in Excel to accomplish these tasks. Demonstrated experience in managing audits and financial planning/reports is highly valuable. Let's ensure our financial health with your accounting expertise!
...ΠΡΟΩΘΗΣΗΣ ΕΠΙΣΤΗΜΟΝΙΚΩΝ ΒΙΒΛΙΩΝ 5. ΔΗΜΟΤΙΚΕΣ ΒΙΒΛΙΟΘΗΚΕΣ 6. ΠΟΛΙΤΙΣΤΙΚΟΙ ΣΥΛΛΟΓΟΙ - ΛΥΚΕΙΑ ΕΛΛΗΝΙΔΩΝ / ΝΟΜΟ 7. ΠΑΝΕΠΙΣΤΗΜΙΑ ΚΡΗΤΗΣ ( ΘΕΛΩ ΕΠΑΦΕΣ Σ&Ep...
...for a skilled website developer who excels at working with WordPress and Elementor and has expertise in developing directory websites using the "MyListing" theme. Your fluency in English is vital as we will need to communicate effectively. Key tasks will include: - Updating the layout of the homepage - Adding new sections to the website - Updating current content - Ability to upload data from Excel into specific categories - Rectifying issues with the "copy and duplicate" store hours feature Having an understanding of how menu and site features work is essential. Ability to read the needs of the project is important. Previous experience working on similar tasks and knowledge of "MyListing" theme is greatly advantageous. In your application, be sur...
...to be updated at a frequency that suits your working schedule. Currently, the reports are updated manually with some assistance from a web-based Enterprise Resource Planning system. The existing system, however, lacks the comprehensive functionalities that I require, thereby necessitating your expertise in the creation of a more robust solution. Ideal Skills: - Experience in creating report automation systems. - Proficient in data management and reporting and analytical tools. - In-depth knowledge in ERP systems. - Attention to detail, problem-solving skills, and strong organisational skills. Objective: - To create an efficient, highly-functional report management system that reduces manual input and increases productivity. - The system should be easy to use, adaptable to cha...
I'...customer satisfaction. This is to go over data in a QBR I have a task. The task will tell you the company and the hypothetical situation to complete- almost as if you are an interview. There will be two parts. The first part do some research on the company and the competitor mentioned. The second is to look at the data I’ll provide on excel I need you to follow the steps in the task write the answers in a presentation. The task involved analysing data (only excel not code!) The price is fixed for this. 40 pound. If you are skilled in this it should take no longer than an hour to source information then basic presentation skills. Please don’t ask for more as budget is final. Also don’t bid if you are not qualified to do the task as I will not r...
I'm in need of a professional eBay manager to assist with the overall handling of my store....specifically want focus on include: - Listing Optimization: The right candidate will ensure every product is meticulously listed to maximize visibility and conversion rates. Essential skills will include pricing strategy, keyword research and photography. - Order Fulfillment: Ensuring that every order from my store is correctly fulfilled in a timely manner is crucial. The ideal manager would excel in order tracking, packaging, shipping, and ensuring customer satisfaction. Given the comprehensive nature of the role, the ideal manager should be well-versed in the eBay platform and have exceptional organizational skills. Good customer service and solid marketing strategy knowledge will...
This project is focused on leveraging Tosca for the purpose of automating software testing. Though the specific aspects of testing and the programming languages in the software being tested weren't specified, a general proficiency in software testing principles and methods, as well as familiarity with a range of testing types (functional, performance, security, etc.) and programming languages (Java, Python, C#, etc.) will be highly beneficial for this project. Key Skills and Experience: - Extensive experience with Tosca - Proficiency in software testing - Familiarity with diverse testing types - Experience with multiple programming languages - Ability to handle underspecified tasks and adapt to potentially changing project scope
...richly illustrated manual is aimed at offering advanced training to experienced artists. Designed in canva for easy adjustments made be the owner. - Style: Your design should emulate realistic and photographic styles. Your illustrations should look lifelike and the photos should be extremely clear to portray the precise procedures and expected outcomes. - Content: The workbook must include step-by-step illustrations, detailed technical diagrams, and high-quality before-and-after photos. These elements should be intelligently incorporated to aid in comprehension and practical application. The perfect candidate is someone with an eye for detail, experience in designing educational or training manuals and a strong knowledge of graphic design best practices. Prior work e...
For our cosmetics company we need to record all ingredients that we buy with their associated data. Then when we make a product using all of the ingredients we need to record per batch which ingredients we use. Example attached and detailed information below: Please see attached spreadsheet and below explanation of each point as well as what we are trying to achieve. Sorry it is a bit long winded but hopefully this explains why we need help!! Ingredients Master Tab Currently: • KAN Unique Code o When a product comes through the door it goes into a box. I then go through this box and write on it with a marker pen its own unique number. This unique number is then placed into Column A • Product Name / Manufacturer / Product Expiry Date / Manufacturer Record Number o I input the i...
...within Kajabi is a must. - Sales Funnels Creation: I need a sales funnel that converts effectively. Your previous experience in creating and implementing high-performing funnels is highly desirable. specifically: 1. WEBSITE HAS BEEN LAID OUT, NEED TO FINISH IT 2. SET UP REGISTRATION QUESTIONS AND PAYMENTS (WOULD LIKE TO OFFER ACH PMT OPTION ALSO) 3. FUNNEL REGISTRATION QUESTIONS TO AN EXCEL REPORT TO USE FOR MAIL MERGE DOCS TO PRINT CUSTOMIZED ITEMS (CAN THIS MAIL MERGE BE AUTOMATED ALSO?) 4. AFTER ATTENDEE REGISTERS: a. POP UP ASKING TO COMPLETE PRE-RETREAT SURVEY b. WELCOME EMAIL WITH DETAILS IS SENT c. CALENDAR INVITE IS SENT (IF LIVE DEI) have welcome video attached d. NOTIFICATION IS SENT TO ME, MY ASSISTANT, AND POSSIBLY VENDORS (INITIATING SHIPMENT OF PROD...
I'...individual with proficiency in Microsoft Excel and Microsoft Word to assist me in generating delivery notes. For this project, your tasks include: - Reading data from an Excel spreadsheet and populating it into a Word template for the delivery note. The data to be transferred includes: customer names and addresses, item descriptions, and quantities. - Automating this process for all entries in the spreadsheet in such a way that each entry generates a separate delivery note automatically. - Replicating this delivery note for all the 92 notes captured in the Excel spreadsheet. In addition, you will be creating a PDF copy of each finished delivery note. Possessing experience in visual basic for applications (VBA), data processing, and automation...
I'm in need of a skilled website developer and graphic designer to help bring my project to life. The ideal partner would: - Create a portfolio website: My vision involves a polished and professionally d...showcase my work effectively. Preferably, if you have experience in building portfolio websites or similar, it would be a great fit. - Design a classic and traditional logo: The logo should feature a traditional and elegant style, centered around Permanent Make-up theme. Proficiency in creating Lettermark logos or designs with a classic flair would be ideal. Your creativity will be valued in every step of this project, from website layout to logo color choices. I look forward to hearing your ideas and collaborating to create an end product that meets my needs and exceeds m...
I'm in need of a skilled Excel data entry operator who can take on the challenge of working with more than 5 files of intermediate to complex data. The ideal candidate should be able to comfortably handle the following tasks: - Data Entry and Formatting: Efficiently input data into Excel sheets, ensuring it’s formatted accurately to maintain consistent, clean data sets. - Formulas and Functions Creation: Develop and implement essential Excel formulas and functions to streamline calculations and data manipulation. - Data Analysis and Reporting: Use Excel’s analysis features to interpret the data, generating informative reports to drive decision-making. Strong fluency in Microsoft Excel, proficiency with intermediate to advanced functions and fo...
Step into a world of love, laughter, and forever promises with "Eternal Bonds: A Love Story Unveiled." This captivating wedding highlight video encapsulates the magical journey of [couple's names] as they embark on the most beautiful chapter of their lives together.
Searching for a Python expert who is well-versed in SAML SSO authentication. The aim of this project is enacting functionality that includes: - Authenticating user credentials. - Allowing access to secure resources on a website. Post authentication, the system will execute automation and webscraping tasks such as: - Collection of data. - Interaction with webpages. - Triggering specific actions on the website. The ideal applicant should be proficient in Python and familiar with the requests library. A deep understanding of Single Sign-On (SSO) systems and a proven track record with project-based applications related to SAML (Security Assertion Markup Language) is a must. Experience in webscraping is also highly desirable. Being able to navigate and interact with webpages post SSO...
I urgently require an expert to lift protection from a VBA macro in my Excel 2007 document. A complex password (10+ characters, including symbols) protects the macro. Here's what's needed: - Thorough understanding of Excel 2007 and later - Proficiency in dealing with complex passwords - Demonstrable experience in unlocking protected VBA macros The document itself is not password-protected and remains accessible. However, the VBA macro within is locked. I am specifically looking for a problem-solver with a track record in removing complex macro passwords without affecting the functionality of the macro. Please only apply if you meet these criteria.
...their needs are met with professionalism and efficiency. Conduct data entry tasks in Excel with accuracy and attention to detail. Performance Metrics: The Call Center / Customer Service / Sales Expert shall be evaluated based on the achievement of CONVERSION quotas set forth by our company. Quality of conversion calls, including professionalism, clarity, and adherence to scripting guidelines. Customer satisfaction ratings based on post-conversion interaction surveys. Requirements: Proven expertise in utilizing VICI Dialer for call center operations. Extensive experience in voice-based customer service and sales roles, preferably in the healthcare industry. Proficiency in data entry tasks using Microsoft Excel. Excellent communication skills with fluency in English (bot...
Hi Subhash As discussed, project for the 400+ pages of data entry. For Tuesday please. Thanks ! Always a pleasure
Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.
