Excel Macro Projects
Looking for freelance Excel Macro jobs and project work? PeoplePerHour has you covered.
Excel document design
I would like an excel report designing to capture numerous pieces of information and formulate multiple lines. The report will be used to calculate income from various streams, whilst calculating multiple expenditure lines to feed into an overall profit and loss template
15 hours ago33 proposalsRemoteCleaning Excel Sheet
1) Clean active members spreadsheet. - I have an excel spreadsheet of 200 'active' members, and I need someone to clean this list so that it only includes paid members. - There is one column called 'Active memberships'. Keep rows that have data in 'active memberships', and delete rows that do not have any data in 'active memberships'. 2) Clean 'email subscribers' spreadsheet - I have another excel spreadsheet of email subscribers, and I need this to be cleaned so that it only includes people not paying for memberships. - This would involve taking the newly cleaned 'active members' spreadsheet above and removing these members from the 'email subscribers' spreadsheet 3) Final clean of 'email subscribers' spreadsheet - 5 days before the email campaign, remove another list of people from the 'email subscribers' spreadsheet - This will be around 10-20 people on another spreadsheet, who are new enquiries who have not yet attended a free session, so do not need to receive the email campaign I've attached the first two spreadsheets, and I will send the final spreadsheet on the appropriate date (27th May) I look forward to hearing from you!
a day ago86 proposalsRemoteopportunity
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.
6 days ago42 proposalsRemoteWrite Excellent Ad Strength For Google Search Ads
Write Ad Strength for responsive search ads. You will be doing this for 10 Ads. You will do the following tasks: 1: Include popular keywords in your headlines. 2: Make your headlines more unique. 3: Make your descriptions more unique. All above needs to show as Excellent with blue ticks. The Keywords are already been added the campaigns. This is a quick job - More work would be offered if your work is good.
a day ago23 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
18 days ago72 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.
6 days ago33 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
16 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.
12 days ago34 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.
16 days ago95 proposalsRemoteA few really nice looking excle graphs
We are seeking a skilled freelancer to create visually appealing Excel graphs based on a provided dataset. The project requires the creation of 3-4 graphs, preferably stacked bar charts, to effectively present the data. The freelancer should have a strong understanding of Excel and graphic design principles to deliver high-quality graphs that meet our requirements. Attention to detail, ability to work independently, and timely delivery are essential for this project. If you have a passion for data visualization and excel, we would love to hear from you.
a day ago19 proposalsRemoteopportunity
Excel Data Consolidate&CSV Formatting for Shopify Product Upload
We are looking for a skilled freelancer to assist us in consolidating data from various product ranges stored in separate Excel sheets. The task involves merging Excel sheets when necessary and pulling relevant data, such as prices, to match product codes from different sheets. The ultimate goal is to generate a comprehensive CSV file that adheres to the required template for Shopify product uploads. Some products contain variants, which requires expertise in bulk Shopify uploads to ensure accurate listing of main products alongside their variants. Key Responsibilities: - Consolidate data from multiple Excel sheets into a unified file, accommodating products and their variants. - Match product codes with corresponding prices and other essential information, maintaining consistency throughout. - Ensure accuracy and completeness of data across all product entries, including variants. - Format the final CSV file to meet the specifications of the Shopify platform for hassle-free uploading. - Validate the CSV file to verify compatibility and smooth integration with Shopify's product management system. Requirements: - Proficiency in Excel and CSV file manipulation, with a focus on managing product variants. - Experience with bulk Shopify uploads, particularly in accurately listing main products alongside their variants. - Attention to detail and precision in data entry and manipulation tasks. - Ability to meet project deadlines and deliverables effectively. - Strong communication skills to provide regular updates and address any inquiries promptly. If you possess the requisite skills and are interested in collaborating on this project, please submit your proposal detailing your relevant experience and your approach to completing the task. We welcome any portfolio samples or past projects demonstrating your expertise in data management and bulk Shopify uploads, particularly concerning product variants.
2 days ago36 proposalsRemoteChatGPT descriptions for products
The job entails copying content from a website, rephrasing with CHATGPT in a certain way and inputting in an excell sheet.
a day ago59 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.
24 days ago37 proposalsRemoteData 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
15 days ago55 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.
6 days ago5 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.
a month ago17 proposalsRemoteProofreading books
Looking for a proofreader who is excellent in the English Language and understands how to proof read without the use of grammarly. English must be your 1st language. Payment will be made in accordance with the word count. The perfect candidate can rely on monthly proofreading projects i.e. Books. You will also need to have experience proofreading books.
11 hours ago32 proposalsRemoteurgent
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.
23 days ago20 proposalsRemoteExpires in 6Compressor 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.
9 days ago14 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.
17 days ago20 proposalsRemote