Customisation of Excel for Store Management
Budjetti ₹1500-12500 INR
Job Description:
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".
Myönnetty käyttäjälle:
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]
26 freelanceria on tarjonnut keskimäärin ₹6885 tähän työhön
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 a Lisää
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, Lisää
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 Lisää
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. Lisää
Hey, I'm an Advanced Level Exce Expert and will do it. Please send me a message so we can discuss further. Thanking You
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 Lisää
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 m Lisää
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
"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 Accounta Lisää
I can do it within 4 days. I have been doing this kind of work from last 4 years. I have expertises in it.
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.
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
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 read Lisää
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 w Lisää
I have work experience of more than 3 year in Industry as Data Scientist and Excel Expert to resolve the client queries with options.
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.