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
  • 1682 views
résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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 !

 

résultat(s)
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

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Advanced level

With our "advanced" tutorials, discover and master the full potential of Excel, using complex functions, macros and the power of DCTs and Power Pivot, combined with the Power Query tool.

  • Your trainer for this course
  • Cours E-learning
  • 1844 Views
ALL COURSES

Reminder

Show

/

Join Live Training Session