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.
Automating Subtotals
Feb 24
Voiding a Check
Feb 24
This simple task generates a surprising number of support calls. Watch for these two important details and you should have no problems.
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.
In both payables and receivables, Peachtree shows you the status of an invoice as Paid In Full, Partially Paid, Unpaid, or Past Due. But how can you quickly find out which payments or credits were applied to that invoice and when were they applied?
Multiple Customer Contacts
Dec 24
Do you have several different contacts for some of your customers? Now you can add as many contacts as you want to a customer in Peachtree.
Email forms and reports
Dec 24
Stop spending your time stuffing envelopes or faxing reports. Invoices, statments, Purchase Orders, and reports can all be emailed directly from Peachtree.
Close pop-ups with Alt+F4
Dec 24
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.
Finally, in version 2010, Peachtree can tell you who is logged in when you need to have single user access.
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.
