The word itself suggests two variables involved in this data table… With just a couple of clicks (or a single keyboard shortcut), you can convert your flat data into a data table … How to Create a Two-Variable Data Table in Excel? Excel Tables. We’ve had Excel tables since Excel 2007.. They’re perfect data containers and can be used as a simple data entry form. Also watch a video on creating a table in Excel.. It’s one of the available What-If analysis tools in Excel, together with the ‘Scenarios’ and ‘ Goal Seek ’ tools. A data table is an Excel tool you can use to test different scenarios. In this article, you’ll learn what a data table … Two-variable data table helps us to analyze how the combination of two different variables impact on the overall data table. Creating a table is easy. Data tables are used in Excel Excel Resources Learn Excel online with 100's of free Excel tutorials, resources, guides & cheat sheets! CFI's resources are the best way to learn Excel … Select the range of data … What are Data Tables? Working efficiently with your table data. Tables might be the best feature in Excel that you aren't yet using.It's quick to create a table in Excel.