fullscreen background
Skip to main content

Summer Quarter

Summer Catalogues
Now Available
Registration Opens May 22
shopping cart icon0

Courses

« Back to Professional & Personal Development

WSP 109 — Demystifying Excel PivotTables

Quarter: Spring
Day(s): Saturday
Course Format: On-campus course
Duration: 1 day
Date(s): May 20
Time: 10:00 am—4:00 pm
Drop Deadline: May 13
Unit: 0
Tuition: $200
Instructor(s): Maria Pribyl
Limit: 20
Status: Open
Spring
On-campus course
Saturday
10:00 am—4:00 pm
Date(s)
May 20
1 day
Drop By
May 13
0 Unit
Fees
$200
Instructor(s):
Maria Pribyl
Limit
20
Open
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.

Due to its short format, this course may not be taken for Credit or a Letter Grade.

Students must have a working knowledge of Excel and the ability to navigate around a spreadsheet. Students are required to bring a 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 the Mac platform as well.

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, 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.
DOWNLOAD THE PRELIMINARY SYLLABUS » (subject to change)