Automate excel with vbaроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
...seeking a seasoned data analyst with expertise in data science who can thoroughly clean, preprocess, and visualize a dataset sourced from CSV files. The chosen candidate: - Should first start with cleaning and preprocessing the data to create a reliable foundation for analysis. - Should then interpret and present that same data through meaningful visuals to explore its intricate properties and characteristics. - Should additionally facilitate statistical analysis to derive patterns and trends otherwise invisible to the naked eye. The hoped-for end-product of this project is not just predictive analytics but insight and data-driven recommendations that will inform future decision-making. Proficient use of Python or R for these tasks is essential, as is familiarity with...
I'm in need of an individual proficient in Excel to streamline data analysis for my sales numbers. The main objective will be to dissect revenue trends within the data, so particular attention to this metric is essential. Ideal qualities include: - Great attention to detail - Previous experience in data analysis - Proficiency in Excel - Understanding of sales and revenue benchmarks This role will require you to receive raw data and translate it into an easy-to-understand format, highlighting pivotal information. Your focus will be on creating complex formulas to identify revenue trends, which will help inform our future sales strategies.
I'm looking to automate my trading processes using the Zerodha Excel API. As I'm unsure of the API's development, I need a freelancer who is experienced in API integrations and has a good understanding of automated trading systems. Key Elements: - Automation: The primary goal is to automate trades based on predefined criteria. This involves developing a system that can analyze market conditions and execute trades automatically. - Zerodha Excel API: As I am unsure about the development of this API, you should have a good understanding of it or be able to quickly grasp its functionalities. - Trading Experience: It would be beneficial if you have prior experience in developing automated trading systems. - Predefined criteria: The system should be ab...
...a skilled individual who is proficient in Excel to analyze market research data. This work requires a keen eye for detail and understanding of advanced analysis techniques. The main objective of this project is to provide precise quantitative summaries of the market research data. Your responsibilities will include: - Receiving and understanding the raw data provided - Analyzing and interpreting complex data sets - Producing quantitative summaries and reports based on your findings Ideal Skills & Experience: - Proficient in Excel - Previous experience in data analysis - Good understanding of market research principles - Excellent task management skills - Experience in generating data-driven reports. This project is ideal for freelancers with a knack for...
As a team heavily reliant on Google Sheets for our daily reporting, we're looking for a proficient freelancer who can automate the process of compiling our marketing metrics. Key Tasks: - Automate the process of copying data between sheets - Ensure data collation for metrics such as click-through rates, conversion rates, and social media engagement Ideal Skills and Experience: - Extensive knowledge in Google Sheets - Experience in automation and data analysis - Knowledge of marketing metrics would be an asset
...(the choice in BOLD). - Some questions "refer to a figure". Most questions have zero or one figures, a few have more. I have provided Columns Figure A... FigureH for these as required. LOOK AT THE EXAMPLE. task is to put all 1090 questions into an excel file. I have put one question in there as a sample. I have also put one image which shows two additional questions. - If you win the project, you will get the full PDF. You will be able to cut and paste from the PDF. - To bid on this project, you must give me the excel file back with these two sample entries put in after the one that I did. The sample is a JPG file so you must type it in manually. Successful project: - All questions in there, in correct order from the PDF. - No typos. - Correct an...
I'm looking for a reliable freelancer to help with a small-sized project involving Excel data entry. The information will be shared via online documents. Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail is a must - Ability to handle small-scale tasks efficiently
...looking for a skilled sales closer with a strong track record in retail sales. The ideal candidate should have a versatile background, capable of handling both brick-and-mortar and e-commerce environments. Experience in the pharmaceutical or healthcare industry is a plus. Key responsibilities include: - Engaging with potential customers and guiding them through the sales process - Closing deals with efficiency and a customer-centric approach - Nurturing leads and maintaining strong relationships with existing clients The main products you'll be dealing with are pharmaceuticals, so any previous experience in this specific area is highly desirable. Your success will be measured on your ability to generate sales, retain customers, and ensure their ...
I will write ...daily , One such project should be made I'm seeking a proficient Excel specialist to take on a project that primarily involves formatting and creating advanced formulas. Key Responsibilities: - Take charge of the spreadsheet's aesthetic and logical formatting - Develop and implement formulas to aid data analysis and interpretation - Arrange numerical data alphabetically from A to Z Ideal Skills: - Proficiency in Excel functions and formulas - Strong attention to detail, particularly regarding formatting - Excellent problem-solving skills Project Timeline: This project needs to be completed within a month, demonstrating your ability to meet deadlines is crucial. So, if you have good experience with Excel, particularly with...
I am seeking an expert freelancer who can develop a Digital Work Hour Monitor System for me in South Africa. This system's primary function is to handle project management, with specific features that include: - Task Assignment & Tracking: Assign and keep a screen of tasks automatically. - Time Tracking & Logging: Capture precise work hours, and automate attendance track. - Project Tracking: Monitor multiple projects' progress simultaneously. - Pay Hourly Basis: Computes payroll based on tracked work hours. - Automated Time Tracker: Logs time spent on each task and project. - Application Tracking: Monitors usage of tools and applications for each project. - Offline Tracking: Log task hours when offline, and sync when back online. - URL
I'm currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.
...maintenance materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with...
I'm in need of a proficient individual who excels in SPSS for a data interpretation task. The main task involves the analysis of a questionnaire and exporting relevant tables from...individual who excels in SPSS for a data interpretation task. The main task involves the analysis of a questionnaire and exporting relevant tables from SPSS. Here's what I'm looking for: • Skilled in analyzing questionnaires using SPSS • Able to export data into tables • Analysis should be done based on patterns of behavior • Writing a brief description of data based on hypotheses The data is on an Excel file right now. Please bid only if you have relevant skills and experience as it will demand a high level of expertise and detail orientation. Don't hesitate ...
...backend operations and Tailwind CSS and Vue.js for frontend tasks to enhance my webapp's functionality. Key Task: - automate Facebook sharing validation. Job Features: - Implement an auto-validation function using Facebook API to verify whether a shared content from the webapp to Facebook has actually been posted. - link this validated action with a coin reward function within the webapp. The goal is to validate if the content was actually reshared by our user before our system award them coins Separate the frontent input coin by adding new column Required Skills : - Expertise in PHP Laravel, Tailwind CSS, and Vue.js - Proven experience with Facebook API - Familiarity with developing reward mechanisms within a webapp - Strong attention to details -...
...Specialist to review our contracts, ensure compliance with contract terms and conditions, and audit financial records. Key Responsibilities: - Reviewing contracts: You will be tasked with thoroughly examining our USAID contracts. - Ensuring compliance: It's essential that you ensure we strictly adhere to all terms and conditions outlined in our contracts. - Auditing financial records: You will need to conduct detailed audits of our financial records to guarantee compliance. Industry Experience: While not mandatory, if you've previously worked in the media TV channel sector, it would be an added advantage. Understanding the unique nuances and challenges of this industry will help you excel in this role. Ideal Skills and Experience: - Experience with...
I need a competent Excel specialist to develop a robust strategy for documentations. The specific tasks are not yet determined, and the information that needs to be included will be clarified as we proceed. However, the project has no strict deadline, giving you ample time to plan, organize, and execute best practices. The ideal candidate will possess: - Outstanding Excel skills, including creating and working with complex formulas. - Robust organizational skills to manage and structure vast amounts of information. - Proactive attitude for identifying potential tasks that need documentation. - High attention to detail and accuracy. - Experience in data entry, sales records, and inventory management would be advantageous. Please bid with your plan of action and...
I'm in need of a sharp Australian expert who has access to the Australian Bureau of Statistics (ABS) database and can help me gather pertinent data regarding Melbourne's older population. If you have experience with ABS table builders this should be a relatively easy job as much of the data is collected in these ranges. Key Deliverables in Excel: - All SA3s in the Eastern and Southern Melbourne planning regions - TOTAL number of people in each SA3 and the number of people in the ages of 50+, 60+, 70+, 80+, 85+ - The number of people with income per week in each SA3 of $3,000-$3,999, $4,000 - $4,999, $5,000 - $5,999, $6,000 - $7,999, $8,000 or more The example table shows information from the 2016 Census and I will need data from the 2021 Census. Key Re...
I need a solution that will automate a post to my own managed facebook group. I have a php script that creates the post ready to be sent to the group. My post will contain text and images. I had a previous system that used an fb app using publish_ to_group that I believe is no longer supported. I need a replacement solution. I am not sure if there is? Happy to use any technology (not just FB app) that may achieve the same result. Please do not bid unless you fully understand the issue and can suggest an alternative. I will not pay for 'learning on the job' so please ensure you know the solution and can implement it within your quote before bidding.
1 excel import task. and fix minor issue in db. Able to work with ftp. Follow and start Immediately
I need a tool that can search multiple sheets in an Excel workbook and copy specific rows to a new sheet based on manual selection. The core requirements of the tool are: - Searching across multiple sheets to find specific data. - Allowing me to manually select a specific number of rows from the search results for copying. Given these criteria, the ideal tool would be: - Capable of working with Excel files. - Providing a user-friendly interface for easy manual selection. If you have experience with these requirements, please reach out.
I need a highly accurate and detail-oriented individual to assist with entering both numeric and text data into Excel. Requirements: - Excellent proficiency in Excel - Previous data entry experience - High level of accuracy and attention to detail - Ability to handle both numeric and text data entry efficiently This role will suit someone who thrives on working with data and can ensure that all data gets entered correctly the first time, every time.
I'm looking for a freelancer proficient in Excel to help me with daily data entry and organization tasks. Key aspects of the project include: - **Data Entry and Organization**: Your main responsibility will be to input new data, as well as maintain and organize existing data in a structured manner. - **Regular Updates**: The document will need to be updated regularly, making consistency and accuracy pivotal in this role. Ideal candidates should have: - Strong proficiency in Excel, particularly in data entry and organization. - A keen eye for detail and a methodical approach to work. - The ability to work consistently, as the document will require daily updates. - Prior experience with similar tasks is a plus, but not essential.
I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.
I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.
...automating daily pricing updates from a specific website. The script should pull the pricing information and update it into our system. Key Requirements: - Develop a script that can extract data from a website and automate the pricing update process - The script should be able to run daily, without manual intervention - Ensure the script is robust and can handle occasional changes in the website's layout without breaking Ideal Skills and Experience: - Proficient in web scraping and data extraction - Experienced in script automation, particularly on a daily basis - Familiarity with handling data within a business context - Ability to create a reliable and sustainable solution, accommodating for potential changes in the website's structure If you have a proven ...
I'm seeking a skilled Google Apps Script developer to create custom functions or macros for my project. The main objective of this job is to automate repetitive tasks, contributing to the overall efficiency of our system and services. Key Points: - The main objective of the project is to create custom functions or macros. - The primary users of these functionalities will be external clients, so ensuring user-friendliness and accuracy is crucial. Ideal Skills: - Proficiency in Google Apps Script with prior experience in creating custom functions. - Understanding of automation and a track record of developing solutions that optimize processes. - Strong communication skills as the macros are for external clients.
I require a professional data scraper to scrape multiple websites. Key tasks include: - No limitation on type of data scraped as this was not specified. - Scraping must be done across multiple websites, specifics will be provided upon project commencement. - All data should be delivered in Excel spreadsheet format. Ideal skills and experience: - Prior experience in web scraping across multiple diverse websites. - Proficient in using different scraping tools. - Strong understanding of Excel and data parsing. - Attention to detail and commitment to high quality, error-free work.
...experienced Excel tutor to provide me with in-person lessons focusing on basic formulas and functions. My Current Skill Level: I would rate myself as a beginner - I have minimal experience with Excel and would need a tutor who can help me understand the basics. Skills to Learn: My main goal is to grasp basic formulas and functions within Excel. I'm looking to build a strong foundation before moving onto more complex features. The ideal candidate for this job has: - Proven experience in tutoring or teaching beginners Excel - Strong understanding of basic formulas and functions in Excel - Excellent communication skills to effectively convey concepts to a novice - Availability for in-person sessions If you think you'...
Hi Adel Automate, I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Hello, everyday my teammate (driver) will screenshot their completed task and send to my WeChat (desktop app). I need the robot, to use exisitng WeChat feature to extract the data from the photo, and copy the extracted data into the excel. Here is the simple introduction how the taks looks like: Please let me know if you required more clarification of my requirement. I'm fine with any RPA product, (preferable Microsoft Power Automate). As long as the RPA product is free/not expensive.
...coast region of Australia. Key Information Required: - Contact details: I need a name of the person who manages the trucks their phone number. - Geographic location: It's important to know where these individuals or companies are located. - I need the company name The final list should be delivered in an Excel spreadsheet. Ideal Skills and Experience: - Strong research abilities: The ability to dig deep and find the right contacts in these specified industries. - Proficiency in Excel: The ability to compile and present the data in an organized and clear manner. - Understanding of the target industries: Experience in or understanding of the Transportation and logistics, Construction, and Agriculture sectors would be a big plus. Please let me know about any past ...
...Setter to promote and sell IUL and insurance products. The successful candidate must have a proven track record in lead generation and appointment setting, as well as excellent communication and negotiation skills. Responsibilities include identifying potential leads, contacting customers, setting up appointments, and following up to ensure sales conversions. The ideal candidate should be familiar with IUL and insurance products, possess strong interpersonal skills, and be able to work independently. Training is provided. We are looking for someone that holds a valid state issued life insurance license or is willing to get a license in any state in America. To become a license agent you will have to be 18 years and up, hold a government issued ID in America, pass a background t...
I need a professional...- Extracting: I require the following contact information to be extracted: Business Name, Email, Phone number, Full address separated by suburb, postcode and state. - Formatting: All extracted data should be structured and organized into an Excel spreadsheet. Ideal Skills: - Web Scraping: Proficiency in web scraping tools and techniques is essential. - Data Entry: Experience with data entry and extraction. - Attention to Detail: Accuracy in capturing and organizing contact details is crucial. - Excel Proficiency: Ability to create and format an Excel spreadsheet effectively. - Communication: Regular communication and updates on the progress of the task would be appreciated. I'm looking for a reliable freelancer who can deliver t...
I'm in need of an experienced Java Selenium APIs tutor to help me automate test cases for two business web applications. Requirements: - Expertise in Java programming and IntelliJ for test automation. - Proficient in Selenium and APIs, particularly in creating automation scripts. - Knowledge of Cucumber for implementing BDD framework. - Ability to guide and advise on the automation process. This is a collaborative effort, I'm looking for someone who can not only help automate my test cases, but also teach me how to do it effectively. Also due to Coles VPN and restricted access, the job has to be online with connecting to my computer either through meetings with share screen or sharing through git hub!
Hello. I have a multiple page excel spreadsheet, but I need it to have more flexibility. It is for a 10 room facility, and it's purpose is to show projected revenue based on room type, employee job type, and schedule. The current spreadsheet has 10 rooms with two room types. Also there are 11employees with 6 job types. Your task will be to change the current spreadsheet to 40 rooms, 3 room types. and 22 employees with 12 job types. Changes to be made to Revenue Targets Page, Column A -I want to be able to select room type from a dropdown menu, and input the revenue for different room types on the Revenue Target page. Room types are Private Room, Shared Room, Shared Medicaid. Employees Page, Column A -I want to select employee job type from a...
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yel...
Project Description: We are looking for an experienced Autodesk Revit plugin developer to create a custom plugin that integrates with Revit 2024. The plugin will automate the retrieval of quantity data from specific Revit schedules and perform calculations based on user-selected options. Requirements: The project must be completed within 2 days from the start date. The freelancer will have access to support and clarification throughout the project duration. Proficiency in Autodesk Revit plugin development. Access to Revit 2024 installed on your PC for testing and development. Ability to work independently and efficiently. Project Details: The objective is to develop a plugin that performs the following tasks: Retrieve quantity data for four specified materials from pred...
...net/ PLEASE CHECK THE DOCUMENTATION FIRST BEFORE APPLYING, YOU NEED TO KNOW WHAT YOU'RE REGISTERING FOR! I'm seeking a IOS/JavaScript/Lua developer with considerable experience in mobile platforms to compose a script of medium complexity. The main purpose of this script will be to automate certain processes on a mobile device. using AutoTouch. Key Deliverables: 1. Create a script that will automate tasks. 2. Ensure compatibility and smooth operation on a mobile platform. 3. Enable interaction with external APIs or services as necessary. You must have a background in automation scripts and API interactions and should be comfortable working with mobile platforms. Fluency in English is preferred for effective communication throughout the pro...
We are looking for an experienced Autodesk Revit plugin developer to create a custom plugin that integrates with Revit 2024. The plugin will automate the retrieval of quantity data from specific Revit schedules and perform calculations based on user-selected options.
We are looking for an experienced Autodesk Revit plugin developer to create a custom plugin that integrates with Revit 2024. The plugin will automate the retrieval of quantity data from specific Revit schedules and perform calculations based on user-selected options.
Necesito crear una un excel con formulas que me calculen los montos acumulados segun una tasa de interes
Generar un reporte con tablas dinámicas nivel general y específico de una base de datos de 10,000 usuarios; se requiere mostrar presupuesto ocupado de 2023 y lo que va 2024; por diferentes áreas cómo se ha gastado el presupuesto, lo que se busca es un reporte como el del llamado ejemplo; pero con la información mostrada en base de datos; visualizar presupuesto utilizado por mes, y por usuario a nivel área.
I need a skilled developer to automate several tasks on my Wix e-commerce website. This includes payment processing through PayPal, efficient order fulfillment and inventory management. Key requirements: - Automating payment processing for customer purchases using PayPal - Streamlining order fulfillment to ensure timely delivery to customers - Implementing a system for inventory management to prevent stockouts and overstocking Additional features: - Sending order confirmation emails to customers post-purchase - Providing shipping updates to customers - Generating inventory restock alerts to inform me of low stock levels Ideal Skills: - Proficiency in Wix, with experience in e-commerce automation - In-depth knowledge of PayPal API for seamless payment processing - Prior w...
I'm looking for a skilled Excel expert to automate the formatting of a spreadsheet from a Quickbooks export. Key Requirements: - I primarily need the freelancer to set up and automate formatting in my Quickbooks Excel spreadsheets. - The final formatting should be both visually appealing and easy to read for the end user, we will provide guidance on what the end result should look similar to. Ideal Skills and Experience: - Strong proficiency in Excel, especially with automating processes and conditional formatting. - Previous experience working on projects involving data visualization and presentation. - A good eye for design to ensure the data is clearly differentiated and visually engaging.
I have a project that involves data entry from an Excel file. The data needs cleaning and formatting before entry, and the end goal is data analysis. I am looking for a freelancer who can help me with the following: - Excel Data Entry: Transfer data from an Excel file into a designated system. - Data Cleaning & Formatting: Ensure the data is cleaned and formatted correctly before entry. - Data Analysis: Help in structuring the information in a way that facilitates analysis. Ideal skills for this project include experience in data entry, Excel, and data analysis. Looking for a reliable and detail-oriented freelancer to complete this task efficiently.
I require an experienced data cleaning specialist who can proficiently handle Excel spreadsheets. My project involves tidying up datasets related to customer, product, and financial data, though different types of data might need to be scrubbed too. This data cleansing task involves a lower volume dataset of less than 1,000 records. Key tasks include: - Identifying and correcting any inaccuracies. - Identifying and handling missing data. - Assuring the consistency of datasets. The ideal freelancer should have strong skills in spreadsheet management, a keen attention to detail, exceptional data analysis abilities, and a solid understanding of customer, product, and financial data. Experience in Excel and a proven track record in data cleansing are a must.
