There are several different types of FORECAST functions available in Excel. You can use the FORECAST.ETS function to calculate a potential future value based on historical values.

If you're still manually sifting through massive spreadsheets or relying on clunky, old-school sorting tools, you're doing it ...