A search function built into the spreadsheet can find any text in the descriptions or go directly to a given stock number. One thing a database or custom program provides is a window for entering new inventory items. A spreadsheet does not easily do this. New data is always entered in the table view. It is easier, however, to print out selected data with a spreadsheet than with a database.
Spreadsheets can imitate many features of relational databases.
Spreadsheet Expense Journal . Again, new columns may be easily added. One for check number would be a logical addition. When it comes time to close the year's books, spreadsheet functions can be told to sort the expenses by account and date and to total the individual accounts. Spreadsheets usually include graphing functions.