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 ...

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 ...

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 ...

Using a formulaic reference to the total on another Excel 2013 sheet creates a dynamic link between the two cells. When the original total changes, the updated figure is automatically forwarded to the ...

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 ...