Instructor for this course
more

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.

Course Series

This course is included in the following series:

4 CoursesPivotTable Essentials

  1. PivotTable Essentials
  2. How to Use PivotTables instead of Formula-Based Reports
  3. PivotTable Conclusion and External Data Introduction
  4. Using PivotTables and PivotCharts to Prepare External Data

Learning Objectives

  •  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: February 04, 2018

Included In Certifications

This course is included in the following Expert Certifications:

9 CoursesExcel for Professional Applications Certification

  1. Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
  2. Excel Training: Skills for Better Workbook Design
  3. Excel Training: Boosting Proficiency with Selected Shortcuts (PC version)
  4. Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
  5. Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
  6. PivotTable Essentials
  7. How to Use PivotTables instead of Formula-Based Reports
  8. PivotTable Conclusion and External Data Introduction
  9. Using PivotTables and PivotCharts to Prepare External Data

2 Reviews (6 ratings)Reviews

4
Member's Profile
This class covered a lot of information in a short time. It will take practice to use the information in my daily work.
5
Member's Profile
Sorting, filtering instructions for Pivot tables and introduces pulling web data into excel. I’ve learned so much!

Prerequisites

Course Complexity: Advanced

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.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  9:31Chapter 17: Show Values As
  17:52Chapter 18: Sorting
  16:48Chapter 19: Filtering
  12:32Chapter 20: Hybrid Reports with GETPIVOTDATA
  18:56Chapter 21: Web Data Part 1
  6:31Chapter 21: Web Data Part 2
CONTINUOUS PLAY
SUPPORTING MATERIALS
  ZIPSlides: PivotTable Conclusion and External Data Introduction
  PDFPivotTable Conclusion and External Data Introduction Glossary
REVIEW AND TEST
  quizReview Questions
 examFinal Exam