The Open Door Web Site
Using MS Excel as a Database
ICT in Biology Index
ICT IN BIOLOGY
Using MS Excel 2013 as a Database
Preparing your database.
Open the file and save it onto your computer's desktop. Open MSDATA.xls from your desktop.
Remove any empty dividing lines between volunteers (for example, line 29 and line 30).
Select the line(s), right click and select delete.
Return to line 1 of the database and highlight cells A to H
Go to Data and Filter
Small downward-pointing arrows will appear to the right in cells A to H in line 1
Sort Smallest to Largest (Ascending)
Go to A1 Volunteer, click on the arrow and select 3
You have now filtered all of the information concerning volunteer number 3.
Notice that the arrow in A1 has changed to a small filter icon. This indicates to you that a filter has been used in this column.
You should also notice that the number of filtered entries is indicated in the left had corner of the Excel window. In this example "33 of 579 records found".
To return to the complete database, click on the filter icon (in this case in A1) and Select All.
The Open Door Web Site is non-profit making. Your donations help towards the cost of maintaining this free service on-line.
Donate to the Open Door Web Site using PayPal