Excel Formulas Automating Obsolete Inventory Forecast (Part 1)

In Part 1 video, you will learn how to use MAX function to simplify a long IF function, and use mixed reference formulas to sum all the previous months up to now, to avoid manual formula adjustment.

Jennifer works in Supply Chain field. Every month she needs to forecast how much inventory will become obsolete by month.

She had the work done with Excel formulas, however there are still parts requiring her manual check and manual formula adjustments.

I coached her to find better solution with new formulas, which automated the whole process. No more manual checks and adjustments.

In this Part 1 video, I walk you through how to build the new formulas to automate this process.

Jennifer told me her ultimate objective in that process is just to have two columns of summary results. In that case, it's not even necessary to create the two blocks of 24 month supporting columns.

We can have formulas done along the input data in a vertical orientation, rather than laying out the 24 months horizontally.

In the Part 2 video, I help you to think differently, and restructure the whole process, still accomplish the same objective. Click here to watch Part 2 video    • Excel Formulas Automating Obsolete In...  

If you encounter Excel challenges at work, please contact me. I will coach you to find solutions to solve your problems.

You can find my contact here https://www.superexcel.online/contact-us

Steve Huang