Excel Vba Projects
Looking for freelance Excel Vba jobs and project work? PeoplePerHour has you covered.
opportunity
Automate Excel to PowerPoint
Looking for a custom Ribbon creation in Power Point to select and transfer cells from an Excel worksheet into specific visuals within a powerpoint template.
2 days ago37 proposalsRemoteAutomate my timesheet creation in Excel
I have to produce a monthly timesheet with the hours of how many patients I have seen every day. I would like an automation that fill in the format I require for the timesheet in excel, given the input such as patient number and hours done for each day in the working week. This file is in excel then I will submit and create it in pdf.
4 days ago45 proposalsRemoteEntering receipts in Excel
I need UK based person for entering receipts on a spreadsheets for bookkeeping purposes. each time this needs doing the batch of receipts will be sent to you and on completion will be randomly checked for accuracy. there will be roughly around 500-700 receipts. Each receipt will require about 8-9 fields e.g. Date, supplier, Desc. Nett amount, VAT, total, method of payment This can be done in the next 2-3 weeks but will have to give a time at before excepting the job my budget is 10p/ entry
15 days ago68 proposalsRemoteExcel data organization for integration with Google Contact
Kindly Read The Following Text Attentively Before Providing A Quotation. Thank You. Excel data organization for integration with Google Contact and personal system formats Some of my contacts in Google Contacts are not in the correct format, with some numbers appearing in a jumbled way and others having different symbols like "+" or "00". I want to fix the format to align with Google Contact standards. The Contacts data exported from POS in Excel format requires verification as there are missing entries in both POS and Google data. These discrepancies need to be resolved before converting the data to Google format for uploading to Google Drive. Ensure that the file with all requisition corrections is uploaded in the relevant format on Google without any errors LIKE THIS IMAGE "GOOGLE UPLOAD ERROR TO BE FIX" Approx 15 to 18 K data in Excel sheet I would like to address the data problems and errors that are visible in the attached images.
2 days ago24 proposalsRemoteDigital marketing and excel worker
I need a digital marketer to promote my product and a person who knows Microsoft office. Have you any prior experience in this field, have you worked on similar projects. Responsibilities Develop and implement digital marketing campaigns across various platforms (social media, email, SEO/SEM). Create engaging content, including blog posts, social media posts, and newsletters. Monitor and analyze campaign performance metrics to optimize strategies. Stay up-to-date with digital marketing trends and best practices. Collaborate with cross-functional teams to achieve marketing goals. Qualifications Bachelor's degree in Marketing, Communications, or related field. Proven experience in digital marketing, with a strong portfolio of successful campaigns. Proficiency in social media management tools (e.g., Hootsuite, Buffer). Excellent written and verbal communication skills. Analytical mindset with the ability to interpret data and make data-driven decisions. Benefits Competitive salary Health insurance Flexible work hours Opportunity for growth and career development
12 days ago18 proposalsRemoteExcel work flow track for employees
I am seeking a solution to monitor the progress of each employee's contribution to a project. The system should incorporate the fixed costs associated with each project and calculate the remaining compensation owed to each employee based on their completed tasks. While the fixed costs may vary across projects, each employee receives a uniform compensation for their respective stage of completion.
8 days ago31 proposalsRemoteBank Statement Conversion into Excel
I'm looking for a professional freelancer to convert a 300-line PDF bank statement into an Excel report for reporting purposes. The specific bank statement details that need to be included are Date and Description as well as Debit and Credit amounts. Key Requirements: - Extract date and description details from the bank statement - Extract Debit and Credit amounts from the bank statement - Must have a clear understanding of date formatting in Excel Ideal Skills/Experience: - Must have extensive experience in data entry and Excel - Should have a good understanding of banking terms - Attention to detail is critical - Previous experience in bank statement conversion will be advantageous.
13 days ago87 proposalsRemoteI need someone with excellent photoshoping skills
I need someone with excellent photoshop skills who can modify pictures creating effects by adding and removing materials on the objects in the photo.
20 days ago36 proposalsRemoteWe Need Someone That is Excellent With TikTok To Help Manage It
Hi, We are a Government regulated fashion modelling agency based in south London, UK. We have all other social media, including IG and Facebook, but not TikTok as we underestimated it. To our horror, we have just noticed that people having been going on it (being Tiktok) and slamming us. We have seen numerous comments such as we are "no good", we are a "scam", we "are not legit" and all sorts of other negative comments. We need someone that knows TikTok inside out and a person that can help us do the following: 1) Be our dedicated TikTok Manager that will focus on it daily and monitor any negative comments. In doing so, you can reply to the comments with positive comments. 2) Know how to report illegal defamatory comments to TikTok Management and get them removed or banned. 3) Last but certainly not least, know how to start addressing and combating this problem immediately. Certain key things you should know about us: a) We cannot be a scam or not legitimate because we are Government regulated. b) Anything we charge our models gets refunded after the 12-month contract ends. c) When we accept a model, we give them many freebies, which many models spend a lot of money out there on. These include, a free professional model portfolio of pictures, they are airbrushed and retouched in Milan, Italy to make sure the model looks their best. We also do a free video reel of them and offer free catwalk/runaway training. Additionally, we have also carried out many good jobs for our models which is on our Instagram. So as you can see above, we are confused as to why we can be labeled a scam as. We need this to be put on TikTok urgently and regularly to combat these negative comments and the fears that some people will have in using us. In the UK, there are many scams but these happen when models go into photographic studios, spend a lot of money, and end up losing it. They lose their money because the studios cannot get them work as they are not Government regulated and neither do they get their money back. We do all these things for our models so once again, where is the scam? If you think you are the right person to tackle this project for us on an ongoing basis, get in touch ASAP. Lastly, any model can go and contact any company that we claimed to have worked with that is on our Instagram and verify they have worked with us. So where is the scam? Thank you for your time.
25 days ago17 proposalsRemoteurgent
Research Job Vacancies that schools are advertising
Hello there We are a recruitment company and provide supply teachers into schools. At the moment we are trying to fill vacancies in September. I have a long list of schools that we service. I need somebody to go on every school website and record in an excel doc what vacancies they are advertising. What i need at an end is an excel doc that I sort on vacancy ie Maths Teacher and it will bring up every school looking for a maths teacher I hope that makes sense!
3 days ago75 proposalsRemoteExpires in 27Data Entry
I work as part of an accountancy firm and we require someone who has good knowledge of using excel & tax calc. we require 2 excel spreadsheets to be transferred from excel to tax calc. these spreadsheets include customer name contact details Etc. the outcome we expect is that all information from the excel spreadsheets is transferred onto tax calc. the deadline we have for this is 2 weeks. we will pay a fixed fee of £102
11 days ago51 proposalsRemotePlease can you format this data for Stannp
Please can you format this data so it is appropriate for Stannp, hopefully you are familiar with this website? I would like to use this site to send out letters. I have attached both the excel doc and PDF.
2 days ago1 proposalRemoteurgent
Invest in a new business (financial statements, excel)
A university student seeks assistance with generating projected financial statements for an assignment analyzing the viability of an athlete camp venture. The freelancer will build multi-year income statements, cashflow statements, and balance sheets in Excel to model revenues, expenses, liquidity, and profitability on a monthly, quarterly, and annual basis for the first 5 years of operations. A discounted cashflow analysis and break-even calculation for year 1 will also be developed. Sensitivity analysis and interpretation of findings will be provided in a typed, double-spaced report with font size 12 discussing business viability and short to medium-term profitability based on the financial modeling and analysis conducted. Expertise in financial statement preparation and business valuation is required.
19 days ago19 proposalsRemoteExpires in 10Work on Microsoft Excel files
Hello I need an expert in Microsoft Excel to help create a documents and to do some updates on other one. Ideali someone who speaks French. Thanks.
a month ago23 proposalsRemoteCompressor valve dynamic analysis
Require to develop an excel program that can provide correct information on valve opening and closing events based on compressor geometry and pressures/temperatures.
5 days ago13 proposalsRemoteopportunitypre-funded
Build an ROI Calculator with User Instructions into Excel
Impact-Centric ROI Calculator - Developer Brief We are seeking a skilled developer to create an Impact-Centric ROI Calculator that will accompany our sales training module. The calculator must be designed to have perfect utility across all Business-to-Business (B2B) sales environments, including products, services, hardware, and software (SaaS) sales. Key Requirements: Currency Options: The calculator must support three currency options – USD, British Pound Sterling, and Euro. Workbook Structure: The workbook should be organized into five main tabs: Home, Input, Calculations, Output, and Instructions. Home Tab: Create an introductory screen with a purpose statement and basic navigation instructions. Input Tab: Divide the tab into 'Cost Investment' and 'Gains from Investment' sections, each with relevant categories. Include a Rule of Thirds attribution section and a timeframe selection option. Data Validation: Implement data validation to ensure data integrity and minimize user input errors. Calculations Tab: Use Excel formulas to calculate key metrics such as ROI Percentage, Payback Period, and Break-even Point based on the selected timeframe. Include a Rule of Thirds attribution calculation. Output Tab: Display the calculated results in a user-friendly format, incorporating dynamic charts and graphs for visual representation. Instructions Tab: Provide step-by-step instructions on using the calculator, including timeframe selection and interpretation of key metrics. User Guide: Create a separate worksheet named "User Guide" that includes an introduction, overview of each worksheet's purpose, step-by-step instructions, guidance on timeframe selection, and explanation of key metrics. Testing: Ensure the calculator's utility across various B2B sales scenarios, including producers/manufacturers, resellers and distributors, professional service providers, and subscription software providers (SaaS). The ideal candidate should have strong experience in developing complex Excel workbooks, proficiency in Excel formulas and functions, and a deep understanding of data validation and user experience design. If you are interested in this project and possess the required skills, please submit your proposal, along with a portfolio showcasing relevant experience.
21 days ago23 proposalsRemoteOperational Metrics Dashboard Design
I'm looking for an expert in analytics to create a compelling dashboard that pulls data from Excel spreadsheets. You would be focussing primarily on reflecting operational stats in a clear and concise way. Key duties: • Integration of Excel spreadsheet data into the dashboard • Showcasing operational metrics, specifically focusing on account monitoring status on a daily basis like inspection due date Perfect for someone who: • Has experience with data integration from Excel spreadsheets • Understands operational metrics and how to present them effectively • Can deliver a user-friendly dashboard for easy understanding of data • Has a keen eye for details and accuracy.
13 days ago20 proposalsRemoteWordPress Landing Page Creation
I am seeking a skilled freelancer who has significant experience in building WordPress landing pages. The purpose of this landing page and its specific features are left open for creative interpretation, as I have not specified any particular elements, color schemes, or branding guidelines. Nonetheless, a comprehensive understanding of WordPress and its functionalities are essential in order to create a high-quality page. Ideal skills and experience: - Expertise in WordPress - Exceptional creativity and ability to work within broad parameters - Understanding of best practices for landing page design - Willingness to provide design recommendations and insight based on previous success in similar projects. This project offers an excellent opportunity for those who excel at employing their creative judgment and WordPress capabilities. I will need a portfolio
2 days ago40 proposalsRemoteExcel Product Data Enrichment in Dutch, French and English
I want to improve the search function of a webshop. I want to do this by adding extra data to the products (in the form of tags). I have a list of 11,000 product names in Dutch. These product names consist of a piece of proper name, noun and then sometimes some content information. For example: Orange Cleaner degreaser 5L c We are looking for a quick way to see the noun plural in the column next to it. Also, one or more synonyms in the column(s) next to it would be nice. Example: degreasers (=plural) I understand this can be done with a Python script that performs these tasks. This script uses the Natural Language Toolkit (NLTK) library to identify multiples and synonyms. This script assumes you have a list of product names and want to find the plurals and synonyms for each of them. It prints the original product name, the plural (if found) and the synonym (if found). I am looking for someone to help me create this list. I have the same list in English and French which the same thing needs to be done. Ideal Skills and Experience: - Advanced Excel skills. - Familiarity with implementing plural forms and synonyms. - Ability to ensure data integrity and consistency.
18 days ago14 proposalsRemoteSkillful Excel Formatting and Complex Calculations
I need help from an Excel expert to do a job that won't require more than five pages. Effective data formatting and organization require assistance. The project calls for the usage of sophisticated formulas, including VLOOKUP and INDEX MATCH, in addition to simple formatting. For this job, the perfect freelancer should possess: Proven expertise in developing and utilizing complex Excel formulas, such as VLOOKUP and INDEX MATCH; - A keen eye for detail and a commitment to data accuracy; - The capacity to do jobs quickly and effectively. You can be confident that more opportunities for positions similar to this one may arise in the future if this project is successful. eagerly awaiting your bids.
a month ago63 proposalsRemote