You might assume that you need complex statistical software or manual regression formulas to predict how much your business will earn over the next few months. However, with modern dynamic arrays in Excel for Microsoft 365 and Excel 2021 or later, you can enter a single formula into a cell and instantly project months of future revenue.