Microsoft’s updated spreadsheet tool isn’t getting a lot of new, whiz-bang features, but it is becoming more functional. That’s something both new and experienced users will enjoy—especially a new ...

Learn how you can combine PivotChart and Slicer objects to create an easy-to-use and dynamic data summarization. Excel 2010 introduced Slicers, which you can use to filter PivotTable and PivotChart ...

Excel's PivotTable feature lets you organize and summarize data into a meaningful report format without changing the data set. Beyond reporting, PivotTables offer a quick and easy way to analyze ...

There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical ...

Summarizing data is a common task in Excel, and there’s usually more than one way to do so. Susan Harkins explains three ways to return averages for multiple groups. If you have three or more rows of ...