City of St. Catharines Learning & Development

To take this course you must have a solid understanding of Excel Course 1B and Excel Course 2B. You should consider yourself an Intermediate or better Excel user.

Boost your Excel game with practical skills in advanced filtering, grouping, and consolidating. This course shows you how to shape and organize your data for clear, accurate results—without the extra hassle.

Advanced Filter

• Filter vs. Advanced Filter
• Criteria, List and Output Ranges
• Simple and Formula‐based Criteria
• Performing a Filter
• Using OR Conditions
• Copy Unique Records
• (You should already be familiar with the regular Filter feature.)

Creating Groups & Subtotals

• Using Auto Outline
• Manually Creating Groups
• Collapse and Expand
• Hide/Show Outline Symbols
• Add Subtotals
• Subtotal Options
• Remove Subtotals

Data Consolidation

• Consolidate by Position
• Consolidate by Category