Excel Vba Projects
Looking for freelance Excel Vba 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
3 days ago43 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.
8 days ago43 proposalsRemoteCompress large excel file over 300mb
I need someone to compress a large excel file without loss of quality. The file is over 300mb and would need to be compress to a very small file so it is sent by email.
11 minutes ago0 proposalsRemoteExcel to Word Data Conversion with NDA (24-Hour Turnaround)
I have an urgent project requiring the conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed successfully. Only professionals with strong credentials and proven expertise will be considered.
15 minutes ago4 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.
4 days ago26 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
21 days ago75 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
18 days ago19 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.
14 days ago36 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.
19 days ago99 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.
3 days ago23 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.
4 days ago38 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.
4 days ago63 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.
a month ago36 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
17 days ago60 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.
8 days ago8 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.
3 days ago47 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.
25 days ago21 proposalsRemoteExpires in 4Compressor 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.
11 days ago15 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.
19 days ago20 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.
a month ago23 proposalsRemote