Excel macros jobs

I am looking for a freelancer to create Excel templates for margin contribution. The project requires specific calculations for contribution margin. Requirements: - Experience in creating Excel templates - Proficiency in performing complex formulas in Excel - Ability to assist in data gathering The Excel templates should be moderately complex, with some complex formulas.

I require a highly skilled Excel specialist with experience in financial modeling for businesses, particularly within construction. The task involves developing a comprehensive business plan Excel sheet with extensive functionality. The features include: - Financial Projections: The spreadsheet should allow for advanced calculations such as revenue streams, cost of goods sold, and operating expenses. Ideally, you'll have a solid understanding of these types of financial calculations and can implement them effectively. - Expense Tracking: This feature is crucial for managing operational costs. The system should accurately track various expenditure categories including employee salaries, supplies and materials, and rent and utilities. - Cash Flow Analysis: This is vital...

I am looking for a freelancer to create a database of 100k UK small business owners with less than 11 employees. The companies need to have email marketing campaigns. The database should include the following information: - Company name - Con...and if 5% or more fail payment will not be made. The ideal candidate for this project should have experience in data entry and database management. Attention to detail and accuracy are crucial for this task. The preferred format for the final database is Excel. The freelancer should be proficient in using Excel and organizing data in a clear and concise manner. Overall, I am looking for a freelancer who can create a comprehensive database of UK small business owners, with specific industries in mind, and deliver the final product...

I need to plug in the events and when the planning phase starts and when its complete. I need to color code by type of event as well

I am in need of an advanced Excel or Google Sheets expert who has extensive knowledge in the vlookup function and exporting data from a website. The tasks for this project include: * Assisting in understanding how to use the vlookup function effectively in Excel or Google Sheets. * Guiding me through exporting data from a website and inputting it into Excel or Google Sheets. The ideal freelancer for this task should be able to provide examples of their past work utilizing these skills. Required skills and expertise: * Advanced knowledge and skills in using the vlookup function. * Significant experience in exporting data from websites into Excel or Google Sheets. * Ability to teach technical concepts in an easy-to-understand manner. I look forward to your w...

Adding manual entry form and synchronize with the power query table.

I am looking for a freelancer to help with an Excel data cleaning project. The details of the project are as follows: Size of the data: - The dataset consists of less than 1000 rows. Types of data included: - The dataset contains both numerical and textual data. Desired format of the cleaned data: - The cleaned data should be in Excel format. Skills and experience required for the job: - Proficiency in Excel and data cleaning techniques. - Ability to handle both numerical and textual data. - Attention to detail to ensure accurate cleaning of the data. If you have experience in Excel data cleaning and are comfortable working with both numerical and textual data, please submit your proposal.

I require an experienced Excel user who can compile data, specifically text and numbers, into an Excel document. - The file should have less than 50 columns and rows - The data needs to be arranged in numerical order The ideal freelancer for this job would have strong Excel skills, be experienced in data compilation, and have a keen eye for detail. Familiarity with numerical data organization is also important for the successful completion of this task.

...evaluating the aesthetic appeal and design elements of various websites. You will be provided with an Excel spreadsheet containing a list of website domains and a specialized browser plugin that enables the opening of multiple websites simultaneously. Key Responsibilities: - Open a list of websites using the provided plugin. - Evaluate the visual design of each website. - Rate the websites based on their design aesthetics, user interface, and overall visual appeal. - Record your ratings and observations in the provided Excel spreadsheet. - Meet designated deadlines for completing evaluations. Qualifications: - Proven experience in web design. - Strong aesthetic sense. - Proficiency in Excel and comfortable working with browser plugins. - Ability to work independ...

...proficiency in Excel functions. In specific, I'm dealing with high-volume data which slows down my calculations significantly. To counter this, I need a custom software solution. The candidate needs to have intimate knowledge of various Excel functions as the software should optimize the calculation speed. This includes: - SUM function - VLOOKUP function - IF function - Nested Function with iferror - SUMIF - VLOOKUP The software should be able to process around 200,000 orders from various tables at high speed. In addition, the output from this software should be compatible and must be exportable in an Excel file format. Desired skills include advanced Excel, software development and problem-solving. Experience in developing similar software or adv...

Hello, Thanks for your in...need of an experienced web scraper. My requirements for the job are fairly open-ended as I've multiple websites that I'd like scraped. However, specific information to scrape from those websites hasn't been determined yet, therefore a freelancer with ability to extract diverse range of datas like text, images, and product details would be greatly appreciated. The scraped data needs to be in a Excel format for ease of use. Your understanding and experience regarding data format will be crucial in this role. Ideal skills: - Proven experience with web scraping - Proficient in handling diverse data types. - Strong understanding of data formats, specifically CSV. The money will be transferred ONLY AFTER the entire data set is transferred...

I am looking for an Ou...sales is required) - Excellent communication and persuasion skills - Ability to effectively present product information and benefits to potential customers - Strong phone etiquette and customer service skills - Ability to work independently and meet daily call targets -MUST be proficient in English Ideal Skills and Experience: - Proven track record outbound calling campaigns - Familiarity with Excel and Skype - Knowledge of the Australian Medical Industry - Ability to handle objections and rejections professionally - Strong organizational and time management skills If you have a passion for excellent communication skills, and the ability to showcase our Doctor, we would love to hear from you. Please provide your relevant experience and availability for thi...

I'm in dire...active subscription refuses to load on my Dell laptop, making it impossible for me to access key Office 365 products namely Word and Excel. - Error Encountered: When attempting to load these applications, I receive a 'Sign in required' error message. Sign in leads to blue circlevof death. - Ideal Skills: A robust understanding of Microsoft 365 and Office 365 products is required, alongside experience in troubleshooting such applications, particularly on Dell hardware. Previous success in solving similar activation and login issues will be an asset. Your role will entail not only diagnosing the root of this issue but also implementing a fix to get my Word and Excel functioning normally again. Your expertise is much appreciated in resolving this...

i have an excel sheet that i need put some apis

I am looking for a freelancer who can assist me with a data entry project. The project involves typing data into Excel format. Skills and Experience: - Proficient in typing and accuracy - Familiarity with Excel and its functions - Attention to detail and organization Requirements: - Complete 100-500 data entries in Excel format Preferred Format: - Excel If you have the necessary skills and experience, please submit your proposal. Thank you.

I am in need of an experienced Java,Vuejs developer to assist with some bug fixing. The main tasks will include: - Fix import, export data - Save data into database

I need a tool that calculates some excel sheets for me in a specific order

I'm looking for a skillful developer who can assist me in creating a PMO dashboard in Excel that will be updated weekly. The dashboard should effectively track two major KPIs: Task completion rate and project timelines. Skills and Experience Required: - Proficient in Excel formulas, pivot tables, and dashboard creation - Experience with PMO Dashboard Development - A strong understanding of KPI tracking - Detail-oriented and efficient Role Duties: - Design a comprehensive and visually appealing PMO dashboard (including Kanban, Charts, Timelines) - Implement features to track task completion and project timelines - Prepare the dashboard for weekly updates With your help, I aim to have a practical tool that streamlines project management and improves decision-making.

I am looking for a Magento specialist to help me import new product data into my online store via Excel. The Excel file may not contain all the necessary data, so there may be need for further discussions on additional specs. I'll provide important product information including images, descriptions, price, and more. Ideal candidate should have. - Strong experience with Magento product import - Proficient in using Excel for data management - Excellent attention to details - Proactive communication skills, as some information may be revolving - Ability to respect deadlines

Need a script which can run through a table of sequential road names and address ranges and flags records where there is a gap in the ending value of one record and the starting value of the next record (segment). The table needs to be analyzed twice once for the even number columns and the odd number columns. The analysis will be done on records sharing the...which can run through a table of sequential road names and address ranges and flags records where there is a gap in the ending value of one record and the starting value of the next record (segment). The table needs to be analyzed twice once for the even number columns and the odd number columns. The analysis will be done on records sharing the same road name. More explanation in Address Example excel. The full dataset is also...

I am seeking an expert in advanced Excel functions to replicate an existing template we use in our MS ONEDRIVE OFFICE 365 subscription for recording sales and transaction information. The project has the following requirements: - Proficiency in Advanced functions (Array Formulas, Macros) is a must, due to the complexity of formulas used in our existing template. - Freelancers will be tasked to create formulas that auto-calculate cells across various sections within the template. - We prefer freelancers who can provide detailed project proposals. This will aid in our selection process by demonstrating your plan of execution and understanding of the project requirements. Note, the original template will be emailed to the chosen freelancer for reference. We are looking forwa...

We need to create a comprehensive Excel list of individuals with the job title "Kitchen Designers" in Rhode Island and half of Massachusetts, spanning from Worcester to the East Coast. The list should include their phone numbers, email addresses, full names and titles, the companies they work for, LinkedIn IDs, and any additional available information. Please reach out if you can assist with this task. Need at least 2000 names Deadline 12 hours and budget 18$AUD fixed.

Hi Md Rashed K, My name is Lisa Wunderle and I'm with Inspire Medical Systems. You've worked with my regional manager Tracy Miller in the past and have helped her update an excel spreadsheet tracker we use. This tracker has a number of macros and reports that are generated from the data. I have a few trackers that need to be updated and would like your help. I'm new to Freelancer, so please let me know what they next steps would be. Thank you! Lisa

I need it urgently, Hi, I will share more details only selected candidate in via chat box. Thanks

...refreshes in real-time from an existing Excel file. Skills and experience needed: - Proficiency in PowerBI and Excel - Ability to create custom data visualization based on client's requirements - Knowledge of real-time data integration and refresh capabilities in PowerBI Requirements: - The dashboard should display the client's own visuals, so the freelancer should be able to work with custom visuals. - The Excel file provided by the client will be used to update and refresh the dashboard. - The dashboard should update in real-time, reflecting any changes made to the Excel file immediately. Please note that the client will provide the visuals and the Excel file, so the freelancer's role will be to set up the PowerBI dashboard, integr...

I am looking for someone who has experience working with the Java, VueJs. Skills and Experience: - Proficient in using API - Familiarity with create and download excel from API - Experience with upload data from excel Project Description: I need assistance in implementing export and import data retrieval functionality using the JAVA API. The ideal candidate should be able to work with VueJS to call API and create function import export excel from API

I am in need of a freelancer who can assist with data entry from handwritten documents into Excel. The ideal candidate should have experience in accurately transcribing handwritten information and entering it into Excel. Key requirements: - Proficiency in data entry from handwritten documents - Strong attention to detail and accuracy - Experience working with Excel The project involves transcribing less than 50 pages of handwritten documents into an Excel format. The freelancer will need to accurately enter the information provided in the documents into the designated Excel sheets. Ideal skills and experience: - Experience in data entry from handwritten documents - Proficiency in Excel - Strong attention to detail and accuracy in data entry

generar a través de plantillas actas de facturación usando Excel y Word

I am looking for an expert who can assist with an Excel project. Selected candidate will: - Work on implementing a 'fuzzy match' mechanism, which will match partial student numbers across two spreadsheets. - Transfer relevant marks data from the first spreadsheet to the second. - Maintain a maximum error tolerance of less than 5% during this 'fuzzy match'. This project is focused primarily on handling student marks data. So the key task involves transferring only the 'student marks' columns from the first to the second spreadsheet. Ideal candidates should possess: - Solid expertise in Excel, especially VLOOKUP and fuzzy match techniques. - High attention to detail to ensure minimal errors during data transfers. - Proven experience handling la...

I'm in need of assistance to create an Excel formula that utilizes aspects of calculus - need a total of 2 pages. 25 usd

Would like someone to design a estimate form for my small business that will have drop downs of services and products offered. I can populate the list. Just need the design work done. Will also need to calculate simple math

Need recover Excel Password It need person have professional Experience

I am looking for a freelancer who can assist me with a data entry project. The project involves typing data into Excel format. Skills and Experience: - Proficient in typing and accuracy - Familiarity with Excel and its functions - Attention to detail and organization Requirements: - Complete 100-500 data entries in Excel format Preferred Format: - Excel If you have the necessary skills and experience, please submit your proposal. Thank you.

I am looking for a freelancer who can help me with formula adjustments in my Excel spreadsheet. Skills and experience required: - Strong knowledge of Excel formulas and functions - Attention to detail and accuracy in making adjustments - Ability to work independently and meet deadlines Actual task list - Order Pending Sheet 1) Arrangements of Columns: J – Despatch Date K – Print L – Needs Picking M – Weight N – Delivery Company O – Status 2) Order is by “despatch date”. 3) When click on “Print: cell it prints a label with the relevant data from the “Print” sheet. 4) In “Needs picking” column, when click “picked”, it moves the row to the worksheet “Picked”. Pick...

I'm searching for a qualified developer to build a functioning interface capable of converting data from Excel into BMECAT format. My aim is to conveniently share accurate product data with suppliers. The data fields that need to be transformed include the product's detailed description, with technical specifications, and supplier information. Ideal skills and experience: - Proficiency in Excel and knowledge of BMECAT format - Experience in developing custom interfaces - Attention to detail, especially with technical content - Experience in product data management Sample data file we can export from our current PIM System

I am looking for someone to help me find the password for my .xlsx Excel file on my Mac16.8. I remember some parts of the password, but not all of it. I have not tried any password recovery methods before reaching out for assistance. Skills and experience needed for this project: - Strong knowledge and expertise in Excel file password recovery - Experience working with Mac16.8 operating system - Familiarity with password cracking tools and techniques - Excellent problem-solving skills and attention to detail

I am looking for a freelancer who can assist me with a data entry project. The project involves typing data into Excel format. Skills and Experience: - Proficient in typing and accuracy - Familiarity with Excel and its functions - Attention to detail and organization Requirements: - Complete 100-500 data entries in Excel format Preferred Format: - Excel If you have the necessary skills and experience, please submit your proposal. Thank you.

I am looking for a data entry expert to assist me with a large volume of typing work. The data needs to be entered in a specific format, which is not Microsoft Excel or Google Sheets. Skills and Experience: - Proficient typing skills and attention to detail - Experience with data entry in various formats - Ability to handle large volumes of data entry tasks efficiently - Familiarity with different data entry software and tools - Excellent organizational and time management skills

Project Title: Excel Code 128 Barcode Font Integration Description: I am looking for a freelancer who can help me with integrating the Code 128 barcode font into my Excel spreadsheet. Skills and Experience: - Proficient in Excel 2010, Excel 2013, or Excel 2016 - Familiarity with Code 128 barcode font integration - Experience with basic integration of barcode fonts in Excel - Attention to detail and accuracy * Here is an article that explains what we need: Requirements: - I already have the Code 128 barcode font file, so no need to provide it - The level of integration needed is basic, without any advanced automation - The freelancer should be able to set up the integration seamlessly and ensure that the barcode font is functioning

We are looking for an mid-level data entry specialist to assist us in registering data from photos into an excisting Excel spreadsheet. The data will be sent to you on a weekly basis. The ideal candidate should have basic knowledge of Excel and be able to accurately and efficiently record the data. The tasks include entering data from images and ensuring that the information is accurate and organized. Strong attention to detail and excellent time management skills are required. The ability to work independently and meet deadlines is also essential. The job will require a quick turnaround and will be ongoing. Greek speakers prefered.

I am looking for an expert in MS Excel to develop a special .csv file generator as per the attached BRD and .xlsx spreadsheet prototype. This tool will allow us to maintain static content in various locales inside our Magento 2 CMS. Skills and experience required: - Expert in MS Access VBA and Macro. - Advanced knowledge on the coding functions. - Ability to challenge or question the BRD in a constructive manner - Potentially propose functional amendment/solutions which serve the ultimate goal. - Ability to work with provided designs or suggest design recommendations - Strong communication skills to discuss additional features. - Ability to align with project lead and other developpers under the project. - Access to Trello Dashboard and MS TEAMS for collaboration purposes. The fo...

I'm seeking a skilled freelancer with proficiency in Codeigniter and MySQL for a data exportation task. The job requires using Codeigniter to export data from a MySQL database to an Excel sheet. Ideally, the freelancer should possess: - Solid experience in Codeigniter and MySQL - Knowledge of data exportation - Understanding of Excel file formats Please note that further details regarding the format or arrangement of the exported data will be provided upon awarding the project.

Project Title: Excel VLOOKUP for Retrieving Dates I am looking for someone who is proficient in Excel and has intermediate level skills to help me with a VLOOKUP operation. The specific data I am looking to retrieve using VLOOKUP is dates. Table Preparation: - One table is already prepared and ready for the VLOOKUP operation. - The other table needs work and needs to be prepared for the VLOOKUP operation. Ideal Skills and Experience: - Intermediate level proficiency in Excel. - Strong understanding of VLOOKUP function and its usage. - Experience in working with dates in Excel. - Attention to detail to ensure accurate retrieval of dates using VLOOKUP. If you have the necessary skills and experience, please submit your proposal.

...lfinancial portfolios, particularly stocks. The following are the key tasks, skills, and experiences expected for this project: Key tasks: * Prepare a model in Excel sheet where data can be entered monthly by me and output is given in chart form and irr, xirr , abosulteky return, annualized return etc so it helps me analyse the performance of each pms scheme versus various benchmarks and other investments ∆ the output table needs to give every scheme say ()- return for 1 month ,3 months , , one year, 2 years , 3 years ,5 years etc or a specific time range . Performance should also be displayed as a graph ∆ the Excel sheet must account for the initial investmet and then top-up or and when it happens ∆ current sheet is having data for 4 years that too has

I am looking for an Excel expert who can proficiently design bar, line, and pie charts. My need is for numerical and date-related data to be translated into these formats. The goal is not only to visualize trends, but also to aid in data analysis. By making this data more digestible and visually appealing, we hope to glean critical insights from it. Key skills needed are: - Strong Excel charting skills - Ability to work with numeric and date data - Understanding of how to visually display data trends and analysis Relevant experience in data visualization projects will be highly appreciated. We are enthusiastic about the potential findings this data can lead us to. Thanks in advance for your interest and bids.

I am looking for an Excel expert who can proficiently design bar, line, and pie charts. My need is for numerical and date-related data to be translated into these formats. The goal is not only to visualize trends, but also to aid in data analysis. By making this data more digestible and visually appealing, we hope to glean critical insights from it. Key skills needed are: - Strong Excel charting skills - Ability to work with numeric and date data - Understanding of how to visually display data trends and analysis Relevant experience in data visualization projects will be highly appreciated. We are enthusiastic about the potential findings this data can lead us to. Thanks in advance for your interest and bids.

...proficiency in Excel functions. In specific, I'm dealing with high-volume data which slows down my calculations significantly. To counter this, I need a custom software solution. The candidate needs to have intimate knowledge of various Excel functions as the software should optimize the calculation speed. This includes: - SUM function - VLOOKUP function - IF function - Nested Function with iferror - SUMIF - VLOOKUP The software should be able to process around 200,000 orders from various tables at high speed. In addition, the output from this software should be compatible and must be exportable in an Excel file format. Desired skills include advanced Excel, software development and problem-solving. Experience in developing similar software or adv...

I am looking for a freelancer who can help me with typing data into an Excel sheet. The data can include both text and numbers. I do not have a specific format or template for the sheet, so I would need help with creating a format. The size of the sheet can vary, with the number of rows and columns being either less than 100, between 100 and 500, or more than 500. Ideal skills and experience for this job include: - Proficiency in Excel - Accurate and fast typing skills - Attention to detail - Ability to create a format or template for the Excel sheet as needed

I am looking for an Excel specialist to help me with a project. If you have expertise in Excel and this sounds like something you can help with, please let me know.

I am looking for a freelancer who can help me with typing data into an Excel sheet. The data can include both text and numbers. I do not have a specific format or template for the sheet, so I would need help with creating a format. The size of the sheet can vary, with the number of rows and columns being either less than 100, between 100 and 500, or more than 500. Ideal skills and experience for this job include: - Proficiency in Excel - Accurate and fast typing skills - Attention to detail - Ability to create a format or template for the Excel sheet as needed