The Open Door Web Site

Biology
 

 

ICT IN BIOLOGY

USING EXCEL AS A DATA BASE CONTINUED

DATABASE OF FEMALE REPRODUCTIVE HORMONES

Using the Custom option

This is very useful if you want to compare results, for example those of volunteer 3 and volunteer 7.
Return to the complete database. Click on the arrow in A1 and select Custom. A pop-up window will appear.

Enter to information as shown below

And OK

You have now filtered the information from volunteers 3 and 7 only.

Now go to cell B1 and click on the arrow
Select day 8

You can now compare the results from day 8 from the two volunteers selected.

Notice that two arrows in line 1 are now coloured (in this case, blue). This means that you have to click on both arrows, selecting ALL in each case, to return to the complete database.

> ICT in Biology

ICT in Biology Index


This Site was last
updated on 06/11/07
© The Open Door Team
Any questions or problems regarding this site should be addressed to
the webmaster

© Paul Billiet and Shirley Burchill 2007