
Aug 29, 2018
Predict your data’s future using a Forecast Sheet
(Excel 2016 – Subscription Version)
Did you know that you can easily create a forecast when you’re working with time-based data in Excel? Forecasts help you determine trends in your data and they give you an idea of what to plan for in the future. This blog is written to provide you with the tools you need to predict sales, forecast business finances or predict demand for your product.

To create a forecast sheet, your data needs date or time entries with consistent intervals. For example, let's say you have a worksheet with monthly sales figures for the past year. Even if you're missing the corresponding sales figures for a month or two, you can still create a forecast.
Click on a cell within your data series, then click on the main ribbon’s Data tab. In the Forecast group, click on Forecast Sheet. (When you click the Forecast Sheet button, Excel automatically selects your entire data series.)
Click on the Line Chart button or Column Chart button in the upper-right corner of the Create Forecast Worksheet dialog box, choosing the option that best represents your data. Select an end date from the Forecast End menu, and then click Create.
The forecast chart displays within your worksheet, providing a forecast for the future along with an upper and lower confidence bound to give you an idea of the best- and worst-case scenarios.
Do you want to learn more tips and tricks in Excel or learn more about working with Office 365, call 1300 794 006 or send your enquiry to [email protected].
How do your Excel skills stack up?
Test NowNext up:
- VMware Cloud comes to Australia and New Zealand
- Discovering the digital workplace of the future
- The Benefits of a Multi-Cloud Strategy
- 6 Steps to Communicate across your Organisation
- Understanding Cisco Certifications
- 10 Ways to Enhance your IT Leadership Skills
- Gain a Project Management Qualification with PRINCE2 included
- An Advanced Diploma of Information Technology with an advantage
- What makes this Diploma of Information Technology different?
- Introducing Microsoft Azure Role Based Certifications
Previously
- How to manage your transition to Microsoft Office 365
- Information Lifecycle Management – It’s not too hard!
- What is on the Horizon from Microsoft
- 3 Quick wins for your remaining training budget
- The next step in Online Education
- Active Listening
- Challenges and Solutions in Cloud Migration
- SharePoint embraces AI revolution
- How does Cloud Security Stack up?
- The Endless Possibilities That AI Offers Today