fullscreen background
Skip to main content

Fall Quarter

Fall Quarter Underway
Late-Start Classes
Still Available
shopping cart icon0


« Back to Professional & Personal Development

WSP 109 — Demystifying Excel PivotTables

Quarter: Fall
Day(s): Saturday
Course Format: On-campus course
Duration: 1 day
Date(s): Dec 2
Time: 10:00 am—4:00 pm
Drop Deadline: Nov 25
Unit: 0
Tuition: $250
Instructor(s): Maria Pribyl
Limit: 20
Status: Open
On-campus course
10:00 am—4:00 pm
Dec 2
1 day
Drop By
Nov 25
0 Unit
Maria Pribyl
Microsoft Excel’s PivotTables feature is one of the most powerful data analysis functions that allows you to extract, summarize, and transform in a matter of seconds a large amount of data into an understandable report. This interactive, hands-on workshop will teach you the best practices and time-saving techniques for reporting your data more productively.

A PivotTable can automatically sort, sum, count, average, subtotal, and compare the data being analyzed. In this course, we will explore how to prepare your database to construct an effective PivotTable and modify it efficiently to provide a variety of summarized outcomes. You will learn how to “filter” your results to meet specific criteria; “drill down” on a given summarized total; dynamically modify your searches using “slicers”; effortlessly group dates into months, quarters, and years; view detailed or summarized data with a click of a button; display your results in a variety of report layout formats; easily update a PivotTable by refreshing the data; and lastly, convert a PivotTable into a PivotChart with a simple keyboard shortcut. By the end of the workshop, you will have learned how to create, modify, and display a database efficiently with the powerful Excel PivotTable.

Students must have a working knowledge of Excel and the ability to navigate around a spreadsheet. Students are required to bring a fully charged laptop computer to class.

Note to Mac users: Although the workshop will be taught on the Windows platform, the techniques and handouts presented will be applicable to Excel for Mac as well.

Grade restriction: NGR only; no credit/letter grade.

Maria Pribyl, Founder and President, Snippet Training

Maria Pribyl provides technology training for many universities and companies in the Bay Area, including Stanford, Santa Clara University, San Jose State, Adobe, Blue Coat Systems, Cisco, NVIDIA, Samsung, SanDisk, Symantec, Toyota, Yahoo, PayPal, and others.

Textbooks for this course:

There are no required textbooks; however, some fee-based online readings may be assigned.