Microsoft excel macro jobs

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.

I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.

I am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must be able to easily navigate Google Sheets ...

...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within AutoCAD itself. - You...

I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text and numeric data from t...

Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.

Hired already client is aware of details

Freelancer as The Research General job description: He will prepare a plan to study the extent of customer satisfaction with services, and a...• Results reports, complete with graphs that illustrate the data and written text that explains complex results. • Performs other related duties as assigned. Help in creating a Dashboard using Tableau. Qualifications and skills: • Superior research and analytical skills. • The ability to translate complex concepts and methodologies into easily understandable language. • Proficient in using Microsoft Office Suite or related software. • Proficient in using Tableau and MSQL and linking them. • Bachelor's degree in marketing research, statistics, mathematics, or related field required, MBA preferred. &b...

I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the value. The dashboard should be sor...

I'm looking for a professional who can deploy IT policies with Microsoft Business Premium for less than 10 users in accordance with the ISO27001 standard. The key areas I'm looking to cover are: 1 Clear Desk & Clear Screen Policy 2 Acceptable Use Of IT Assest Policy 3 Procedure Of User Access Management 4 Procudure Of Third Party Security 5 Vulnerability Management Process 6 Password Policy 7 Management Review Process 8 Mobile Usage & Electronic Media Policy 9 Teleworking Policy 10 Archival, Retention and Disposal Policy 11 Data Protection Policy 12 Information Continuity and Application Security Measure 13 System Configuration Standard IT Procudure Documents 1 Approved Software List 2 Asset Inventory 3 Deploying Anti Virus for Desktop 4 Workstat...

Please Sign Up or Login to see details.

I'm in need of a skilled developer to create a Microsoft Outlook plugin that will enable me to upload the email body to my CRM system. or similar

Implementing AI key features within Microsoft Copilot Studio. This document outlines the project scope and requirements to help guide your work effectively. Project Overview: We aim to enhance Microsoft Copilot Studio by integrating three essential features: 1. Chatbot Integration 2. Global Search Functionality 3. In-App Communications with Actions 1. Chatbot Integration: Objective: Enable Copilot Studio users to interact with a chatbot directly within the application interface. The chatbot should provide assistance, answer queries, and offer suggestions related to coding tasks. Key Requirements: • Seamless integration of a chatbot interface within Copilot Studio. • Natural language processing capabilities to understand user queries. • Ability to provide releva...

I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in a clear, concise...

I'm in search of an individual who is both tech-savvy and creative, capable of designing and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it's o...

...Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azure or similar - Experience in image classification and object detection - Ability to create Metadata files in Excel or CSV format. Remember that while these are the core requirements, I am open to suggestion...

I'm in need of a tool that can effortlessly upload text information from an Excel document to a website form on a daily basis. The tool should also facilitate the mapping of Excel columns to the corresponding fields in the website form through a user-friendly interface. Key requirements include: - Daily automated upload of data from Excel to the website form - A straightforward, user-friendly interface for mapping Excel columns to website form fields - Accurate and efficient transfer of text information - A secure and reliable tool that ensures data integrity Ideal candidates for this project should have: - A strong background in web development with experience in form automation - Proficiency in Excel, including working with data extraction and ma...

I'm seeking a freelancer to meticulously enter and format data into a PowerPoint slide. The slide will contain d...meticulously enter and format data into a PowerPoint slide. The slide will contain data Key Responsibilities: - Efficiently enter multiple paragraphs of data into a PowerPoint slide - Work with a pre-existing, detailed design to ensure formatting is consistent and visually appealing - Attention to detail is critical as the data must be accurately transcribed Ideal Freelancer: - Proficient in Microsoft PowerPoint - Superior data entry skills - Excellent attention to detail and design consistency - Strong written communication skills to ensure accurate transcriptions and formatting. Please note, this task requires a high degree of precision and adherence to the p...

...inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling potentially complex website structures, and able to work with a high level of det...

I'm looking for a SEO specialist to help me to improve the traffic on my website. The focus is on local search engine optimization / onpage-seo. ## Note: - I need only an instruction excel - list. The language of the page is in german, but an online translation tool can be used. - No Plugin will be used, but other proven SEO - Tools are possible. Key Responsibilities: - On-page SEO analysis to identify the status of the page (one page, homepage) - You will send me your seo recommendations for onpage optimations - You will use a seo tool (we discuss which one is best) - I only need a written instructionfile what should be done at page, - start asap - Time: 2 hours a week for one month Ideal Candidate: - experience with on-page SEO for websites - Strong analytical skills ...

Hi Nadia A. The project is: Research and identify qualified 1,000 sign manufacturers /stores /sellers /suppliers (that sell signs) across Germany. Compile the leads data into a Excel format.

I'm seeking an individual with the Azure Virtual Desktop Speciality (AZ-140) certification to help me register in the AI...Speciality (AZ-140) certification to help me register in the AI Cloud Partner Program. Key Requirements: - Possession of Azure Virtual Desktop Speciality (AZ-140) certification is a must - Experience with Microsoft Partner programs, particularly the AI Cloud Partner Program, is highly advantageous Your primary task will be assisting me in registering for the AI Cloud Partner program. This involves navigating through the registration process and ensuring all necessary steps are completed accurately. If you're proficient in Azure Virtual Desktop and understand the intricacies of Microsoft Partner programs, especially AI Cloud Partner Program,...

...digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organizational and data handling skills. - Ex...

I have a list of 2060 SKUs in an Excel sheet that I need corresponding images scraped from Website A. Each image should be saved with the SKU number as the filename (e.g., for SKU 32440). Key Requirements: - Scrape images from Website A for 2060 SKUs - Save each image as a high-resolution jpg with the SKU number as the filename Delivery: - I will provide you with the Excel sheet containing the list of SKUs via email. - You should deliver the images in a compressed file with 2060 images, each named according to the corresponding SKU. Ideal Skills and Experience: - Experience in web scraping, particularly image scraping - Proficient in Excel for managing SKU lists - Ability to deliver high-resolution images - Attention to detail to ensure correct matching of SKUs an...

We run an aged care service provider. We want to create an AI agent that can act as the Service coordinatior for the services we provide to clients. Tasks that the AI must be able to perform: - Manage Microsoft Outlook service mailbox - We get emails requesting services. Agent must be able to respond with our rates and negotiate this with the customer - If we win the job the agent must then be able to login to various platforms (e.g. , or ) and post an ad to advertise the job. May need to also call local businesses to get information. - We will have many subcontractors apply for the jobs. Agent needs to communicate and negotiate with these individuals. - Agent will present best options for us to pick from. - Once we pick they will interact

ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)

i want to be data entry job use word, pdf , excel , PowerPoint , and any type of graphic design work . i have 3 years teaching experience with data collection , data entry , and graphics design . i have fully and wonderful experience in Microsoft office , excel, PowerPoint , photoshop , illustrator, CorelDRAW, filora

I have handwritten notes that need to be entered into a Word document. Key Requirements: - Data Entry: The freelancer will be required to accurately transcribe the text data from the handwritten notes into a Word document. - Formatting: The data needs to be entered in a clear and organized man...manner, with appropriate paragraphing and alignment. Ideal Skills: - Proficiency in English: A good understanding of English language is necessary to ensure accurate transcription. - Typing Skills: Fast and accurate typing is essential to complete the task within a reasonable timeframe. - Attention to Detail: The ability to closely follow the source material and input the data with precision. - Microsoft Word: Familiarity with Word is important to ensure the data is entered and formatted ...

For this project, we need to consolidate customer data from multiple Excel files into one Excel sheet using macros. This will allow us to manage our data more efficiently. Key tasks include: - Creating a macro that can extract and merge customer data across several Excel files. - Managing the data in a way that it is grouped by Customer ID. Skills and Experience: - Extensive knowledge in Excel and proficiency in creating macros. - Prior work experience with data consolidation projects. - Exceptional attention to detail. - Ability to organize data effectively. - Knowledge of data management according to customer demographics.

I need an expert in Microsoft Intune and Entra to review our device enrollment and management settings. Key objectives:- 1. Ensure policies are secure e.g. MFA, Bitlocker, password strength, DLP controls 2. Ensure that an administrator password is required to install new software, but automated Windows and software updates continue 3. Ensure that company resources in Microsoft 365 (OneDrive) can only be accessed on company and compliant devices (note we use Power Automate and connections cannot break) Additional details / requirements:- - I have managed to do a few of these configurations with some success, although there are a lot of options and I'm not sure things are correctly configured - The company is very small with 3 devices and Microsoft 365 Business P...

...data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data analysis and interpretation skills. - Proficiency in working with ad spend and sales data. - Experience with trend analysis and correlation studies. - Proficient in Google Ads, Facebook Ads, and...

I'm in urgent need of a developer who can create a feature-rich video call app for iOS and Android with the following capabilities: - Group Video Calls: I want users to have the option to engage in video calls with multiple participants, similar to Zoom or Microsoft Teams. - Screen Sharing: I would like to provide the option for users to share their screens during video calls, a feature that's particularly useful for presentations and remote assistance. - Chat Functionality: A text chat feature will also be necessary for users to communicate in various ways. I'm looking to have this project completed ASAP. The ideal candidate for this project should have experience in developing multi-platform applications and be familiar with video call applications. Experience in ...

Hi, i am looking for help with a solidwork project. I want to build tuned pipe , expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. ...adjustable point to be able to adjust length and diameter for each my subsection. Because each pipe is build with many differents cones -Each section/cone needs to be customable on the amount of flat pattern needed. Each flat pettern are to be angle from both edges Steel plate thischness will be 1mm All dimensions are to be outside diameter. I want to be able to enter all my dimensions and length on an excel sheet(edit table) that will be included in ...

...based on assumptions - Balance Sheet Projections:Project key items like working capital, fixed assets, debt, and equity based on historical ratios and expected changes. - Cash Flow Projections:Derive operating cash flow from projected income statements and balance sheet changes. Estimate capital expenditures and financing activities. - Dynamic Model: - Create a dynamic model in Excel, ensuring that changes in assumptions automatically update all related financial statements. - Assumptions Tab: - Develop a separate tab to document key assumptions, ( also can use screenshots with source link) including revenue growth rates, cost inflation, capital expenditure plans etc. 3. DCF Analysis: - Free Cash Flow (FCF) Calculation: Calculate FCF - Discount Ra...

Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.

We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks

I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.

I need a freelancer to search List of Medical centers & Hospitals in Australia. Currently we have a list of centers & hospitals but need to search & add about 3000 more which are not included there (Including the contact details). We need a complete file with accurate detils & milestone will not be released until the work is checked. All centers should be added as per the state. Please quote with the time period & the exact fees you will charge for this. Ongoing work for successful candidate.

...The request has to be fulfilled this week. I'm in need of a professional who can assist me with creating workflow automations and integrating with Microsoft applications. We will organise a teams sessions and go through the desired customizations , all the work is done via remote access. I have a Microsoft environment comprising of SharePoint, Outlook, Teams, Word, Excel, and PowerPoint. Some tasks need to be automated such as document approval , collaborations and other SharePoint settings. Ideally, you should be highly proficient in Power Automate (Microsoft's workflow automation tool) and have strong experience in integrating various Microsoft applications. A background in SharePoint, Outlook, Teams, and the Office suite is a big plus. Your p...

I have a basic school project that requires inputting provided data into Microsoft Excel. Here are the specifics: - You will be provided with a simple dataset. - The main objective of the project is to input data from this dataset accurately based on the given instructions. The ideal freelancer for this project would be someone who is: - Proficient in Microsoft Excel. - Detail-oriented to ensure accurate data input. - Able to follow provided instructions carefully.

**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and ann...

I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.

I'm in need of a Power BI expert to create a comprehensive dashboard for our recruitment department. The dashboard will pull data from our existing Excel spreadsheets and update daily. Key Features Required: - Job Status: This will give us a clear overview of the number of open positions, positions in the interview stage, and positions that have been filled. - Recruitment Pipeline: Visual representation of where in the recruitment process our candidates are, from application to hire. - Applicant Information: A detailed breakdown of our applicants, their demographics, and the source from which they applied. - Application Source: Analysis of the effectiveness of our recruitment sources. - Time to Hire: Ideally, a calculation of the time it takes to move a candidate from applicat...

I am in need of a diligent professional who can assist in extracting text data from PDF files and accurately inputting the information into an Excel spreadsheet. The job calls for attention to detail and excellent data entry skills. Essential Skills and Experience: - Proficiency in Data Entry - Expertise in Excel Your responsibilities will include: - Accurately converting text data from PDF files into Excel - Ensuring data integrity through careful data entry - Delivering the project on time Ideal candidates would have prior experience in handling similar tasks. Your accuracy and commitment to the task at hand will be pivotal to the outcome of this project. Looking forward to receiving your bids.

I'm looking for a skilled developer to create a chat bot using Microsoft Copilot. The chat bot will be used for specific tasks and handle various information on a messaging platform that is yet to be decided. Key Responsibilities: - Develop a chatbot using Microsoft Copilot - Integrate the chat bot with the messaging platform that is chosen - Implement the specific functions and tasks the chat bot is required to handle Ideal Skills and Experience: - Strong experience in chat bot development - Proficient in using Microsoft Copilot - Familiarity with integrating chat bots with different messaging platforms - Ability to create a seamless user experience - Excellent problem-solving skills - Strong communication skills to understand the project requirements and prov...

I'm in need of a talented individual who can assist me with some general admin tasks, more specifically on data entry. The work will involve copy and pasting data into spreadsheets. Ideal Skills and Experience: - Excellent attention to detail - Fast and accurate typing skills - Ability to handle confidential information - Proficiency in Microsoft Excel Task Description: Your main task will be to create video using our system. Applicant must be skilled in organization and time management, as accuracy and efficiency are crucial to this role. u will be given detailed video training - offer at usd10 for 25 vids basically copy and paste work Please only apply if you can meet the task and skill requirements. Looking forward to hearing from you.

I am in need of a skilled Excel professional who can create a comprehensive Excel dashboard focused on data analysis. The dashboard will integrate with various Excel files to provide real-time data updates. Key Requirements: - Create an Excel dashboard that primarily focuses on data analysis - Integrate the dashboard with multiple Excel files - Ensure that the data updates are in real-time Ideal Skills: - Proficiency in Excel - Experience in creating complex and dynamic dashboards - Knowledge of data analysis techniques - Familiarity with real-time data integration This project is ideal for an Excel expert who can not only design a visually appealing dashboard but also ensure that it is highly functional for data analysis purposes.

We seek an Excel expert with experience in developing Bill of Materials (BOM) and Inventory management solutions tailored for small home businesses. The focus is on simplicity and functionality without the need for a commercial product presentation. **Key Features Needed:** - A user-friendly Excel workbook that manages electronic components, their stock levels, and inventory updates post-sales efficiently. - BOM creation from inventory items with an ability to incorporate "other costs" into each assembly. - Stock purchase entries should automatically update inventory quantities and costs. - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system should allow ea...

I'm currently looking for a mid-level administrative assistant to join my team in Birmingham. The main responsibilities for this role will be: - Assisting with various administrative tasks. This may include managing appointments, basic bookkeeping, and other tasks to support the smooth operation of the office. I'm looking for someone with prior experien...managing appointments, basic bookkeeping, and other tasks to support the smooth operation of the office. I'm looking for someone with prior experience in a similar role, preferably in a mid-level capacity. You should have strong organizational and time-management skills. Please note, specific software skills are not required for this role. However, proficiency in common office software such as Microsoft Office S...