From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Forecast future results

Forecast future results - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Forecast future results

“

- [Presenter] When you own or operate a business, you're always wondering what happens next. In this movie, I will show you a couple of techniques you can use to answer those questions at least as far as current trends allow. My sample file is 02_05_Forecast and you can find it in the chapter two folder of the exercise files collection. I'm on the trend worksheet in this workbook and you can see that I have quarterly sales data for the years of 2021 and 2022. What I'd like to do is to get a forecast based on those values for the quarters in 2023, and you can do that using the fill-handle. If you're not familiar with the fill-handle, I will give you a quick demonstration of how it works. In cell D-2. I'll type a one and then in cell D-3, I'll type a two. Then I will select cells D-2 and D-3. If you haven't used the fill-handle before, it is the green square at the bottom-right corner of a selected cell or cell range. If you want to drag the fill-handle to extend value, select the two…

Contents