Forecasting can help with budget planning, and Excel has always had some type of forecasting capabilities. In Excel 2016, forecasting becomes easier and faster than ever. In this movie, you will know how to use one button forecasting to show forecasted data figures and a graph for future dates on a separate sheet.
- [Voiceover] For anyone migrating from Excel 2013 to 2016,…you're going to feel right at home.…You will notice those UI changes, but all in all,…the formats are exactly the same, you won't have any…compatibility issues and there are some new features…worth mentioning, which we'll do in this chapter.…Beginning with one I really like it's one button forecasting…you'll see down below here on this file called forecast0301…which you'll find in the chapter three folder…of your exercise files.…There's only one tab for expenses.…
The expenses are listed in columns for each month of 2016.…Except for the last three months, or the last quarter.…Here's where forecasting could come in handy…as we prepare to budget for those months or that quarter.…So let's say we wanted to figure out our advertising…expenses projected for the last quarter of the year.…We can do it with one button forecasting.…First we'll click and drag from cell b3 that's where we…see the first of January 2016, I'll cross it down…to include row five and the empty cells in columns…
- Recognize the changes to the user interface.
- Describe when you would use Touch mode.
- Explain how to quickly format shapes.
- Cite how to quickly choose a chart type.
- Name the pane that opens up when a picture is added to a slide and describe what it does.
- Explain how to import your contacts, email, calendars, and more.