Find Jobs
Hire Freelancers

Excel expert

$30-250 USD

Closed
Posted about 4 years ago

$30-250 USD

Paid on delivery
I work for a Direct mail company. We have a client in which we print mass quantities of pieces ahead of time and then twice a week they place an order for each of the pieces. The numbers can vary pretty greatly and instead of taking an inventory every time there is an order I want to the ability to enter in the number and have it deduct from the total inventory. The issue I am having is though once I delete that number it takes it out of the ending inventory as well. I do not want to have to continue adding columns for every new order as I want to keep the main page of the excel file as simplistic as possible to eliminate the chance of errors from multiple different data entry points. That being said every time there is a new entry I would like it to copy the data to a second sheet in order to track trends etc.
Project ID: 23863841

About the project

35 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
35 freelancers are bidding on average $136 USD for this job
User Avatar
Hello, I can help you with your project - Excel expert I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD in 4 days
4.9 (594 reviews)
8.5
8.5
User Avatar
Dear Employer, I have closely checked your job and will deliver an efficient solution on this wherein you will not have to add the fields again and again. Please message me to discuss further, I will for sure do your job. Thanks and Regards, Ash
$250 USD in 5 days
5.0 (300 reviews)
8.4
8.4
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards
$150 USD in 1 day
5.0 (514 reviews)
8.1
8.1
User Avatar
Hi Sir, I am expert in Excel/VBA. I can give you accurate solution to this scenario. Please ping back to discuss further/. I can complete the job within hour. Please check my reviews. Thank You Regards Rishi
$45 USD in 1 day
4.9 (182 reviews)
6.1
6.1
User Avatar
Hi, I can assist you to modify your excel orders - inventory tool. I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets) as an Industrial Engineer at Michelin Romania .  I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work.  Best regards,  Florin Enache.
$200 USD in 3 days
5.0 (23 reviews)
5.7
5.7
User Avatar
Hi there, I suggest to have the data stack in a columnar layout instead of a static tabular layout. have a simple entry form that where you can input the new orders or new inventories. Once you have it, everything can be easily manipulated using a standard pivot table. If you have ample time, I would like to show you a video demo of what I talking about tomorrow. I’ll be standing by to help. -Reggie
$80 USD in 2 days
5.0 (49 reviews)
5.5
5.5
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have an opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I am a full-time freelancer, I can start working on the project immediately and complete the job within some hours. Regards
$30 USD in 1 day
4.9 (64 reviews)
5.7
5.7
User Avatar
Hi there. I have good experience working with XL and creating the tools required to make work easier for the end users. I can help you get what you want. Regards. Reuben
$99 USD in 5 days
5.0 (26 reviews)
5.2
5.2
User Avatar
Hello, I could put a button on top of sheet 1 which when you push it will: 1) Copy the figures in the 'Remaining' column over to the 'Inventory at Hand' column (values only no formulas). 2). Clear all the figures in the 'Current Order' column to zero so you can start again. What do you do when stock comes in? I could add another column to sheet 1 for incoming stock.
$100 USD in 7 days
5.0 (3 reviews)
4.9
4.9
User Avatar
Hi there. Great idea to streamline your running inventory calculation. I will be able to do this for you in 1 to 2 days. I'm highly experienced in Excel, working with complex functions, Macros and VBA on a daily basis. I pride myself on my analytical, problem solving and creative skills combined with a meticulous attention to detail, which have helped me deliver effective solutions that provide an exceptional user experience. I hope you consider me for your project. Kind regards, Lynn
$135 USD in 2 days
5.0 (3 reviews)
4.5
4.5
User Avatar
ready to develop the necessary code. and design to have the main customer inventory sheet as simple as it is, by creating a user input from to add customer orders, store it and deduct amounts from main sheet inventory automatically. best, Rageh
$100 USD in 2 days
4.9 (17 reviews)
4.6
4.6
User Avatar
Hi there! Most people are just going to solve what you asked of them. But based on what I saw from your file, you actually need to change the layout of your data. This is so that you can generate reports more easily from it. So I would suggest we have a discussion to understand your workflow better. I scanned through your proposals as well and Reggie is the only one who suggested something close to what I would do. Drop me a message and after we discuss, I will do up a demo before you decide to award the project. I am usually available from 8 AM to 11 PM (GMT+8) and will reply within an hour.
$200 USD in 3 days
5.0 (13 reviews)
4.3
4.3
User Avatar
Hi First of all - do You prefer Excel? Dont You want to go to GoogleSheet for this scope? 2 - im not sure i understood You right. Can You explain more detailed? As I understood there are three process parts a) You have some basic inventory value for each product b) You have some basic order (lets say -15000) c) every time You add new order You want it also to be added to basic order (independent of how many times it was done I can provide some kind of MACROS - e.g. a microprogram inside of Excel/Google Sheet (google sheet is preferred) + add new sheet where You will put a new order then click button "REGISTER" and it will automatically calculate new values. If You want to see all the history of orders - we can use a new sheet where will be some kind of log of all orders My condition is 60$ initial milestone Lets chat
$140 USD in 4 days
5.0 (2 reviews)
3.3
3.3
User Avatar
I'm an expert in data entry. I am working with a team of data entrant experts who can complete your projects within your given deadline. We can manage bulk data entry work in a very short period of time. Our services include; Data Processing- Scrapping-Typing-Web/Internet Search-Data Entry-Data Collection- Copy/Paste Jobs-PDF/Image to Excel & Word Conversion. We need a chance to show you our potential. :)
$30 USD in 1 day
5.0 (4 reviews)
2.7
2.7
User Avatar
Hello, Good day!! I would like to help you. I have good experience in Excel and Formulas. I have done few projects on Excel VBA ( Automation / Macros). I prefer good experience and job satisfaction than money. Please let me know more about the project to give exact timeline. Hope to work with you soon. Thanks!
$30 USD in 3 days
5.0 (4 reviews)
1.4
1.4
User Avatar
I am full time excel programmer. I am able to do any task, such as tables, graphics and formulas. Responsable and detailed. I will always try to deliver the result as fast as posible. Contact me if you are interested.
$30 USD in 7 days
5.0 (2 reviews)
0.8
0.8
User Avatar
Hi! Allow me to do the job for you. I am easy to work with, can follow instructions, can work with less supervision, meets deadline and can start immediately. I've been using ms excel, word or powerpoint ever since and I assure you quality work as per your given deadline. Looking forward to work with you. Regards, Rilon
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Buenas noches soy Arquitecto y Gerente de Obra y constantemente utilizo Excel para pago de nominas... envíame un mensaje explicándome lo que necesitas... para poder ayudarte en tu proyecto... saludos cordiales... Arq. Carlex Araujo...
$140 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Best work and work completed on time
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have a good experience of working on excel. I can complete this project as per deadline.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Phoenix, United States
0.0
0
Member since Feb 12, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.