Excel: Pivot Tables and Dashboards Class
Microsoft Excel’s Pivot Tables turn data into instant calculations. Summarize & analyze data with Pivot Charts. Create Dashboards to see statistics at a glance.
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.
- Our "Learn Excel in 3 Hours Flat" live class/webinar, or
- Prior Excel experience.
- A copy of Microsoft Excel
Who should take this 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 should you bring?
A laptop computer with Excel loaded (any version is fine).
What You’ll Learn
- All About Lists
- Creating Data Tables
- Formatting Tables
- Calcliating Statistics
- Sorting Data
- Filtering Data
- Creating Pivot Tables
- Changing Value Field Statistics
- Pivot Charts
Watch it again later
A recording of the webinar will be added to this course in two weeks so you can review it at your convenience.
Can't make this class?
Here is the course outline:
1. Where to take the class
Sat., 11/23/19 @ 10am-1pm PST. Click the links for instructions.
Please let us know how you will be attending!
How to connect to the Zoom webinar
Where to attend in person
2. Download the Handout
Download the handout that goes with the course.
Download the handouts here
3. 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.
Creating Pivot Tables and Dashboards
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
The following certificates are awarded when the course is completed:
|Royalwise Credit Certificate|