The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Of all the Excel tools, the PivotTable provides the most effective way to analyze your company’s general ledger data because it enables you to slice, dice, drill, group, analyze, compare, chart, and ...

Use Excel PivotTables to quickly analyze grades Want to quickly sort the data in your Excel gradebook by category, such as section number or teaching assistant’s name? PivotTables let you view this ...

The last two courses cover business analysis and related strategies/tools, including using professional spreadsheet models. You'll also learn how to collect, analyze, and forecast data to generate ...