How to automate consolidation in excel jobs
...Data: The main purpose of this project is to gather information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial to ensur...
...looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing sch...
Напишите код на Python, который будет использовать мои модели Azure Doc Intelligence для обработки загруженного PDF, затем использовать извлеченные данные и создать таблицу в Excel с ними
I am in need of a proficient data entry expert to help input numbers from online sources into an Excel sheet. These numbers should be entered as plain numerical values. Key Requirements: - Competence in Excel and data entry - Attention to detail - Ability to extract numeric data from online sources. Based on the nature of this project, having a background in data mining could be a bonus, but is not mandatory. The successful freelancer should have a keen eye for detail and be able to accurately enter numbers without errors. Accuracy and speed are both key in order to complete this project successfully.
I'm in need of a freelancer who has expertise in Excel for a massive data entry project. The sheets are more complex than usual, carrying over 500 rows and columns. Key tasks within the project include: - Data typing that entails input of text, numbers, and dates - Use of a structured data format for effective input The ideal candidate should possess a keen eye for detail to maintain data accuracy, strong familiarity with Excel, and speed typing skills. Prior experience in large Excel data input is also desirable.
I need a proficient Excel professional to efficiently manage data entry and cleaning tasks. The responsibilities of the chosen freelancer will include: - Entry of both numerical and textual data into Excel from various sources. - Pre-entry cleaning and categorization of the provided data, ensuring it's thoroughly structured and void of errors for optimum usage. Ideal Skills and Experience: - Proven experience in Excel data entry and data cleaning. - Highly detailed oriented and organized. - Excellent communication skills to report progress and any issues encountered. - Ability to work within strict deadlines. This role requires a keen eye for detail, a high level of organization, and the ability to handle numerical and textu...
I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.
I have a large Excel sheet that needs to be typed in, and then analyzed for trends using a variety of statistical analysis techniques. Key Requirements: - Data Entry: The project involves a substantial amount of data that needs to be accurately typed into Excel. This part of the project requires a detail-oriented and precise freelancer. - Trend Analysis: Once the data entry is complete, I need you to analyze the data for trends. This requires a good level of understanding and experience in trend analysis. - Statistical Analysis: The project also involves performing a range of statistical analysis on the data, including: * Descriptive Statistics: This will involve summarizing the main aspects of the data set, such as mean, median, mode,...
...architecture decisions for your team. It is your responsibility to drive projects forward, mentor junior team members, ensure alignment with the company’s overall architectural direction, and contribute to continuous improvement initiatives. By delivering innovative and reliable software, you will contribute to the success of our organization and make a meaningful impact to thousands of customers and millions of users. What you’ll do ● Lead and develop high-quality working software, with a solid design and architecture that is consistent with our overall company-wide approach ● Provide technical guidance and mentorship to less experienced team members ● Partner with Architecture and Engineering Director t...
I'm in need of a talented developer to create a robust and user-friendly ERP system tailored for my school. The system should incorporate a range of school-specific features and ensure that it can handle the significant amount of students enrolled (500 or more). Key Features: - **Student Attendance Tracking**: An essential feature that will allow efficient monitoring of student attendance. It should be easily navigable and facilitate real-time updates. - **Gradebook and Report Card Generation**: A feature that will automate the grading process, enabling teachers to input grades and generate student report cards efficiently. - **Parent Communication Portal**: A secure platform through which parents can access important information about their children'...
I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.
I'm looking for a skilled analyst to examine and arrange a substantial set of numerical data using Excel. The primary purpose of this project is to facilitate thorough data analysis. However, the data's arrangement or layout has yet to be defined, and I'm open to suggestions from the freelancer on how best to structure the data for optimal analysis. Ideal Skillset: - Strong background in data analysis and numerical data - Proficient in Excel, including its advanced functions - Ability to suggest and implement data arrangement strategies in Excel This project will require strict attention to detail and excellent organizational skills. So, if this project is up your alley, don&#...
Seeking a skilled programmer adept in WordPress for custom coding work and form layout adjustments. Requires proficiency in backend management, specifically relating to data capture, viewing, and exporting in Excel format. A highlight of the project entails the customization of our existing WordPress theme and the integration of new, unspecified features. Lack of detailed request emphasizes the need for a freelancer capable of intuitive problem solving. Primary tasks include: - WordPress custom coding - PDF form adjustments - Data capture and export to Excel Ideal candidate should have knowledge and experience in custom coding, WordPress navigation, and form data handling. Exceptional problem-solving skills are highly appreciated. U...
...urgently requiring a resourceful developer to create a tailor-made HR dashboard for our company. The developer should ideally have extensive experience in HR dashboard creation and a strong understanding of HR-related metrics. Key Features: - The dashboard should prominently feature recruitment metrics and performance evaluations. Recruitment Metrics Include: - Time-to-hire - Cost-per-hire Performance Evaluations Indicators: - Retention rate The dashboard should present these metrics in a clear, accessible format, preferably utilizing visually-pleasing graphs and charts. To excel at this project, the developer should have significant experience working on similar projects, a keen eye for design, and a knack for turning complex data into ea...
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.
Hi Ashish, this is for the tasks I emailed about.
I'm looking for a detail-oriented freelancer to help me with an Excel data entry project. The task primarily involves typing text from scanned documents into my Excel sheet. **Key Requirements:** - Accurate typing of text from scanned documents into Excel - Organizing the data into tables and lists **Skills Needed:** - Proficient in Microsoft Excel - Attention to detail to ensure accuracy - Experience in data entry, ideally with scanned documents - Ability to organize data into tables and lists The ideal candidate should be comfortable working with scanned documents, have a knack for accuracy and attention to detail in typing, and be able to organize the data effectively into tables and li...
I'm in need of an expert who can develop a risk assessment model for Cmbs SASB. The main goal of this project is to identify and analyze risks associated with my investments. Key Project Details: - The primary focus will be creating a risk model for Cmbs SASB. - I will provide third-party analytics data which you will need to integrate into the model. - The development and implementation of this model will be done using Excel. Ideal Candidate: - Prior experience in financial risk assessment, ideally involving Cmbs SASB. - Proficiency in Excel is a must, as this will be the main tool for developing the model. Please provide any relevant past work or experience that you think aligns well with this project. We can discuss f...
I have a project which involves transferring text data from PDF documents into an Excel sheet. The data is purely text-based and will need to be accurately inputted. The ideal freelancer for this project would: - Have experience with Excel data entries, especially involving text - Be proficient in working with PDF documents - Have previous experience in data import from different formats Your job will largely involve: - Importing data from PDF files into Excel accurately - Ensuring correct data input without losing any details - Maintaining the original structure and formatting wherever necessary Please ensure the completion of this project in a timely and precise manner.
...looking for someone to build a basic Shopify app that will eventually be integrated with an API that we're developing (may need hep on this, but it's a separate project). We'll need the freelancers to ultimately sign an NDA and IP agreement. There are several important elements we need built, though we are not yet fixed on a development stack. Basically we need functionality such as shopping cart management, order modifications, returns and exchanges, product information, FAQs, store policies, discounts, and upselling/cross-selling capabilities. Probably most or all is in some github repository, which we are fine with using as well as GPT-4, which, if you don't have an account, we'll get you one. It is important to only use MIT or si...
I'm searching for a detail-oriented freelancer with extensive experience working with Excel. - This task involves typing text data into an Excel spreadsheet. - The data entered will be a mixture of both structured and random entries. Thus, a keen eye for detail and the ability to maintain organization amidst complexity is key. - As a crucial aspect of this project, I require error checking to ensure the highest quality of work. The ideal candidate should have experience and knowledge in Excel data validation. - For successful completion of this project, accuracy and attention to detail are paramount. Candidates with previous background in similar tasks will be highly regarded.
...experience in Drupal 10 and Microsoft 365 Suite (MS Forms, PowerApps, Power Automate, SharePoint Online). • Drupal 10 Services: The Drupal 10 project should include features like custom theme development, content management system, user registration and login, search functionality, and issue troubleshooting. - Theme Development: The custom theme should adhere strictly to our corporate branding guidelines and styleguides. • Microsoft 365 Services: The professional should also have expertise in MS Forms, PowerApps, Power Automate, SharePoint Online, and related M365 knowledge and competencies to ensure smooth operation of the systems. In total, this project will involve approximately 400 man-days of work, with 200 man-days ...
I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.
...before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if t...
I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.
I'm in need of a software programmer who is proficient in Python, Java, and C++ to develop a small-scale software program primarily aimed at automating a specific task. The task itself is relatively simple, but the automation of it is critical to increase efficiency. Key aspects of the project: - The software program must be designed to automate a specific task. It's crucial that the programmer fully understands the task at hand to ensure a seamless integration of automation. - The scope of the project is small-scale, so the focus is on developing a functional, efficient automation solution. - Proficiency in Python, Java, and C++ is non-negotiable. The software is expected to be developed using these languages. Id...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set t...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...funding opportunities in order to ensure successful grant approvals. The Grant Writer MUST be Canadian or have the expertise and experience with the Canadian government, ideally living in Canada and speaks and writes English Fluently. They MUST specialize in IT/digital marketing/ ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for finding funding opportunities for our organization and writing polished proposals to earn Ontario & Federal government grant money. The Grant Writer will identify, define and develop funding sources to support existing and planned program activities as well as lead the development, ...
...professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how ...
I require an proficient developer to create a script that can send out automated emails through Gmail. This task should be accomplished with an appropriate scripting language for Gmail's environment. Key Requirements: - Send out notification emails. - The notifications will be for scheduled reminders and service status updates. - Targeted audiences are all users and selected groups. Relevant skills include proficiency in JavaScript (as Gmail Scripts commonly employs this language) and familiarity with Gmail's API. Knowledge of handling scheduled tasks and interaction with user databases is also beneficial. In short, I'm looking for a coding and Gmail expert who can automate the process of sending important reminders and status updates to...
...am looking for someone experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail t...
I would like to design standard operating procedure (rules of lead engagement) based on large medium and enterprise segments- 1) how should sales consume the leads once a lead is assigned to the sales reps. 2) Define the stage movement timeline from one stage to another in salesforce based on which stage the lead is in. 3) How long to wait to send a follow up email /call after the two way connection has been established. 4) Reason to close or recycle the lead 5) Activities logged in salesforce. etc.
I am in need of someone with expertise in updating tasks in a digital planner. I would need the freelancer to: - Automate the initial task in bucket 1 to re-appear after completion - After bucket 1's task has been completed, automate a new task in bucket two, -Once bucket 2's task is complete, automate a new task in bucket 3, and so on. I specifically require these tasks to be automated using Power Automate. The ideal freelancer will have experience in digital task management, Power Automate and task automation. This should allow for a smooth update of tasks in my planner without the need for manual input.
...looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowled...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's access...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user...
More details: What is the intended purpose of the device? Power automation What specific functions or tasks should the device be able to automate? power grid line control Do you have any specific requirements or features in mind for the power grid line control functionality? Real-time monitoring, Remote control. Develop a hardware prototype for detecting illegal electrical current tapping and automatically shutting off power to prevent hazards.
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
Project Description: I am seeking an experienced freelancer to develop an All-in-One AI-based HR Solution Platform entirely from scratch. This platform will serve as a comprehensive tool to streamline various HR processes and enhance efficiency across our clients' organizations. Requirements: The freelancer is required to develop a single platform capable of providing web and aap based services for product owner and client user interface, with the following functionalities: 1. Recruitment and Applicant Tracking: Streamline the recruitment process, from job posting to candidate selection, with robust applicant tracking capabilities. 2. Employee Onboarding and Offboarding: Simplify the onboarding and offboarding processes for new and departing employe...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting ...
...looking to create a WhatsApp CRM that incorporates a variety of features to improve our customer relations and team management. Key Features: - Scheduling Surveys: The system should support date availability checks, scheduling and booking confirmation via WhatsApp to our staff. Their responses should organise them into yes and no groups. This will help us automate repetitive tasks and sharing of information to groups of people. - CRM Management: I am an agent to film ans supply extras for background. This requires searching for certain character features of our staff. For example brown hair, 5"4 female. of male 6'2 blonde. I then send a availability check to work on certain dates and if they agree i send their profile to...
Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Imag...
...help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering principles. The effici...
...set up a robust CI/CD pipeline to automate software delivery on the AWS platform. This project is specifically focused on AWS, and ideally, you should have experience with the following: - AWS EKS: The ability to create, manage and optimize a Kubernetes cluster on AWS EKS. - Argocd: Proficiency in configuring and deploying applications to Kubernetes using Argocd. - CI/CD Best Practices: Strong understanding of industry best practices for CI/CD, including infrastructure as code and automated testing. - Monitoring and Logging: Experience with setting up highly advanced monitoring and logging for CI/CD pipelines, ensuring real-time monitoring and comprehensive logging capabilities. Your role will be to design and implement a robust system th...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
I'm in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided ...
