This course examines various ways to present report values; discussing the subtly of properly sorting a recurring-use PivotTable; and covering numerous filtering options, including slicers. Next, you’ll explore the look-up function designed specifically to retrieve values from PivotTables. The session concludes by transitioning to data acquisition techniques, and you’ll retrieve data from perhaps the largest external data source of all-the Internet.
Show values as. Sorting. Filtering. Hybrid reports with GETPIVOTDATA. Web data.
Accounting professionals who use Excel for Windows.
State the process for displaying PivotTable report values as a percentage of the report total. Identify the default sort order of a PivotTable. Recall three ways to filter a PivotTable report.
Non-Member Price $89.00
Member Price $69.00