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