Excel - Creating a forecast sheet with Excel Tutorial
In this video, you will learn about creating a forecast sheet with Excel.
The video covers the functionality of one-click forecasting in Excel 2016, which allows you to forecast based on exponential smoothing.
By clicking the forecast sheet button on the Data tab, you can quickly create a visualization of your data series.
The video also explains how to adjust forecast parameters, choose a chart type for visualization, and set the forecast end.
This will help you create accurate and informative forecasts using Excel.
- 0:43
- 360 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 2615 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 2388 times
-
3D Maps
- 1:41
- Viewed 1927 times
-
Manage conditional formatting
- 4:30
- Viewed 1892 times
-
Create a combo chart
- 1:47
- Viewed 1822 times
-
Introduction to Excel
- Viewed 1720 times
-
The SUMIF function
- 5:27
- Viewed 1700 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 1680 times
-
The SUM function
- 4:37
- Viewed 1624 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 1611 times
-
Customize charts
- 4:28
- Viewed 1604 times
-
Functions and formulas
- 3:24
- Viewed 1604 times
-
AutoFill
- 2:55
- Viewed 1590 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 1569 times
-
Advanced formulas and references
- 4:06
- Viewed 1569 times
-
Using functions
- 5:12
- Viewed 1557 times
-
Drop-down list settings
- 4:14
- Viewed 1555 times
-
New Chart types
- 1:52
- Viewed 1552 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 1521 times
-
Assign a button to a macro
- 2:49
- Viewed 1514 times
-
More complex formulas
- 4:17
- Viewed 1513 times
-
Manage drop-down lists
- 6:12
- Viewed 1510 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 1504 times
-
AutoFilter details
- 3:27
- Viewed 1494 times
-
Operator order
- 2:04
- Viewed 1489 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 1487 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 1483 times
-
Sort details
- 4:46
- Viewed 1478 times
-
Basic math
- 2:28
- Viewed 1471 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 1469 times
-
Freeze panes in detail
- 3:30
- Viewed 1466 times
-
Start using Excel
- 4:22
- Viewed 1462 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 1455 times
-
Look up values on a different worksheet
- 2:39
- Viewed 1451 times
-
More print options
- 5:59
- Viewed 1451 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 1438 times
-
One click Forecasting
- 1:01
- Viewed 1435 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 1430 times
-
Add numbers
- 2:54
- Viewed 1428 times
-
Print worksheets and workbooks
- 1:07
- Viewed 1425 times
-
Work with macros
- 4:40
- Viewed 1407 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 1406 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 1404 times
-
Improved version history
- 0:51
- Viewed 1401 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1397 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 1394 times
-
Create a PivotTable report manually
- 4:59
- Viewed 1394 times
-
Insert columns and rows
- 4:16
- Viewed 1384 times
-
Insert headers and footers
- 2:02
- Viewed 1380 times
-
Input and error messages
- 2:52
- Viewed 1379 times
-
Ink Equation
- 0:41
- Viewed 1376 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 1374 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 1366 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 1361 times
-
A closer look at the ribbon
- 3:55
- Viewed 1359 times
-
A first look at Excel 2016
- 3:22
- Viewed 1357 times
-
IF with AND and OR
- 3:35
- Viewed 1356 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 1355 times
-
Add formulas and references
- 2:52
- Viewed 1351 times
-
Advanced filter details
- 4:13
- Viewed 1350 times
-
Save and print an Excel workbook
- 1:53
- Viewed 1350 times
-
Header and footer details
- 3:41
- Viewed 1348 times
-
IFS
- 1:05
- Viewed 1346 times
-
Copying formulas
- 3:00
- Viewed 1344 times
-
Subtract time
- 3:58
- Viewed 1344 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 1338 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 1335 times
-
AVERAGEIF function
- 3:04
- Viewed 1333 times
-
Freeze or lock panes
- 1:06
- Viewed 1332 times
-
Use conditional formatting
- 2:02
- Viewed 1328 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 1315 times
-
Copy a chart
- 2:59
- Viewed 1306 times
-
Weighted average
- 2:06
- Viewed 1300 times
-
Cell references
- 1:34
- Viewed 1298 times
-
Share documents
- 1:13
- Viewed 1293 times
-
Save your macro
- 2:59
- Viewed 1292 times
-
Get going fast
- 1:38
- Viewed 1283 times
-
Average a group of numbers
- 2:01
- Viewed 1272 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1265 times
-
Drop-down lists
- 0:55
- Viewed 1261 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1251 times
-
TEXTJOIN
- 0:47
- Viewed 1238 times
-
Conditionally format text
- 2:12
- Viewed 1236 times
-
How to create a table
- 2:11
- Viewed 1232 times
-
Save, publish, and share
- 2:22
- Viewed 1218 times
-
Sort and filter data
- 1:38
- Viewed 1215 times
-
Advanced IF functions
- 3:22
- Viewed 1212 times
-
Edit a macro
- 3:29
- Viewed 1208 times
-
How things are organized
- 1:58
- Viewed 1207 times
-
Conditionally format dates
- 2:38
- Viewed 1206 times
-
CONCAT
- 0:51
- Viewed 1203 times
-
Translate your Excel spreadsheets
- Viewed 1203 times
-
Use slicers to filter data
- 1:25
- Viewed 1195 times
-
Flash Fill
- 2:59
- Viewed 1193 times
-
SWITCH
- 1:03
- Viewed 1173 times
-
Create a chart
- 0:52
- Viewed 1169 times
-
Microsoft Search
- 0:34
- Viewed 1163 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1143 times
-
Nested IF functions
- 3:30
- Viewed 1125 times
-
Page numbers in depth
- 3:06
- Viewed 1102 times
-
Map Chart in Excel
- 0:31
- Viewed 1086 times
-
Funnel Chart
- 0:33
- Viewed 1068 times
-
Check Accessibility in Excel
- Viewed 911 times
-
Accessibility in Excel
- Viewed 898 times
-
Change chart type
- Viewed 742 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 620 times
-
XLOOKUP (Basic metrics)
- Viewed 615 times
-
Text before & after Function
- Viewed 602 times
-
Insert an image in a cell with image function
- Viewed 581 times
-
XLOOKUP (Advanced metrics)
- Viewed 566 times
-
Create dynamic drop down lists
- Viewed 524 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 514 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 371 times
-
Create private channels
- Viewed 2499 times
-
Morph transition
- 0:43
- Viewed 2096 times
-
Blur my background while video conferencing with Teams
- 0:29
- Viewed 1710 times
-
Instant captions & subtitles in Powerpoint
- 0:43
- Viewed 1590 times
-
Create a team using an existing team as a template
- 0:43
- Viewed 1481 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1397 times
-
IFS
- 1:05
- Viewed 1346 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 1338 times
-
On-Slide 3D Model Animation
- 0:45
- Viewed 1284 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 1240 times
-
TEXTJOIN
- 0:47
- Viewed 1238 times
-
Use a Wiki tab in Teams to take notes
- 0:45
- Viewed 1234 times
-
Archive or restore a team
- 0:47
- Viewed 1220 times
-
Design ideas with Powerpoint
- 0:37
- Viewed 1219 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 1213 times
-
CONCAT
- 0:51
- Viewed 1203 times
-
Do Not Disturb
- 0:35
- Viewed 1201 times
-
Automatic transcription
- Viewed 1194 times
-
Presenter Mode
- Viewed 1185 times
-
SWITCH
- 1:03
- Viewed 1173 times
-
Disable the sound of a chat
- 0:33
- Viewed 1167 times
-
Reusing slides
- 0:37
- Viewed 1163 times
-
Microsoft Search
- 0:34
- Viewed 1163 times
-
Quickly sort emails
- 0:27
- Viewed 1162 times
-
How to set quiet hours
- 0:32
- Viewed 1151 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1143 times
-
Automatically recording a meeting
- Viewed 1132 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 1131 times
-
How to search a file in all channels
- 0:29
- Viewed 1127 times
-
Spotlight a participant
- Viewed 1111 times
-
Schedule a meeting for a large group
- 0:43
- Viewed 1108 times
-
Identify meeting members
- 0:26
- Viewed 1091 times
-
Map Chart in Excel
- 0:31
- Viewed 1086 times
-
Locate your documents
- 0:20
- Viewed 1077 times
-
Embed fonts in presentations
- 0:40
- Viewed 1075 times
-
Make your presentation lively with the Zoom function
- 0:41
- Viewed 1073 times
-
Funnel Chart
- 0:33
- Viewed 1068 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 1067 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 1056 times
-
Display 3 time zones
- 0:37
- Viewed 1053 times
-
Create a site off a template
- Viewed 1049 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 1039 times
-
Removing the background of a picture
- 0:41
- Viewed 1024 times
-
Icon insertion
- 0:54
- Viewed 1006 times
-
Use dictate to type in Word
- 0:27
- Viewed 998 times
-
New tab "Recording"
- 0:43
- Viewed 993 times
-
Start an ad hoc meeting
- Viewed 944 times
-
Filter the display of you documents
- Viewed 933 times
-
Insert icons
- 0:43
- Viewed 909 times
-
3D Models
- 0:42
- Viewed 905 times
-
Edit document with natural gestures
- 0:34
- Viewed 903 times
-
Reply to a Teams conversation from an email
- Viewed 900 times
-
Let Word read your documents out loud
- 0:36
- Viewed 893 times
-
Chat with co-authors while editing
- 0:29
- Viewed 888 times
-
Upload a folder into Teams
- Viewed 874 times
-
Sync only one channel
- Viewed 847 times
-
Set your status message
- Viewed 840 times
-
Translate your Word documents into any language
- 0:33
- Viewed 823 times
-
Use a background image during a video call
- Viewed 807 times
-
PivotTable Insertions
- 0:43
- Viewed 803 times
-
Simply view conversations in meetings
- Viewed 765 times
-
Sharing your smartphone's screen
- Viewed 732 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 514 times
-
Work on multiple windows
- Viewed 500 times
-
Configure multiple virtual desktops
- Viewed 499 times
-
Make screenshots easier
- Viewed 469 times
-
View events
- Viewed 54 times
-
Take notes in meetings
- Viewed 62 times
-
Manage a meeting
- Viewed 63 times
-
Start an instant meeting
- Viewed 58 times
-
Join a meeting as a participant
- Viewed 75 times
-
Automatically record a meeting
- Viewed 59 times
-
Presentation of different tools in a meeting
- Viewed 59 times
-
Share content in meetings
- Viewed 64 times
-
Use a background image during a video call
- Viewed 58 times
-
Schedule private or team meetings
- Viewed 62 times
-
Synchronize only one channel
- Viewed 60 times
-
Pin a channel to your favorites
- Viewed 58 times
-
Add channels and tabs
- Viewed 56 times
-
Interact in a conversation
- Viewed 61 times
-
Edit and enhance messages
- Viewed 70 times
-
Create a team using a template
- Viewed 67 times
-
Create a team and add members
- Viewed 75 times
-
Plan a meeting based on a conversation
- Viewed 60 times
-
Interact in conversations
- Viewed 57 times
-
Private and small group chats
- Viewed 58 times
-
Overview of conversations
- Viewed 57 times
-
Define your status message
- Viewed 81 times
-
Customize notifications
- Viewed 61 times
-
Edit photo in Teams
- Viewed 57 times
-
Find content and people
- Viewed 58 times
-
Presentation of the desktop application
- Viewed 58 times
-
Introduction to Teams
- Viewed 64 times