Filtering and Slicing Excel Data

Manage and analyze your spreadsheets more effectively with this comprehensive course titled Filtering and Slicing Excel Data. Led by Excel expert and CPA David Ringstrom, this presentation guides users through the essential techniques required to take massive lists of data and collapse them down to exactly what needs to be seen in a given moment. Whether you are working with unfamiliar datasets or routine reports, mastering these tools allows you to gain a bird's eye view of your information without the overwhelm of endless scrolling.

The course begins by exploring the fundamental Filter feature, a tool that has been a staple in Excel for decades. David explains how to apply criteria to individual columns, manage filter buttons, and utilize keyboard shortcuts to speed up the process. Beyond the basics, you will learn how to overcome common pitfalls, such as calculating accurate totals for filtered data using the SUBTOTAL function rather than standard SUM functions, ensuring your analysis remains accurate even when rows are hidden.

As the session progresses, the focus shifts to modernizing your workflow by converting standard lists into Excel Tables. This section highlights the power of Slicers, a visual tool described as a remote control for filters, which allows for faster and more intuitive data navigation. You will also discover advanced techniques, including the use of wildcard criteria, filtering by color, and deploying the dynamic FILTER worksheet function available in newer versions of Excel to create automated, formula-based solutions.

Key topics covered in this course include:

• Mastering the basics of the Filter feature to quickly sift through large lists and isolate specific data points.
• utilizing the AutoFilter command and customizing the Quick Access Toolbar to filter data with a single click or keyboard shortcut.
• Understanding the nuances of the SUBTOTAL function to create accurate ad hoc totals that respect filtered rows.
• Transforming data ranges into Excel Tables to unlock automatic formatting, total rows, and the Slicer feature.
• Using Slicers to visually filter data and viewing the status of multiple criteria simultaneously.
• Applying Advanced Filter techniques to create complex criteria ranges directly on the worksheet.
• Implementing the FILTER worksheet function to build dynamic arrays that update automatically as data changes.
• Identifying and removing blank rows efficiently to maintain data integrity.
• Utilizing top-bottom rules and sorting options within Pivot Tables and Pivot Charts to highlight key performance metrics.

This course is designed for users of Microsoft 365 Excel for Windows, though many concepts apply to Excel for Mac as well. By the end of this presentation, you will have a robust set of tools to reduce manual clicking, automate data analysis, and present your findings with clarity and precision.