Introduction To MS Excel tutorial
Chapter 1: MS Excel Basics

Chapter 2: Editing Worksheet In Excel

Chapter 3: Formatting Cells

Chapter 4: Formatting Worksheets

Chapter 5: Working With Formulas

Chapter 6: Advanced Operations

How To Create Data Tables In MS Excel 2010

Data Table in Excel offers a unique way to see different results by altering the input cell in the formula. In order to use Data Table, go to the Data Tab followed by What-If Analysis dropdown and finally Data Table.

Data Table with Example

For example, if you have price and quantity as many values in the worksheet along with discount as third variable for calculating Net Price, make use of the Data Table to see varying results by making changes in the price.

MS Excel tutorial

In order to apply Data Table, first select the range of table data, then follow earlier-mentioned steps. A dialog box will appear on the screen asking for Input row and Input Colum. Now, Input Row as Price cell and Input Column as Quantity cell.

MS Excel tutorial

Once it’s done, click on OK and Excel will generate a data table like below image.

MS Excel tutorial

Tags

You may also like...

Sorry - Comments are closed

Australia

Unknown
Humidity: 65
Wind: 9 km/h
71 F
65 93
25 Mar 2016
63 87
26 Mar 2016

Slideshow