Advanced Excel: PivotTables

In this advanced Excel computer class, you will learn how to use PivotTables. PivotTables are a powerful tool used to calculate, summarize, and analyze data, letting you see comparisons, patterns, and trends. This class is recommended for people who have an intermediate level knowledge of Excel (or who have taken an Intermediate Excel class).

Create drop-downs with data validation and review filtering within a table.

Gain an understanding of PivotTables and then create, analyze data, and format within one.

Group Exercise 1: create a PivotTable with others in the class using an existing worksheet.

Learn how to filter within a PivotTable.

Group Exercise 2: replicate PivotTable examples with a large data set.

Create a PivotChart and adjust the data/apply filtering.

This is a single-session class and requires registration. Register by visiting oakcreeklibrary.org/events or over the phone by calling 414-766-7900.

You may also like the following events from Oak Creek WI Public Library:

• Next Wednesday, 12th November, 04:00 pm, After School Art Club in Oak Creek
• This month, 17th November, 06:30 pm, Middle School Craft Club in Oak Creek
• This month, 17th November, 06:30 pm, Music and Movement in Oak Creek

Also check out other Workshops in Oak Creek.