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

Source data won’t always come in the form you need in Excel. When that happens, consider using Flash Fill to save time and aggravation. Flash Fill showed up in Microsoft Excel 2013, so you’re probably ...