Excel macrosPekerjaan

We are looking for a crawler/scrapper for a specific android app. e.g. This app has a map which is overlaid by a marker on specific locations, once you click on it it shows further details like address, availability, amenities available etc. We would like a tool which on a given frequency (calibratable) pulls the data from the app and update in a excel file ( or similar database). The tool can be developed in any environment, but should be executable on Windows machine. The deliverable is the tool and its source code.

I am looking to submit data across multiple website forms such as company rewards sites, membership signups, etc I will provide an excel sheet with following data to enter Entry fields would be Full Name First Name Last Name Address City State State A- ‘A’ stands for abbreviation Zip Code Phone Number Email Address I Will also provide a list of multiple sites and webpages that I would like the data to be entered and submitted. I need this data to entered to all website web forms all at once as a batch if applicable. Skills and experience: - Experience in web form automation is required. Number of webpages: - The estimated number of webpages to be handled is between 250 and 1200. - Knowledge of web automation tools such as Microsoft Power Automate Deskt...

I am in need of an Excel database specialist to create and set up a comprehensive database for my company. This will involve: - Implementing a spreadsheet to store various types of data including customer information, sales data, product inventory, and production information. This project requires a freelancer who possesses strong excel skills, an understanding of databasing and someone who pays great attention to detail to ensure all data fields are captured correctly. Previous experience in data base creation or working with similar fields is a plus. Lastly, fluency in Spanish would be highly beneficial as some of the fields are Spanish terms. The end goal is an efficient, easy-to-use Excel database that meets all our business data needs with colorful dashboards...

I am in search of an individual or team with exceptional skills in locating...track record in locating private buyers/ sellers of high-value assets. - Strong networking skills with access to exclusive, off-market listings. - Knowledge of aviation industry standards, specifically private jet models, specifications, and legal requirements. - Excellence in communication, ensuring a smooth and discreet process. This is a unique and challenging opportunity for professionals who excel in the art of sourcing exclusive assets. Your expertise can facilitate an acquisition that not only meets but exceeds expectations, setting a new standard for personalized travel solutions. ****You are only finding private jet payout will be sent on final sale of Jet, Payout depending on Performance and ty...

I need an app for data entry and produce a compound of that data. Also, generate graphics in excel.

...textual data into an Excel Spreadsheet. Here's a bit more about what you'd be doing: - Enter a significant amount of data: The spreadsheet will consist of 100-1000 rows and columns worth of various types of data. - Handle varied data types: The data to be entered is a mix of both numerical and textual data. Ideal skills for this project include: - Advanced data entry proficiency: Fast, accurate input skills will be key since there's a considerable amount of data to handle. - Experience with Excel: You'll certainly need a good working knowledge of Excel to navigate through data input efficiently. - High attention to detail: Given the volume and variety of data, precision will be paramount to ensure no errors during data entry. Looking forwa...

I am seeking a skilled expert to assist me with a Power BI project, focusing on data modeling. Specification: * I have a collection of Excel/CSV files lined up for this project. * The data pulling for this project is simple, containing only a few columns. Skills and Experience: * Expertise in Power BI with special focus on Data Modeling is preferred. * Being well-versed with handling Excel/CSV files would be beneficial. * Proven experience with managing small-sized datasets will be advantageous in this project. In-depth understanding of Power BI and Excel/CSV data handling is a must for this project. Above all, I am looking for someone who can deliver high quality work within tight deadlines. If you fit the bill, let's get in touch.

...am in immediate need of a proficient MS Excel expert with deep knowledge of Excel 365. The task at hand is quite specific: - Create a auto generated text string part number (Col C) based on selected matrices (Col D-AA), Yes in field - build the part number string from the text in the headings ColD3,AA3 - add a "+" between each selected option in the generated string (Col C) - sample file included for task at hand - if the options column is populated with "Yes" then add the text option to the generated string part number. two examples are in the sample supplied - add drop down box per cell in the options matrix for "Yes" or blank. The professional for this role ought to possess a substantial understanding of data manipulation and expertise i...

Have another quote to convert. PDF to Excel. As done previously.

I'm in need of an exhaustive contact list of private colleges in the UK for marketing outreach. I will be sending them marketing email to sell my services including IT and AI courses. 1. Create an Excel file. 2. 1st column name of the college, 2nd column email1, 3rd column email2 and so forth for more emails. 3. Any other helpful information that you can easily scrap could be helpful such as the name of the principal or key persons to address email, or phone numbers etc. In the UK students generally attend year 1 to year 12 in schools and then they go to FURTHER EDUCATION colleges for diplomas/certificates or for degrees (bachelor/master) attend universities. *** No schools or universities should be the included list. *** Remember I am targeting diploma awarding colleges NOT ...

I urgently require data entry into Excel spreadsheets. The data includes text, numbers, and emails. The formatting is straightforward - only the specific fields that I will provide. The Ideal Candidate: - Strong experience in Excel data entry - Attention to detail - Ability to work in a time-sensitive environment Please note, I'm looking for someone able to start as soon as possible.

I'm on the hunt for an expert in upper-level Excel design who will breathe life into my raw data. Your work should include: - Aesthetic and user-friendly form designs, - Creation of custom formulas, - Integration of conditional formatting to facilitate data analysis, - Not sure about the exact formulas I'd need at this point, but definitely expect some decent use of lookups, - Ideally, if there are multiple properties, i should be able to one main sheet to review the total income/net worth. I gave provisional thought to graphical representation and didn't provide specific options. However, given your expertise, I trust you'll incorporate a proper way to represent data. Ideal candidates should be adept in Excel, data visualization, and have a knack for s...

Silakan Daftar atau Login tuntuk melihat rincian.

I am in need of an expert in Excel, well-versed in sorting and filtering large data sets (containing more than 1000 rows). The project will involve: - Data Sorting & Filtering: You'll need to efficiently sort and filter my dataset according to the variables I provide. This will help me to pinpoint the essential details in my sea of data. - Descriptive Statistics: Additionally, your task will include calculating intermediate-level statistics, such as standard deviation & variance. This will help provide a clearer picture of the patterns and trends in my data. This is the perfect opportunity for freelancers with experience in handling large data sets in Excel and who are proficient in computing standard deviation, variance and other similar statistical operatio...

Busco asistente personal y reclutamiento. Requisitos -Hablar españ...-Atender candidatos y citarlos a entrevista, por correo electrónico. -Enviar evaluaciones por correo electrónico. -Manejar agenda para entrevistas de candidatos, preferible que sea ágil para utilizar plataformas de citas o calendarios. -Saber utilizar plataforma de Chat GPt, Bard. -Redactar vacantes en Canva o otra app de diseño. -Tener excelente ortografía y redacción. -Registrar candidatos en Excel. -Envíar mensajes de que no quedaron en el proceso. -Dar apoyo en otras funciones afines, cómo redacción de informes y evaluaciones para los Candidatos.. Obligatorio -Tener computadora o laptop, para poder utilizar el correo correctamente. El tra...

...freelancer to assist me with transferring information from PDF files into a structured digital format. My project involves converting data from multiple PDF documents into an organized, user-friendly system, likely a database or spreadsheet. Ideal Skills and Experience: - Proficient in data entry with a keen eye for accuracy. - Experienced in handling PDF files and converting their contents into Excel spreadsheets or similar formats. - Capable of organizing data logically and efficiently. - Familiarity with data management software is a plus. - Ability to meet tight deadlines without compromising on quality. The project needs someone who is meticulous, reliable, and can work independently with minimal supervision. If you have experience in data entry, especially from PDF files...

...a whiz with Excel but also has outstanding communication skills and can effortlessly manage phone calls. This unique blend of skills will help streamline my workflow, ensuring efficient phone call management and meticulous Excel sheet maintenance. The ideal freelancer for this role should bring a proactive attitude, a keen eye for detail, and the capacity to handle tasks with precision. **Key Responsibilities:** - Manage outgoing and incoming calls on a weekly basis, ensuring clear and concise communication. - Maintain and update Excel sheets with accuracy and attention to detail, keeping track of all necessary data. - Exhibit excellent communication skills to handle queries or issues that may arise during calls. **Ideal Skills and Experience:** - Proficiency in M...

...my existing Excel spreadsheet data into a comprehensive and visually engaging report. This report will primarily facilitate data analysis and insights, helping me understand complex datasets at a glance. **Key Requirements:** - Develop an array of pie charts, lists, bar graphs ( to your choosing) to represent different data sets effectively. - Provide a one-time setup for these charts and stats with no need for ongoing updates. - Ensure that the visuals are not just informative but also aesthetically pleasing to make the data analysis process more engaging. - must be 2 pages of charts maximum - must include all categories that are assigned - does not need to be exclusively percentage numbers can be words, raw numbers etc. **Ideal Skills and Experience:** - Proficiency in E...

I'm looking for a knowledgeable and efficient individual who can generate a data spreadsheet that encompasses names, dates, and numbers. These categories should be organized into separate columns for easy navigation and viewing. Key Requirements: - Proficiency in Microsoft Excel or similar platforms. - Expertise in data entry with an attention to detail. - Ability to categorize data into separate columns for easy browsing. - Understanding of date operations. Kindly note, there is no need for any complex calculations or operations to be applied to the collected data, just publications specific to events and their dates. Your understanding, professionalism and speedy delivery are what I require for this job. Thank you.

We are looking for a data collection group to input into an excel spreadsheet golf ball data metrics. We are specifically looking for data from a company that makes a product called Trackman. We only want data from a Trackman device. NOT OTHER MANUFACTURES. Please see images for the specific data fields we are requesting and the spreadsheet format. The project requires the following; - Locate data sources on the internet through message boards. Many individuals post their shared link so users and coaches can view their data. - Create a excel spreadsheet with the fields provide in the attachment. Input all 12 fields. - Include the links where the data came from as a reference. - 2000 shot metrics are required (24,000 total data points). Each shot metric has 12 fields. If you...

...knowledgeable freelancer who can create a comprehensive Bill of Materials (BOM) in Excel that will help streamline our inventory management, specifically focusing on raw materials, finished products, and various components. This BOM will be a vital tool for managing our stock efficiently, helping to avoid overstocking or stockouts, and ensuring that we maintain a cost-effective operation. **Key Requirements:** - **Item Details:** I need the BOM to include multiple layers of item categorization, such as Item Category, Sub Category, and precise Item Name. Additionally, it’s crucial to track each item's Expiry Date and Batch Number to ensure product quality and compliance with regulations. - **Calculations and Formulas:** The excel sheet must include formulas fo...

I'm on a quest for a talented Excel guru that can help me pull data based on multiple criteria including - text, numbers, and dates. You will be tasked with developing a sophisticated formula capable of performing an index match or similar method for data analysis. Important skills and experience: - Proven Excel expertise, particularly in advanced formulas - Data analysis capabilities - Solid understanding of numeric, text, and date criteria within Excel - Previous work experience involving financial analysis is a plus, but not a must In your bid, please detail your relevant experience and your approach to tasks of this nature. Let's get the numbers crunched!

I'm seeking a seasoned Sales Manager to boost the sales of my company's tech services, which include IT consulting, software development, and network infrastructure. The ideal candidate would excel in: - Generating hot leads - Closing lucrative deals - Managing robust client relationships While handling small to medium-sized businesses, strong interpersonal skills, a keen understanding of tech services, and a persistent nature would significantly contribute to your success. Prior experience in selling tech services in international market to similar clientele is highly beneficial. Let's bring revenue up!

I'm in urgent need of professionals adept in data entry and data validation tasks who can efficiently manage responsibilities from the comfort of their homes. This project offers flexible working hours, fitting perfectly with those looking for an adaptable schedule. **Here's what you'll be doing:** - **Data Input:** Accurat...occur through **Live Chat**. Prompt responses and clear communication are key. **Ideal Skills and Experience:** - Proven experience in data entry and validation. - Keen attention to detail. - Excellent typing speed and accuracy. - Effective communication skills, specifically through live chat. - Ability to work independently with minimal supervision. This project is suited for individuals who excel in a flexible work environment but meet tight...

...textual data into an Excel Spreadsheet. Here's a bit more about what you'd be doing: - Enter a significant amount of data: The spreadsheet will consist of 100-1000 rows and columns worth of various types of data. - Handle varied data types: The data to be entered is a mix of both numerical and textual data. Ideal skills for this project include: - Advanced data entry proficiency: Fast, accurate input skills will be key since there's a considerable amount of data to handle. - Experience with Excel: You'll certainly need a good working knowledge of Excel to navigate through data input efficiently. - High attention to detail: Given the volume and variety of data, precision will be paramount to ensure no errors during data entry. Looking forwa...

More details: What specific services are you looking for in transportation and trucking scan? Fleet management What is the primary goal for integrating fleet management? View of all app...transportation and trucking scan? Fleet management What is the primary goal for integrating fleet management? View of all applicable providers in the US How soon do you need your project completed? ASAP Looking for a market scan with specific information for example, number of trucks, type of freight, employee headcount, type of software, freight lanes across a long list (~350) of companies. An excel spreadsheet and list of companies would be provided to start the research and would require columns to be populated by looking at company websites / calling companies to source the relevant in...

...will identify which questions should be answered by your analysis. List the 10 most important questions that arise from your review of the Vertical Analysis and Horizontal Analysis you performed (see the excel tabs named Vertical Analysis and Horizontal Analysis). Answer each of the 10 questions that you identified. You may refer to MANAGEMENT’S DISCUSSION AND ANALYSIS OF FINANCIAL RESULTS OF OPERATIONS inside SEC 10-K reports. Note: which questions are relevant for each company can be different; use the BS analysis to drive the Q&A process. 4- Ratio Analysis and Interpretation: Using the excel tabs Ratios-avg or Ratios-end, evaluate each of the ratios and explain whether/if/how each ratio affects your conclusion about your firm’s economic position. See the...

I'm looking for a talented artist to bring a cherished memory to life through a unique piece of artwork. I have a photo of the original scene where the memory was created. The concept I have in mind bal... **Ideal Skills and Experience:** - Proficiency in digital art creation - Ability to blend realistic and cartoonish art styles seamlessly - Strong communication skills to ensure the final product matches the vision - Experience in creating custom artwork based on client descriptions or memories - A portfolio showcasing similar works is highly desirable This project is perfect for artists who excel at infusing realism into cartoon-inspired art or vice versa. If you have a knack for capturing emotions and stories in your pieces, I can't wait to see how you'll bring ...

I'm currently experiencing challenges with my project which requires Python programming and Excel skills. The script in question is not running as expected and not producing desired outputs. Key Responsibilities: - Review and understand the existing script - Identifying and fixing the coding issues preventing the script from running - Ensuring the script accurately calculates data and issues are resolved Ideal Skills: - Python programming - In-depth knowledge of Excel - Experience in debugging and fixing code Only experienced.

I'm seeking an expert in Excel and Google Sheets proficient in generating line graphs and preparing datasets from scratch. Notably, the focal point revolves around: - Crafting engaging line graphs representing various elements to visualize data trends effectively. - Initiative in creating a comprehensive customer engagement data set. An ideal candidate would have a solid background in data analysis, data interpretation, and knowledge in market research may be advantageous. The task requires strong attention to detail, prowess in handling Excel and Google Sheets, and exceptional abilities in data visualization.

...and total of expenses, and our net profits during the period. - **Analysis for Strategy Planning:** Beyond just numbers, I expect insightful analysis on what these figures mean in the context of our business operations and market conditions. Recommendations on potential adjustments or new strategies will be highly valued. **Ideal Skills and Experience:** - Proficiency in accounting software and Excel. - Strong analytical skills with a knack for identifying trends and insights. - Experience in financial forecasting and reporting. - Excellent communication skills for presenting complex information in an understandable manner. Your expertise will be instrumental in guiding the strategic direction of our business, ensuring we're not only responsive to our current financial st...

...is to have this information neatly formatted into an Excel spreadsheet for my analysis. **Requirements:** - Proficiency in webscraping technologies and tools. - Ability to identify and extract specific text content. - Expertise in data formatting and Excel spreadsheet manipulation. **Ideal Skills and Experience:** - Strong background in Python, particularly with libraries like BeautifulSoup or Scrapy. - Experience with data extraction and web crawling. - Proficient in Excel formatting, including creating tables, applying filters, and using formulas. - Attention to detail to ensure accurate data extraction and formatting. - Good communication skills to clarify details or requirements. **Project Deliverables:** - A comprehensive Excel spreadsheet contain...

I'm in search of an Excel expert who can competently handle tasks involving data analysis, spreadsheet design, and formula development. Key Responsibilities: - Analyse a medium-sized dataset (100-1000 rows) - Design an efficient and clear spreadsheet in a Database format - Develop effective formulas based on given specifications Ideal Skills: - Excellent knack for data analysis - Proficiency in designing Excel spreadsheets - Advanced understanding and ability to develop accurate formulas - Familiarity with Database formatting of spreadsheets Your ability to streamline data, create visually informative spreadsheets while maintaining a clean and organized layout in this project is just the expertise I need. If you fit this description and have a proven history in these...

I'm looking for an experienced freelancer to handle a data entry project that consists primarily of text data. The candidate will need to extract this data from online sources I will specify and enter it into an Excel spreadsheet format with accuracy and efficiency. **Key Requirements:** - Proficiency in data entry with a keen eye for details. - Strong experience in handling text data. - Excellent knowledge of Excel and its various functions. - Ability to source data online and discern what is relevant. **Desired Skills:** - Fast typing speed with high accuracy. - Experience in web research. - Familiarity with data entry protocols and spreadsheet management. - Good organizational skills to handle data in a logical and accessible manner. The perfect candidate will n...

I need to split data and clean work

I am seeking a proficient Excel expert who can precisely update the parameters within an existing formula. This task is critical for improving the performance and accuracy of our data analysis processes. Ideal candidates will have a strong background in managing, analyzing, and fixing formulas within Excel to cater to specific business needs. **Requirements:** - Expertise in Excel formulae modifications, particularly in updating parameters to enhance functionality. - Strong understanding of handling numerical data types within Excel formulas. - Ability to efficiently diagnose and modify existing Excel formulas based on provided parameters. - Proficiency in securely handling Excel files shared for the purpose of updating formula parameters. **Shar...

I am seeking a talented copywriter with a unique blend of expertise in academic writing and copywriting. The purpose of this role is ...and management. - Ability to translate complex research into accessible content. Key Project Expectations: - Develop white papers with an executive summary and a detailed analysis. - Engage a corporate leader audience through clear, authoritative content. - Ensure the final product is polished, well-structured, and ready for presentation. This role is a fantastic opportunity for individuals who excel at making academic insights practical and engaging for industry professionals. If you have a track record of transforming scholarly articles into influential white papers and possess an understanding of leadership dynamics, I invite you to submit your...

I'm looking for someone with intermediate expertise in Excel to assist with various data entry tasks related to accounting. The scope of work will primarily involve the following: - Invoicing: You'll be required to input all necessary invoice data accurately. - Expense tracking: This will involve keeping a thorough record of all business expenses. - Bank reconciliation: You'll need to match our bank records with our Excel records, ensuring that all transactions align. If you have prior experience with Excel data entry in an accounting context, particularly with invoicing, expense tracking, and bank reconciliation, you might just be the perfect fit for my project.

...filters and other barriers that prevent successful delivery. - **Reduce Bounce Rates**: High bounce rates harm sender reputation. The service must minimize this by removing invalid, inactive, or non-existent email addresses from the list. **Integration Needs**: - **Batch Processing via File Uploads**: The service must accept batch processing, allowing me to upload lists in a suitable format (CSV, Excel) for validation. A user-friendly interface for uploading and downloading processed files is essential. **Ideal Skills and Experience for the Job**: - Proficiency in email validation software and techniques. - Experience handling large datasets and performing batch processing. - Knowledge of the best practices in email marketing, especially related to list hygiene. - Ability to c...

VBA Tool to import two kinds of pdf inputs and extract data in one common sheet. Dynamic selection of inputs structure. and Input-2021-Extracted (without account numbers).pdf files conversion to excel output. Scalable and customizable for other input

Here's a breakdown of programming a Modern Portfolio Theory (MPT) Markowitz setup in Excel using VBA: Objective: Build a VBA program that calculates efficient portfolios based on user-defined inputs, adhering to MPT principles. Inputs: • Import historic prices from Yahoo Finance. I have a functional code that you can uce. • Expected returns: Leave a field in the main excel sheet that allows for the user to input the expected returns for each asset. • Risk-free rate: Leave a field for the user to input the risk-free rate of return. • Log returns: Calculate the log returns on the historical prices, taking into account the dividends. • covariance matrix: A matrix representing the covariance between each pair of assets. • Target return or ris...

I am seeking an experienced software engineer to create and develop a production-level application for operating a wearable device. This project involves programm...Linux OS and its application in embedded systems. - Familiarity with user interface design, aiming for a user-friendly experience. **Objectives:** - Deliver a robust, efficient piece of software capable of real-time operations and seamless hardware interaction. - Ensure the software’s stability and reliability on Linux environments. This project offers an exciting challenge for developers who excel in creating innovative, user-focused solutions for wearable technologies. Your expertise will play a critical role in bringing this wearable device to life, ensuring it meets the desired specifications and operational...

I am looking for a professional who can help me create an Excel course that takes students and professionals from complete beginners to advanced users. The course should cover all the essentials and more. Here's what you would need to do: - Design a beginner to advanced level course layout - Cover topics such as Basic Excel Functions, Formulas, Data Analysis and Visualization, Macros, and Automation processes - The course should be aimed at enhancing efficiency in data management and making data analysis easy - The target audience would be students and professionals The ideal freelancer for this project is one with experience in both Excel and course creation. They should have an excellent understanding of Excel's advanced functions and the ability t...

...directly from an uploaded Excel sheet without actually collecting this information during the browsing session. **Essential Features:** - **Product Search Functionality:** Enable users to easily search for products. - **Shopping Cart:** A seamless checkout experience. - **User Registration and Login:** Utilize phone numbers for account creation and access. - **Data Display:** Show relevant user details from an Excel file on the website without storing these details. **Ideal Skills and Experience:** - Proficiency in website cloning and customization. - Strong backend development skills to handle data display functionalities. - Experience with e-commerce platforms, specifically in creating secure login systems and integrating shopping carts. - Capability to work with Ex...

need to convert the following images into Excel files. The images contain Indian numbers. (( Urgent delivery within a few hours )) * You are required to convert the columns containing numbers in black or blue only. * Columns in red are not required. * Each image must be in a separate Excel file or a separate sheet within the Excel file. * There is an example within the images showing the required format - coloring the columns is not mandatory, just input the numbers. * Project Budget: $6 To ensure that you have read the description, please include the following phrase: "Project Budget: $6"

Silakan Daftar atau Login tuntuk melihat rincian.

Product Owner: Scaling Excel Analysis Solution to Enterprise Level Description: We are looking for an experienced Product Owner to oversee the transformation of our existing Excel analysis solution into a scalable, enterprise-level product. The current solution involves data analysis using Python Anaconda, focusing on ensuring uniqueness in the submissions column. The goal is to elevate this solution to a comprehensive data management platform that can be marketed and sold to companies in the future. Responsibilities: Collaborate with stakeholders to understand the requirements and vision for the product. Define and prioritize product features and enhancements based on customer needs and market trends. Conduct market research and competitive analysis to identify opportuni...

...assist with a project involving Excel data analysis. The task entails processing an Excel sheet with three columns: name, date, and submissions. The primary objective is to ensure that the submissions column contains unique values in every row, with no duplicates allowed. Requirements: Proficiency in Python programming, specifically using Anaconda distribution for data analysis. Experience in data manipulation and analysis, particularly with Excel files. Ability to write efficient code to process and analyze large datasets. Strong attention to detail to ensure the accuracy and correctness of results. Deliverables: Reads the provided Excel sheet. Processes the data to ensure uniqueness in the submissions column. Outputs the modified data either to a new ...

im looking for a excel expert who can reduce the price -19% in a column. quick 2 min work for a expert budget 8€

Project Description: I need to convert the following images into Excel files. The images contain Indian numbers. You are required to convert the columns containing numbers in black or blue only. Columns in red are not required. Each image must be in a separate Excel file or a separate sheet within the Excel file. There is an example within the images showing the required format - coloring the columns is not mandatory, just input the numbers. Project Budget: $4 To ensure that you have read the description, please include the following phrase: "Project Budget: $4"