Excel: Dynamic Filter Techniques for Analysis

Duration: 120 Minutes

OVERVIEW:

Provide participants with a comprehensive understanding of Excel's Sort and Filter tools and functions, including advanced techniques to quickly and effectively manage and analyze data.

Audience: For Intermediate Users of Excel, and for those who are working with larger lists

Sorting Data

• Using Basic Sort in Excel
• Using a Multilevel Sort
• Using the SORT and SORTBY Functions

Filtering Data

• Using Basic Filters
• Advanced Filter Techniques
• Basics of FILTER Function
• FILTER Function Advanced Techniques
• Practical Uses of the FILTER Function

Excel Tables

• Understanding Excel Tables
• Excel Table Tools and Techniques
• Using Excel Tables for Filter and Calculations
• Formula Techniques for Excel Tables

Extract Unique Records

• Using the Remove Duplicates Method
• Using the UNIQUE Function
• Dealing with Spills
• Advantages of the UNIQUE Function
• Practical Uses of the UNIQUE Function

By the End of This course

Participants will have practical understanding of Excel’s Sort and Filter tools including new functions designed to simplify their work, as well as allowing them to organize and analyze data with confidence and precision.