Excel macro data cell jobs

Looking for a professional with expertise in Excel to create spreadsheet templates for our business data analysis and financial tracking needs. Key Responsibilities: - Design spreadsheet templates that can effectively analyze various types of business data including: - Daily payments - Dues - Closed accounts - Daily totals - Carry forward amounts - Incorporate functions that assist in financial tracking. Ideal Skills and Experience: - Advanced proficiency in Excel - Excellent analytical skills - Previous experience in financial tracking and data analysis - Understanding of business processes and financial variables. Please provide examples of similar work accomplished and ensure you're able to meet all specified requirements.

I require a data analyst with proficiency in PowerBI to create a dashboard focused on analyzing compensation rates based on demographic details. I've attached a rough markup and source data. Will need this completed in a short timeframe due March 7th by 8am PT. The data source will probably need some cleaning in Power Query to be able to be presented accurately. You don’t need to recreate exactly, so feel free to add anything that you think would be worthwhile to look at. Thanks!!

THIS IS FOR UNITED STATES ONLY! We are searching a person that can work at the supermarket. The payment will be $12 for working hour (at least 75 scans in 1 hour). Only offer if you have at least 20 hours free in the week. This job involves going to a supermarket and taking photos of products (3 photos for each product). You'll only need a basic cell phone camera without editing photos. See attached sample photos. A list of product categories will be provided and there is no limit to the number of products to be shipped. If you are interested, leave a message and I will give you more information.

I need a capable freelancer to extract both text and image data from a specific app and translate it into both Word and Excel formats. Here's what's required: - Extract text and image data from app - Efficiently rewrite this information into Word and Excel files - There's no need to organize the data according to any specific criteria within the Excel document, offloading it randomly is perfectly acceptable Preferably, the freelancer should have excellent data entry skills and proficiency in using Word and Excel. Experience with data extraction from apps would be a plus. There is around 800 questions.

...that can create an intuitive and reporting-rich Tableau dashboard from a set of data in Excel spreadsheets. Key Deliverables: - Data Analysis: Analyze the set of data from the Excel spreadsheet to create insightful visualizations and reports in Tableau in a user-friendly way. - Data Visualization: Develop a histogram visualization tool that will be included in the Tableau dashboard to enhance readability and clarity of insights derived from the data. - Data Filtering: Implement a Category-based filter system to ensure ease of use and data accessibility. This should allow users to effortlessly navigate through our data set. Ideal Candidate: - Proficient in Tableau software and Excel. - Strong background i...

I want to create an unlimited chrome tool or addon with functions like the addon below

...freelancer to do the following using Excel macro. 1. Collect Web URLs and name. Using my LinkedIn, I will open multiple tabs in the web browser (happy to use the browser of your choice). Each Tab will have a different person's profile. I will execute the macro prepared by the freelancer, this macro will do the following: a. Navigate to each tab. b. Collect URL in Excel (col A) c. Collect person's name in col B d. Collect person designation in col C. 2. I will manually review the data collected in Excel and create another list in a separate Excel containing the person's profile URL and message. I will execute the second macro created by the freelancer. This macro should do the following. a. FYI: My ...

...substantial experience in web scraping, particularly extracting data from dynamic and complex websites. The project involves two main tasks: 1. Web Scraping: - I require specific data from , specifically, the "All-Time High" (ATH) price data from any coin listed. It is important to be well-versed in scraping techniques to navigate the website and extract this specific piece of information accurately and efficiently. 2. Data Extraction: - Use Excel VBA macro to extract the data. In one column there will be the urls of the coins to extract the ATH, like this one - The macro will rerturn the ATH value in the next column. - The macro will run clicking a button. - The macro will end once all rows with urls...

I'm looking for an expert who can create a custo...client - webmail.free.fr. (ROUND CUBE) This extension needs to be capable of automating email sending processes by pulling recipient's data from Excel files on my desktop. Rather than a predefined email template, the extension should allow for dynamic content from these Excel files to be sent as the email body. Successful freelancers interested in this job should definitely mention their experience and extend their portfolio that highlights their skills ideally in the following areas: * Chrome Extension development * Automation processes * Experience in coding for webmail service – in this case, '' * Advanced knowledge of Excel and data handling Please also specify your pro...

Project Title: Macro Automation for PC Video Game Overview: I am seeking a skilled freelancer to develop a macro based on images from a PC video game that I have created. The macro will primarily focus on automating repetitive actions within the meny of the game. Requirements: - Proficiency in creating macros for PC video games - Strong understanding of image recognition and automation techniques or OCR - Experience with scripting languages, such as AutoHotkey or similar - Ability to effectively communicate and collaborate on the project Specific Tasks: - Develop a macro that can automate repetitive actions within the PC video game menu - Utilize image recognition to identify specific in-game menu elements and trigger corresponding actions - Ensure compatibil...

I have an excel sheet in which i have varied and diverse range of products from Audio Gadget Category. For each product, i have certain aspects which i want you to research and just fill it in. I will attach the screenshot of it for your reference. There are total 75 products and total of 7 aspects, as mentioned in the attached screenshot.

I need a person to type and hold data entry from PDF files to Excel Format. Aproximate 20 Pages of data concerning tablets and graphiics to bem digitalized.

I am in desperate need of an Excel expert with an accounting background who can fix the incorrect calculations and formatting issues plaguing my Balance sheet and Profit/Loss sheet. The historical data period needing corrections remains unspecified, implying it might range from a year or more. Here's what I need from you: - Proven track record working with Excel accounting - Fine attention to detail and accuracy - Ability to work with missing information - Prior experience in managing and fixing financial data - Expert knowledge of accounting principles and practices Your main role would be to meticulously review and correct any calculations and formatting, making sure my Balance sheet and Profit & Loss sheet are flawless. With your expertise in ...

I am in desperate need of an Excel expert with an accounting background who can fix the incorrect calculations and formatting issues plaguing my Balance sheet and Profit/Loss sheet. The historical data period needing corrections remains unspecified, implying it might range from a year or more. Here's what I need from you: - Proven track record working with Excel accounting - Fine attention to detail and accuracy - Ability to work with missing information - Prior experience in managing and fixing financial data - Expert knowledge of accounting principles and practices Your main role would be to meticulously review and correct any calculations and formatting, making sure my Balance sheet and Profit & Loss sheet are flawless. With your expertise in ...

I'm in search of a competent coder with specific skills in Macro for an Excel based project. The ultimate goal is to automate a certain process, thereby making tedious tasks less time-consuming and more efficient. Specifically, I am looking for someone who: - Has proven experience in Macro coding, particularly in relation to Excel - Can demonstrate a portfolio of past work that involved creating macros for the purpose of automating work processes - Is capable of understanding the workflow and creating a macro that reduces manual input You will be tasked with improving our existing workflow through automation by developing a custom Excel macro. Dialogue and communication will be crucial in understanding the specific needs of the proce...

I am looking for an experienced app developer to create a unique application transforming an cell phone, specifically Doogee V20 pro,( Infiray thermal sensor) into a security camera. This app should not only convert the smartphone into a camera but should also utilize its thermal sensor. Key Features should include: - Motion detection: The app should alert me as soon as it detects any motion. - Live streaming option: I want to monitor live footage from the camera on my mobile app, I like option to choose active part of screen, to eliminate false alarms. Adequate skills in Android development and experience in working with video streaming and sensors would be ideal for this project. Familiarity with the "Security camera cz" app or similar projects will be a bonus as I woul...

I am currently in need of a professional with strong skills and experience in Microsoft Excel and English typing. The work will involve: - Typing text data onto an Excel sheet - The language predominantly used in the text data is English - The structure of the text data on the Excel sheet is unknown as I wasn't able to provide this information. An ability to work with data in both rows and columns or mixed formats might be required. Skills required: - Extensive experience using Microsoft Excel - English fluency - Fast and accurate typing skills - Attention to detail - Ability to work with potentially varying data structure. Please reach out if you feel this project suits your set of skills.

I'm in need of an expert who can perform a comprehensive financial analysis of cost structures, specifically organized by project, in my Excel data. Key Responsibilities: - Analyzing and interpreting complex cost structures from Excel data - Delivering a clear and concise report based on the analysis Ideal Skillset: - High proficiency in Excel - Solid background in financial analysis - Experience in cost analysis by project - Excellent data interpretation skills The output of this project will play a crucial role in refining our budgeting and financial planning. Expertise in handling similar projects is a must. Thanks in advance for your interest and bid.

Overview of the Task: The original test sheets contain many data sets each with 49 numbers. Each data set is a column. Each of the data sets/columns has 7 out of 49 numbers selected as Process numbers. These are given in bold red. Now, the last column, the rightmost column, is the target data set for prediction. All other columns are data sets to be used for training the model. The project's ultimate objective is to predict the 7 process numbers of that last column/data set using Machine Learning models. We are using as many as 5 different types of ML models to predict these 7 pattern numbers from the target data set which is the last column of each test sheet. During this process of prediction, we have come across certain observa...

...Comparison of current performance with previous periods Fuel sales vs. other services Operational Metrics: Number of trucks parked overnight Fuel sales volume Inventory levels for essential items (e.g., food, hygiene products) Staffing levels and labor costs Customer Service Metrics: Feedback and ratings from truckers Number of returning customers Average length of stay for truckers Regarding the Excel Sheet Import for Truck Details, this feature could include: Importing trucker details such as license plate numbers, arrival times, departure times, and any specific service requests Tracking and managing reservations Integration with the check-in/check-out process Once we integrate their current Accounting System into our NewDev, the designed functionalities need to inform the ...

I require a freelancer who can build an efficient VLOOKUP formula in Excel. Key details: - The VLOOKUP will be based on the 'Product Code' between two spreadsheets. - The lookup will be conducted in 'Column A’ on sheet 1 and compare sheet 2 with column b on sheet 2 - 'Column B' contains text-based values. The freelancer will need proficiency in Excel, and specifically in the creation and deployment of VLOOKUP formulas. Additionally, familiarity with product code databases or similar text-based lookups would be highly beneficial. Please ensure you can complete a project of this nature efficiently and accurately. It might seem straightforward, but I still need someone who can verify the results thoroughly.

I need an expert in data entry, especially focused on excel data typing. I have multiple worksheets containing text and numerical data that needs accurate transcription. Ideal Skills & Experience: - Proficient in Excel - Familiarity with basic and intermediate features of Excel - High accuracy in data typing - Knowledge of currency formatting Job Specifications: - Data consists of both text and numbers. - The data will be from multiple worksheets, although they have a simple layout. - Currency formatting will be required in the typed data. - Precise data entry is mandatory as the information keyed in will directly influence further applications. Your role will not only include typing the data but a...

...Microsoft Excel to carry out complex data manipulation tasks in my spreadsheet. Core Responsibilities: - Perform data manipulation using advanced Excel functions and formulas. - Specifically, I require you to execute lookups in the Excel spreadsheet to locate and retrieve necessary data. This operation will be an integral part of this project. Key Skills and Experience: - Proven expertise in using Excel for complex data manipulation tasks. - Excellent understanding and practical experience with Excel functions and formulas - Specific experience in performing operations with lookups within Excel is paramount. - Efficient and detail-oriented with a knack for accuracy. In summary, this project involves a signi...

I'm in need of a freelancer with extensive experience in Excel, specifically in applying VLOOKUP, IF, and SUM formulas. Task will mainly focus on: - Utilizing VLOOKUP to retrieve valuable data from a different sheet. - Employing IF and SUM formulas as necessary to enhance data analysis. The ideal freelancer for this project is expected to have a profound understanding of Excel functions and capabilities, and a proven track record in the efficient use of Excel for data analysis. Experience in data retrieval and comparison using VLOOKUP is highly essential for this role. Ability to cross-reference and perform calculations with accuracy is required. If you fit the description, let's get to work.

Hi, I need to configure a calendar with fullcalendar compatible for angular 15 version. The calendar must have the following characteristics: month, week view. Drag and drop the event to reschedule it. It must not be possible to reschedule an event (by dragging it) if it overlaps the destination cell. The calendar data can be mocked, it will then be hooked to an API. Thank you

I am seeking a diligent freelancer with expertise in converting single column numeric data from PDF files to Excel. The ideal candidate should have: - Demonstrable experience with similar projects - Proficiency in data extraction or manipulation tools - Proven background in handling single column data specifically numeric Please make sure you include your past work in your application. Experience in the relevant field would be a plus. The tool is expected to accurately convert these numeric values, ensuring the integrity of the data remains intact. If you believe you're the right fit for this, I look forward to your proposals.

I have a need for an Excel expert to develop a macro that automates data entry. This will specifically involve autofilling data in my spreadsheet from an eForm. The information that needs to be automatically entered into Excel from the eForm is the email field. In this project, we ask for: • Automation of data entry from eForm to Excel using Macros • Sole focus placed on the email field for the autofill feature Successful freelancers should have an exceptional understanding and experience with Excel Macros. Your ability to work swiftly is crucial as this project is required ASAP. I am looking for consistent, open communication to ensure that all objectives are met to the required standard.

...assist me with a data entry project. Here's a rundown of the requirements: - Your task will revolve around data entry specifically involving the process of copying and pasting. - You will work with data from PDF files, so a good understanding of this format is necessary. Being able to handle complex PDFs with limited Search/Find functionality would also be a key skill. - The end destination for the data will be an Excel Spreadsheet. Proficiency in Excel is a must, including creating and managing spreadsheets, sorting data into cells, and maintaining accurate and clean data. - The ideal candidate should have a keen eye for detail to ensure data accuracy, and solid time-management skills to meet deadlines. This project...

I need an experienced freelancer to develop a comparative tool on Excel for use in the general insurance broking industry. The tool should be completed in 3 working days. Main functionalities should include: - Automated quotation generation - Comparative analysis of insurance policies - User-friendly interface The comparative analysis should look into: - Price comparisons - Coverage comparisons - Comparisons of policy terms and conditions The focus will be on Workmen Compensation policies. Therefore, your understanding and experience in this area of insurance would be greatly beneficial. Ideal Skills: - Proficiency in Excel - Expertise in VBA or Macros - Understanding of General Insurance Broking - Knowledge of Workmen Compensation Policies Please only respond if...

I'm looking for a skilled guy in selenium and python; who is able to make a tool for collect info from amazon, following those feautures: 1. The script logs in to the affiliate account using the provided credentials. 2. The script loads the source CSV file cont...Description, Image 1, Image 2 (if available), Image 3(if available), Number of Reviews, Starts(Rating) and Price) 6. It will then click on the “TEXT” option below “Get Link” on top and it will switch to the popup window and wait for the popup to load and extract the affiliate link from the text box within the popup. 7. After scraping the details for the products, it saves the product details to a new Excel file with above mentioned detail parameters and affiliate link. 8. Script will also displa...

I am in need of an experienced social media editor to creatively spruce up my reels for personal brand showcasing on Instagram and Facebook. The winning freelancer should excel in: - Clever and engaging editing for social media platforms, specifically reels format. - Understanding personal brands and how they are represented visually. - Delivery of high-quality, professionally edited content. Your foremost task will be to capture the essence of my personal brand in the aesthetic and theme of the reels. Storyboard creation based on my brand's tone will be a plus point. Send me a messages, and I will send a un-edited reel for you to edit. Please include relevant examples of your past reels edits in your bids.

I need an expert in Microsoft Excel to help create a comprehensive drill down from a concise set of exit interview data. - The source data consists of elements such as names and categories. - Specific information required from the drill-down includes reasons for leaving, exit employee comments, and the departments they worked in. - You will craft tools within Excel that will allow me to easily access and analyze this crucial insight at a glance. Skills needed: - Advanced knowledge of Microsoft Excel - data visual Your ability to communicate effectively in English and deliver prompt results is also very important in this project.

...creation of weekly MIS reports using Excel. The selected candidate will have: - Expertise in Excel and data manipulation - A deep understanding of sales data - A proven track record in automating data reporting tasks Tasks will include: - Understanding my sales data structure and reporting needs - Designing and implementing a process to extract significant data - in this case, Revenue, from my Excel sheets - Setting up an automatic report generation mechanism This project will require a tool or macro that can generate these reports on a weekly basis, without fail. The tool or macro should be straightforward to use and should effectively sort and analyze the data to produce the desired reports, highlighting ...

I'm looking for an experienced Python and Django developer who can also handle back-end and meta integrations. My primary expectation for this role is to maintain an existing AI chatbot. The chatbot is currently functional but it's in need of improvements and optimizations. Key tasks: - Debugging and error fixes: I require someone with expertise in inspecting and fixin...Integrating new features: We're always looking to stay ahead of the tech curve. New features that enhance the performance and capabilities of our bot would be greatly beneficial. The successful freelancer would ideally have previous experience in AI chatbot development and maintenance. Proficiency in bot design, user flow optimization and the ability to implement cutting-edge features are required to e...

I urgently require an experienced Yetiforce developer to tweak our Account module. The customization needed is the integration of a feature to take photos directly from a cell. This task requires immediate attention. • Module to Customize: Account - Integrate new cell photo-taking functionality Ideal Skills: - Proficiency in Yetiforce development - Experience in handling photo integrations on platforms - Ability to deliver under tight deadlines This immediate task will require a high level of expertise and professionalism. I would highly appreciate it if only experienced freelancers place bids.

I'm looking to build a new React application that leverages a .NET API, all from scratch while utilizing an existing SQL database. - **Core Functionalities:** - **User Authentication:** Secure login system using email and password. This system should ensure that user data is protected and only authorized users can access the application. - **CRUD Operations:** The ability for users to create, read, update, and delete data within the database seamlessly. This includes managing user details, settings, and other data points relevant to the application. - **Role-Based Access Control (RBAC):** Different levels of access and permissions for users based on their role within the application. Specifically, I need two roles: Administrator and Standard User. Administ...

I am searching for a skilled developer who can design a web scraper that retrieves daily data. The Requirements: 1. Scrape text content and Excel data from pre-determined websites (only 1-2 websites). 2. Set up the system for daily scraping duties. Ideal Skills And Experience: - Profound knowledge of different scraping tools and techniques. - Excellent problem-solving skills. - Experience with Excel and text data. - Ability to work punctually and reliability for daily tasks. This project might require some adjustments and optimization, so ongoing communication is essential. Clear communication abilities and good comprehension of English will be a plus.

...creating an Excel formula that effectively deals with addition. In row Q I have it in pounds and the next row I have discounted. Every pound I need Column R to add up just the pounds in increments of $5.00. To be more specific, the formula in focus is needed to add data across rows, which are continuous or next to each other. This means that the required action will involve reading and adding values across various cells on the same row. To make a successful bid, you should: - Be proficient in Microsoft Excel - Have a clear understanding of Excel formulas, specifically in dealing with addition operations - Have the capability to create formulas for continuous rows - Be able to deliver the task quickly and accurately. Your responsibility will be to deliver...

...an expert freelancer capable in data scraping, particularly from an Excel database to LinkedIn. Outlined below are the significant requirements for this project: - Source data extraction: Skillfully extract Names, Email Addresses, Job Titles, and LinkedIn URLs from an Excel database. - Detailed profiling: Leverage both extracted data and set criteria including Location, Industry, and Experience Level, to find the relevant LinkedIn profiles. - Volume handling: There are over 500 entries in the database that need to be processed, hence experience in handling large volumes of data is necessary. The ideal freelancer for this job should have experience in data scraping, Excel, and LinkedIn search. They should also have a knack for d...

I am looking for a resourceful virtual assistant who can help in various data-oriented tasks. The job may not be limited to, but majorly includes data entry, research, and email management as these will form the bedrock of the activities to be carried out. IDEAL SKILLS • Experience in data entry • Research abilities • Proficient in email management Though the specific tasks were skipped during the question phase, I expect your application to include details about your past work experiences where you carried out similar tasks. A comprehensive project proposal will also be beneficial. SOFTWARE PROFICIENCY It would be a plus if you have proficiency in tools like Microsoft Excel, Google Sheets, or any CRM systems. While these tools were skipped dur...

FOR AU BASED FREELANCERS ONLY I'm looking for a skilled freelancer who can create a PDF document from an Excel spreadsheet. Here are the specifics: - Include data based on certain criteria from the spreadsheet. - Both numerical and text columns need to be incorporated in the PDF. I am uncertain about the styling and formatting of the document. Therefore, I ask you to suggest some options. An ideal candidate for this project will have proficiency in data handling, Excel manipulation, and PDF creation, with an eye for clear and engaging document design, which proves beneficial in suggesting viable format options.

i need a webscript where it hosts a large data , around 1 million with 3 columns if i search for a value, it needs to locate it, returning the row & cell # & say "Exists" or "Does NOT exist" it needs to be a bit fast 1- has a feature to search one value a time or two within the same row example colum1: John, Column2: miller: Column3: 8777 i can either search for John OR search for John & 8777 (both value need to exist in the same row to validate the search) 2-the script need to have a feature to update the data using excel sheet 3-if it support a simple API to do this that would be great otherwise i can just HTTP POST IT have room to add more features later

52,237 from various links in excel database This process should extract: - Product name - Artist - Design details - Print Size - Print Shape - Price (this will have several variables, depending on shape and size) -Design Details This needs to be entered into excel database & product images saved into a folder we will provide a link for in drive

Hi, I'm looking for someone to do a simple task. I have 2 excel CSVs. I'm looking to divide each in half. I need one half labeled "Cleaned" and the other half labeled "Dirty", it doesn't matter which half as long as we keep the same titles of the files. I can pay $15 for this as it will take less than an hour and requires minimal skill. I'm looking for someone to do this in the next hour.

I require pr...Arduino project that involves designing a small, weight-sensitive controller. This controller must send notifications to both iOS and Android phones, as soon as any weight is detected. I am flexible in terms of the programming language utilized for the Arduino project so proficiency in either C++, Python, or Java is acceptable. The Key Specifications: - The Arduino must detect weight through a load cell. - Capable of developing smooth communication between the Arduino and smartphones for effective notifications. Ideal candidates would already have experience with Arduino, a solid understanding of load cells for weight detection, and programming expertise in at least one of the mentioned languages. Familiarity with mobile notification integrations would also be adv...

...expert who can perform complex tasks in Excel, with a specific focus on data analysis, visualizations and automation of reports. The core responsibilities of the role will cover: - Extensive data analysis on multiple data inputs which majorly include call logs and agent productivity records. - Development of data visualizations that offer clear insights into the call center's performance. - Automation of reports for easy and hassle-free work flow. The chief goal of the project is to track the call center's performance and identify areas for improvement. An ideal candidate for this project needs to have proven experience in handling large data sets as well as the ability to create stunning, impactful visualizations. Strong knowledge ...

...furniture items for the common areas of a housing project. The goal is to expand this catalogue to include new items while maintaining the same format. However, I am also open to improvements in the design if you can enhance its visual appeal and functionality. Scope of Work: Catalogue Expansion: The primary task involves replacing furniture items to the existing catalogue. I will provide an Excel file and a PDF catalogue with details and images of the additional furniture pieces to be included. Package Creation: We require three distinct packages to be developed: A furniture package for a 3-bedroom house A furniture package for a 1-bedroom apartment A furniture package for a 2-bedroom apartment Design Consistency: The new catalogues should either maintain the existing format o...

I am in need of a custom, comprehensive Excel spreadsheet creation, designed to support manual data entry. The spreadsheet should include capability to calculate formulas including but not limited to Sum, Average, and Count functions. The Essential Features: 1. **Data Collection**: The spreadsheet must be designed for manual data input. This means efficient, user-friendly navigation and data input methodology. 2. **Calculations & Reports**: Importance lies in its capability to not only store data but also generate actionable reports. These reports should have the: - Ability to sort data - Option for interactive charts - Summary statistics 3. **Design**: While there are no specific design elements or themes to be ad...

I am currently using Office 365 and I need assistance converting multiple Excel files into PDF format. This task requires: - An understanding of Excel Office 365 to ensure seamless conversion - The capability to convert numerous files (not a one-off job) - Advanced knowledge in creating PDFs with specific, custom formatting, as this is essential to the project. Ideal skills and experience include: - Proficiency in Excel and its nuances, particularly Office 365 - Proven experience converting Excel to PDF in previous projects - Strong attention to detail, especially related to file formatting - Demonstrated ability to handle multiple files, ensuring each one retains its uniqueness in the conversion process. The excle file as some pictures and formatting - t...

need 2 restaurant menu from a webpage entered into an excel sheet. ill send u excel template to show u example this is 2 menu only ill have more in future (if u do a good job) no time wasters