training in excel - Template

Resolved · Low Priority · Version Standard

Thu 4 Oct 2007, 15:58 Delegate Siqing said...

Siqing has attended:
Excel Intermediate course

Template

how to find a saved template?

Fri 5 Oct 2007, 11:16 Trainer Amanda said...

RE: template

Hi Siqing

Thank you for your question.

If you save your templates into the Templates folder when you create it, then you can find it by going to File - New then click the General Templates link in the task pane (on the right of your screen) and you will find your template on the General Solutions tab.

If you have saved the template elsewhere you will need to remember where you have saved it to!

Amanda

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

training in excel - Template

Template

RE: template

Excel articles

Excel tip:

Generating Random Numbers