Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+xp+training - Analysis Tools

excel+xp+training - Analysis Tools

ResolvedVersion Standard

Fri 27 Apr 2007, 09:44 Delegate Peter said...

Peter has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Analysis Tools

What can the anaylsis tool show me when analysing large amounts of data?

Mon 30 Apr 2007, 09:31 Trainer David said...

RE: Analysis Tools

Peter

there are various specialist analysis tools in the add in pak, these will take data and randomise numbers etc that could be applied to market survey samples or other survey outcomes as might be required.

for further information look at the help files for the individual tools and see if there are any uses for your own particular role.

hope this answers your question

regards

david

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

excel+xp+training - Analysis Tools

Analysis Tools

RE: Analysis Tools

Excel articles

Excel tip:

Autofit column width – Excel (all versions)