Skip to content
View menu
Royalwise OWLS (On-demand Web-based Learning Solutions)
Log in
QuickBooks® Training Library

Excel Pivot Tables and Dashboards Course


Course
Quantity
For someone else
Alicia Katz Pollock
Quantity
For someone else
Purchase for $70 or enter access code

Microsoft Excel’s Pivot Tables turn data into instant calculations. Summarize & analyze data with Pivot Charts. Create Dashboards to see statistics at a glance.

What You’ll Learn in This Pivot Tables and Dashboards: Excel Training

  • All About Lists

  • Creating Data Tables

  • Formatting Tables

  • Calculating Statistics

  • Sorting Data

  • Filtering Data

  • Creating Pivot Tables

  • Pivoting

  • Bursting

  • Changing Value Field Statistics

  • Timelines

  • Dashboards

  • Pivot Charts

  • Slicers

 

Pivot Tables and Dashboards: Excel Training Course Description

Understand your Excel data instantly by turning endless rows & columns of numbers into stunning visuals. We’ll manipulate vast amounts of data, by creating Pivot Tables, Pivot Charts, and Dashboards. We’ll even format everything from the shape to the color. Numbers never looked so pretty! A must for anyone who uses Excel.

It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover work similarly in Excel for PC and Mac.

 

 

 

 

 

 

 

 

Instructional Level

Advanced

 

Course Length

2 hours

 

Course Credits

Certificate of Completion

 

Field of Study

Computer Software & Applications

 

Delivery Method

QAS Self Study

 

Suggested Prerequisites

 

Who should take this course?

  • Business owners and employees looking to manipulate and analyze Excel spreadsheet data for business decisions.
  • Students and job-seekers looking to boost their employment marketability.
  • Experienced users looking to glean essential nuggets of information to make using Excel easier than before.

 

Evergreen Access (Made to Stay Current)

Your purchase is designed to stay useful long after you finish the course! As the software changes, we refresh the content so you’re not learning from outdated screens. You’ll also have access to the class discussion/Q&A so you can ask questions when real-life situations pop up. And because it’s lifetime access, you can revisit the videos, handouts, and materials anytime you need a quick refresher.

 

Live Session + Replay Included

If you can’t attend at the scheduled time, go ahead and enroll—your live registration includes free access to the on-demand replay. We record every live class and post an edited version to the course page within two weeks of the class date. Once it’s available, you’ll receive a notification inside your OWLS portal.

While the replay is being published, you can download the notes/handouts and complete any quizzes or questionnaires so you’re ready to follow along when you watch.

 

 

 

 

 

 

 

 

 

 

Refunds & Cancellations

Please view our Terms of Service, for information on refunds, cancellations, and complaint resolution. To request a refund, please contact us.
Course Page Updated: March 2026

 

 

 

^ Back to Top ^

 

 

 

Here is the course outline:

1. Download the Handout

Download the handout that goes with the course.

2 sections
Download the handouts here
Updated handout

2. Watch the Videos: Excel Pivot Tables and Dashboards

Understand your Excel data instantly by turning endless rows & columns of numbers into stunning visuals. We’ll manipulate vast amounts of data, by creating Pivot Tables, Pivot Charts, and Dashboards.

7 sections
Intro and Overview of Pivot Tables, Pivot Charts, and Dashboards
Working with Data Tables in Excel
Using Conditional Formatting in Excel
Working with Pivot Tables
Working with Pivot Charts
Working with Dashboards in Excel
Review Questions: Excel Pivot Tables and Dashboards

3. Take the Quiz

Take this quiz to demonstrate your mastery of the material. Pass the quiz with an 80% or higher to complete the Course, earn your Certificate, and win points!

4 sections
Turn in your completed Data List file
Turn in your Pivot Table file
Quiz: Excel Pivot Tables and Dashboards
Evaluation & Participation Survey

Completion

The following certificates are awarded when the course is completed:

Royalwise CPE Certificate
Back to top