One nice feature in Peachtree is the ability to save reports as a PDF. Now you can add the same ability to almost any program for free.

Grouping rows in Excel allows you to roll up sections of a spreadsheet so that you can have both detail and summary views of the same data. Switching between the two views is as simple a single click.

Last month I talked about the benefits of using the SUBTOTAL function. This month I’ll show you how, in some cases, Excel can insert subtotals for you and give you a collapsible outline of your data that lets you choose between seeing full detail with subtotals, just subtotals, or just the grand total.

You often need to have subtotals in a spreadsheet, but if you are not careful, you can end up accidentally including your subtotals in the grand total. The Subtotal function in Excel, can make it faster and easier to avoid that problem.

Reduce the chances of you computer being infected by using this keyboard shortcut to close internet pop-ups.

Conditional formatting in Excel saves you time by making important information stand out.

Using the mouse to select cells in Excel is fast and easy if all the cells you want are on screen. But how many times have you tried to select a larger area and overshot your target by hundreds of rows or columns? By using the keyboard to select cells you will gain the control you need to select large ranges easily.

AutoFilter is a great tool to help you find the information you are looking for in a large spreadsheet. It lets you apply a filter to a spreadsheet so that it only shows the rows you want to see