Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Forecasting Tools for Data Analysts

Simon Sez IT via YouTube

Start learning Write review
Boot.dev Ad

The Most Addictive Python and SQL Courses

Learn More → Corporate Finance Institute Ad

35% Off Finance Skills That Get You Hired - Code CFI35

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
This 19-minute tutorial from Simon Sez IT explores essential Excel forecasting tools designed specifically for data analysts. Master four powerful Excel features: begin with Forecast Sheet to automatically predict trends based on historical data, then learn Goal Seek to reverse-engineer solutions for specific targets. Explore the Scenario Manager to create, compare, and analyze multiple business scenarios, and finally discover how to transform scenario data into dynamic PivotTable reports for enhanced decision-making. The video includes convenient timestamps for easy navigation between sections: Forecast Sheet (00:00), Goal Seek (06:03), Scenario Manager Summary (09:35), and Scenario Manager PivotTable Report (17:20). Perfect for analysts looking to enhance their Excel forecasting capabilities and make more data-driven decisions.

Syllabus

00:00:00 - Forecast Sheet
00:06:03 - Goal Seek
00:09:35 - Scenario Manager Summary
00:17:20 - Scenario Manager PivotTable Report

Taught by

Simon Sez IT

Reviews

Start your review of Excel Forecasting Tools for Data Analysts

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.