Subtotals with Excel

The video demonstrates how to use the Subtotal Function in Excel to: Assume you have a list of case numbers assigned to a specific detective, precinct, district, city, etc. Use the Subtotal function to quickly add data and get case totals by detective, precinct, district, city, etc. The Subtotal function will provide an overall count for each category (e.g.,  detective, …

Pivot Tables for Case Assignments

The video demonstrates how to use pivot tables in excel to: Determine the total number of cases assigned to detective/s Sort by the number of cases assigned to a detective by month Determine the total number of cases assigned to a group of detectives BY CONSULTING ANALYST, MAYRA LOPEZ