WSP 109 — Demystifying Excel PivotTables
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.