Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...

In this KS1 Maths article you'll learn how to read data tables and tally charts. We also have KS1 videos, a quiz and lots of examples.

To build the demonstration PivotTable using the data set in Figure A, do the following: Click anywhere inside the data set and then click the Insert tab. In the Tables group, click PivotTable.