|
|
|
|
|
|
Exploring Excel's Functions, Part 4: Database Functions
Why on earth would Excel have database functions? After all, Excel is a spreadsheet program, and Access is the database program that is part of the Microsoft Office suite. This is true, but Excel's spreadsheet structure (that is, rows and columns) lends itself to certain kinds of simple databases, and the Excel database functions are designed specifically to work with this kind of data. Continuing Peter Aitken's series on Excel's advanced functions, this article explores the Excel database and shows you how you can use database functions to store many kinds of useful data.
| Source: |
Not available
|
| Version: |
N/A
|
| Type: |
Tips
|
|
|
|
|
|
|
|
|
|
|
|
