Eight Handy Tools in Excel You Probably Don't Know About

摘要

If you use Excel just to keep simple spreadsheets, you might as well be using a ledger and a quill pen. Well, okay, the ledger won't calculate totals for you. But really, there are tons of valuable tools just below the surface that will help you with a wide variety of tasks. Here are eight of our favorites. 1. SUBTOTALS. When you've got reams of data organized by date, it may be hard to see the big picture. Excel's built-in subtotal feature can help. Click Subtotal on the Data ribbon in Excel 2007 or choose Subtotals from the Data menu in 2003. By default it offers a sum-type subtotal at each change in the leftmost column, but you can pick the column and operation you prefer. You can even create multiple subtotals, perhaps for month, quarter, and year.