Excel Data Table
Using Data Table in Excel, you can easily get one or two inputs and perform What-if analysis from the Forecast Group under the Data Tab.
A Data Table gives us the desired or projected outputs based on the given inputs. The given inputs can be a single variable or it can be a multiple variables. In this video tutorial, we are going to learn a simple usage of Data Table using the following concepts:
- One-variable Data Tables
- Two-variable Data Tables
If you watch and understand the entire tutorial along with practice, it is a great time saver in such scenarios.
I hope you understood and practiced the entire concept. Thanks for your time for reading this article.