I am in charge of procuring crop chemicals and distributing them out to our network of rural stores in Australia.
I currently use an excel worksheet with product descriptions, order information, pricing (invoice and net) delivery schedules,forecast numbers and delivered to stores information.
I also constantly update the worksheet with everything from forecast numbers to ETA's.
I am looking to get a dashboard set up to read the information a bit easier and quicker, expand the options to include notes if needed per product and to track the invoice pricing that constantly changes per purchase order.
I have tried to use pivot tables and splicers, but im still not sure exactly what i really need to see and do!
I will attach my worksheet and a couple of examples of what i would like to see.
15 freelancers are bidding on average $164 for this job
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. Stay tuned, I'm still working on this proposal.
Hi Sir, I’ve more than 5 years of experience of MS Excel with advance level formulas, dynamics charts, user interactive dashboards and VBA coding to automate tasks. Kindly text me for further details. Thanks