Find Jobs
Hire Freelancers

Customisation of Excel for Store Management

₹1500-12500 INR

Færdiggjort
Slået op over 1 år siden

₹1500-12500 INR

Betales ved levering
I have created stock report. Now, I using dropdown list for "Opening balance", "Inward", "Outward" and "closing balance" in column and put values separately in different columns for all three options. Now, I want calculate the closing stock at the end of each day. for this, I have to sum values in "Opening Bal." column with sum of values "Inward" column and then subtract the sum of values in "Outward" column of entire day. I have to perform same at the end of the day. My problem is that is there way or function i put so it calculate closing stock values automatically when i put a drop-down option as "Closing Stock". And It should only sum the values of "Opening balance", "Inward" and "Outward" before previous "Closing Stock".
Projekt-ID: 35465981

Om projektet

26 forslag
Projekt på afstand
Aktiv 1 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
ok sure i can customize your excel sheet as per your store data pls PM me can we discuss few quires wait for reply [login to view URL]
₹5.000 INR på 2 dage
4,7 (37 anmeldelser)
4,8
4,8
26 freelancere byder i gennemsnit ₹6.885 INR på dette job
Brug Avatar.
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am available almost 24-7 and am very responsive. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 Kindly contact me via chat for further details and discussion.. Thank you Sandeep
₹12.000 INR på 5 dage
4,9 (663 anmeldelser)
8,6
8,6
Brug Avatar.
Hello Devraj R., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on PHP, Visual Basic, Data Processing, Excel, Software Architecture Lets connect in chat so that We discuss further. Regards
₹7.000 INR på 7 dage
5,0 (95 anmeldelser)
6,9
6,9
Brug Avatar.
Customisation of Excel for Store Management Good afternoon Devraj R. , Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, OPENCV, WEKA, TABLEAU, POWER BI, and EXCEL tools like image processing, machine learning, deep learning, AI, NLP, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
₹12.500 INR på 6 dage
4,6 (106 anmeldelser)
7,1
7,1
Brug Avatar.
Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.
₹12.500 INR på 3 dage
4,9 (127 anmeldelser)
6,6
6,6
Brug Avatar.
Hello there Iam excel and data analysis EXPERT level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need this finished? I understand how annoying it is and can get this fixed for you quickly! Please see the sample I fixed. I look forward to working on this project with you. Regards
₹11.500 INR på 2 dage
4,9 (202 anmeldelser)
6,2
6,2
Brug Avatar.
Hey, I'm an Advanced Level Exce Expert and will do it. Please send me a message so we can discuss further. Thanking You
₹2.500 INR på 1 dag
4,8 (59 anmeldelser)
4,8
4,8
Brug Avatar.
Hi, I'm a Chartered Accountant from Institute of the Chartered Accountants of India ( Top recognised body in accounting and finance department ) Apart from that I have undergone 5 years of extensive training in one of the best management firm where I was involved in preparing Financial statements, Financial Models, pitch deck, business valuation, market research, competitive analysis etc. Right now I'm working with a top US boutique firm as a valuation analyst , frankly speaking I'm obsessed with MS Excel that's why I take weekly classes where I teach people MS Excel. Maybe we could do a quick zoom meeting to discuss more. Thank You
₹8.000 INR på 2 dage
4,9 (26 anmeldelser)
4,9
4,9
Brug Avatar.
Hello, I can do your project and I have a solution along with relevant inventory management experience of SAP B1. Please review my profile as i have below relevant skills and experience required for this project. Excel Advanced VBA Google Sheets Apps Script Google Data Studio Google Forms I can start working right now. Kindly send me a message to discuss further for references, portfolio and case studies. Regards Muhammad
₹2.500 INR på 1 dag
4,9 (7 anmeldelser)
3,0
3,0
Brug Avatar.
Hi There, As an Excel and VBA Developer, I can help you to automated your "stocks file according to your three dropdown" and i can do this easily & quickly. I have also worked this type of similar project and i have more than 3 years expereinced in this profile. If you are interested so we can discuss on it, I am available 24*7 for the work. Thanks, Daksh Mahaur Excel and VBA Developer
₹12.500 INR på 1 dag
5,0 (8 anmeldelser)
3,0
3,0
Brug Avatar.
Hello, I am Vikram, read the project description auto calcualte sum based on 'closing stock in drop down'. I can help write the formula's or give VBA solution that will do the work in few seconds. I am experienced and expertise of 3+ years in Excel Formula's and Excel Automations. Please message me to discuss more. Regards, Vikram
₹2.500 INR på 2 dage
4,9 (24 anmeldelser)
3,0
3,0
Brug Avatar.
Hi, I have experience in writing macros. Also i use pivot table/vlookup for my routine work. I need to see at excel sheet u made. Thanks Sandeep
₹7.000 INR på 7 dage
3,9 (11 anmeldelser)
3,4
3,4
Brug Avatar.
"Sir, Excel and Ms word is my filed and complex formulas is my passion. I am an Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working here from the last 1.5 year and I have 224+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards. "Nasir Ali "
₹1.500 INR på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I can do it within 4 days. I have been doing this kind of work from last 4 years. I have expertises in it.
₹10.000 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I have all the skills and experience listed in the job description, and I'm confident that I can make an immediate impact on your report.
₹2.000 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I can work for you better than everyone else. Hire me and u gonna be surprised with my result. I am currently studying and got leisure time. So i wanna earn
₹7.000 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hi, GREETINGS ! Being qualified from a reputed academy in Data Science where I studied, learned and got certified with very good percentage. I'm a data analyst and good at converting raw data into into meaningful readable and understandable excel data and at the same time creating meaning and dynamic dashboards and visuals for strategic decision making and/or getting good idea meaning out of raw data if not anything. Client satisfaction is utmost important and the priority is as always to deliver the desired and required results by the customer and most of the time giving much more to the client than he has asked for as an added advantage for the client.
₹5.000 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Please give me an opportunity i will do all needfull in time? Hello there, I am an excel specialist. I can create interactive graphs for your data. I am skilled and experienced in advanced excel. I have experiences working on excel charts of various formats. I do excellent work and pay attention to the details of a task. I am a fast learner. I give clients 100% job satisfaction. Willing to work strictly within your budget. At your service.
₹7.000 INR på 7 dage
3,8 (1 bedømmelse)
0,0
0,0
Brug Avatar.
I have work experience of more than 3 year in Industry as Data Scientist and Excel Expert to resolve the client queries with options.
₹2.000 INR på 3 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I am in CA final, great skill in MS Excel and other Data related work. Best and fast typing skill , done Audit of many listed companies, so better at time managment and skills.
₹2.000 INR på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I am having lot of experience in stores accounting and stick list updation. I also have experience in excel worksheet development for various applications. I am sure I can develop the best excel worksheets for your given job. Given an opportunity I can complete your work in the given time with high degree if accuracy.
₹15.000 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for INDIA
vidisha, India
5,0
1
Medlem siden nov. 2, 2021

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.