Excel project on Sales
Budget: €6 – €12 EUR
1. Design a formula in excel (or else propose alterative) to easily update historical and future sales numbers by classification system.
2. Define missing items that are classified according to specified logic
3. Ensure all Items in each historical sales sheet are classified and capture date added/ data removed data on this item classification.
4. Propose a design of the process to allow this can be easily applied going forward when new sheets are added.
2. Define missing items that are classified according to specified logic
3. Ensure all Items in each historical sales sheet are classified and capture date added/ data removed data on this item classification.
4. Propose a design of the process to allow this can be easily applied going forward when new sheets are added.