In-person, instructor-led class open to the public at TriHealth's Norwood location. Electronic training material will be provided. You may purchase a hardcopy training manual to take home ($25) by selecting the option listed. Marking in or damaging classroom-use training material will result in a charge. Class will be cancelled 2 business in advance if a minimum # of students is not reached.
Address: 4750 Wesley Ave, 1B Education Center, Norwood, OH 45212.
Course Length: 1/2 day, 8:30 AM to 12:30 PM or 1:00 PM to 5:00 PM (varies by day)
Course Objectives
Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data.
You will:
- Prepare data for PivotTable reporting and create PivotTables from various data sources.
- Analyze data by using PivotTables.
- Work with PivotCharts.
Course Content
Lesson 1: Preparing Data and Creating PivotTables
Topic A: Prepare Data
Topic B: Create a PivotTable from a Local Data Source
Topic C: Create a PivotTable from Multiple Local Data Sources
Topic D: Create a PivotTable from an External Data Source
Lesson 2: Analyzing Data by Using PivotTables
Topic A: Summarize PivotTable Data
Topic B: Organize PivotTable Data
Topic C: Filter PivotTable Data
Topic D: Format a PivotTable
Topic E: Refresh and Change PivotTable Data
Lesson 3: Working with PivotCharts
Topic A: Create a PivotChart
Topic B: Manipulate PivotChart Data
Topic C: Format a PivotChart