Microsoft Excel 2003

Course Description

Who Should Attend:

This is an intermediate-level workshop appropriate for any worker tasked with using Microsoft Office Excel 2003 to analyze child support data.

Overview and Focus:

The focus of the workshop is to provide Microsoft Office Excel 2003 skills necessary to make efficient use of the various reports made available by the Pennsylvania Child Support Enforcement System (PACSES).

Topics Addressed:

The primary topics addressed in the workshop are the following:

• Understanding basic Microsoft Office Excel terminology and navigation
• Modifying a worksheet
• Modifying a workbook
• Using data analysis tools
  • Sorting
  • Filtering
  • Formulas
  • Basic pivot tables
• Distributing reports

Various IV-D reports will be discussed and used during the course including:

• Data Integrity Task (DIT) lists
• Self-assessment actionable case lists
• Form OCSE-157 actionable case lists
• E-reports, highlighting the Combo Report (CMBO)

Length of program:

6.5 hours

Course Level

Professional Development These highly interactive courses provide professional skill development for child support enforcement (CSE) staff to foster improved performance in their individual CSE roles. Examples of topics in this category include Customer Service, Coaching for Excellent Performance, and Supervisory Roles and Responsibilities.