Instructor for this course
more

This course begins by comparing the formula-based reports we built using SUMIFS in previous courses to reports using PivotTables. We dig into the details between these two report types so that you are comfortable applying them to specific scenarios.

This session is really fun because we create two versions of many reports, one version with formulas and the other with PivotTables so that you are comfortable replacing formula-based reports with PivotTables when appropriate.

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

  • Identify the three PivotTable report layout formats
  • Discover the operator that causes Excel to create absolute structured table references
  • Recognize the difference between calculated fields and calculated items
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 (7 ratings)Reviews

5
Member's Profile
A thouroughly thorough course on a deep excel subject. I feel very prepared now and highly recommend. It just took me a good bit longer than the state course time, as I wanted to learn this well. Scored 100%! :)
5
Member's Profile
The class showed me how to do some things in a different way than I had been. I can now use pivot tables to display data in much more user friendly way.

Prerequisites

Course Complexity: Intermediate

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:38Chapter 11: Report Type Comparison Part 1
  12:28Chapter 11: Report Type Comparison Part 2
  8:06Chapter 12: Options
  11:39Chapter 13: Report Layout and Design
  18:47Chapter 14: Multiple Value Fields
  15:50Chapter 15: Calculated Fields
  9:31Chapter 16: Calculated Items
CONTINUOUS PLAY
  1:25:59How to Use PivotTables instead of Formula-Based Reports
SUPPORTING MATERIALS
  ZIPSupporting Files:How to Use PivotTables instead of Formula-Based Reports
  PDFHow to Use PivotTables instead of Formula-Based Reports Glossary
REVIEW AND TEST
  quizReview Questions
 examFinal Exam