You don't need complex formulas to summarize thousands of rows when PivotTables can do the heavy lifting for you.

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

Ever wondered how some managers seem to have a sixth sense for spotting trends and making data-driven decisions? What if you could unlock that same ability with just a few clicks in Excel? Excel Pivot ...

Many of these errors start long before you click "Insert." ...

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

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Ever found yourself wondering if there’s a more efficient way to handle your data in Excel? If you’ve been using Pivot Tables but feel like you’re only scratching the surface, you’re in for a treat.

Need to know your organization’s YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel. You can make an Excel PivotChart to show year-over-year results like this one.