Two-Way Data Tables with What-if Analysis Tools in Excel

Watch Video

In this video, we will use two-way data tables to explore uncertain demand. We will also introduce some new and useful Excel functions.

Two-way data tables (also called two-variable data tables) let you see how two different inputs jointly affect a single output.

Timestamps :

00:00 - Scenario
04:03 - Preparing Modal
07:23 - VLOOKUP with Sorted Range
11:50 - Creating Two Way Data Table With What If Analysis
15:35 - Conditional Formatting Of Profit

Download Data Files

Click below to download data files used in this video.

Download
Free

Business Analytics and Decision Making With Excel Playlist

URL- https://www.youtube.com/playlist?list=PLEgGrg5FcCZgs_ur_gOsfcHm6BjdxLc7A