Excel 2019: Use Table Slicers, Calculations & Cleanup

Course description

Excel 2019 offers powerful ways to make tables more dynamic, interactive, and efficient through slicers, automated calculations, and built-in data cleanup tools. This course demonstrates how to enhance ordinary tables with visual filtering, responsive totals, and duplicate management that keep your data accurate and analysis-ready. You’ll learn how slicers provide an intuitive, clickable interface for filtering large datasets by category, instantly displaying which options remain valid as filters change. The course explains how to add, position, and format slicers effectively adjusting layout, captions, and columns for clean, professional dashboards. You’ll also explore how Excel tables handle calculations automatically, filling entire columns from a single formula entry and keeping totals synchronized with filtered data. Structured references make formulas clearer, easier to maintain, and resistant to errors when rows expand or contract. The module also covers the Total Row feature, showing how Excel’s built-in subtotal functions respond dynamically to filters for accurate, real-time summaries. To complete the workflow, you’ll learn to clean and refine table data using Excel’s Remove Duplicates command to eliminate redundant or incomplete entries without manual sorting. Whether you need to isolate unique combinations, simplify reports, or ensure reliable data for PivotTables, these capabilities turn standard tables into flexible, self-maintaining tools that support better analysis and decision-making.

Course outline