Excel - Creating a forecast sheet with Excel Video
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
- 815 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3299 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 3051 times
-
3D Maps
- 1:41
- Viewed 2670 times
-
Manage conditional formatting
- 4:30
- Viewed 2649 times
-
Create a combo chart
- 1:47
- Viewed 2531 times
-
The SUMIF function
- 5:27
- Viewed 2525 times
-
Functions and formulas
- 3:24
- Viewed 2435 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2416 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2410 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2392 times
-
The SUM function
- 4:37
- Viewed 2380 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2369 times
-
More complex formulas
- 4:17
- Viewed 2367 times
-
Using functions
- 5:12
- Viewed 2362 times
-
Manage drop-down lists
- 6:12
- Viewed 2351 times
-
Advanced formulas and references
- 4:06
- Viewed 2345 times
-
More print options
- 5:59
- Viewed 2344 times
-
Introduction to Excel
- 0:59
- Viewed 2337 times
-
Customize charts
- 4:28
- Viewed 2322 times
-
New Chart types
- 1:52
- Viewed 2317 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2268 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2262 times
-
Start using Excel
- 4:22
- Viewed 2258 times
-
Freeze panes in detail
- 3:30
- Viewed 2251 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2247 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2240 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2232 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2231 times
-
AutoFilter details
- 3:27
- Viewed 2230 times
-
AutoFill
- 2:55
- Viewed 2225 times
-
Drop-down list settings
- 4:14
- Viewed 2222 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2212 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2210 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2207 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2196 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2193 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2188 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2182 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2171 times
-
Header and footer details
- 3:41
- Viewed 2158 times
-
Add numbers
- 2:54
- Viewed 2155 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2155 times
-
Sort details
- 4:46
- Viewed 2144 times
-
Operator order
- 2:04
- Viewed 2142 times
-
A first look at Excel 2016
- 3:22
- Viewed 2141 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 2137 times
-
IF with AND and OR
- 3:35
- Viewed 2136 times
-
Assign a button to a macro
- 2:49
- Viewed 2130 times
-
A closer look at the ribbon
- 3:55
- Viewed 2125 times
-
Work with macros
- 4:40
- Viewed 2118 times
-
Advanced filter details
- 4:13
- Viewed 2110 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 2108 times
-
Insert columns and rows
- 4:16
- Viewed 2106 times
-
Print worksheets and workbooks
- 1:07
- Viewed 2105 times
-
Insert headers and footers
- 2:02
- Viewed 2104 times
-
One click Forecasting
- 1:01
- Viewed 2102 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 2102 times
-
Basic math
- 2:28
- Viewed 2099 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 2099 times
-
Use conditional formatting
- 2:02
- Viewed 2094 times
-
Ink Equation
- 0:41
- Viewed 2082 times
-
AVERAGEIF function
- 3:04
- Viewed 2067 times
-
Save your macro
- 2:59
- Viewed 2066 times
-
Improved version history
- 0:51
- Viewed 2049 times
-
Subtract time
- 3:58
- Viewed 2044 times
-
Input and error messages
- 2:52
- Viewed 2044 times
-
Copy a chart
- 2:59
- Viewed 2041 times
-
Save and print an Excel workbook
- 1:53
- Viewed 2022 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 2019 times
-
Cell references
- 1:34
- Viewed 2017 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 2008 times
-
IFS
- 1:05
- Viewed 1990 times
-
Conditionally format dates
- 2:38
- Viewed 1986 times
-
TEXTJOIN
- 0:47
- Viewed 1985 times
-
Get going fast
- 1:38
- Viewed 1975 times
-
Copying formulas
- 3:00
- Viewed 1970 times
-
Add formulas and references
- 2:52
- Viewed 1969 times
-
Conditionally format text
- 2:12
- Viewed 1967 times
-
Freeze or lock panes
- 1:06
- Viewed 1943 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1939 times
-
Save, publish, and share
- 2:22
- Viewed 1933 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1932 times
-
Weighted average
- 2:06
- Viewed 1917 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1908 times
-
Use slicers to filter data
- 1:25
- Viewed 1891 times
-
Average a group of numbers
- 2:01
- Viewed 1890 times
-
How to create a table
- 2:11
- Viewed 1886 times
-
Share documents
- 1:13
- Viewed 1878 times
-
How things are organized
- 1:58
- Viewed 1871 times
-
Drop-down lists
- 0:55
- Viewed 1868 times
-
Advanced IF functions
- 3:22
- Viewed 1867 times
-
Create a chart
- 0:52
- Viewed 1852 times
-
CONCAT
- 0:51
- Viewed 1838 times
-
Edit a macro
- 3:29
- Viewed 1829 times
-
Flash Fill
- 2:59
- Viewed 1810 times
-
Sort and filter data
- 1:38
- Viewed 1794 times
-
SWITCH
- 1:03
- Viewed 1783 times
-
Nested IF functions
- 3:30
- Viewed 1781 times
-
Microsoft Search
- 0:34
- Viewed 1755 times
-
Page numbers in depth
- 3:06
- Viewed 1754 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1707 times
-
Map Chart in Excel
- 0:31
- Viewed 1697 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1697 times
-
Funnel Chart
- 0:33
- Viewed 1538 times
-
Accessibility in Excel
- 1:12
- Viewed 1507 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1451 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1198 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1168 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1137 times
-
Change chart type
- 1:29
- Viewed 1135 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 1103 times
-
Create dynamic drop down lists
- 3:26
- Viewed 1093 times
-
Text before & after Function
- 4:57
- Viewed 1087 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1040 times
-
Morph transition
- 0:43
- Viewed 2930 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2392 times
-
Instant captions & subtitles in Powerpoint
- 0:43
- Viewed 2221 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 2099 times
-
IFS
- 1:05
- Viewed 1990 times
-
TEXTJOIN
- 0:47
- Viewed 1985 times
-
On-Slide 3D Model Animation
- 0:45
- Viewed 1938 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1908 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 1890 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 1887 times
-
Design ideas with Powerpoint
- 0:37
- Viewed 1877 times
-
CONCAT
- 0:51
- Viewed 1838 times
-
How to search a file in all channels
- 0:29
- Viewed 1799 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 1783 times
-
SWITCH
- 1:03
- Viewed 1783 times
-
Quickly sort emails
- 0:27
- Viewed 1766 times
-
Display 3 time zones
- 0:37
- Viewed 1760 times
-
Microsoft Search
- 0:34
- Viewed 1755 times
-
Locate your documents
- 0:20
- Viewed 1728 times
-
How to set quiet hours
- 0:32
- Viewed 1715 times
-
Reusing slides
- 0:37
- Viewed 1711 times
-
Identify meeting members
- 0:26
- Viewed 1708 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1707 times
-
Map Chart in Excel
- 0:31
- Viewed 1697 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 1693 times
-
Embed fonts in presentations
- 0:40
- Viewed 1627 times
-
Make your presentation lively with the Zoom function
- 0:41
- Viewed 1617 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 1614 times
-
Icon insertion
- 0:54
- Viewed 1601 times
-
Use dictate to type in Word
- 0:27
- Viewed 1599 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 1596 times
-
Funnel Chart
- 0:33
- Viewed 1538 times
-
3D Models
- 0:42
- Viewed 1508 times
-
Insert icons
- 0:43
- Viewed 1488 times
-
Edit document with natural gestures
- 0:34
- Viewed 1487 times
-
Let Word read your documents out loud
- 0:36
- Viewed 1465 times
-
Removing the background of a picture
- 0:41
- Viewed 1437 times
-
New tab "Recording"
- 0:43
- Viewed 1414 times
-
Chat with co-authors while editing
- 0:29
- Viewed 1397 times
-
Translate your Word documents into any language
- 0:33
- Viewed 1366 times
-
PivotTable Insertions
- 0:43
- Viewed 1290 times
-
Make screenshots easier
- 3:59
- Viewed 1064 times
-
Configure multiple virtual desktops
- 1:35
- Viewed 1058 times
-
Work on multiple windows
- 1:21
- Viewed 988 times
-
Customise my SharePoint site navigation
- 2:20
- Viewed 101 times
-
Managing permissions on a SharePoint List
- 1:42
- Viewed 107 times
-
Managing permissions on a SharePoint page
- 1:27
- Viewed 104 times
-
Managing permissions on a SharePoint file
- 1:12
- Viewed 115 times
-
Managing permissions in a SharePoint folder
- 1:10
- Viewed 111 times
-
Managing permissions of a document library
- 2:01
- Viewed 100 times
-
Create a permission group
- 2:11
- Viewed 145 times
-
SharePoint permission levels
- 2:16
- Viewed 104 times
-
Generate a usage report for my SharePoint site
- 1:42
- Viewed 109 times
-
Create a SharePoint news and send it via mail
- 1:59
- Viewed 142 times
-
Create a SharePoint Lists
- 2:18
- Viewed 153 times
-
Create a document library
- 1:56
- Viewed 149 times
-
Create and publish a SharePoint page
- 2:44
- Viewed 157 times
-
Customise my site Homepage
- 3:03
- Viewed 109 times
-
Configure the global Theme and logo
- 2:26
- Viewed 155 times
-
Delete a SharePoint site
- 1:12
- Viewed 103 times
-
Modify membership to the sites of my organization
- 1:38
- Viewed 107 times
-
Create a SharePoint site
- 1:57
- Viewed 154 times
-
Choose expiration and permissions options for links opened to anyone
- 1:08
- Viewed 100 times
-
Disable the OneDrive sync button
- 0:49
- Viewed 111 times
-
Prevent comments on modern pages
- 1:15
- Viewed 146 times
-
Disable subsite creation
- 0:53
- Viewed 103 times
-
Set the proper time zone
- 0:44
- Viewed 106 times
-
Define site storage limits
- 1:42
- Viewed 98 times
-
Disable site creation
- 0:52
- Viewed 106 times
-
Access the admin center
- 0:52
- Viewed 150 times
-
Work together on the same document
- 1:48
- Viewed 111 times
-
Create a folder or a file in a library
- 1:46
- Viewed 154 times
-
Synchronise a SharePoint document library
- 1:42
- Viewed 120 times
-
Use the filter pane in a library
- 2:00
- Viewed 105 times
-
Pin a document to the top of a document library
- 1:32
- Viewed 104 times
-
Share a document to someone outside of my SharePoint site
- 3:57
- Viewed 102 times
-
Use version history
- 1:57
- Viewed 103 times
-
Open and work on a document
- 2:42
- Viewed 107 times
-
Rename and find a document
- 2:00
- Viewed 98 times
-
Create a SharePoint site
- 2:58
- Viewed 160 times
-
Register as a Participant in a Teams Webinar
- 1:05
- Viewed 158 times
-
Add Interactivity to Your Teams Webinar
- 2:02
- Viewed 112 times
-
Ensure Your Webinar Options Before Launching
- 1:09
- Viewed 107 times
-
Prepare Your Webinar with Microsoft Teams
- 3:13
- Viewed 104 times
-
Participate in a Town Hall
- 0:53
- Viewed 99 times
-
End the Event and Gather Statistics
- 1:10
- Viewed 104 times
-
Communicate Behind the Scenes
- 0:56
- Viewed 108 times
-
Moderate the Chat During a Town Hall
- 1:26
- Viewed 103 times
-
Start and Manage Your Event with Multiple People
- 1:20
- Viewed 107 times
-
Start and Manage Your Event Alone
- 1:56
- Viewed 104 times
-
Test Your Event with the Green Room
- 1:52
- Viewed 106 times
-
Plan and Launch a Town Hall
- 2:15
- Viewed 114 times
-
When and Why to Use Town Hall
- 1:38
- Viewed 119 times
-
Differentiate Between Meeting Types
- 1:38
- Viewed 108 times
-
Secure Teams Upon Creation
- 2:57
- Viewed 103 times
-
Apply a Specific Policy to a User
- 1:22
- Viewed 157 times
-
Send an Email to a Team
- 0:38
- Viewed 162 times
-
Analyze Team Dynamics
- 1:19
- Viewed 106 times
-
Create and Send Signatures with Dedicated Services
- 1:46
- Viewed 149 times
-
Create Approval Templates
- 2:06
- Viewed 155 times
-
Manage Document Approval
- 0:56
- Viewed 105 times
-
Make a New Approval Request
- 1:26
- Viewed 151 times
-
Use Templates for Document Creation
- 1:03
- Viewed 109 times
-
Manage Storage Spaces on Teams
- 2:05
- Viewed 106 times
-
Filter Your Document Display
- 1:10
- Viewed 103 times
-
Secure a Shared Document with a Password
- 1:28
- Viewed 111 times
-
Restrict a Document to Certain Team Members
- 1:50
- Viewed 107 times
-
Restrict a Document to Read-Only
- 0:58
- Viewed 106 times
-
Centralize Important Events in a Single Channel Calendar
- 0:42
- Viewed 112 times
-
Set Up Monitoring in a Channel with an RSS Feed
- 0:48
- Viewed 105 times
-
Add and Explore Workflows
- 1:35
- Viewed 107 times
-
Use Connectors to Receive Notifications
- 0:48
- Viewed 103 times
-
Manage Privacy in Private Channels
- 2:34
- Viewed 100 times
-
Integrate Klaxoon in a Teams Channel
- 0:40
- Viewed 106 times
-
Enable Klaxoon as an App in Teams
- 1:44
- Viewed 107 times
-
Understand and Secure Information Sharing in Instant Messaging
- 2:38
- Viewed 155 times
-
Use Commands and Keyboard Shortcuts
- 1:29
- Viewed 124 times
-
Customize the Display of the Function Panel
- 0:45
- Viewed 100 times
-
Manage Conversation Options
- 1:35
- Viewed 107 times
-
Use Viva Insights in Conversations
- 0:53
- Viewed 104 times
-
Schedule Message Delivery
- 0:58
- Viewed 145 times
-
Finding Help?
- 0:56
- Viewed 412 times
-
Chancing Your Status
- 0:40
- Viewed 450 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 397 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 457 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 390 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 623 times
-
File Management
- 1:04
- Viewed 412 times
-
Managing Teams and Channels
- 2:15
- Viewed 406 times
-
Posting in a Channel
- 2:15
- Viewed 434 times
-
Creating a Channel
- 2:05
- Viewed 379 times
-
Creating or Joining a Team
- 1:11
- Viewed 613 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 400 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 594 times
-
Starting a Conversation
- 0:53
- Viewed 428 times
-
Searching for Items or People
- 0:30
- Viewed 380 times
-
Interface Overview
- 1:10
- Viewed 457 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 456 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 430 times
-
Change application settings
- 2:53
- Viewed 440 times
-
Manage accessibility settings
- 1:33
- Viewed 645 times
-
Manage privacy settings
- 1:00
- Viewed 451 times
-
Set up and customize your teams
- 2:02
- Viewed 394 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 441 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 406 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 444 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 473 times
-
Generate a presence report
- 1:23
- Viewed 398 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 406 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 416 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 628 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 470 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 419 times
-
Following your activities and your team's activities
- 1:26
- Viewed 399 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 409 times
-
Manage team files
- 1:28
- Viewed 429 times
-
Invite external guests
- 1:19
- Viewed 448 times
-
Create private and shared channels
- 1:52
- Viewed 629 times
-
Manage your teams
- 2:38
- Viewed 460 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 622 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 410 times
-
Store files in conversations
- 1:38
- Viewed 386 times
-
Isolate a conversation window
- 0:50
- Viewed 419 times
-
Use and co-edit files
- 2:06
- Viewed 434 times
-
View events
- 2:21
- Viewed 573 times
-
Take notes in meetings
- 0:35
- Viewed 514 times
-
Manage a meeting
- 2:08
- Viewed 520 times
-
Start an instant meeting
- 1:33
- Viewed 586 times
-
Join a meeting as a participant
- 2:13
- Viewed 834 times
-
Automatically record a meeting
- 1:12
- Viewed 587 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 559 times
-
Share content in meetings
- 2:44
- Viewed 508 times
-
Use a background image during a video call
- 1:19
- Viewed 465 times
-
Schedule private or team meetings
- 2:17
- Viewed 626 times
-
Synchronize only one channel
- 0:56
- Viewed 653 times
-
Pin a channel to your favorites
- 1:04
- Viewed 588 times
-
Add channels and tabs
- 1:40
- Viewed 615 times
-
Interact in a conversation
- 2:03
- Viewed 441 times
-
Edit and enhance messages
- 1:57
- Viewed 821 times
-
Create a team using a template
- 1:03
- Viewed 779 times
-
Create a team and add members
- 1:37
- Viewed 705 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 741 times
-
Interact in conversations
- 1:30
- Viewed 619 times
-
Private and small group chats
- 2:03
- Viewed 528 times
-
Overview of conversations
- 1:02
- Viewed 590 times
-
Define your status message
- 2:13
- Viewed 899 times
-
Customize notifications
- 2:05
- Viewed 641 times
-
Edit photo in Teams
- 0:42
- Viewed 494 times
-
Find content and people
- 0:59
- Viewed 596 times
-
Presentation of the desktop application
- 2:16
- Viewed 481 times
-
Introduction to Teams
- 1:25
- Viewed 473 times