Original Source: Production Scheduling
"Analytics for demand planning in Excel usually involves big tables of data. To understand the demand for a product, you need to look into its history. Analytics with an order history over a year or more can have 100K+ records. Here is a technique to perform fast analytical formulas on many thousand rows.