Skip to content
OnDemand Videos

Excel Pivot Tables and Dashboards Course


Course
Quantity
For someone else
Alicia Katz Pollock
Quantity
For someone else
Purchase for $54 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.

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 

CPE Credits

2 CPE, Certificate of Completion

Delivery Method 

QAS Self Study 

Field of Study

Computer Software & Applications

Prerequisites 

  •   Prior Excel experience.
  •   A copy of Microsoft Excel.

Who should take this Pivot Tables and Dashboards: Excel Training class?

  •   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.

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

 


Refunds & Cancellations

Please view our Terms of Service, for information on refunds, cancellations, and complaint resolution. To request a refund, please contact us.

 

Royalwise Solutions Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

 

 




Course Credits: 2 CPE, Certificate of Completion. Must be awarded within one year of enrollment.


Course Updated: December 2021

Here is the course outline:

1. Download the Handout

Download the handout that goes with the course.

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.

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!

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