Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training seminar - Table array

excel training seminar - Table array

ResolvedVersion Standard

Fri 21 Sep 2007, 16:22 Delegate Matthew said...

Matthew has attended:
Excel Advanced course

Table array

can anyone explain difference between the 1 and 2 way tables?

Tue 25 Sep 2007, 16:10 Trainer Anthony said...

RE: table array

Hi Matthew. Essentially, a one-way table has one input value which you change which then impacts on the value in any number of other cells. One the other hand, a two-way table involves changing values in two cells and those combining through a formula to provide one value. There are some interesting examples in this document:

http://www.doc.gold.ac.uk/ ~mas01rmz/331/Labs/lab1.doc

Hope this helps,

Anthony

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

excel training seminar - Table array

Table array

RE: table array

Excel articles

Excel tip:

Manually rotating a 3D chart