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
  • 679 views
00:00:09
Click on “Forecast Sheet”
00:00:14
Historical data are displayed to create a forecast sheet
00:00:19
Configure creation using the different options.
00:00:28
Then click on “Create”.
00:00:32
Excel then creates a new spreadsheet on which you can view future data
00:00:38
and statistics

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
In der Registerkarte "Daten"
00:00:09
Klicken Sie auf "Prognoseblatt"
00:00:14
Historische Daten werden angezeigt, um ein Prognoseblatt zu erstellen
00:00:19
Konfigurieren Sie die Erstellung mit den verschiedenen Optionen.
00:00:28
Klicken Sie dann auf "Erstellen".
00:00:32
Excel erstellt dann eine neue Kalkulationstabelle, auf der Sie zukünftige Daten anzeigen können
00:00:38
und Statistiken

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
En la pestaña "Datos",
00:00:09
Haga clic en "Hoja de pronóstico"
00:00:14
Los datos históricos se muestran para crear una hoja de previsión
00:00:19
Configure la creación con las diferentes opciones.
00:00:28
A continuación, haga clic en "Crear".
00:00:32
Excel luego crea una nueva hoja de cálculo en la que puede ver datos futuros
00:00:38
y las estadísticas

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
Na guia "dados",
00:00:09
Clique em "folha de previsão"
00:00:14
Os dados históricos são exibidos para criar uma folha de previsão
00:00:19
Configure a criação usando as diferentes opções.
00:00:28
Em seguida, clique em "criar".
00:00:32
O Excel, em seguida, cria uma nova planilha na qual você pode exibir dados futuros
00:00:38
e estatísticas

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
Op het tabblad "gegevens"
00:00:09
Klik op "prognose blad"
00:00:14
Historische gegevens worden weergegeven om een prognose blad te maken
00:00:19
Configureer het maken met de verschillende opties.
00:00:28
Klik dan op "Create".
00:00:32
Excel maakt vervolgens een nieuw werkblad waarop u toekomstige gegevens weergeven
00:00:38
en statistieken

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
Nella scheda "Dati",
00:00:09
Clicca su "Foglio Previsione"
00:00:14
Vengono visualizzati i dati cronologici per creare un foglio di previsione
00:00:19
Configurare la creazione utilizzando le diverse opzioni.
00:00:28
Quindi fare clic su "Crea".
00:00:32
Excel crea quindi un nuovo foglio di calcolo in cui è possibile visualizzare dati futuri
00:00:38
e statistiche

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
在"資料"選項卡中,
00:00:09
點擊"預測表"
00:00:14
顯示歷史資料以創建預測表
00:00:19
使用不同的選項配置創建。
00:00:28
然後按一下"創建"。
00:00:32
Excel 然後創建一個新的試算表,您可以在該試算表上查看未來資料
00:00:38
和統計

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
[データ] タブで、
00:00:09
「予測シート」をクリックしてください。
00:00:14
履歴データが表示され、予測シートが作成されます。
00:00:19
さまざまなオプションを使用して作成を構成します。
00:00:28
次に、「作成」をクリックします。
00:00:32
Excel は、将来のデータを表示できる新しいスプレッドシートを作成します。
00:00:38
と統計

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
Trong tab "dữ liệu",
00:00:09
Nhấp vào "bảng dự báo"
00:00:14
Dữ liệu lịch sử được hiển thị để tạo bảng dự báo
00:00:19
Cấu hình sáng tạo bằng cách sử dụng các tùy chọn khác nhau.
00:00:28
Sau đó bấm vào "tạo".
00:00:32
Excel sau đó tạo một bảng tính mới mà bạn có thể xem dữ liệu trong tương lai
00:00:38
và thống kê

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
Pada tab "data",
00:00:09
Klik pada "Forecast lembar"
00:00:14
Data historis ditampilkan untuk membuat lembar ramalan
00:00:19
Konfigurasikan pembuatan menggunakan opsi yang berbeda.
00:00:28
Kemudian klik pada "Create".
00:00:32
Excel kemudian membuat spreadsheet baru di mana Anda dapat melihat data di masa mendatang
00:00:38
dan Statistik

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
Во вкладке "Данные"
00:00:09
Нажмите на "Прогнозный лист"
00:00:14
Исторические данные отображаются для создания листа прогнозов
00:00:19
Настройте создание с использованием различных опций.
00:00:28
Затем нажмите на кнопку "Создать".
00:00:32
Затем Excel создает новую таблицу, на которой можно просматривать будущие данные
00:00:38
и статистика

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
В раздела "Данни"
00:00:09
Кликнете върху "Прогнозен лист"
00:00:14
Исторически данни се показват за създаване на прогнозен лист
00:00:19
Конфигуриране на създаване с помощта на различни опции.
00:00:28
След това кликнете върху "Създаване".
00:00:32
Excel създава нова електронна таблица, в която можете да преглеждате бъдещи данни
00:00:38
и статистика

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
În fila "Date",
00:00:09
Faceți clic pe "Foaie de prognoză"
00:00:14
Datele istorice sunt afișate pentru a crea o foaie de prognoză
00:00:19
Configurați crearea utilizând diferite opțiuni.
00:00:28
Apoi faceți clic pe "Creare".
00:00:32
Excel creează apoi o foaie de calcul nouă pe care puteți vizualiza date viitoare
00:00:38
și statistici

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
На вкладці "Дані"
00:00:09
Натисніть на "Прогноз аркуша"
00:00:14
Історичні дані відображаються для створення аркуша прогнозу
00:00:19
Налаштувати створення за допомогою різних параметрів.
00:00:28
Потім натисніть на кнопку "Створити".
00:00:32
Після цього програма Excel створить нову електронну таблицю, на якій можна переглядати майбутні дані
00:00:38
та статистики

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
W zakładce "Dane"
00:00:09
Kliknij na "Arkusz prognozy"
00:00:14
Dane historyczne są wyświetlane w celu utworzenia arkusza prognozy
00:00:19
Skonfiguruj tworzenie przy użyciu różnych opcji.
00:00:28
Następnie kliknij "Utwórz".
00:00:32
Następnie program Excel tworzy nowy arkusz kalkulacyjny, na którym można wyświetlać przyszłe dane
00:00:38
i statystyki

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
"Veri" sekmesinde,
00:00:09
"Tahmin Sayfası"na tıklayın
00:00:14
Bir tahmin sayfası oluşturmak için geçmiş veriler görüntülenir
00:00:19
Farklı seçenekleri kullanarak oluşturmayı yapılandırın.
00:00:28
Ardından "Oluştur"a tıklayın.
00:00:32
Excel daha sonra gelecekteki verileri görüntüleyebileceğiniz yeni bir elektronik tablo oluşturur
00:00:38
ve istatistik

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
No separador "Dados",
00:00:09
Clique em "Folha de Previsão"
00:00:14
Os dados históricos são apresentados para criar uma folha de previsão
00:00:19
Configurar a criação usando as diferentes opções.
00:00:28
Em seguida, clique em "Criar".
00:00:32
O Excel cria então uma nova folha de cálculo na qual pode ver dados futuros
00:00:38
e estatísticas

No elements match your search in this video....
Do another search or back to content !

 

00:00:05
Na kartici "Podaci"
00:00:09
Kliknite na dugme "List sa predviđanjima"
00:00:14
Istorijski podaci se prikazuju da bi se kreirao list sa predviđanjima
00:00:19
Konfigurišite kreiranje pomoću različitih opcija.
00:00:28
Zatim kliknite na dugme "Kreiraj".
00:00:32
Excel zatim kreira novu unakrsnu tabelu na kojoj možete da prikažete buduće podatke
00:00:38
i statistika

No elements match your search in this video....
Do another search or back to content !

 

00:00:09
انقر على "ورقة التنبؤ"
00:00:14
يتم عرض البيانات التاريخية لإنشاء ورقة تنبؤ
00:00:19
تكوين الإنشاء باستخدام خيارات مختلفة.
00:00:28
ثم انقر على "إنشاء".
00:00:32
Excel ثم إنشاء جدول بيانات جديد يمكنك عرض البيانات المستقبلية
00:00:38
والإحصاءات

No elements match your search in this video....
Do another search or back to content !

 

00:00:09
"예측 시트"를 클릭합니다.
00:00:14
예측 시트를 만들 도록 기록 데이터가 표시됩니다.
00:00:19
다른 옵션을 사용하여 생성을 구성합니다.
00:00:28
그런 다음 "만들기"를 클릭합니다.
00:00:32
그런 다음 Excel에서 향후 데이터를 볼 수 있는 새 스프레드시트를 만듭니다.
00:00:38
및 통계

No elements match your search in this video....
Do another search or back to content !

 

00:00:09
点击"预测表"
00:00:14
显示历史数据以创建预测表
00:00:19
使用不同的选项配置创建。
00:00:28
然后点击"创建"。
00:00:32
然后,Excel 会创建一个新的电子表格,您可以在其中查看将来的数据
00:00:38
和统计

No elements match your search in this video....
Do another search or back to content !

 

00:00:09
คลิกที่ "ใบคาดการณ์"
00:00:14
ข้อมูลในอดีตจะแสดงขึ้นเพื่อสร้างแผ่นงานการคาดการณ์
00:00:19
ตั้งค่าคอนฟิกการสร้างโดยใช้ตัวเลือกต่างๆ
00:00:28
จากนั้นคลิกที่ "สร้าง"
00:00:32
จากนั้น Excel จะสร้างสเปรดชีตใหม่ซึ่งคุณสามารถดูข้อมูลในอนาคตได้
00:00:38
และสถิติ

No elements match your search in this video....
Do another search or back to content !

 

DiLeaP AI: THIS MIGHT BE HELPFUL

Reminder

Show