In this course, we conclude our PivotTable discussion by examining various ways to present report values, discussing the subtlety of properly sorting a recurring-use PivotTable, and covering numerous filtering options, including slicers.
Next, we explore the lookup function designed specifically to retrieve values from PivotTables. The course concludes by transitioning to data acquisition techniques, and we’ll retrieve data, including stock quotes, from perhaps the largest external data source of all, the World Wide Web.
Prerequisites
No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.
Learning Objective
- Explore the process for displaying PivotTable report values as a percentage of the report total.
- Identify the default sort order of a PivotTable.
- Discover three ways to filter a PivotTable report.
Last updated/reviewed: July 7, 2025
(0) Reviews
(43 rating)Lesson Questions and Answers0 Questions
There are no questions.
Answers to Frequently Asked Questions (FAQs)
Jeff Lenning
President
INTRODUCTION AND OVERVIEW
- Chapter 17: Show Values As 9:31
- Chapter 18: Sorting 17:52
- Chapter 19: Filtering 16:48
- Chapter 20: Hybrid Reports with GETPIVOTDATA 12:32
- Chapter 21: Web Data Part 1 18:56
- Chapter 21: Web Data Part 2 6:31
SUPPORTING MATERIALS
- Slides: PivotTable Conclusion and External Data Introduction ZIP
- PivotTable Conclusion and External Data Introduction Glossary PDF
REVIEW AND TEST
- REVIEW QUESTIONS quiz
- FINAL EXAM exam
Ask the instructor a question about this lesson