Advanced Excel: PivotTables
Advertisement
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 www.oakcreeklibrary.org/events or over the phone by calling 414-766-7900.
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 www.oakcreeklibrary.org/events or over the phone by calling 414-766-7900.
Advertisement
Where is it happening?
8040 S 6th Street, Oak Creek, WI, United States, Wisconsin 53154
Event Location & Nearby Stays:
Know what’s Happening Next — before everyone else does.
Host or PublisherOak Creek WI Public Library
![Gourd Rattle Workshop [Deposit]](https://cdn-ip.allevents.in/s/rs:fill:500:250/g:sm/sh:100/aHR0cHM6Ly9jZG4tYXouYWxsZXZlbnRzLmluL2V2ZW50czMvYmFubmVycy9lNzhjNmJlYmM0YzdjYjNjYzEyZjAwMjFjZTBkNzUxODMwMDFjYzE1NDc5NDM2MTIzNzJkMDhkOTYyNDcwMzdiLXJpbWctdzEyMDAtaDY3NS1kY2Y4ZThjOC1nbWlyP3Y9MTc5MjY4MTA3MA.avif)
