How to Use the Forecast Sheet in Excel - Tutorial 📈



1
27399

Excel tutorial on how to use the Forecast Sheet in Excel. The Forecast Sheet button does a quick analysis of data on your sheet and also creates a chart of what it’s forecasting. You can then use this chart as a visual to help you understand the forecasted results better or as a quick visual for a presentation. Watch as we create a forecast using the Forecast Sheet feature in this tutorial. The Forecast Sheet button became available with Excel 2016 and is also available in Office 365 Excel version. To use the Forecast Sheet tool, you need 2 pieces of information: 1. a range of dates and 2. the data results for those dates. The dates used should be consistent and in chronological order. This data will be used to project results and will be output in both a detailed spreadsheet and a chart. The default chart is a line chart, you can also switch to a column chart. After "creating" the final, you can format the chart just like any other chart in Excel, including switching to a different chart type, if you prefer. Click here to read our step by step article on this: https://yacostasolutions.com/forecast-sheet-in-excel/ If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/ *FYI: This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://amzn.to/302tWl4 The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://amzn.to/360RNnI Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊 To catch our Excel tutorials as they come out, subscribe to this channel by clicking: goo.gl/t7VrWZ Thanks! *DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support! #ExcelTutorial #YAcostaTutorials

Published by: Y. Acosta Excel Tutorials Published at: 5 years ago Category: آموزشی