Excel Data Table​

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

Download Excel

for Practice

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.

Want to receive weekly insights  tips & tricks

then register here

PrabasTech Welcome you.
Would you like to join a course?