Bob has all his passwords inputted in a spreadsheet. Is that secure? Leo says if it works for him, that's one step better than just using the same password over and over. But if someone gets ahold of that file, they have the keys to his kingdom. That's why using LastPass, which generates complicated and secure passwords is a good idea. Bob agrees, but he doesn't know how to use it to change his passwords. Leo says if he goes to LastPass's help desk, they describe step by step how to do it.
Dan wants to know if there's an app that will automatically look at his bank account and divide up his expenses to categorize them for taxes. Leo says that spreadsheets were designed with a database feature which will certainly do that. All he needs to do is set it up. There are also spreadsheet templates for Excel and others which are likely available to do what he wants. Leo also says that it may be worth doing with Mint. It's free and has a lot of automatic features.
The chatroom recommends SimplePlanning.net.
Reb is a PC technician and he wants a piece of software that can show how custom changes can affect the system. Leo says that a Dashboard app is probably the best option. It can read data and then display it graphically. Leo says there used to be an app called Demo that used to do just that. But what Reb is looking for is likely a highly customizable app that he'd need to have written.
Leo says that the key is to do it in a spreadsheet and then print to PDF. He needs to do it with forms that they already have, though. Leo says Jeremy can import a form into the spreadsheet, or even embed the spreadsheet into the document on Word. CutePDF will let him print to PDF.
These are called "Freeze Panes", and it's under the 'View' menu in Excel.