Back to All Events

Excel 2013 Pivot Tables

Excel 2013 Pivot Tables

April 25, 2018
Morning Session: 8:00 a.m. - 12:00 p.m.
Afternoon Session: 1:00 p.m. - 5:00 p.m.
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $15

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Prerequisites: Before starting this course, students are recommended to take or have equivalent knowledge of Excel 2013 Beginner and Excel 2013 Intermediate courses.

Overview
Upon successful completion of this class, students will be able to build a PivotTable, analyze data using PivotTables, and present PivotTable data visually.

Course Content

Lesson 1: Building a PivotTable
Topic 1A: Insert a PivotTable
Topic 1B: Create a PivotTable Based on External Data
Topic 1C: Categorize PivotTable Data
Topic 1D: Customize a PivotTable

Lesson 2: Analyzing Data Using PivotTables
Topic 2A: Create Custom Calculations in a PivotTable
Topic 2B: Restructure a PivotTable

Lesson 3: Presenting PivotTable Data Visually
Topic 3A: Format a PivotTable
Topic 3B: Present a PivotTable in a PivotChart
Topic 3C: Print PivotTables and PivotCharts

Earlier Event: April 18
Geospatial Python
Later Event: May 2
Excel 2013 for Beginners