Perhaps the most valuable of these quick analysis tools—at least from an ease-of-use standpoint—is the recommended Pivot Table feature.

Quick Analysis Let's say you have a spreadsheet containing records of your sales. When you highlight some of your cells, the Quick Analysis tool in Excel will immediately offer to do the following ...

Excel's Analyze Data has been around for a while, but many users are still unaware of its power and flexibility.

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals.