Calculating-Spreadsheet-Databases
Created with Microsoft Excel
by David Alderoty © 2012
This website provides 20 databases,
with various types of calculation mechanisms,
which were created with Microsoft Excel.
The databases are provided without charge,
for you to enter and store your own data.
To contact the author (David Alderoty) use this
e mail address: David@TechForText.com, or left click
on the link below for a website communication form.
Link for a Website Communication Form
This website has a hyperlinked table of contents, on the very bottom of this webpage.
If you want to go directly to the table of contents left click on these words.
GENERAL CONCEPTS AND INSTRUCTIONS
The databases on this website do not contain any data. They were designed for users to download, and enter their own data. All of the databases provided by this website were created with Microsoft Excel, and they all have some type of calculation mechanism. The calculation functionality differs with each database, and it ranges from simple devices that count the number of entries in the database, to multiple sets of statistical calculations. The databases are listed in the following paragraphs, with download links, in categories that relate to their utility, which are as follows:
Databases For Multiple Lines Of Text,(Databases 1 to 6)
Statistical Databases (Databases 7 to 15)
Hyperlink-Databases (Databases 16 to 20)
The databases contain anywhere from one to six columns, and they all have the Microsoft Excel alphabetizing and search mechanism on the top of each column. In addition, Excel’s general-purpose search device (Find) can be used with these databases, which is especially useful if you want to search all of the columns simultaneously. (This search device (Find) can be opened, by pressing the F key, WHILE HOLDING DOWN THE CTRL KEY.)
General Instructions to Use The Databases
The databases on this website are easy to use. To use a database from this website, left click with the mouse on the cell where you want to enter your data, and then immediately type the words or numbers into the cell. To alphabetize your data, left click on the right side of a black box above each column, and Microsoft Excel’s alphabetizing mechanism will open, with a menu. (See the screenshot below.) Then, you can click on the option you prefer for alphabetizing, which are from A to Z, or Z. to A. Excel’s alphabetizing mechanism has a number of other features to help you search your database.
The screenshot above, with the yellow type, shows the precise section to left click on to open the alphabetizing mechanism. Each of the databases has one or more black boxes with yellow type, similar to this screenshot. The words in yellow type should be deleted and replaced, with column headings that you find useful for your needs. Examples of typical column headings are NAMES, ADDRESSES, PHONE and TEST SCORES.
Important Note About the Downloads
All of the databases from this website are free of charge, and they require Microsoft Windows, and Excel, and they are obtainable by clicking on download links. The databases from this website are in the Microsoft Excel template format, and they are available in two versions, which are for Microsoft Excel 2003, and for Excel 2007-2010. When you download any of the databases, they will be in a zipped folder, which will contain both versions, and they are marked accordingly, directly on the file icon, such as the following examples:
1)2003-OneColumnText1.xlt
1)2010-OneColumnText1.xltx
2)2003-TwoColumnText.xlt
2)2010Two-ColumnText.xltx
3)2003-3ColumnText.xlt
3)2010-3ColumnText.xltx
4)2003-4ColumnText.xlt
4)2010-4ColumnText.xltx
You must remove the databases from the zipped folder, before you use them. However, with most computers, you can open the file from the zipped folder, by clicking on the icon, but you must save the file in a different location on your computer, with the new filename. If the file does not open remove it from the zipped folder, with the windows cut and paste mechanism.
DATABASES FOR MULTIPLE LINES OF TEXT
Description of Databases for Text
The following six databases are designed for records that involve multiple lines of text. The capacity varies with each of the databases, and it ranges from approximately 70 to 300 words a text in one cell. However, you can go beyond this point, and enter over 1000 words in one cell, but to see all of the text you will have to left click on the cell, with the mouse. When a large amount of text is entered in a cell, you can scroll up or down within the cell using the arrow keys. The mouse will not function for this purpose.
All of the following databases have a device that counts the number of cells that have text, and the number of cells that are unoccupied. They also have a function that displays the time and date, on the top section. They all have 500 rows, and thus are suitable for 500 records.
With the databases in THIS SECTION, you can CHANGE all of the following, with the conventional Microsoft Excel controls: font face; font color; font size; background colors of cells; and align text to the left, right, or center. This cannot be done with the other databases from this website.
Note, with all of the databases in this section, if you want Microsoft Excel's alphabetizing mechanism to work effectively, you must enter a name or other keyword, before entering any other text in a cell. This is usually important in the first column. However, it may be less important in the other columns, if you are not planning to use the alphabetizing mechanism with these columns.
1) One-Column Database, for Multiple Lines of Text
This database has only one column, and one cell for each record, but each cell can contain over 300 words. This device should be especially useful for various types of notes. Left click on these words to download this one column database.
2) Two-Column Database, for Multiple Lines of Text
This database has two columns, and two boxes for each record, but each box can hold over 150 words. This device should be especially useful for various types of notes. Left click on these words to download this two column database.
3) Three Column Database, for Multiple Lines of Text
This database has three columns, and three cells for each record, and each cell can hold over 100 words. This device should be especially useful for various types of record-keeping that involve multiple lines of text. Left click on these words to download this three column database.
4) Four-Column Database, for Multiple Lines of Text
This database has four columns, and four boxes for each record, and each can hold over 100 words. To see all four columns it may be necessary to scroll from left to right, unless you have a very wide screen. This device should be especially useful when detailed information involving multiple lines of text, must be stored in a database. Left click on these words to download this four column database.
5) Five-Column Database, for Multiple Lines of Text
This database has five columns, and five cells for each record, which can hold over 150 words per cell. To see all five columns it is necessary to scroll from left to right. This can be done with the right arrow key, or with the mouse. This device should be especially useful when detailed information involving multiple lines of text, must be stored in a database. Left click on these words to download this five column database.
6) Six-Column Database, for Multiple Lines of Text
This database has six columns, and it has six cells for each record, which can hold over 180 words per cell. To see all six columns it is necessary to scroll from left to right. This can be done with the right arrow key, or with the mouse. This database should be especially useful when detailed information, involving multiple lines of text, must be stored in a database. Left click on these words to download this six column database.
General Description of the Statistical Databases
The following nine databases have calculation mechanisms for one or more statistical calculations. All of the following databases have a device that counts the number of cells that have data, and the number of cells that are unoccupied. They also have a function that displays the time and date, on the top section. They all have 500 rows, and thus are suitable for 500 records, except for database 15, which has 40 rows. The number of columns varies with each database.
All of the databases in this section have a special feature that automatically rounds calculated results to the number of decimal places set by the user. Specifically, there is an input box, on the upper section of the database, which shows the number of decimal places that will be displayed in the calculated results. This number can be changed by the user, to provide the preferred number of decimal places in the calculations.
7) A Database, with a Mechanism for Calculating the Average of a Set of Numbers
7) A Database, with a Mechanism for
Calculating the Average of a Set of Numbers
This database has a device that calculates the average, when a set of numbers (such as test scores) are entered in the right column. Enter the name, or a descriptive phrase, associated with each number, in the left column. The calculated results are presented on top of the database in red type. Left click on these words to download this statistical database.
8) A Database, with a Device for Calculating the Geometric Mean, of a Set of Numbers
8) A Database, with a Device for Calculating
the Geometric Mean, of a Set of Numbers
This database has a mechanism for calculating the Geometric Mean, of a set of numbers. To use this database, enter numbers in the right column. In the left column, enter a name or a descriptive phrase, associated with each number, you entered. The calculated results are presented on top of the database in red type. Left click on these words to download this statistical database, (for the geometric mean).
9) A Database with a Mechanism for calculating the
Average, and Standard Deviation of a Set of Numbers
This database has a device that calculates the average, and the Standard Deviation (based on a sample), when a set of numbers are entered in the right column. Enter the name, or a descriptive phrase, associated with each number, in the left column. The calculated results are presented on top of the database in red type. Left click on these words to download this statistical database, (for the average and standard deviation).
10) A Database with a Mechanism for Calculating the Correlation Coefficient of Two Sets of Numbers
10) A Database with a Mechanism for Calculating
the Correlation Coefficient of Two Sets of Numbers
This is a database with three columns, and it has a device for calculating the correlation coefficient when two sets of numbers are entered, in the second and third columns. The first column is for entering descriptive text that relate to the numbers. The first three rows, of the second and third columns, must contain numbers to get a calculated result. Left click on these words to download this statistical database (for calculating correlation coefficients).
11) A Database, with a Mechanism to Calculate
the Average, and the Standard Deviation
Based on a Sample, and the Entire Population.
This is a two column database, with a mechanism for calculating the average, and the Standard Deviation, based on a sample, and also based on the entire population. The calculation mechanism also displays the highest and smallest numbers entered, the difference between the largest and smallest numbers, and the average of the largest and smallest numbers.
With this database a set of numbers are entered in the right column, and the first two rows must contain numbers for this device to calculate the standard deviation. Names, or descriptive phrases, that relate to the numbers are entered in the left column. The calculated results are presented on top of the database in red type. Left click on these words to download this statistical database (for the average and standard deviation).
12) A Database with a Mechanism for Calculating Ten Statistical Calculations Simultaneously
12) A Database with a Mechanism for Calculating
Ten Statistical Calculations Simultaneously
This is a two column database, with a mechanism that calculates ten results simultaneously, when a set of numbers (such as test scores) are entered in the right column. Enter the name, or a descriptive phrase, associated with each number, in the left column. Left click on these words to download this statistical database, which performs all the calculations listed below.
1) The Average
2) The Standard Deviation (based on a sample)
3)The Standard Deviation (based on entire population)
4) The highest number on the list
5) The smallest number on the list
THE FOLLOWING ARE NONSTANDARD (OR EXPERIMENTAL) CALCULATIONS
6) The difference between largest and smallest number entered
7) The average based only on the largest and smallest numbers entered
8) The average of the largest and smallest number, DIVIDED by the average of all the numbers entered
9) The average of all the numbers entered, DIVIDED by the average of the largest and smallest numbers
10) The RECIPROCAL of Standard Deviation (based on entire population)
13) A Database, with a Mechanism for Carrying Out
Five Calculations for Each Number Entered, and for
Computing the Average and Standard Deviation
This database calculates the average and the standard deviation, but it has a calculation mechanism that is different than the other devices listed above. Specifically, it calculates a set of five components that relate to each score that was entered, which are displayed in five column list, on the right side of the database. For more details about the calculations performed by this database, scroll down, and read the following paragraphs. Left click on these words to download this statistical database, which performs all of the calculations listed below.
In COLUMN D, of DATABASE 13, each score entered, is divided by the sum of all the scores in the database. These results are multiplied by 100 to convert them to percentages, as illustrated in the following formula:
|
|
With this formula all the calculated results will be less than 100%. The sum of all the calculated results relate to the entire group, which is always 100%. This type of calculation can be useful when scores are used, with related calculations, to determine the contribution of each individual in a workgroup to the completed project, such as for financial compensation. The following is an example of calculations with this formula. The scores used for this example are presented on the left side of the table presented below:
NOTE: I am using the same scores (100, 50, 49, 48) as examples, for all of the following, which will illustrate the great differences between each formula.
In COLUMN E, of DATABASE 13, each score entered, is divided by the highest score in the database. These results are multiplied by 100 to convert them to percentages, as illustrated in the following formula:
|
|
With this formula the highest score is always 100%, and all the other scores are less than 100%. That is all the scores are compared with the highest score with this formula, which is illustrated with the following calculated results:
In COLUMN F, of DATABASE 13 each score entered, is divided by the average score. The average score is based on all the scores entered in the database. These results are multiplied by 100 to convert them to percentages, as illustrated in the following formula:
|
|
With this formula scores that are below average will be LESS than 100%, and scores that are above average will be GREATER than 100%. With this formula the average is mathematically defined as 100%. (This is somewhat similar to the way IQ tests are scored, where the average score is 100, scores less than 100 are below average, and scores greater than 100 are above average.)
The average Score is 61.75
In COLUMN G, of DATABASE 13, the calculations are performed with a Microsoft Excel function, called: PERCENTRANK, which calculates the rank in percentages, of all the scores in the database. With this function the highest is always 100% and the lowest score is always 0%. There are some practical limitations to the utility of this function. For example, if one student in a class achieved 100% on a test, and everyone else in the class obtained 99%, this function would designate 100% for the highest score, and all the other students would receive a zero.
In COLUMN H, of DATABASE 13 the calculations are performed with a Microsoft Excel function, called: RANK. This function is different than the above, in that it only assigns numbers to the scores based on magnitude. The highest score is ranked 1, the second-highest score is ranked 2, and the third is ranked 3, etc. (Incidentally, this sequence can be reversed, by placing 1 within the function itself. When this is done, the lowest score would be defined as 1, the next lowest would be 2, etc.) The following example, illustrates the way the function calculates in database 13.
Databases 14 and 15 Are Modifications of the
Above with a Better Layout, and without the
Excel Function Percentrank and Rank
Databases 14 and 15 are two column databases that have a mechanism for calculating the average, and three additional calculations are performed on each number that is entered. The calculated result for the average is presented on the top of the databases, and the other calculations are presented in three columns on the right side of the databases.
To download DATABASE 14 left click on these words.
To download DATABASE 15 left click on these words
If you want to see an online version of database 15
left click on these words, or go to:
www.TechForText.com/Online-Table-for-Calculating-the-Average
Note the online version does not have
an alphabetizing or search function.
Information about the calculations in columns D, E and F of databases 14 and 15 is presented below. This involves the exact same formulas and examples that were presented for database 13.
For DATABASE 14 and 15, the calculations in column D, are the individual score, divided by the sum of all the scores. This is multiplied by 100 to display the results as a percentage. See the formula below:
|
|
The following chart shows examples of
calculated results obtained with this formula
For DATABASE 14 and 15, the calculations in column E, are the individual score, divided by the highest score. This is multiplied by 100 to display the results as a percentage. See the formula below:
|
|
The following chart shows examples of
calculated results obtained with this formula.
For DATABASE 14 and 15, the calculations in column F, are the individual score, divided by the average score. This is multiplied by 100 to display the results as a percentage. See the formula below:
|
|
The following chart shows examples of
Calculated results obtained with this formula.
(The average score is 61.75)
HYPERLINK-DATABASES: A VERY USEFUL CONCEPT
FOR STORING DIGITAL MEDIA AND HUGE
QUANTITIES OF INFORMATION
General Concepts and Utility of Hyperlink Databases
General Concepts and
Utility of Hyperlink Databases
The following databases are designed to store hyperlinks to external documents, files, and websites, along with related information that relate to the linked material. However, even conventional databases and worksheets created with Microsoft Excel, have this hyperlink functionality, if it was not disabled when the Excel device was created. This functionality can be quite valuable, if it is used as described in the following paragraphs.
Databases with hyperlinks, eliminates a problem that is frequently encountered with conventional databases, which is simply a limited amount of space to enter data. Examples where this can be a difficulty is with records involving medical treatment, student performance, and the work history of employees. Records of this nature, can involve dozens or even hundreds of pages of information gathered over a period of many years. Entering, such huge quantities of information directly into conventional databases might not be feasible, especially if it was created with spreadsheet software.
The problem discussed above is eliminated with the databases and instructions presented in this section, because you can create hyperlinks to external documents. This generally involves, at least one external document, and a related hyperlink, for each record stored in the database. With these databases you can easily access detailed information, by searching for the record you need with the Excel search functions, and then clicking on the hyperlink IN THE RECORD to open the external document. When this is done, you can also delete or add additional information into the external document. With this technique, each record has its own external document(s), which are not linked to any other records in the database.
Conventional word processor documents can easily be used with the technique described above. One of the best examples is Microsoft Word, which has its own search function, and also provides the functionality for storing photographs, sketches, diagrams, mathematical notation, as well as conventional text. However, other types of documents can also be used for this purpose, such as PowerPoint, or even an Excel spreadsheet.
Linking database records to individual spreadsheets is a useful way of creating a database for expense accounts, (when a company has a large number of employees with expense accounts.) This provides the functionality needed to keep track of each purchase made by an employee, and for calculating the monthly expenses of each individual with an expense account. A similar database can also be created to keep track of the sales performance of individual employees. This can involve external spreadsheets linked to the records of each employee in a database, to precisely calculate sales performance in dollars.
The databases with hyperlinks have many other uses besides the above. They are useful for storing and accessing any type of digital media, including websites, e‑books, videos, music, and sound recordings. This is more efficient than conventional ways of storing media, which may involve serial numbers or titles use to access the media manually. (An example of this is the Dewey Decimal System, used to store and find books in a library.) With the hyperlink database, you just search for what you want with the built-in function, and when you find a relevant record, you just left click on a hyperlink, to open an e-book, a video or sound recording. It does not even make any difference if the document, e‑books, video, music, or sound recording is on your computer's hard drive, or somewhere on the Internet. The hyperlink databases can be especially useful for storing links to access websites that you find especially useful, interesting, or entertaining.
Another use for databases with hyperlinks is for opening software, documents, or any file on your computer. This can involve a two column database, with descriptive phrases describing the software, documents or files, in one column, with the adjoining column used to store the hyperlinks needed to open the software. This can be a very useful way of organizing the documents and software you have on your computer, because you can alphabetize everything you have listed in the database with a few clicks of the mouse. You also can use the Microsoft Excel search function to find any documents or software you have listed in the database.
A Brief Note on Hyperlink Functionality
for Individuals that Create Their Own
Excel Spreadsheets and Databases
The hyperlink functionality in Microsoft Excel can be inadvertently disabled, when an Excel worksheet or database is protected with the mechanism built into the software. However, if an Excel worksheet or database is not protected, the hyperlink functionality is enabled by default, but it there are any formulas involved, they will most likely be accidentally destroyed, sooner or later, if the Excel device is not protected. To protect a database or worksheet created with Excel, and maintain the hyperlink functionality place a checkmark in the Protect Sheet dialog box, next to the words Insert Hyperlinks. A screenshot of this dialog box is presented below, with the required checkmark, which is highlighted in blue.
Keep in mind that the above note is not relevant for the practical use of the databases presented in this section, because I created them with the hyperlink functionality enabled, but they are protected to prevent the accidental destruction of the formulas they contain.
All of the above raises the question, how do you create hyperlinks in databases that are created with Microsoft Excel. This is explained in detail, in the following paragraphs.
How to Create Hyperlinks to Websites, Videos, and Other Files on the Internet, in a Database Created With Excel
How To Create Hyperlinks to Websites, Videos,
And Other Files on the Internet, in
A Database Created With Excel
It is relatively easy to create hyperlinks to websites and videos on the Internet, in the databases presented below, and in any Excel worksheet that has the hyperlink functionality enabled. To create the hyperlink, you simply type the URL directly into the cell where you want to place the link. Then, press the enter key, or left click with the mouse outside of the cell. When this is done, the URL will turn blue, indicating that the hyperlink was successfully created.
A Method Similar to the Above for Creating Hyperlinks to Files on Your Computer
A Method Similar to the Above for Creating
Hyperlinks to Files on Your Computer
A method similar to the above, can also be used to create hyperlinks to files on your computer, including documents, software applications, and videos. However, you must know the exact location of the file, and the syntax is a little more complicated than the above. See the following example:
file:///C:\Users\RunDavid\Desktop\Word.docx
As shown with the above example, you must indicate that the hyperlink is for a file, with file:///. This syntax might differ with various operating systems and even with different versions of Windows and Microsoft Excel. I tested it with Windows 7, 64 bit version, and Microsoft Excel 2010.
NOTE: Both of the techniques discussed above, (for creating Internet links, and for linking to files on your computer) works equally well in a number of applications, including Microsoft Word, PowerPoint, OneNote, OpenOffice Write, and OpenOffice Calc. However, there are other methods of creating hyperlinks discussed below.
Microsoft Excel's Hyperlink Function
Another technique of creating hyperlinks is to use Microsoft Excel's hyperlink function, which is a spreadsheet formula that is entered into a cell: =HYPERLINK(). When creating links to websites and files on the Internet, with this formula, it is necessary to enter http://, and the entire URL must be in quotation marks, as illustrated below:
=HYPERLINK("http://www.David100.com")
With this formula =HYPERLINK(),You can conceal the URL, and enter a word or phrase for the hyperlink, as shown below:
=HYPERLINK("http://www.David100.com", "David")
With the above example, the hyperlink, would appear as David
Microsoft Excel's hyperlink function can also be used for accessing and opening any file, on your computer, including documents, and computer programs. However, you must know the exact location of the file. This is illustrated with the following example:
=HYPERLINK("C:\Users\RunDavid\Desktop\Word.docx")
You can also use a word or phrase for the hyperlink, for any file on your computer, which is identical to the technique described above for a website. This is illustrated below with a hypothetical Word document:
=HYPERLINK("C:\Users\RunDavid\Desktop\Word.docx", "Notes") With this example, the hyperlink would look like the following: Notes
One of The Easiest Methods: Microsoft Excel’s Insert Hyperlink Dialog Box
One of the Easiest Methods:
Microsoft Excel’s Insert Hyperlink Dialog Box
One of the best devices for creating hyperlinks is Microsoft Excel’s Hyperlink Dialog box. With this device, you do NOT have to know the exact location of the file you want to link to, in terms of syntax. To create links to documents, files, and software on your computer, follow the steps listed below:
First click on the cell where you want to place the hyperlink, and then type a word or short phrase into the cell. Then immediately, press the k key WHILE HOLDING DOWN THE Ctrl key. When this is done, the dialog box presented below will open. Then, search for the document, or software, or other file you want to link to, using the slider on the right. When you find the file you want, left click on it with the mouse. After this, left click on the OK button, on the lower right of the dialog box. When this is completed, the dialog box automatically closes, and you should have a functioning hyperlink.
The above dialog box, can be used to link to specific cells or sections in a worksheet, or to link to any website or file On the Internet.
Demonstrating the utility of a Hyperlinked Database, with a functioning example with over 70 links
Demonstrating the utility of a Hyperlinked Database,
with a functioning example with over 70 links
To demonstrate the functionality of a hyperlinked database, and the related concepts discussed above, I created a database with a number of hyperlinks to websites, PDF files, and videos on the Internet. This database also has links to some of the downloadable zipped folders from this website.
When you left click on a hyperlink, especially if it is in a database, it may take anywhere from 2 seconds to 20 seconds before the website or file opens. If the file is large, and it involves downloading from the Internet, it can take several minutes or longer, before the file is downloaded. However, this does not apply to the following database, because all of the downloadable files are small.
You can download this database by left clicking on one of the following links:
If you want the database for Microsoft
Excel 2010 left click on these words.
If you want the database for Microsoft
Excel 2003 left click on these words.
If you want to download both versions of this
database, (Excel 2003 for Excel 2007- 2010)
in a zipped folder, left click on these words.
Download Links For The Hyperlink Databases,
which Are Designed for You to Enter
In the following paragraphs, there are download links for the Hyperlink Databases. All of these databases can handle up to 500 records, but the number of columns varies with each database. On top of the databases there is a mechanism that displays the time and date, which is followed by the instructions. These databases have a mechanism that counts the number of occupied and unoccupied cells in a column. There are additional instructions on how to create hyperlinks on the bottom of each database. If you read the material presented above, you will be familiar with these instructions.
16) Two Column Hyperlink Database.
If you want to download a two column Hyperlink Database, left click on these words.
17) Three Column Hyperlink Database.
If you want to download a three column Hyperlink Database, left click on these words.
18) Four Column Hyperlink Database.
If you want to download a four column Hyperlink Database, left click on these words. (To see all four columns, you may have to scroll from left to right, using the left arrow key.)
19) Five Column Hyperlink Database.
If you want to download a five column Hyperlink Database, left click on these words. (To see all four columns, you have to scroll from left to right, using the left arrow key.)
20) Six Column Hyperlink Database.
If you want to download a six column Hyperlink Database, left click on these words. (To see all four columns, you have to scroll from left to right, using the left arrow key.)
------------------------------------------------------
If you want to go to the top of this
website, left click on these words
A Hyperlinked Table Of Contents
This is a hyperlinked table of contents of this website. Left click on the heading or subheading you want to read. When this is done the section with the words you clicked on will appear on your computer screen.
GENERAL CONCEPTS AND INSTRUCTIONS
Important Note About the Downloads
DATABASES FOR MULTIPLE LINES OF TEXT
Description of Databases for Text
1) One-Column Database, for Multiple Lines of Text
2) Two-Column Database, for Multiple Lines of Text
3) Three Column Database, for Multiple Lines of Text
4) Four-Column Database, for Multiple Lines of Text
5) Five-Column Database, for Multiple Lines of Text
6) Six-Column Database, for Multiple Lines of Text
General Description of the Statistical Databases
7) A Database, with a Mechanism for Calculating the Average of a Set of Numbers
8) A Database, with a Device for Calculating the Geometric Mean, of a Set of Numbers
10) A Database with a Mechanism for Calculating the Correlation Coefficient of Two Sets of Numbers
12) A Database with a Mechanism for Calculating Ten Statistical Calculations Simultaneously
General Concepts and Utility of Hyperlink Databases
A Method Similar to the Above for Creating Hyperlinks to Files on Your Computer
Microsoft Excel's Hyperlink Function
One of The Easiest Methods: Microsoft Excel’s Insert Hyperlink Dialog Box
Demonstrating the utility of a Hyperlinked Database, with a functioning example with over 70 links
Download Links For The Hyperlink Databases,
which Are Designed for You to Enter
16) Two Column Hyperlink Database.
17) Three Column Hyperlink Database.
18) Four Column Hyperlink Database.
19) Five Column Hyperlink Database.
20) Six Column Hyperlink Database.