Excel – Pivot Tables

• Pre-registration is required for all classes.
• Classes take place in downtown Oakland.
• Log into UC Learning Center (UCLC) to pre-register and see full class description and location.

An Intermediate Level Excel background is strongly encouraged.

The pivot table in Excel is arguably the most powerful tool in the entire Microsoft Office suite. When the success of the organization relies on the ability of its employees to analyze complex data efficiently and quickly, it is essential that you master pivot tables. A pivot table is a data summarization tool that can automatically sort, group, count, filter, report, and summate data with simple dragging and dropping. UCOPs pivot tables training will enhance your ability to manipulate, analyze, and interpret large quantities of data and empower you to make effective, data-driven solutions.

Through hands-on lessons in our computer lab, accompanied by the pivot tables training curriculum, you will learn to:

• Import and prepare large datasets into Excel
• Setup data and create a pivot table
• Understand source data considerations
• Respond to changes in source data
• Work with Report Layout options
• Group PivotTable data and create Calculated Fields
• Sort and filter data
• Create data subsets and extract detail from a pivot table
• Create a Pivot Chart
• and much more