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, 9:00 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
 

Excel Pivot Tables (TriHealth)

$175.00Price
Class Dates
Select
Purchase hardcopy training material?
Select
What version of MS Office are you using?
Select