Q. I receive regular spreadsheets with all of our company’s accounts, departments, employees, and balances, and I have to subtotal the amounts by accounts, departments, etc. I have been manually doing ...

Here are a few quick methods of analyzing records to find out what’s been paid and how much customers owe. If you work with transaction records, you probably need a way to track what’s outstanding and ...

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting. Microsoft Excel PivotTables are a great way to summarize data. They’re easy to ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...